Question 1

Dotted page break lines appear in a worksheet after it is viewed in Print Preview.

Accepted Answer

A) True 
 B)False

Question 2

When a predefined header or footer is inserted into a worksheet, a(n) ________ is used to provide instructions for printing.

Accepted Answer

The answer of When a predefined header or footer is...

Question 3

The terms displayed value and underlying value are always synonymous.

Accepted Answer

A) True 
 B)False

Question 4

Clarify data in a row or column by typing a(n) ________ at the beginning of the row or column.

Accepted Answer

The answer of Clarify data in a row or column...

Question 5

When a formula has a cell reference, the ________ value of the cell is used in the formula calculation.

Accepted Answer

The answer of When a formula has a cell reference,...

Question 6

Which is NOT an option in the Auto Fill Options menu?

Accepted Answer

A)  Copy Cells 
B)  Fill Series 
C)  Paste Cells 
D)  Fill Format Only 
A)  Copy Cells 
B)  Fill Series 
C)  Paste Cells 
D)  Fill Format Only

Question 7

The dimensions of a printed worksheet can be adjusted with ________ so that the worksheet prints on a specified number of pages.

Accepted Answer

The answer of The dimensions of a printed worksheet can...

Question 8

When the header or the footer of a worksheet is active, the Header & Footer Tools Layout contextual tab appears on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 9

The content of a cell can be edited in the worksheet by double-clicking the cell.

Accepted Answer

A) True 
 B)False

Question 10

The Increase Decimal button and the Decrease Decimal button are in the ________ group on the Home tab.

Accepted Answer

The answer of The Increase Decimal button and the Decrease...

Question 11

Which cells are included in the sum calculated by the function =SUM(D5:G5)?

Accepted Answer

A)  D5, E5, and F5 
B)  E5, F5, and G5 
C)  E5 and F5 
D)  D5, E5, F5, and G5 
A)  D5, E5, and F5 
B)  E5, F5, and G5 
C)  E5 and F5 
D)  D5, E5, F5, and G5

Question 12

Labels are text data values entered at the top of a column or the beginning of a row to clarify the data in the worksheet.

Accepted Answer

A) True 
 B)False

Question 13

When Excel opens, a new blank ________ is displayed.

Accepted Answer

A)  presentation 
B)  document 
C)  workbook 
D)  database 
A)  presentation 
B)  document 
C)  workbook 
D)  database

Question 14

Two or more adjacent cells in a worksheet are a(n) ________.

Accepted Answer

A)  unit 
B)  group 
C)  range 
D)  array 
A)  unit 
B)  group 
C)  range 
D)  array

Question 15

If an error is made entering a formula, the Enter key can be pressed to remove the contents and start over.

Accepted Answer

A) True 
 B)False

Question 16

Match the worksheet term with its corresponding meaning.
-Underlying value

Accepted Answer

A) Data displayed in the formula bar 
B) Data displayed in a worksheet cell 
C) Two or more adjacent cells in a worksheet 
D) Feature that displays a portion of text content in a cell 
E) Area that displays active cell reference 
A) Data displayed in the formula bar 
B) Data displayed in a worksheet cell 
C) Two or more adjacent cells in a worksheet 
D) Feature that displays a portion of text content in a cell 
E) Area that displays active cell reference

Question 17

In Excel the term worksheet and ________ mean the same thing.

Accepted Answer

A)  spreadsheet 
B)  datasheet 
C)  reference sheet 
D)  workbook 
A)  spreadsheet 
B)  datasheet 
C)  reference sheet 
D)  workbook

Question 18

A row or column is inserted into a worksheet at the location of the selected cell or cells.

Accepted Answer

A) True 
 B)False

Question 19

The Merge & Center button is in the ________ group on the Home tab.

Accepted Answer

A)  Font 
B)  Alignment 
C)  Number 
D)  Cells 
A)  Font 
B)  Alignment 
C)  Number 
D)  Cells

Question 20

Match the worksheet term with its corresponding meaning.
-Range

Accepted Answer

A) Data displayed in the formula bar 
B) Data displayed in a worksheet cell 
C) Two or more adjacent cells in a worksheet 
D) Feature that displays a portion of text content in a cell 
E) Area that displays active cell reference 
A) Data displayed in the formula bar 
B) Data displayed in a worksheet cell 
C) Two or more adjacent cells in a worksheet 
D) Feature that displays a portion of text content in a cell 
E) Area that displays active cell reference

Dotted page break lines appear in a worksheet after it is viewed in Print Preview.

When a predefined header or footer is inserted into a worksheet, a(n) ________ is used to provide instructions for printing.

The terms displayed value and underlying value are always synonymous.

Clarify data in a row or column by typing a(n) ________ at the beginning of the row or column.

When a formula has a cell reference, the ________ value of the cell is used in the formula calculation.

Which is NOT an option in the Auto Fill Options menu?

The dimensions of a printed worksheet can be adjusted with ________ so that the worksheet prints on a specified number of pages.

When the header or the footer of a worksheet is active, the Header & Footer Tools Layout contextual tab appears on the Ribbon.

The content of a cell can be edited in the worksheet by double-clicking the cell.

The Increase Decimal button and the Decrease Decimal button are in the ________ group on the Home tab.

Which cells are included in the sum calculated by the function =SUM(D5:G5)?

Labels are text data values entered at the top of a column or the beginning of a row to clarify the data in the worksheet.

When Excel opens, a new blank ________ is displayed.

Two or more adjacent cells in a worksheet are a(n) ________.

If an error is made entering a formula, the Enter key can be pressed to remove the contents and start over.

Match the worksheet term with its corresponding meaning. -Underlying value

In Excel the term worksheet and ________ mean the same thing.

A row or column is inserted into a worksheet at the location of the selected cell or cells.

The Merge & Center button is in the ________ group on the Home tab.

Match the worksheet term with its corresponding meaning. -Range

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

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 7: Create Workbooks With Excel 2013

Dotted page break lines appear in a worksheet after it is viewed in Print Preview.

When a predefined header or footer is inserted into a worksheet, a(n) ________ is used to provide instructions for printing.

The terms displayed value and underlying value are always synonymous.

Clarify data in a row or column by typing a(n) ________ at the beginning of the row or column.

When a formula has a cell reference, the ________ value of the cell is used in the formula calculation.

Which is NOT an option in the Auto Fill Options menu?

The dimensions of a printed worksheet can be adjusted with ________ so that the worksheet prints on a specified number of pages.

When the header or the footer of a worksheet is active, the Header & Footer Tools Layout contextual tab appears on the Ribbon.

The content of a cell can be edited in the worksheet by double-clicking the cell.

The Increase Decimal button and the Decrease Decimal button are in the ________ group on the Home tab.

Which cells are included in the sum calculated by the function =SUM(D5:G5)?

Labels are text data values entered at the top of a column or the beginning of a row to clarify the data in the worksheet.

When Excel opens, a new blank ________ is displayed.

Two or more adjacent cells in a worksheet are a(n) ________.

If an error is made entering a formula, the Enter key can be pressed to remove the contents and start over.

Match the worksheet term with its corresponding meaning. -Underlying value

In Excel the term worksheet and ________ mean the same thing.

A row or column is inserted into a worksheet at the location of the selected cell or cells.

The Merge & Center button is in the ________ group on the Home tab.

Match the worksheet term with its corresponding meaning. -Range

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

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