Show:
SORT/FILTER
FREEZING
FORMULAS
FUNCTIONS
SYMBOLS
100
Where do you find the filter function?
home tab
100
Where is the freeze panes command found?
View Ribbon
100
how do you start a formla?
=(equal sign)
100
How do you start a Function?
=(equal sign)
100
What is symbol for addition?
+ (plus sign)
200
Describe how to sort in acending order?
On the data tab, click A-Z
200
How do you freeze a column?
Highlight the column, then click "Freeze Panes" on the View tab, then click "Freeze First Column".
200
What must be included to perform a formula?
(), =, +,-,/,* (parenthesis, equal sign, operation signs)
200
What is a Function usually confused with?
Formula
200
The symbol for subtraction is_____.
-(hyphen)
300
Where do you find the sort function?
data tab and the home ribbon
300
Which ribbon is the freeze panes command located?
View ribbon
300
What is a formula usually confused with?
function
300
What is the function for todays date/time?
=NOW()
300
what symbol is used to perform division?
/ (backslash)
400
How do you sort in descending order?
on the data tab, click Z-A
400
What is the process in which you freeze a row?
Highlight the row, then click "Freeze Panes" in the View tab, then click "Freeze Top Row".
400
=(C1 +C3)/B2 C1=10 C3=30 B2=2
20
400
=SUM(A5:A10) A5=1 A6=2 A7=3 A8=4 A9=5 A10=6
21
400
What is the symbol to start a function or formula?
=(equal sign)
500
Why would you use sort in a worksheet?
It increases organization and productivity
500
Why would you use the "Freeze Panes" option in a workbook?
It allows the user to easily view information while seeing row aand column headers.
500
=(B4/E7)*H1 B4=40 E7=20 H1=2
4
500
=SUM(A10:A13)-D3 A10=6 A11=9 A12=12 A13=2 D3=1
28
500
What symbol do you use for abolute values?
$ (dollar sign)