Excel Tut 2 – Flashcards

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

As a general rule, you should _____.

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

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

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

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 _____.

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.

_____ are an example of conditional formats in Excel.

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

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

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

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

The header and footer sections include a _____.

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

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?

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

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

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

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

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

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