EXCEL 2
All of the following are valid Excel arithmetic operators except ___
>
You can click the __ button to undo an automatic correction.
Auto Correct Options
Which of the following Option button gives options for filling cells following a fill operation?
Auto Fill Options
A ___ is text and graphics that print at the bottom of every page.
Footer
The ____ Auto Complete list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
A _____ is a prewritten formula that is built into excel.
Function
A ____ is text and graphics that print at the top of each page.
Header
When designing a worksheet, which steps should be taken to ensure that functional consideration supersede visual aesthetics?
Identification of how to format various elements of the worksheet
The ____ option button lists formatting options following an insertion of cells, rows, or columns.
Insert
Which of the following is a method of entering functions?
Keyboard, touch gestures, or pointer The Sum menu The insert function in the formula bar The name box area in the formula bar
The ____ function displays the highest value in a range.
Max
The ____ function determines the lowest number in a range.
Min
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
A company or department may standardize with a specific ___ so that all of their documents have a similar appearance.
Theme
Using the Excel spell checker, you can____.
Check the spelling of words in a selected range Add words to the dictionary
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
When you decrease the row height to ____, the row is hidden.
0
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
When Excel follows the order of operations, the formula, 8*3+2, equals ______
26
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
Which of the following calculations multiplies 23 by 0.01?
=23%
Which of the following are valid formulas?
=3^4 =H3/H11 =11+9 =22-F15
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
The ____ function sums the numbers in the specified range then divides the sum by the number of cells with numeric values in the range.
Average
A ____ Circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
Indirect
The default view in Excel is called ___ view.
Normal
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
You can use the ___ to check which cells are references in the formula assigned to the active cell.
Range Finder
The adjusted cell references in a copies and pasted formula are called ____ references.
Relative
Excel automatically appends the _____ to complete the average function when you click the enter box or press the enter key.
Right Parenthesis
When more than one arithmetic operator is involved in a formula, excel follows the same basic order of ____ that you use in algebra.
operations
