Home
Subjects
Explanations
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
Excel Module 2 Exam
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (27)
A ____ is a prewritten formula that is built into Excel.
function
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.
indirect
Valid Excel arithmetic operators ______
+, -, /^, *, %
The calculation to multiply 23 by 0.01 is ______.
23*0.01=23%
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
_______ 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.
relative
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
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.
Trace Error
The _____ options button lists formatting options following an insertion of cells, rows, or columns.
Insert
The ____ function displays the highest value in a range.
Max
The ____ function determines the lowest number in a range.
Min
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.
average
The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
formula
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
range finder
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
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.
8.43
When you decrease the row height to ____, the row is hidden.
0
A ____ is text and graphics that print at the top of each page.
Header
A _____ is text and graphics that print at the bottom of every page.
footer
The default view in Excel is called _____ view.
Normal
______ views allows you to create or modify a worksheet while viewing how it will look in printed format.
Page layout
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
Sets found in the same folder
Excel Module 1 Exam
33 terms
Excel Module 3
25 terms
Other sets by this creator
Chapters 5-7 Vocab
9 terms
FACS-Chapter 1 Vocab
28 terms
Excel Module 3
25 terms
Health- Chapter 8 Vocab
22 terms
Other Quizlet sets
Soils Exam 3
31 terms
AP Art History: Africa
14 terms
Cardiovascular quiz
10 terms
2021 NATOPS
377 terms