SST ROUND, TODAY, NOW functions

SST ROUND, TODAY, NOW functions

7th Grade

10 Qs

quiz-placeholder

Similar activities

Basis Data

Basis Data

7th Grade

10 Qs

Spreadsheets

Spreadsheets

7th Grade

15 Qs

Excel - Formulas and Functions

Excel - Formulas and Functions

7th Grade

10 Qs

Spreadsheet Charts & Advanced Functions

Spreadsheet Charts & Advanced Functions

6th - 8th Grade

11 Qs

Lesson 4 - Gantt Chart

Lesson 4 - Gantt Chart

7th Grade

7 Qs

M2 Flowchart P1

M2 Flowchart P1

7th - 8th Grade

8 Qs

Module 2 - Lesson 5

Module 2 - Lesson 5

6th - 12th Grade

10 Qs

Flow Charts

Flow Charts

1st - 10th Grade

10 Qs

SST ROUND, TODAY, NOW functions

SST ROUND, TODAY, NOW functions

Assessment

Quiz

Computers

7th Grade

Hard

Created by

Rudie Asmara

Used 5+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following will return today's date only?

=NOW()

=TODAY(Date)

=TODAY()

=NOW(DATE)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following will return today's date and time?

=NOW()

=TODAY(Date)

=TODAY()

=NOW(DATE)

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which of the following functions have no (zero) arguments? [more than 1 answer]

NOW

TODAY

SUM

ROUND

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula will return a whole number?

=ROUND(98.78 , 0)

=ROUND(98.78 , 1)

=ROUND(98.78 , 2)

=ROUND(98.78 , -1)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A chart type used to analyse rainfall data trends over a period of time.

Line Chart

Bar Chart

Column Chart

Pie Chart

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

A chart type used to compare proportion of parts as part of a whole.

Line Chart

Bar Chart

Column Chart

Pie Chart

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the outcome of =ROUND(123.45, 0)?

123

124

123.4

123.5

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?

Discover more resources for Computers