ITE 115 Excel Module 2

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

Select the right footer text box and type your name.

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

left center

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

merge and center button

To change the color of cell content, you use the ________ color list arrow.

Font

The Clipboard task pane shows the contents of the _____.

Office Clipboard

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?

Page Layout

You can edit a worksheet footer in _____.

Page Layout view

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?

Paintbrush

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?

Top/Bottom Rules

Currency is an example of a number format.

True

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

True

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

True

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?

X- Margins, Y- Custom Margins

You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the _____ feature.

find and replace

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

font

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

False

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

File tab, Info Button

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

True

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

true

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

Accounting

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

true

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

true

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

two

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

type

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

False

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

39

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

Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.

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?

Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.

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?

Design

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

False

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

Home tab Format Cells dialog box Mini toolbar

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?

Margins

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

Orientation

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

Paste button Paste Preview Paste list arrow Paste option icon

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?

Pick the color set he wants.

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

Quick Analysis tool

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.

True

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.

True

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

color

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

conditional formatting

The Comma Style format adds a comma and a dollar sign to a cell value.

false