Question 1

When the serial number for a date appears in a selected cell in the worksheet, it also appears as the underlying value in the formula bar.

Accepted Answer

A) True 
 B)False

Question 2

The name of a worksheet tab can have as many as ________ characters.

Accepted Answer

The answer of The name of a worksheet tab can...

Question 3

The Show Formulas button is a toggle button.

Accepted Answer

A) True 
 B)False

Question 4

Clicking the Paste button places the ________ in the destination cells.

Accepted Answer

A)  cell content only 
B)  cell formatting only 
C)  cell content and cell formatting 
D)  cell content, cell formatting, and column width 
A)  cell content only 
B)  cell formatting only 
C)  cell content and cell formatting 
D)  cell content, cell formatting, and column width

Question 5

A single-click or double-click on a worksheet tab makes that worksheet active.

Accepted Answer

A) True 
 B)False

Question 6

When several worksheets are grouped, inserting a row ________.

Accepted Answer

A)  inserts it only into the first worksheet in the group 
B)  inserts it into all of the worksheets in the group 
C)  displays an error message 
D)  fails to insert a row into any of the worksheets in the group 
A)  inserts it only into the first worksheet in the group 
B)  inserts it into all of the worksheets in the group 
C)  displays an error message 
D)  fails to insert a row into any of the worksheets in the group

Question 7

When Clear Content is selected from the Clear button options, only the ________ is removed from the cell.

Accepted Answer

A)  fill 
B)  text 
C)  comment 
D)  hyperlink 
A)  fill 
B)  text 
C)  comment 
D)  hyperlink

Question 8

Worksheet tabs CANNOT be added to a worksheet.

Accepted Answer

A) True 
 B)False

Question 9

When worksheets in a workbook are grouped, the word Group is displayed on the ________.

Accepted Answer

The answer of When worksheets in a workbook are grouped,...

Question 10

Which date is assigned the serial number of 1?

Accepted Answer

A)  January 1, 2000 
B)  January 1, 1900 
C)  January 1, 1800 
D)  January 1, 1700 
A)  January 1, 2000 
B)  January 1, 1900 
C)  January 1, 1800 
D)  January 1, 1700

Question 11

Selecting a row and clicking the Insert command, inserts a row above the selected row.

Accepted Answer

A) True 
 B)False

Question 12

In a formula that references a cell in another worksheet, the name of the worksheet is followed by a(n) ________.

Accepted Answer

The answer of In a formula that references a cell...

Question 13

What feature is useful in creating or modifying a set of worksheets that are similar in purpose and structure?

Accepted Answer

The answer of What feature is useful in creating or...

Question 14

When data are entered in a cell and formatting is applied to a cell in one worksheet in a group, the corresponding cells in the other grouped worksheets also receive the data and formatting.

Accepted Answer

A) True 
 B)False

Question 15

Match each paste option with its description.
-Formatting

Accepted Answer

A) Pastes only formatting to paste area 
B) Pastes content and formatting to paste area 
C) Pastes only formulas to paste area 
D) Pastes all content and formatting, including column width formatting, to paste area 
E) Rows from original cells are pasted as columns in paste area 
A) Pastes only formatting to paste area 
B) Pastes content and formatting to paste area 
C) Pastes only formulas to paste area 
D) Pastes all content and formatting, including column width formatting, to paste area 
E) Rows from original cells are pasted as columns in paste area

Question 16

Match each paste option with its description.
-Paste

Accepted Answer

A) Pastes only formatting to paste area 
B) Pastes content and formatting to paste area 
C) Pastes only formulas to paste area 
D) Pastes all content and formatting, including column width formatting, to paste area 
E) Rows from original cells are pasted as columns in paste area 
A) Pastes only formatting to paste area 
B) Pastes content and formatting to paste area 
C) Pastes only formulas to paste area 
D) Pastes all content and formatting, including column width formatting, to paste area 
E) Rows from original cells are pasted as columns in paste area

Question 17

The ________ option stops a worksheet tab from being displayed at the bottom of a workbook.

Accepted Answer

The answer of The ________ option stops a worksheet tab...

Question 18

A worksheet tab can be repositioned in the Tab group by ________ the tab to the new location.

Accepted Answer

clicking a

Question 19

Excel evaluates the formula =4-2*6/2+7 and performs ________ first.

Accepted Answer

A)  Subtraction 
B)  Multiplication 
C)  Division 
D)  Addition 
A)  Subtraction 
B)  Multiplication 
C)  Division 
D)  Addition

Question 20

A ________ is a worksheet with cells referred to by summary sheet formulas.

Accepted Answer

A)  total sheet 
B)  detail sheet 
C)  cover sheet 
D)  properties sheet 
A)  total sheet 
B)  detail sheet 
C)  cover sheet 
D)  properties sheet

When the serial number for a date appears in a selected cell in the worksheet, it also appears as the underlying value in the formula bar.

The name of a worksheet tab can have as many as ________ characters.

The Show Formulas button is a toggle button.

Clicking the Paste button places the ________ in the destination cells.

A single-click or double-click on a worksheet tab makes that worksheet active.

When several worksheets are grouped, inserting a row ________.

When Clear Content is selected from the Clear button options, only the ________ is removed from the cell.

Worksheet tabs CANNOT be added to a worksheet.

When worksheets in a workbook are grouped, the word Group is displayed on the ________.

Which date is assigned the serial number of 1?

Selecting a row and clicking the Insert command, inserts a row above the selected row.

In a formula that references a cell in another worksheet, the name of the worksheet is followed by a(n) ________.

What feature is useful in creating or modifying a set of worksheets that are similar in purpose and structure?

When data are entered in a cell and formatting is applied to a cell in one worksheet in a group, the corresponding cells in the other grouped worksheets also receive the data and formatting.

Match each paste option with its description. -Formatting

Match each paste option with its description. -Paste

The ________ option stops a worksheet tab from being displayed at the bottom of a workbook.

A worksheet tab can be repositioned in the Tab group by ________ the tab to the new location.

Excel evaluates the formula =4-2*6/2+7 and performs ________ first.

A ________ is a worksheet with cells referred to by summary sheet formulas.

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters

Exam 9: Manage Multiple Worksheets

When the serial number for a date appears in a selected cell in the worksheet, it also appears as the underlying value in the formula bar.

The name of a worksheet tab can have as many as ________ characters.

The Show Formulas button is a toggle button.

Clicking the Paste button places the ________ in the destination cells.

A single-click or double-click on a worksheet tab makes that worksheet active.

When several worksheets are grouped, inserting a row ________.

When Clear Content is selected from the Clear button options, only the ________ is removed from the cell.

Worksheet tabs CANNOT be added to a worksheet.

When worksheets in a workbook are grouped, the word Group is displayed on the ________.

Which date is assigned the serial number of 1?

Selecting a row and clicking the Insert command, inserts a row above the selected row.

In a formula that references a cell in another worksheet, the name of the worksheet is followed by a(n) ________.

What feature is useful in creating or modifying a set of worksheets that are similar in purpose and structure?

When data are entered in a cell and formatting is applied to a cell in one worksheet in a group, the corresponding cells in the other grouped worksheets also receive the data and formatting.

Match each paste option with its description. -Formatting

Match each paste option with its description. -Paste

The ________ option stops a worksheet tab from being displayed at the bottom of a workbook.

A worksheet tab can be repositioned in the Tab group by ________ the tab to the new location.

Excel evaluates the formula =4-2*6/2+7 and performs ________ first.

A ________ is a worksheet with cells referred to by summary sheet formulas.

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters