Excel Module 2
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?
click on the select button in Rows to repeat at top area and select title row
A predesigned combination of formats, such as font size and color, is called a cell default. T/F
false
Decreasing a cell's indent move its contents to the right one space. T/F
false
TO combine multiple cells into one and center its content, you change the cell's style. T/F
false
TO move cell contents one space to the right, you can use the Increase Space button. T/F
false
To change the background color of a cell, you use the Background color button. T/F
false
To see how copied contents will look with both values and number formatting, you would use Paste Numbers. T/F
false
To rotate cell contents to an exact value, you change its...
orientation
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
Currency is an example of a number format. T/F
true
TO change the background colors in a Power View report, click the POWERVIEW tab> Themes group> Background> Select a color. T/F
true
To insert info that appears at the bottom of every worksheet page, you can use a command on the Insert tab. T/F
true
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. T/F
true
You can apply date formats to cells by using the Date category in the Format Cells dialog box. T/F
true
You can repeatedly paste an item from the Office Clipboard as many times as you like. T/F
true
You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the ____ feature.
Find and Replace
TO format a cell range so that values between 100 and 500 appear in red, which of the following can you use?
Highlight Cells Rules
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
You can create conditional cell formats using either the Home tab or the...
Quick Analysis tool
Clicking the Percentage style in the Number Format list applies ___ decimal places by default.
2
To combine multiple cells into one combined cell, which of the following do you use?
Merge and Center button
Which of the following should be selected as X in the series of clicks to cave a custom theme: X> Themes group> Themes> Custom> Document theme you want to use?
Page Layout
To paste copied cell contents with values only, not including formatting, which of the following can you use?
Paste option icon, Paste list arrow, and Paste Preview
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
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 groups> X> Page Layout tab> Page Setup group> Y> Reset All Page Breaks?
X-Page break Preview, Y-Breaks
