Exam 2: Formatting Workbook Text and Data

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

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

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?

The Clipboard task pane shows the contents of the _____.

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.

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

To create your own theme color,click on Page Layout,then Colors,then Customize Colors,then click the button next to the theme color you want to change,and finally pick a color under Theme Colors.

Sven wants to create a custom theme font set for the heading and body of a presentation.Under tab X,he selects Fonts,and then selects Create New Theme Fonts.Then he selects a heading font,a body font,types in a name for his theme font set and clicks Save.Which of the following can tab X be in the above-mentioned procedure?

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

To copy a cell's formatting to another cell,which of the following can you use?

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

To insert information that appears at the bottom of every worksheet page,you can use a command on the Insert tab.

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?

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?

To format the cell value 44.54 as 44.540,you can use the Increase Decimal button.

When you underline cell content,you are using _____.

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

To change the background colors in a Power View report,click the POWERVIEW tab > Themes group > Background > Select a color.