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
