FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Formatting Workbook Text and Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) X- Margins, Y- Narrow
B) X- Margins, Y- Custom Margins
C) X- Orientation, Y- Landscape
D) X- Print Area, Y- Set Print Area

E) B) and C)
F) B) and D)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) Breaks
B) Margins
C) Orientation
D) Background

E) B) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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.

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