Upgrade to remove ads
Only $2.99/month

Chapter 2 Excel Vocabulary List

Terms in this set (24)

13. margins (EX 110)
Is the arithmetic operator that directs Excel to perform the multiplication operation.
best fit (EX 103)
Means that the width of the column will be increased or decreased so that the widest entry will fit in the column.
circular reference (EX 73)
A formula in a cell that contains a reference.
debugging (EX 115)
Is the process of finding and correcting errors in the worksheet.
equal sign (EX 74)
Alerts Excel that you are entering a formula or function not text.
footer (EX 110)
Is text and graphics that print at the bottom of each page.
formula (EX 73)
Will calculate the results.
formulas version (EX 115)
Which shows the actual formulas you have entered, rather than the resulting values.
function (EX 66)
Is a pre written formula that is built into Excel.
header (EX 110)
Is text and graphics that print at the top of each page.
hiding cells (EX 104)
Is a technique you can use to hide data that might not be relevant to a particular report.
indirect circular reference (EX 73)
Occurs when a formula in a cell or cells that include a formula that refers back to the original cells.
margins (EX 110)
Are those portions of a printed page outside the main body of the printed document.l
MAX function (EX 82)
Displays the highest value in range.
MIN function (EX 84)
Determine the lowest minimum number in the range.
Normal view (EX 110)
That default view that you have worked in up until this point in the book.
order of operations (EX 75)
As follows: first negation(-), then all percentages(%), then all exponentiation, multiplication, addition, and subtractions.
Page Layout view (EX 110)
Allows you to create or modify a worksheet while viewing how it will look in printed form.
pixel (EX 103)
Which is short for picture element, is a dot on the screen that contains color.
Point mode (EX 76)
Allows you to select cells for use in a formula by using your finger or the pointer.
Range Finder (EX 89)
Checks which cells are referenced in the formula assigned to the active cell.
relative cell references (EX 78)
Excel adjusts the row portion of cell references.
spell checker (EX 107)
You can use to check a worksheet for spelling errors.
values version (EX 11)
Which shows the results of the formulas you have entered.
YOU MIGHT ALSO LIKE...