Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select
What is Hide?
100
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance
What is Theme?
100
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy
What is Breaks?
100
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
What is AutoFill?
100
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table
What is Entry?
200
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select
What is Scale?
200
Which view is the default view used in Microsoft Excel
What is Normal?
200
On which short-cut menu can a user hide a row or column from view without permanently deleting the information
What is Choose the Hide command on the Shortcut menu?
200
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a
What is Range?
200
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact
What is Copy?
300
Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose
What is Hide?
300
Which term describes the blank portions of a page that fall outside the main body of the printed document
What is Margin?
300
Which command do you use to remove manual page breaks from a worksheet area
What is Select Remove Page Break from the Breaks drop-down area?
300
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header
What is Labels?
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?
400
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D
What is Unhide?
400
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet
What is Format?
400
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet
What is Sheet Options?
400
ennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header
What is Labels?
400
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit
What is AutoFit?
500
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand
What is Formatting?
500
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table
What is Delete?
500
Alicia needs to move the data in cell B5 to cell E5. Which command would she select
What is Cut?
500
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent
What is Row?
500
Which command on the Fill options dialog box is the default option