Study sets, textbooks, questions
Upgrade to remove ads
Excel Module 2 Exam
Terms in this set (27)
A ____ is a prewritten formula that is built into Excel.
An ____ 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.
Valid Excel arithmetic operators ______
+, -, /^, *, %
The calculation to multiply 23 by 0.01 is ______.
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
_______ happens when you enter the formula =G15 into a cell.
Excel assigns the value of G15 into the active cell
The adjusted cell references in a copied and pasted formula are called ____ cell references.
You can click the ____ button to undo an automatic correction.
The _____ buttons gives options for filling cells following a fill operation.
Auto Fill Options
The ______ button lists error- checking options following the assignment of an invalid formula to a cell.
The _____ options button lists formatting options following an insertion of cells, rows, or columns.
The ____ function displays the highest value in a range.
The ____ function determines the lowest number in a range.
The _____ function sums the numbers in the specified range and then divided the sum by the number of cells with numeric values in the range.
The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
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
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
When you decrease the row height to ____, the row is hidden.
A ____ is text and graphics that print at the top of each page.
A _____ is text and graphics that print at the bottom of every page.
The default view in Excel is called _____ view.
______ views allows you to create or modify a worksheet while viewing how it will look in printed format.
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Sets found in the same folder
Excel Module 1 Exam
Excel Module 3
Other sets by this creator
Chapters 5-7 Vocab
FACS-Chapter 1 Vocab
Excel Module 3
Health- Chapter 8 Vocab
Other Quizlet sets
Soils Exam 3
AP Art History: Africa