Question 1

When pasting a range of cells, you only need to select the ________ corner of the paste area.

Accepted Answer

A)  upper right 
B)  upper left 
C)  lower right 
D)  lower left 
A)  upper right 
B)  upper left 
C)  lower right 
D)  lower left

Question 2

Both the title bar and the worksheet tabs indicate a grouping.

Accepted Answer

A) True 
 B)False

Question 3

The color of a worksheet tab is the same for active and inactive worksheets.

Accepted Answer

A) True 
 B)False

Question 4

Worksheet tab names CANNOT include numbers.

Accepted Answer

A) True 
 B)False

Question 5

There are several ways to delete cell content.

Accepted Answer

A) True 
 B)False

Question 6

Match each paste option with its description.
-Transpose

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 7

Tab scrolling buttons are used to ________.

Accepted Answer

A)  scroll up and down through the active worksheet 
B)  scroll left and right through the active worksheet 
C)  zoom in and out on the active worksheet 
D)  display worksheet tabs that are not in view 
A)  scroll up and down through the active worksheet 
B)  scroll left and right through the active worksheet 
C)  zoom in and out on the active worksheet 
D)  display worksheet tabs that are not in view

Question 8

The ________ button appears to the right of the last worksheet tab in the Tab group.

Accepted Answer

The answer of The ________ button appears to the right...

Question 9

A deleted worksheet can be restored with the Undo button on the Quick Access Toolbar.

Accepted Answer

A) True 
 B)False

Question 10

Cell content and formatting can be copied from one worksheet in a workbook to another worksheet in the workbook.

Accepted Answer

A) True 
 B)False

Question 11

When an item is pasted, it is NOT removed from the Clipboard.

Accepted Answer

A) True 
 B)False

Question 12

Double-clicking a worksheet tab will ________.

Accepted Answer

A)  select the tab's name 
B)  move the tab to the beginning of the Tab group 
C)  move the tab to the end of the Tab group 
D)  make cell A1 the active cell 
A)  select the tab's name 
B)  move the tab to the beginning of the Tab group 
C)  move the tab to the end of the Tab group 
D)  make cell A1 the active cell

Question 13

Clustered bar charts display categories on the horizontal axis and values on the vertical axis.

Accepted Answer

A) True 
 B)False

Question 14

Clicking on a row heading ________.

Accepted Answer

A)  deletes the row 
B)  insert a row above the clicked row 
C)  selects the entire row 
D)  bolds the content of the entire row 
A)  deletes the row 
B)  insert a row above the clicked row 
C)  selects the entire row 
D)  bolds the content of the entire row

Question 15

Select a single ________ to cancel a grouping.

Accepted Answer

The answer of Select a single ________ to cancel a...

Question 16

When the Total style is applied to a group of worksheets, ________.

Accepted Answer

A)  only the first worksheet in the group receives the Total style 
B)  only the last worksheet in the group receives the Total style 
C)  all worksheets in the group receive the Total style 
D)  none of these worksheets receive the Total style because styles cannot be applied to grouped worksheets 
A)  only the first worksheet in the group receives the Total style 
B)  only the last worksheet in the group receives the Total style 
C)  all worksheets in the group receive the Total style 
D)  none of these worksheets receive the Total style because styles cannot be applied to grouped worksheets

Question 17

A formula can include cell references from the worksheet in which it is located but NOT from other worksheets in the workbook.

Accepted Answer

A) True 
 B)False

Question 18

Legend is an option in the ________ button, located by default to the right of a selected chart.

Accepted Answer

A)  Chart Styles 
B)  Chart Elements 
C)  Chart Filter 
D)  Chart Layout 
A)  Chart Styles 
B)  Chart Elements 
C)  Chart Filter 
D)  Chart Layout

Question 19

When a selection has been made and the cut button or copy button is clicked, the selection is ________.

Accepted Answer

A)  highlighted 
B)  surrounded by a moving border 
C)  surrounded by a red solid border 
D)  surrounded by a green solid border 
A)  highlighted 
B)  surrounded by a moving border 
C)  surrounded by a red solid border 
D)  surrounded by a green solid border

Question 20

Formulas with multiple operators CANNOT be entered in grouped worksheets.

Accepted Answer

A) True 
 B)False

When pasting a range of cells, you only need to select the ________ corner of the paste area.

Both the title bar and the worksheet tabs indicate a grouping.

The color of a worksheet tab is the same for active and inactive worksheets.

Worksheet tab names CANNOT include numbers.

There are several ways to delete cell content.

Match each paste option with its description. -Transpose

Tab scrolling buttons are used to ________.

The ________ button appears to the right of the last worksheet tab in the Tab group.

A deleted worksheet can be restored with the Undo button on the Quick Access Toolbar.

Cell content and formatting can be copied from one worksheet in a workbook to another worksheet in the workbook.

When an item is pasted, it is NOT removed from the Clipboard.

Double-clicking a worksheet tab will ________.

Clustered bar charts display categories on the horizontal axis and values on the vertical axis.

Clicking on a row heading ________.

Select a single ________ to cancel a grouping.

When the Total style is applied to a group of worksheets, ________.

A formula can include cell references from the worksheet in which it is located but NOT from other worksheets in the workbook.

Legend is an option in the ________ button, located by default to the right of a selected chart.

When a selection has been made and the cut button or copy button is clicked, the selection is ________.

Formulas with multiple operators CANNOT be entered in grouped worksheets.

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 pasting a range of cells, you only need to select the ________ corner of the paste area.

Both the title bar and the worksheet tabs indicate a grouping.

The color of a worksheet tab is the same for active and inactive worksheets.

Worksheet tab names CANNOT include numbers.

There are several ways to delete cell content.

Match each paste option with its description. -Transpose

Tab scrolling buttons are used to ________.

The ________ button appears to the right of the last worksheet tab in the Tab group.

A deleted worksheet can be restored with the Undo button on the Quick Access Toolbar.

Cell content and formatting can be copied from one worksheet in a workbook to another worksheet in the workbook.

When an item is pasted, it is NOT removed from the Clipboard.

Double-clicking a worksheet tab will ________.

Clustered bar charts display categories on the horizontal axis and values on the vertical axis.

Clicking on a row heading ________.

Select a single ________ to cancel a grouping.

When the Total style is applied to a group of worksheets, ________.

A formula can include cell references from the worksheet in which it is located but NOT from other worksheets in the workbook.

Legend is an option in the ________ button, located by default to the right of a selected chart.

When a selection has been made and the cut button or copy button is clicked, the selection is ________.

Formulas with multiple operators CANNOT be entered in grouped worksheets.

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