Exam 2: Formatting Workbook Text and Data

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.

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.

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

From how many theme options can you choose to change the theme of a Power View report?

A predesigned combination of formats, such as font size and color, is called a cell default.

To paste copied cell contents with values only, not including formatting, which of the following can you use?

For use as watermark, Alba wants to insert a picture as a worksheet background. For this, she clicks the worksheet she wants to display with a background, then selects an option X from the Page Layout tab in the Page Setup group. Alba then selects the picture for use as background, and then clicks Insert. What can X in her series of selections be?

To enter your name in the lower right corner of a worksheet page, you can _____.

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

When you change cell contents to italics, you are changing the cell's alignment.

To choose a standard theme color, click on the Insert tab, click Colors, then pick the color set you want.

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

To combine multiple cells into one and center its content, you change the cells' style.

To see how copied contents will look with both values and number formatting, you would use Paste Numbers.

Musa wants to choose a standard color theme for an Excel worksheet he is working on. He clicks on the Page Layout tab and then clicks Colors. What should he do next to complete the procedure?

Igor wants to set margins for a worksheet he has created per his choice. Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top, Header, Left, Right, Bottom and Footer text boxes > OK?

Betty wants to choose the list to create a custom number format. To do so, what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom

You can create conditional cell formats using either the Home tab or the _____.

To move cell contents one space to the right, you can use the Increase Space button.