Show:
General Knowledge
EXCELlent
Cell shock
Push the Button
Hodge Podge
100
Can be used to move around in a document that is too large to fit on the screen at once.
What are sheet tabs
100
All Excel formulas begin with
What is the equal sign
100
To quickly jump to the first cell in a worksheet, press
What is [Ctrl][Home]
100
You can apply font styles and alignment options using this dialog box
What is Format Cells
100
Electronic spreadsheet program within the Microsoft Office Suite
What is Microsoft Excel
200
The COUNTA function is used to count the number of cells in a range contains this type of data
What is Numbers, text, and formula
200
The Excel operator for division is
What is /
200
Occurs when cells or rows are inserted or deleted in an Excel worksheet
What is cell references are automatically adjusted
200
Formats such as bold, italic, and underlying that you can apply to affect the way text and numbers look in a worksheet
What are Font styles
200
Predefined worksheet formulas that enable you to perform complex calculations easily
What are Functions
300
The user needs to know the name and initial characters of a function when doing this
What is manually typing the function
300
If cell A1 contained 10, cell A2 contained 2, and cell A3 contained =A1/A2, cell A3 would show this on the worksheet
What is 5
300
An Excel user should use a relative cell reference when it is important to
What is preserve the relationship to the formula location
300
The Format Painter button is found in this group on the Home tab of the Ribbon
What is the Clipboard
300
Determines whether the contents of a cell appear boldfaced, italicized, or with dollar signs and commas
What is format
400
The default Accounting number format adds dollar signs and this number of decimal places to the data
What is two
400
In the formula =D1+C1/F3, this calculation would be performed first
What is C1/F3
400
This key allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula
What is [F4]
400
Using the Fill tab and the Border tab in this dialog box allow you to change colors, patterns, and borders of cells
What is Format Cells
400
An object or an independent element on a worksheet, and it is not located in a specific cell or range
What is a chart
500
Use this tab on the Ribbon to insert a comment in a worksheet
What is the Review tab
500
Type of cell reference preserves the exact cell address in a formula
What is absolute
500
Determines how the labels and values of a cell look
What is the format
500
Using the Themes button in the Themes group on this tab on the Ribbon allows a theme to be applied
What is the Layout tab
500
Must be running to start Excel
What is Microsoft Windows