Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A function that displays the highest value in a range.

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 D

Question 2

Clicking the Create Function box opens the Function Arguments dialog box.

Accepted Answer

A) True 
 B)False  False

Question 3

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following is the path to the Spelling button?

Accepted Answer

Question 5

-Point mode allows you to ____, as shown in the accompanying figure.

Accepted Answer

A)  select cells for use in a formula using the keyboard 
B)  select a function from the Sum button list 
C)  select cells for use in a formula using the mouse pointer 
D)  edit cell contents directly in the cell 
A)  select cells for use in a formula using the keyboard 
B)  select a function from the Sum button list 
C)  select cells for use in a formula using the mouse pointer 
D)  edit cell contents directly in the cell

Question 6

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Accepted Answer

A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste 
A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste

Question 7

The AVERAGE function requires that the argument be included within parentheses following the function name.

Accepted Answer

A) True 
 B)False

Question 8

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Accepted Answer

A) True 
 B)False

Question 9

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Accepted Answer

A)  left parenthesis 
B)  right bracket 
C)  right parenthesis 
D)  left bracket 
A)  left parenthesis 
B)  right bracket 
C)  right parenthesis 
D)  left bracket

Question 10

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Accepted Answer

A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder 
A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder

Question 11

The ____ function displays the highest value in a range.

Accepted Answer

A)  MIN 
B)  SUM 
C)  MAX 
D)  AVERAGE 
A)  MIN 
B)  SUM 
C)  MAX 
D)  AVERAGE

Question 12

All of the following are valid Excel arithmetic operators EXCEPT ____.

Accepted Answer

A)  ^ 
B)  * 
C)  % 
D)  > 
A)  ^ 
B)  * 
C)  % 
D)  >

Question 13

Explain what circular references, direct circular references, and indirect circular references are.

Accepted Answer

A formula in a cell that creates a refer

Question 14

The adjusted cell references in a copied and pasted formula are called ____ cell references.

Accepted Answer

A)  related 
B)  relative 
C)  pasted 
D)  alternative 
A)  related 
B)  relative 
C)  pasted 
D)  alternative

Question 15

The equal sign (=) precedes a formula.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is a method of entering functions?

Accepted Answer

A)  keyboard, touch gesture, or pointer 
B)  the Sum menu 
C)  the Insert Function box in the formula bar 
D)  the Name box area in the formula bar 
E)  None of the above 
A)  keyboard, touch gesture, or pointer 
B)  the Sum menu 
C)  the Insert Function box in the formula bar 
D)  the Name box area in the formula bar 
E)  None of the above

Question 17

You can click the Page Layout button on the status bar to switch to ____________________ view.

Accepted Answer

The answer of You can click the Page Layout button...

Question 18

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Accepted Answer

A) True 
 B)False

Question 19

Critical Thinking Questions
Case 2-2
Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance. Her worksheet contains the following data: start and end time, total time, and distance.
-Now Anna wants to know the longest total time she has run. By looking at the total time values, she finds the longest total time to be 54 minutes. Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time. Why did Anna prefer to use the MAX function?

Accepted Answer

A)  She believes that 54 minutes is her best running time. 
B)  The MAX function recalculates the highest value each time a new value is entered into the worksheet. 
C)  She believes that 54 minutes is not her best running time. 
D)  The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet. 
A)  She believes that 54 minutes is her best running time. 
B)  The MAX function recalculates the highest value each time a new value is entered into the worksheet. 
C)  She believes that 54 minutes is not her best running time. 
D)  The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet.

Question 20

Critical Thinking Questions
Case 2-2
Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance. Her worksheet contains the following data: start and end time, total time, and distance.
-After three months, Anna wants to the know the average distance she runs. What should she do to calculate the average distance?

Accepted Answer

A)  Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B)  Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C)  Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D)  Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument. 
A)  Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B)  Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C)  Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D)  Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A function that displays the highest value in a range.

Clicking the Create Function box opens the Function Arguments dialog box.

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Which of the following is the path to the Spelling button?

-Point mode allows you to ____, as shown in the accompanying figure.

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

The AVERAGE function requires that the argument be included within parentheses following the function name.

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

The ____ function displays the highest value in a range.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Explain what circular references, direct circular references, and indirect circular references are.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

The equal sign (=) precedes a formula.

Which of the following is a method of entering functions?

You can click the Page Layout button on the status bar to switch to ____________________ view.

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

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. -A function that displays the highest value in a range.

Clicking the Create Function box opens the Function Arguments dialog box.

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Which of the following is the path to the Spelling button?

-Point mode allows you to ____, as shown in the accompanying figure.

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

The AVERAGE function requires that the argument be included within parentheses following the function name.

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

The ____ function displays the highest value in a range.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Explain what circular references, direct circular references, and indirect circular references are.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

The equal sign (=) precedes a formula.

Which of the following is a method of entering functions?

You can click the Page Layout button on the status bar to switch to ____________________ view.

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

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