Freeze
Sort and Filter
Formulas
Functions
Operations
100
Explain the process of freezing a column
Use freeze panes command on the view ribbon
100
What are the 2 ways to sort data?
Ascending and descending
100
What symbol willl prepare a cell for entry of a formula?
Equal sign
100
What is a function?
Special formulas that do not use operators
100
what is the symbol for additon?
Plus sign (+)
200
Explain the process of freezing a row
Use freeze panes command on view ribbon
200
What ribbon is the sort and filter on?
Home ribbon or data ribbon
200
What symbol will tell spreadsheet software not to treat cell data as a value
Apostrophe
200
What is the addition function? Give an example
SUM, =SUM(B2:B5)
200
What is the symbol for subtraction?
Hyphen (-)
300
What ribbon is the the freeze panes option located in?
View ribbon
300
What is the purpose of filtering data?
Allows the user to display only data that meets specific criteria that is set in filter
300
Divide A7 by the sum of A1:A10
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/A7
300
What is the average function? Give an example
Finds the average of a cell range. =Average(A12:A30)
300
What is the symbol for division?
Backslash (/)
400
What is the purpose of freezing rows and columns?
Allows the user to easily view infomation while seeing the row and column headers.
400
What is the purpose of sorting worksheets?
Increases organization and productivity
400
Write the equation for A7 divided by the sum of B3 through B8
=(B3+B4+B5+B6+B7+B8)/A7
400
Subtract A10 by the sum of C3 through C12
=SUM(C3:C12)-A10
400
What is the symbol for multiplication?
Astrict (*)
500
How do you unfreeze a column or row?
View ribbon, freeze panes, Unfreeze panes
500
What is secondary sort?
secondary sort is the 2nd sort that does not change the primary sort
500
A1=23, A2=89, A6=10. What is the result of the equation =(A1*A2)/A6? Why?
204.7. because you multiply A1 and A2 first then divide by A6, since A1 and A2 are in paranthesis.
500
Find the highest and lowest number in the cell range D4:D25
=Max(D4:D25) and =Min(D4:D25)
500
What is the order of operations and what do each letter stand for?
PEMDAS is the order in which you perform calculations Parenthasis, Exponents, Multiplication, Division, Addition, Subtraction
M
e
n
u