This displays in the cell when the numbers are too large for the cell space. Autofit will correct the issue.
What is ######
100
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location
What is RELATIVE REFERENCE
100
These are the two paper layout options when printing (hint: horizontal and vertical paper)
What is PORTRAIT AND LANDSCAPE
100
Which tab do you use to display the area that contains the print command
What is FILE (BACKSTAGE)
100
This feature makes an exact replica of the cell data and format while keeping the original cell intact?
What is COPY
200
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the
What is ROW
200
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area
What is ABSOLUTE REFERENCE
200
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?
What is PRINT ACTIVE SHEET
200
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
What is NAME BOX
200
Do this to change the width of a column so that the widest entry will fit?
What is AUTOFIT
300
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
What is SAVE
300
Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary!B3" is an example of a(n):
What is EXTERNAL REFERENCE
300
Jim would like to print only the cell range A1:F20. What page setup option should he set?
What is PRINT AREA
300
What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cellS
What is FILL HANDLE
300
This feature automatically inserts data into a cell that begins with the same characters as a previous entry?
What is AUTOCOMPLETE
400
What is the default view used in Microsoft Excel
What is NORMAL
400
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
What is NAMED RANGE
400
What area contains the command used to customize the print options in Microsoft Excel?
What is FILE TAB (BACKSTAGE)
400
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands
What is QUICK ACCESS TOOLBAR
400
This feature allows data to be moved from one worksheet location to another and removes if from the original location?
What is CUT
500
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group
What is RANGE
500
To keep the tax rate in cell A1 constant when used in copying formulas, cell A1 would look like this when used in the formula.
What is $A$1
500
John's workbooks includes 3 worksheets. All need to be printed. Which option should he choose to print them
What is PRINT ENTIRE WORKBOOK
500
Trey would like to outline the cell range A1:F20. Which formatting style should he select to enhance those cells.
What is BORDERS
500
David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?