Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Spell-checking a worksheet.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 2

Which of the following calculations multiplies 23 by 0.01?

Accepted Answer

A)  =23% 
B)  =23 
C)  =23+.01 
D)  =24-.01 
A)  =23% 
B)  =23 
C)  =23+.01 
D)  =24-.01

Question 3

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Accepted Answer

A)  Normal 
B)  Page Layout 
C)  Page Break Preview 
D)  Full Screen 
A)  Normal 
B)  Page Layout 
C)  Page Break Preview 
D)  Full Screen

Question 4

Moving from left to right, the first calculation in the order of operations is negation (-).

Accepted Answer

A) True 
 B)False

Question 5

____________________ view shows the worksheet divided into pages.

Accepted Answer

The answer of ____________________ view shows the worksheet divided into...

Question 6

Cooler colors tend to pull away from the reader.

Accepted Answer

A) True 
 B)False

Question 7

The / arithmetic operator indicates ____________________.

Accepted Answer

The answer of The / arithmetic operator indicates ____________________....

Question 8

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

A)  Find Error 
B)  Explain Error 
C)  Fix Error 
D)  Trace Error 
A)  Find Error 
B)  Explain Error 
C)  Fix Error 
D)  Trace Error

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Opens the Format Cells dialog box.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 10

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Accepted Answer

The answer of The ____________________ is a small black square...

Question 11

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Accepted Answer

The answer of Excel includes a(n) ____________________ you can use...

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Spell-checking a worksheet.

Which of the following calculations multiplies 23 by 0.01?

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Moving from left to right, the first calculation in the order of operations is negation (-).

____________________ view shows the worksheet divided into pages.

Cooler colors tend to pull away from the reader.

The / arithmetic operator indicates ____________________.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Opens the Format Cells dialog box.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 3: Formulas, Functions, and Formatting

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Spell-checking a worksheet.

Which of the following calculations multiplies 23 by 0.01?

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Moving from left to right, the first calculation in the order of operations is negation (-).

____________________ view shows the worksheet divided into pages.

Cooler colors tend to pull away from the reader.

The / arithmetic operator indicates ____________________.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Opens the Format Cells dialog box.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters