Show:
Functions
Sort/Filter
Formulas
Freeze
PEMDAS
100
functions that displays the largest number in a cell range?
What is MINIMUM function
100
A-Z
What is descending order?
100
multiplies B4 by A4
What is =B4*A4
100
freeze panes group location
What is window group
100
Order of the order of operations (completely spelled out)
What is Parenthesis, exponents, multiplcation, division, addition, subtraction.
200
NOW() DAYS360()
What is date functions?
200
Z-A
What is ascending order?
200
Divides A6 by the sum of the cells in the range B8:B12
What is =(B8+B9+B10+B11+B12)/A6
200
View ribbon
What is freeze panes location
200
12+(6*9)/3 (first step done)
What is (6*9)
300
=SUM(D2:D8)
What is SUM function?
300
sort not specified
What is custom sort?
300
A formula that multiplies the difference of B9 and A11 by the sum of D10:D14
What is =(B9-A11)*(D10+D11+D12+D13+D14)
300
How to unfreeze panes
What is freeze panes drop down, unfreeze panes
300
solve. (2+3*6)-3
What is 12
400
calculates the mean of a cell range of data?
What is AVERAGE functions?
400
Shows only data that meets a specified criteria?
What is filter
400
If A12=2, D5=5 and B17=1 write and solve a function where the B17 is added to the product of A12 and D5
What is =(A12*D5)+B17 =11
400
list all freeze pane options
What is Freeze panes, freeze top row, freeze first column
400
list order of operations (7*4)+3-2
What is (7*4) +3 -2
500
=IF(E8="10", "true", "false")
What is the IF function?
500
Shows only data that starts with...
What is begins with filter
500
write and solve a function when A12=2 B10=5 and D5=1 when A12 squared plus D5 multiplied by B10
What is =(A12(A12)+D5)*B10 =25
500
how to get to freeze panes
What is View Ribbon, Window Group, Freeze panes drop down
500
solve. (9*3)-10*1
What is 17