Excel Tut 2

The code _____ will display the filename of the current workbook.

&[File]

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1. Select and copy a range. 2. Click the Paste button arrow in the Clipboard group on the HOME Tab. 3. Specify exactly what you want to paste. 4. Click Paste Special to open the dialog box. 5. Select the range where you want to paste the Clipboard contents.

1, 5, 2, 4, 3

In Excel, dates are _____-aligned in the cell by default, regardless of date format.

right

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.

A1

In the accompanying figure, an example of a theme font is _____.

Calibri

In the accompanying figure, it shows that _____ is the theme font used for headings.

Calibri Light

_____ are an example of conditional formats in Excel.

Data bars

After you merge a range into a single cell, you cannot realign its content.

False

By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.

False

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

False

In the accompanying figure, the _____ indicates the font is 11pt.

Font size box

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.

Manuel page break

_____ merges each of the rows in the selected range across the columns in the range.

Merge Across

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

Number

Setting the _____ to A1:L10 will print only data in those cells.

Print Area

A conditional format can make negative numbers red and positive numbers black.

True

Changing the number of decimal places displayed in a cell does not change the value stored in the cell.

True

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.

True

Each header and footer has three sections—a left section, a center section, and a right section.

True

Formatting changes only the appearance of data—it does not affect the data itself.

True

The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data.

True

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook.

True

As a general rule, you should _____.

center column titles, left-align text, and right-align numbers

To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.

clear rules button

Header and footer elements such as worksheet name, current date, and time are _____ elements.

dynamic

The header and footer sections include a _____.

left, right, and center section

When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.

manual

One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.

merge

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

nonadjacent

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

numbers

The region that is sent to the printer from the active sheet is known as the ____________________.

print area

Information that prints on each page, like a company name or logo, may be set as a _____.

text header

A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.

theme

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

turn it off

In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

use the Number group to decrease number of digits displayed