Question 1

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

Accepted Answer

CTRL

Question 2

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.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

Chart Tools

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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.

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Cells that are entered as numbers align at the right.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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.

Accepted Answer

The answer of A/an ____________________ header or footer can be...

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

To scroll through a worksheet,

Accepted Answer

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 
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 17

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.

Accepted Answer

The answer of To combine data from multiple worksheets on...

Question 18

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.

Accepted Answer

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

Question 19

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

Accepted Answer

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 
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 20

In Excel , a range is expressed as

Accepted Answer

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

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

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.

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

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

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

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.

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

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

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

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

Cells that are entered as numbers align at the right.

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

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.

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

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

To scroll through a worksheet,

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.

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.

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

In Excel , a range is expressed as

Business Documents With Word

Presentations With Powerpoint

Publications With Publisher

Databases With Access

Desktop Information Management With Outlook

Filters

Exam 3: Spreadsheets With Excel

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

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.

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

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

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

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.

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

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

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

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

Cells that are entered as numbers align at the right.

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

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.

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

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

To scroll through a worksheet,

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.

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.

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

In Excel , a range is expressed as

Business Documents With Word

Presentations With Powerpoint

Publications With Publisher

Databases With Access

Desktop Information Management With Outlook

Filters