Show:
Cell References
Formatting
Formulas
Cell Styles/Themes
Wild Card
100
What are the two types of cell references?
Relative & Absolute
100
Name two types of formatting that include dollar signs ($)?
Accounting & Currency
100
Formulas always start with what?
=
100
How do you change a cell style?
Home --> Styles --> Cell Styles
100
What is the order of operations?
PEMDAS
200
Which type of cell reference is used in the formula: $C$5+$E$4
Absolute
200
What is used to copy the formatting of a cell but not the contents?
Format Painter
200
What mathematical symbol is used to show division?
/
200
How do you change a theme?
Page Layout --> Themes
200
How many sheets are in a workbook?
Three
300
Rows are identified by ________ & columns are identified by ________.
Numbers & letters
300
How can you change the formatting of a number.
1) Right click --> Format Cells 2) Home --> Numbers Group
300
What function would you use in a formula to calculate the total?
SUM
300
Describe the difference between a style and a theme.
Styles such as 'Heading 1' are parts of themes. When the theme is changed, the appearance of all of the styles change (i.e. fonts, colors, sizes).
300
Number signs (######) are displayed if a cell is not?
Wide enough
400
What formula would be in cell G5 if the formula from cell E4 (E7+E9) was copied into that cell?
G8+G10
400
How can you combine more than one cell?
Merge and center
400
How can formulas in cells be displayed?
Ctrl+`
400
What are the colors referred to when you change the shading style?
Accents
400
The Tab key is used to move the active cell to the ____________ and the Enter key is used to move the active cell ____________.
Right, Down
500
What formula would be in cell A8 if the formula from B7 ($C$7+C10) was copied into that cell?
$C$7+B11
500
What allows for more than one line of text within a cell?
Wrap text
500
How can you copy formulas to a nearby cell?
Fill Handle
500
What is applied to a cell when a specific condition is met and is used to help make spreadsheet data easier to evaluate?
Conditional Formatting
500
How can you change the amount of pages a document is printed on?
View --> Page Break Preview