Exam 2: Formatting Workbook Text and Data

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.

You can repeatedly paste an item from the Office Clipboard as many times as you like.

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

Decreasing a cell's indent moves its contents to the right one space.

When you underline cell content, you are using _____.

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?

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?

To change theme effects, click on Effects on the Page Layout tab, then select the set of effects that you want to use.

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

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

To rotate cell contents to an exact value, you change its _____.

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

To combine multiple cells into one combined cell, which of the following do you use?

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

Helga wants to reset page breaks in a worksheet to display only automatic page breaks. Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

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

To load the Analysis ToolPak and select Anova: Single Factor for statistical analysis in Excel, one should click on the following series: File tab > Options > Add-Ins category > Manage box > Excel Add-ins > Go . select Analysis ToolPak option on the appearing dialog box > OK > Data > Analysis > Data Analysis dialog box > Anova: Single Factor > OK.

To paste only a copied cell's formats, use the Paste Special command.

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?