Show:
Data
Numbers
Buttons
Mathing
Formatting
100
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format
What is Page Layout?
100
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting
What is Find and Replace?
100
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D
What is Text?
100
On the Home Ribbon, what do you use to change the text color of characters in a cell
What is Font Color drop-down list?
100
Which command do you use to reduce the margin between the border and the text in an indented cell
What is Decrease Indent?
200
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose
What is Tab Color?
200
How would you move sheet tabs to a new position in the workbook
What is Click and drag the sheet tab to the new location?
200
Trey would like to outline the cell range A1:F20. Which formatting style should he select
What is Border?
200
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell
What is Merge and Center?
200
What command do you use to apply a background color to cells in a worksheet
What is Fill Color?
300
David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task
What is Find and Replace?
300
How is an exact copy of a worksheet created within the same workbook
What is Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu?
300
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel
What is Font?
300
Which quick-number style button formats numbers to display as currency in the worksheet
What is Accounting?
300
What type of formatting appears only when the value in a cell meets conditions specified by a user
What is Conditional?
400
Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose
What is Rename?
400
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem
What is Wrap Text?
400
What defines the color of the characters in an Microsoft Excel worksheet
What is Font Color?
400
Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet
What is Orientation?
400
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem
What is AutoFit?
500
John would like to remove a worksheet from his workbook. Which option would he choose
What is Delete?
500
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D
What is Currency?
500
On the Home Ribbon, what do you use to change the font size of characters in a cell
What is Font Size drop-down list?
500
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles
What is Cell Style?
500
Jim would like to print only the cell range A1:F20. What page setup option should he change
What is Print Area?