Exam 2: Formatting Workbook Text and Data

To change the color of cell content,you use the ________ color list 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.

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

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 rotate cell contents to an exact value,you change its _____.

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

To paste a data range so that column data appears in rows and row data appears in columns,you can _____ the data using the Paste list arrow.

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file.What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

A _______ refers to a collection of characters with a similar,specific design.

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 return cell contents to its default font and style,you can use the _____ command.

To align currency symbols and decimal points in a column of numbers,you can apply the ____ number format.

Amari wants to paint the format of one object onto a target object.She selects the first object,then clicks on Format Painter,on the Clipboard group in the Home tab.She then observes the cursor change to a specific icon.Which of the following is the icon into which the cursor changed?

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

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

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

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

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

On which tab and button are document properties located for editing?

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