Deck 3: Spreadsheets With Excel

Question 1

The entry 906 West Palm Street would be interpreted by Excel as a number.

Answer 1

False

Question 2

The ____ command is used to locate and work with a subset of data in a worksheet.

A) Template
B) Filter
C) Sort
D) Freeze Panes

Answer 2

B

Question 3

The cell highlighted with a dark border is called the active cell.

Answer 3

True

Question 4

To average the range beginning with B6 and ending with B8, key

A) =B6+B7+B8
B) =B6..B8/3
C) =average(B6:B8)
D) average(B6..B8)

Question 5

The Range command is used in Excel to move to a specific part of a document.

Question 6

Cells that are entered as numbers align at the right.

Question 7

In Page Break Preview, dashed lines display automatic page breaks.

Question 8

To scroll through a worksheet,

A) click on the scroll box and drag it
B) click the up and down arrows on the scroll bar
C) click the area above or below the scroll box
D) all of the above

Question 9

Chart sheets are displayed

A) on the same page as the worksheet
B) on a separate sheet of the worksheet
C) in an entirely new file
D) none of the above

Question 10

Select the Sort Descending command to sort a range in alphabetical order from A-Z.

Question 11

An intersection of a column and a row is referred to as a/n

A) active cell
B) cell
C) cell pointer
D) function

Question 12

To filter a PivotTable, drag the desired filter field to the Report Filter box in the area below the fields on the Pivot Table Field List.

Question 13

In Excel , a range is expressed as

A) A1..D5
B) A1:D5
C) A1,A5
D) A1..A5..D1..D5

Question 14

The ____ function is entered to determine the number of reservations made for 8 p.m. on Friday night.

A) COUNT
B) MIN
C) MAX
D) SUM

Question 15

In a spreadsheet that contains a large amount of data, use the ____ command to summarize and rearrange data to answer specific questions, such as which course generated the greatest enrollment for which semester and for which instructor.

A) Filter
B) Mail Merge
C) PivotTable
D) Sort

Question 16

Which of the following formulas displays E5 as an absolute cell reference?

A) =A2*E5
B) =A2*$E5
C) =A2*$E5
D) =A2*$E$5

Question 17

The entry of a Social Security number (555-55-5555) would be interpreted by Excel as text.

Question 18

Columns include information arranged horizontally.

Question 19

If a cell displays with ####, the

A) entry has been keyed incorrectly
B) cell must be formatted correctly
C) cell is not wide enough for the entry
D) cell is too wide for the entry.

Question 20

A spreadsheet assists a user in managing numeric information and creating charts.

Question 21

To print a portion of a worksheet, you must select the area to be printed and click

A) Quick Print from the Office button
B) Print Area from the Page Setup group of the Page Layout tab
C) Print Titles from the Page Setup group of the Page Layout tab
D) Print Preview from the Office button

Question 22

Which command is used to repeat the column headings on the second page of a spreadsheet?

A) Print Titles
B) Freeze Titles
C) Freeze Panes
D) Repeat Titles

Question 23

To enter the year 2010 as a text entry, key ____ before the numbers 2010.

A) @
B) '
C) *
D) =

Question 24

To print a wide spreadsheet, change the orientation to ____________________.

Question 25

If cells are not adjacent, hold down the ____________________ key to select.

Question 26

To combine data from multiple worksheets on a summary worksheet, enter a/an ____________________ in a cell on the summary worksheet that will combine the data from the multiple worksheets.

Question 27

A/an ____________________ header or footer can be selected from a gallery of header and footers that contains a variety of text and page number designs.

Question 28

In a PivotTable, when a field is dragged to the Values section below the PivotTable Field List, the default value setting is ____.

A) Average
B) Count
C) Max
D) Sum

Question 29

To design and format a chart, use the commands on the ____________________ Design and Format tabs.

Question 30

Suppose that you want to change the color of the chart area of a column chart, and the chart area is not selected. Click ____, select the chart area, and edit the color.

A) Chart Elements
B) Format Chart Area
C) Format Selection
D) Reset to Match Style