Question 1

Which symbol inserted between two cell addresses indicates a range?

Accepted Answer

A)  colon 
B)  semi-colon 
C)  period 
D)  comma 
A)  colon 
B)  semi-colon 
C)  period 
D)  comma

Question 2

A word identified as misspelled in the Spelling dialog box may actually be spelled correctly.

Accepted Answer

A) True 
 B)False

Question 3

When a cell is active, its column and row headings are ________.

Accepted Answer

A)  flashing 
B)  hidden 
C)  bolded 
D)  shaded 
A)  flashing 
B)  hidden 
C)  bolded 
D)  shaded

Question 4

The ________ option in the Spelling dialog box inserts a word identified as misspelled into the Office dictionary.

Accepted Answer

A)  AutoCorrect 
B)  Change 
C)  Change All 
D)  Add to Dictionary 
A)  AutoCorrect 
B)  Change 
C)  Change All 
D)  Add to Dictionary

Question 5

If the numeric values in cells B1:B9 are selected, and row 10 is empty when the AutoSum button is clicked, the sum of the range (B1:B9) appears in cell ________.

Accepted Answer

The answer of If the numeric values in cells B1:B9...

Question 6

Non-adjacent cells can be selected in a worksheet by holding down the ________ key.

Accepted Answer

A)  Alt 
B)  Home 
C)  Ctrl 
D)  Shift 
A)  Alt 
B)  Home 
C)  Ctrl 
D)  Shift

Question 7

Worksheet headers and footers are divided into three sections-left, middle, right.

Accepted Answer

A) True 
 B)False

Question 8

Match the worksheet term with its corresponding meaning.
-Name Box

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 9

The ________ displays a list of functions that match the first letter typed.

Accepted Answer

A)  Formula AutoComplete feature 
B)  edit feature 
C)  Quick Access Toolbar 
D)  formula bar 
A)  Formula AutoComplete feature 
B)  edit feature 
C)  Quick Access Toolbar 
D)  formula bar

Question 10

When the Center on page Horizontally option is checked on the Margins tab of the Page Setup dialog box, the worksheet cells with content are ________.

Accepted Answer

A)  centered between the left and right margins 
B)  centered between the top and bottom margins 
C)  centered between the left and right edges of the printed page 
D)  centered between the top and bottom edges of the printed page 
A)  centered between the left and right margins 
B)  centered between the top and bottom margins 
C)  centered between the left and right edges of the printed page 
D)  centered between the top and bottom edges of the printed page

Question 11

When no cells are selected and the AutoSum button is clicked, Excel first looks ________ the active cell for a suitable range to sum.

Accepted Answer

A)  above 
B)  below 
C)  to the right of 
D)  to the left of 
A)  above 
B)  below 
C)  to the right of 
D)  to the left of

Question 12

Number values are aligned at the ________ cell edge.

Accepted Answer

The answer of Number values are aligned at the ________...

Question 13

The ________ button can be used to combine a selected row of cells into a single cell that spans multiple columns.

Accepted Answer

The answer of The ________ button can be used to...

Question 14

A formula in a worksheet begins with a(n) ________.

Accepted Answer

The answer of A formula in a worksheet begins with...

Which symbol inserted between two cell addresses indicates a range?

A word identified as misspelled in the Spelling dialog box may actually be spelled correctly.

When a cell is active, its column and row headings are ________.

The ________ option in the Spelling dialog box inserts a word identified as misspelled into the Office dictionary.

If the numeric values in cells B1:B9 are selected, and row 10 is empty when the AutoSum button is clicked, the sum of the range (B1:B9) appears in cell ________.

Non-adjacent cells can be selected in a worksheet by holding down the ________ key.

Worksheet headers and footers are divided into three sections-left, middle, right.

Match the worksheet term with its corresponding meaning. -Name Box

The ________ displays a list of functions that match the first letter typed.

When the Center on page Horizontally option is checked on the Margins tab of the Page Setup dialog box, the worksheet cells with content are ________.

When no cells are selected and the AutoSum button is clicked, Excel first looks ________ the active cell for a suitable range to sum.

Number values are aligned at the ________ cell edge.

The ________ button can be used to combine a selected row of cells into a single cell that spans multiple columns.

A formula in a worksheet begins with a(n) ________.

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

Which symbol inserted between two cell addresses indicates a range?

A word identified as misspelled in the Spelling dialog box may actually be spelled correctly.

When a cell is active, its column and row headings are ________.

The ________ option in the Spelling dialog box inserts a word identified as misspelled into the Office dictionary.

If the numeric values in cells B1:B9 are selected, and row 10 is empty when the AutoSum button is clicked, the sum of the range (B1:B9) appears in cell ________.

Non-adjacent cells can be selected in a worksheet by holding down the ________ key.

Worksheet headers and footers are divided into three sections-left, middle, right.

Match the worksheet term with its corresponding meaning. -Name Box

The ________ displays a list of functions that match the first letter typed.

When the Center on page Horizontally option is checked on the Margins tab of the Page Setup dialog box, the worksheet cells with content are ________.

When no cells are selected and the AutoSum button is clicked, Excel first looks ________ the active cell for a suitable range to sum.

Number values are aligned at the ________ cell edge.

The ________ button can be used to combine a selected row of cells into a single cell that spans multiple columns.

A formula in a worksheet begins with a(n) ________.

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