NEW
Font size
S
M
L
XL
WorksheetsAdvanced Functions
Total questions: 14
Worksheet time: 7mins
Name
Class
Date
1.
What are used in higher-level operations such as conditional and comparison equations.
a)
If Statements
b)
Advanced Spreadsheets
c)
Advanced Functions
d)
Advanced Charts
2.
How many functions are we learning about in this class?
a)
2
b)
3
c)
4
d)
5
3.
This function can be written to carry out an action and is a conditional operator.
a)
If Statements
b)
List Functions
c)
Count Functions
d)
Lookup Functions
4.
What functions are used to calculate a period of time.
a)
Date Function
b)
If Statements
c)
List Functions
d)
Count Functions
5.
Returns the current date.
a)
Date Function
b)
Now Function
c)
Date360 Function
d)
List Function
6.
Calculates the difference in days between 2 dates
a)
Date360
b)
Now
c)
Date Function
d)
Count Function
7.
Function used to compare a cell value to a group of cells in two column vectors
a)
VLookup Function
b)
List Function
c)
Lookup Functions
d)
Count Functions
8.
Used when there are more than two columns in a spreadsheet (looking up information in a table)
a)
VLookup Function
b)
Lookup Function
c)
Array
d)
List Function
9.
A function that is used to assist in organizing information, control content and filter content.
a)
Lookup
b)
Count
c)
List
d)
If Statements
10.
A validated list that limits data entry to specific choices programmed into the function.
a)
Validated
b)
Non-validated
c)
List
d)
Count
11.
Allows additional entries other than those provided in the drop-down menu
a)
Validated
b)
Non-validated
c)
List
d)
Count
12.
Returns the number of cells in a range that contains numbers
a)
Count
b)
CountA
c)
CountIf
d)
List
13.
Returns the number of cells in a range that contain any value/label
a)
Count
b)
CountA
c)
CountIf
d)
List
14.
Returns the number of cells that meet a condition set forth in a formula
a)
Count
b)
CountA
c)
CountIf
d)
List
Reset
