Name the Function
Which function gives the remainder after a division?
MOD
What does =SQRT(81) return?
9
What does =ROUND(3.14159,2) return?
3.14
What does =AND(5>3,2>4) return?
FALSE
Which feature changes a cell's fill colour automatically based on a rule?
Conditional Formatting
Which function gives only the whole-number part of a division?
QUOTIENT
What does =POWER(2,3) return?
8
What does =FLOOR.MATH(7.9) return?
7
What does =NOT(5>3) return?
FALSE
In the cell reference $F10, which part stays fixed when copied: the column or the row?
column (F)
Which function gives the number of days between two dates, and which date goes first?
DAYS, end date first
What does =MOD(20,6) return?
2
What does =CEILING.MATH(42,5) return?
45
What does =SEARCH("a","BANANA") return?
2
In RANK.EQ, what order number makes the smallest value rank 1?
1 (ascending)
Which function returns the value at a chosen row and column of a cell range?
INDEX (row number, then column number)
What does =QUOTIENT(20,6) return?
3
Which gives the bigger result: =ROUND(7.4,0) or =CEILING.MATH(7.4)?
CEILING.MATH (8 against 7)
What does =FIND("a","BANANA") return, and why?
An error (#VALUE!), because FIND is case sensitive
The formula =$A2*B$1 is copied one cell to the right. What does it become?
=$A2*C$1