Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Microsoft Office Excel

Computing

Quiz 2 :

Formatting Workbook Text and Data

Quiz 2 :

Formatting Workbook Text and Data

search
arrow
When you underline cell content, you are using _____.
Free
Multiple Choice
Answer:

Answer:

A

arrow
To format a range so that all values greater than $500 appear in red, which of the following can you use?
Free
Multiple Choice
Answer:

Answer:

A

arrow
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
Free
Multiple Choice
Answer:

Answer:

C

arrow
The Comma Style format adds a comma and a dollar sign to a cell value.
True False
Answer:
arrow
You can apply date formats to cells by using the Date category in the Format Cells dialog box.
True False
Answer:
arrow
To return cell contents to its default font and style, you can use the _____ command.
Multiple Choice
Answer:
arrow
Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?
Multiple Choice
Answer:
arrow
A _______ refers to a collection of characters with a similar, specific design.
Multiple Choice
Answer:
arrow
To change the color of cell content, you use the ________ color list arrow.
Multiple Choice
Answer:
arrow
To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.
Multiple Choice
Answer:
arrow
A predesigned combination of formats, such as font size and color, is called a cell default.
Short Answer
Answer:
arrow
To combine multiple cells into one and center its content, you change the cells' style.
Short Answer
Answer:
arrow
To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.
True False
Answer:
arrow
Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.
Multiple Choice
Answer:
arrow
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Multiple Choice
Answer:
arrow
To change the background color of a cell, you use the Background color button.
Short Answer
Answer:
arrow
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
Multiple Choice
Answer:
arrow
To change a range's conditional formatting from data bars to icon sets, which of the following can you do?
Multiple Choice
Answer:
arrow
Currency is an example of a number format.
True False
Answer:
arrow
Jim frequently prints out the same section of a worksheet. To do so, he selects the cells he wants to define as print area, then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.
True False
Answer:
Showing 1 - 20 of 63