Excel-120

What code does Excel insert when you click the Current Date button on the HEADER & FOOTER TOOLS DESIGN tab?

&[Date]

This is the code that Excel enters in a header or footer when the Sheet Name button is clicked.

&[Tab]

When you save a workbook in an Excel 97-2003 format, the ____ extension is applied.

.xls

By default, Excel 2013 workbooks are saved with the ____ extension.

.xlsx

How many rows can an Excel 2013 workbook contain?

1,048,576

When the worksheet is set to 100% magnification, clicking the Zoom In or Zoom Out buttons at either side of the Zoom slider bar magnifies or shrinks the display of the worksheet by _____ each time the button is clicked.

10%

Excel stores up to ____ actions that can be undone or redone using buttons on the Quick Access toolbar.

100

A range name can include up to this many characters:

255

A header contains ____ boxes.

3

A formula is said to contain a(n) ____ reference when it references a cell spanning two or more worksheets.

3-D

By default, Excel column widths are set at ____ characters, and row heights at ____ points.

8.11; 14.40

Which of the following is an example of a formula with a 3-D reference?

=SUM('Qtr1:Qtr4'!E4)

Which of the following examples makes use of a range?

=SUM(D2:R2)

Without pointing to it, how can you tell if a cell contains a comment?

A diagonal red triangle appears in the upper right corner.

How can you display a list of range names to make editing or deleting them easier?

Click the Name Manager button in the Defined Names group on the FORMULAS tab.

After you have filtered a table, what is one way to get Excel to once again display all the records?

Click the Select All check box on the filtered column's drop-down list.

If you do not want to widen a column, what can you do to fit the text into the column?

Click the Wrap Text button in the Alignment group.

How do you create a shape in your worksheet using the Shapes button?

Click the desired shape and then click and drag in the worksheet to draw the shape.

You can copy the contents of a cell by using either the Copy and Paste functions or the fill handle feature. What is the difference between these two methods?

Copy and Paste copies the contents to the Clipboard; fill handle does not.

When editing a cell address, pressing ____ causes Excel to insert dollar symbols in front of the row and column number immediately to the left of the insertion point.

F4

The _____ tab displays the backstage area that contains options for working with and managing files.

FILE

Which of these buttons can be used to find an Excel function by typing a description of the formula?

Insert Function

Click the Online Pictures button in the Illustrations group on the INSERT tab and the _____ displays:

Insert Pictures window

How does Excel place comments in a worksheet?

It anchors them to the active cell.

Which of the following statements describes how the Borders button changes?

It updates to display the most recently selected border style.

How does the AVERAGE function deal with empty cells and cells containing a zero value?

It uses the zero values in the calculation, but ignores the empty cells.

Dates in Excel are stored as a serial number starting with ____ as 1 and increasing sequentially.

January 1, 1900

On which tab of the Page Setup dialog box will you find options for centering your worksheet horizontally and/or vertically on the page?

Margins

To center text between the top and bottom of a cell, click the _____ button in the Alignment group on the HOME tab.

Middle Align

A chart can be placed in the same worksheet as the data or it can be inserted into its own sheet with options at this dialog box.

Move Chart

To change margins in your worksheet, click the margins gallery in the ____ category in the Print backstage area.

Settings

Save files in a different format with options at this backstage area.

Share

This keyboard shortcut inserts a new comment.

Shift + F2

Miniature charts that illustrate changes in a row or column of data and fit in a cell are called

Sparklines

Make the text in the Excel Help window larger by clicking this button.

Use Large Text

What does the Add Level button in the Sort dialog box do?

adds another row to the dialog box so you can sort by additional columns

The default settings in Excel's Print backstage area are to print one copy of

all pages in the active worksheet.

In Page Break Preview, grayed-out cells

are not within the print area.

How are time values stored in Excel?

as decimal numbers that represent the portion of the day

The options for choosing a template are available

at the New backstage area

When you click the New sheet button, where is the new worksheet placed?

at the end of the existing worksheets

By default, Excel aligns values

at the left edge of the column.

In Page Break Preview, a dashed blue line indicates this type of page break.

automatic

When you type data in a row immediately below an existing table, Excel

automatically expands the table and applies the same formatting.

When you change the color of the fill in a cell, you are changing its

background

What does Excel's Freeze Panes option do?

causes the specified rows and columns to remain fixed while scrolling

Column, line, pie, bar, area, and scatter are types of Excel

charts

What does the Ctrl + F4 keyboard shortcut do?

closes a workbook

A ____ is a user-created pop-up box containing text.

comment

The Clear All option in the Clear button removes the ____ from the active cell.

contents, formats, and comments

What does the Format Painter feature do?

copies formats from a selected cell to another cell

When the active cell contains a formula, dragging the fill handle causes Excel to

copy the formula and change the cell references relative to each destination location.

This type of line indicates a page break in a worksheet.

dashed line

In Page Break Preview, page breaks are shown as ____ lines.

dashed or solid blue

To create an absolute cell address, type this character in front of the column letter or row number that you do not want to change.

dollar sign ($)

When changing a column width by dragging the boundary line to the right or left, a ____ is displayed to indicate the new width.

dotted line

To copy a format from the active cell and paste it multiple times to other cells, begin by ____ the Format Painter button.

double-clicking

This action sets the width of a column to fit the longest entry in the column.

double-clicking the boundary line

In a 3-D range, this punctuation mark separates the worksheet range from the cell reference.

exclamation point (!)

What is the green square at the bottom right corner of an active cell?

fill handle

A ____ is used to display only certain records within a table that meet the specified criteria.

filter

When you format a range of cells as a table, Excel displays ____ in the first row of the table.

filter arrows

The ____ is the typeface used to display and print data. It is measured in ____.

fonts; points

When you point at the border of a selected range of cells, the mouse pointer changes to a white arrow with the move icon attached. The move icon is represented by a

four-headed arrow

Excel features built-in, preprogrammed formulas called

functions.

A(n) ____ is an entry in a cell that helps the reader understand the values in the corresponding column or row.

label

The Find & Replace dialog box can be used to search for and replace

labels, values, and formats

In an Excel worksheet, columns are referenced with ____, while rows are referenced with ____.

letters; numbers

This type of Excel chart is used to depict trends and change over time intervals.

line

What is the first argument required by Excel's built-in IF function?

logical test

When included in a formula, which of the following operators does Excel calculate first?

negation

How many data series does a pie chart generally use?

one

A new Excel workbook initially contains

one worksheet named Sheet1

Ctrl + F is the keyboard shortcut for

opening the Find & Replace dialog box with the Find tab active.

This type of Excel chart is especially useful in showing a data point's size in proportion to the total of all points in the data source range.

pie

When you hold down the Ctrl key and drag a selected range of cells, a ____ attached to the pointer indicates that the source contents are being ____.

plus sign; copied

One of the arguments needed in the PMT function is pv. What does pv stand for?

present value

Which of the following options is not available in the Settings section of the Print backstage area?

printer types

A _____ is a group of adjacent cells in an Excel worksheet.

range

By default, when a formula is copied and pasted from one cell to another, Excel automatically changes the cell addresses to reflect the destination location. This is referred to as ____ addressing.

relative

When copying or moving cells, if data already exists in the destination cells, Excel

replaces the content

By default, Excel aligns date entries at the ____ of the column.

right edge

How do you activate the worksheet shortcut menu?

right-click the worksheet tab

When navigating a worksheet, which of the following methods does not move the position of the active cell?

scrolling with the scroll bars

The first step in creating an Excel chart is to

select the range of cells containing the data to be charted.

Use options in the Page Setup dialog box with this tab selected to specify printing comments in a worksheet.

sheet

Which of the following characters cannot be used when creating a range name?

space

Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.

styles

By default, Excel sorts data alphanumerically, which means entries are sorted in this order:

symbols first, then numbers, then letters

To ungroup grouped worksheets, click Ungroup Sheets in the

tab shortcut menu

Excel contains worksheets that are preformatted and contain text and formulas designed for specific uses. These worksheets are called

templates

All formulas in Excel begin with

the equals sign (=).

The MAX functions returns

the largest value in the argument.

One component of an Excel function is the argument. What is an argument?

the values identified within the function's parentheses

Selecting which of these formatting options will always change the entire worksheet?

themes

Section 1 suggests that when working with formulas in Excel, it is a good idea to create proof formulas. Why?

to check the computations in your formulas

A chart can be modified when it is clicked, and its border becomes

translucent.

Information created in Excel is saved in a file called a

workbook.

The portion of the Excel screen containing the lettered columns and numbered rows is called the

worksheet area.

The Sort & Filter button is located in the _____ group on the HOME tab.

Editing

One way to access Help resources in Excel is to point to a button on a tab and then press the ____ function key.

F1

This keyboard shortcut displays the Save As dialog box to save an Excel file in a different file format.

F12

____ view allows you to see your worksheet along with the print settings.

Page Layout

Which of the following statements correctly describes the relationship between row height and font size?

Row height is automatically increased to accommodate an increase in font size.

When you convert a file to a different format in Excel 2013, you can do this in the

Save As dialog box

This is the command to insert a line break within a cell.

Alt + Enter

This keyboard movement command moves the active cell one screen to the left.

Alt + Page Up

When a chart is selected, these tabs becomes available.

CHART TOOLS DESIGN and CHART TOOLS FORMAT

Holding down this key while dragging a worksheet tab will create a copy of the worksheet in the new position.

Ctrl

You can group multiple nonadjacent worksheets by holding down the ____ key while clicking each tab.

Ctrl

This keyboard shortcut displays the Print backstage area.

Ctrl + P

The keyboard shortcut for cutting the selection and placing it on the Clipboard is

Ctrl + X

The keyboard shortcut for repeating a command is

Ctrl + Y

This keyboard shortcut turns on or off the display of formulas.

Ctrl + `

Which of the following is not one of the groups of shapes listed on the Shapes button?

Cycle

This part of the Excel screen displays the contents of the active cell.

Formula bar

Which cell format is used by default in Excel?

General

On which tab will you find the Insert button?

HOME

Specify the appearance of dates in a worksheet with options at the Format Cells dialog box with this tab selected.

Number

You can decrease the number of decimal places displayed in a number by clicking the Decrease Decimal button, which is located in the ____ group on the ____ tab.

Number; HOME

To search for and insert images at Office.com, use the _____ button on the INSERT tab.

Online Pictures

The ____ button in the Alignment group on the HOME tab can be used to rotate text within cells.

Orientation

The Themes group is located on the ____ tab.

PAGE LAYOUT

Which view displays horizontal and vertical rulers to assist with measurements?

Page Layout

You want to specify rows and columns to repeat on each printed page of your worksheet. Begin by clicking this button in the Page Setup group on the PAGE LAYOUT tab.

Print Titles

To insert a comment, click the New Comment button in the Comments group on the ____ tab.

REVIEW

To which function category do the COUNT, MAX, and AVERAGE functions belong?

Statistical

Suppose a cell in your worksheet contains the formula =B$7*0.5. How would this formula change if it were copied to another cell?

The column will remain fixed at column B, but the row will change.

What happens when you click the Increase Indent button?

The contents of the active cell are indented approximately one character width.

What happens when you change the value of a cell that is referenced elsewhere in a formula?

The worksheet is automatically recalculated so that all values are current.

What happens when you click and drag a worksheet tab in Excel?

The worksheet is moved to a different position in the workbook.

This Excel feature can be used to replace a word in the worksheet with another word of similar meaning.

Thesaurus

The Freeze Panes button is located in the ____ group on the ____ tab.

Window; VIEW

Excel's Accounting format adds ____ to the value in the cell.

a comma in the thousands place

You can edit a chart by right-clicking one of its elements to display

a context-sensitive shortcut menu.

When you sort a table by one of its columns from largest to smallest, what appears in the filter button for the sort column?

a down-pointing black arrow

What image appears on the Microsoft Excel Help button near the upper right corner of the screen?

a question mark (?)

When you use the Formula AutoComplete list box to enter a formula, the first portion of the function is inserted in the active cell, and the required syntax for the arguments appears in

a screen tip

Inserted rows are placed ____ the selected row(s) and inserted columns are placed to the ____ of the selected column(s).

above; left

Excel's Spell Check feature begins checking at the

active cell.