Question 1

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Accepted Answer

A)  placement 
B)  operations 
C)  positioning 
D)  selections 
A)  placement 
B)  operations 
C)  positioning 
D)  selections

Question 2

The Insert Options button lists formatting options.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

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 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A prewritten formula built into Excel.

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 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A formula in a cell that contains a reference back to itself.

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 8

To paste copied cell contents, you can press the ____ keys.

Accepted Answer

A)  CTRL+C 
B)  CTRL+P 
C)  CTRL+V 
D)  CTRL+X 
A)  CTRL+C 
B)  CTRL+P 
C)  CTRL+V 
D)  CTRL+X

Question 9

To use ____________________ to verify that a formula contains the intended cell references, double-tap or double-click the cell with the formula you want to check.

Accepted Answer

The answer of To use ____________________ to verify that a...

Question 10

The ____ function determines the lowest number in a range.

Accepted Answer

A) LOW 
B) BASE 
C) LEAST 
D) MIN 
A) LOW 
B) BASE 
C) LEAST 
D) MIN

Question 11

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accepted Answer

A)  Comma style format 
B)  Accounting number format 
C)  Percent style format 
D)  Currency style format 
A)  Comma style format 
B)  Accounting number format 
C)  Percent style format 
D)  Currency style format

Question 12

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

Accepted Answer

The answer of A formula in a cell that contains...

Question 13

You can choose from 12 categories of formats in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 14

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Accepted Answer

A) True 
 B)False

Question 15

You should ____ a function name in the Formula AutoComplete list to select the function.

Accepted Answer

A)  double-click or double-tap 
B)  click or tap 
C)  right-click or triple-tap 
D)  none of the above 
A)  double-click or double-tap 
B)  click or tap 
C)  right-click or triple-tap 
D)  none of the above

Question 16

To set row height to best fit, ____________________ the bottom boundary of the row heading.

Accepted Answer

double-tap

Question 17

Briefly discuss displaying the formulas version of a worksheet.

Accepted Answer

The values version of the worksheet show

Question 18

You can press the ____________________ key to quit Range Finder.

Accepted Answer

The answer of You can press the ____________________ key to...

Question 19

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 20

A ____ is a prewritten formula that is built into Excel.

Accepted Answer

A)  function 
B)  feature 
C)  task 
D)  calculation 
A)  function 
B)  feature 
C)  task 
D)  calculation

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

The Insert Options button lists formatting options.

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.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A prewritten formula built into Excel.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

To paste copied cell contents, you can press the ____ keys.

To use ____________________ to verify that a formula contains the intended cell references, double-tap or double-click the cell with the formula you want to check.

The ____ function determines the lowest number in a range.

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

You can choose from 12 categories of formats in the Format Cells dialog box.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

You should ____ a function name in the Formula AutoComplete list to select the function.

To set row height to best fit, ____________________ the bottom boundary of the row heading.

Briefly discuss displaying the formulas version of a worksheet.

You can press the ____________________ key to quit Range Finder.

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.

A ____ is a prewritten formula that is built into Excel.

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

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

The Insert Options button lists formatting options.

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.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A prewritten formula built into Excel.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

To paste copied cell contents, you can press the ____ keys.

To use ____________________ to verify that a formula contains the intended cell references, double-tap or double-click the cell with the formula you want to check.

The ____ function determines the lowest number in a range.

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

You can choose from 12 categories of formats in the Format Cells dialog box.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

You should ____ a function name in the Formula AutoComplete list to select the function.

To set row height to best fit, ____________________ the bottom boundary of the row heading.

Briefly discuss displaying the formulas version of a worksheet.

You can press the ____________________ key to quit Range Finder.

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.

A ____ is a prewritten formula that is built into Excel.

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