NEW
Font size
S
M
L
XL
WorksheetsAdvanced Spreadsheet Functions Review
Total questions: 11
Worksheet time: 6mins
Name
Class
Date
1.
IF statements are conditional operators.
a)
TRUE
b)
FALSE
2.
IF statements can be written to carry out an action.
a)
TRUE
b)
FALSE
3.
What are the DATE functions used to calculate?
a)
the future
b)
a period of time
c)
how many
d)
predictions
4.
The NOW function does what?
a)
returns a comparison
b)
returns the possible time
c)
returns the current date
d)
returns the number of days
5.
DATE 360
a)
returns the current date
b)
calculates the number of days in a year
c)
calculated the difference in days between 2 dates
d)
shows how many days we have been in school
6.
A Lookup function is used to?
a)
compare a cell value to an ARRAY of cells and return a value that matches the location of the value in the array.
b)
when you want to locate something in a long list
c)
calculate the date
d)
Validate the time
7.
The List functions is used to do all of the following except?
a)
Assist
b)
Create
c)
Control
d)
Date
8.
What are the two type of lists?
a)
Menu and Drop Down Lists
b)
Validated and Non-Validated
c)
Menu Options
d)
Date
9.
The COUNT function is used to?
a)
Add a range
b)
Return the number of cells in a range.
c)
Sum a Column
d)
Choose the List
10.
COUNTA returns the number of cells in a range that contain?
a)
the date
b)
the name
c)
any value/label
d)
the month
11.
COUNTIF returns the number of cells that meet a condition set forth in a ________________.
a)
Condition
b)
Criteria
c)
Formula
d)
Date
Reset
