Question 1

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 
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

Question 2

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Accepted Answer

The answer of ____________________ are those portions of a printed...

Question 3

You cannot format an entire column at once.

Accepted Answer

A) True 
 B)False

Question 4

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 5

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Accepted Answer

A)  DIVSUM 
B)  RANGEAVG 
C)  AVERAGE 
D)  MAX 
A)  DIVSUM 
B)  RANGEAVG 
C)  AVERAGE 
D)  MAX

Question 6

A(n) ____________________ is a dot on the screen that contains a color.

Accepted Answer

The answer of A(n) ____________________ is a dot on the...

Question 7

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Accepted Answer

A) True 
 B)False

Question 8

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

Accepted Answer

The answer of ____________________ is a technique that can be...

Question 9

____________________ view shows the worksheet divided into pages.

Accepted Answer

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

Question 10

Cooler colors tend to pull away from the reader. _________________________

Accepted Answer

A) True 
 B)False

Question 11

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

Accepted Answer

A)  Identification of how to format various elements of the worksheet 
B)  Avoiding the temptation to use flashy or confusing visual elements within the worksheet 
A)  Identification of how to format various elements of the worksheet 
B)  Avoiding the temptation to use flashy or confusing visual elements within the worksheet

Question 12

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

Question 13

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.

Question 14

The most common error when entering a formula is to reference the wrong cell in the formula.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Accepted Answer

A)  contiguous 
B)  indexed 
C)  direct 
D)  indirect 
A)  contiguous 
B)  indexed 
C)  direct 
D)  indirect

Question 16

____ 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 17

The equal sign (=) precedes a formula.

Accepted Answer

A) True 
 B)False

Question 18

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Accepted Answer

A)  40 
B)  26 
C)  48 
D)  13 
A)  40 
B)  26 
C)  48 
D)  13

Question 19

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 20

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Which of the following is a method of entering functions?

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

You cannot format an entire column at once.

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

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

A(n) ____________________ is a dot on the screen that contains a color.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

____________________ view shows the worksheet divided into pages.

Cooler colors tend to pull away from the reader. _________________________

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

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.

The most common error when entering a formula is to reference the wrong cell in the formula.

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

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

The equal sign (=) precedes a formula.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Access 1 Databases and Database Objects: an Introduction

Access 2 Querying a Database

Excel 1 Creating a Worksheet and a Chart

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

Word 1 Creating, Formatting, and Editing a Word Document With a Picture

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters

Exam 4: Excel 2 Formulas, Functions, and Formatting

Which of the following is a method of entering functions?

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

You cannot format an entire column at once.

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

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

A(n) ____________________ is a dot on the screen that contains a color.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

____________________ view shows the worksheet divided into pages.

Cooler colors tend to pull away from the reader. _________________________

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

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.

The most common error when entering a formula is to reference the wrong cell in the formula.

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

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

The equal sign (=) precedes a formula.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Access 1 Databases and Database Objects: an Introduction

Access 2 Querying a Database

Excel 1 Creating a Worksheet and a Chart

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

Word 1 Creating, Formatting, and Editing a Word Document With a Picture

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters