Question 1

In the formula =$B$1*B11*C5, the cell reference $B$1 is a(n) ____________________ reference.

Accepted Answer

absolute

Question 2

The function inputs are referred to as arguments. _________________________

Accepted Answer

A) True 
 B)False  True

Question 3

To copy a formula from one cell to another, use the Copy button in the ____ group on the HOME tab to copy the cell contents to the Clipboard.

Accepted Answer

A)  Copy and Paste 
B)  Paste Options 
C)  Content 
D)  Clipboard 
A)  Copy and Paste 
B)  Paste Options 
C)  Content 
D)  Clipboard D

Question 4

The Excel operator for addition is ____.

Accepted Answer

A)  + 
B)  * 
C)  / 
D)  = 
A)  + 
B)  * 
C)  / 
D)  =

Question 5

A cell formatted with the Proportion Style displays the % symbol following the value. _________________________

Accepted Answer

A) True 
 B)False

Question 6

The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. _________________________

Accepted Answer

A) True 
 B)False

Question 7

SUM calculates the minimum value in a list of values. _________________________

Accepted Answer

A) True 
 B)False

Question 8

After clicking the AutoSum button and choosing the function you want, Excel presents a suggested range to include in the calculation based on ____.

Accepted Answer

A)  rows or columns of numbers next to the current cell 
B)  your past history with the function 
C)  column width 
D)  all of the above 
A)  rows or columns of numbers next to the current cell 
B)  your past history with the function 
C)  column width 
D)  all of the above

Question 9

The result of a formula can be a ____.

Accepted Answer

A)  value 
B)  label 
C)  either a or b 
D)  neither a nor b 
A)  value 
B)  label 
C)  either a or b 
D)  neither a nor b

Question 10

The ____ Style button formats numbers as percentages, displayed to the nearest percent, with no decimal places.

Accepted Answer

A)  Currency 
B)  Comma 
C)  Percent 
D)  all of the above 
A)  Currency 
B)  Comma 
C)  Percent 
D)  all of the above

Question 11

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

Accepted Answer

A)  values 
B)  formulas 
C)  both a and b 
D)  neither a nor b 
A)  values 
B)  formulas 
C)  both a and b 
D)  neither a nor b

Question 12

____________________ are predefined formulas that perform calculations.

Accepted Answer

The answer of ____________________ are predefined formulas that perform calculations....

Question 13

A formula is an equation that performs calculations, the result of which can be either a value or a label.

Accepted Answer

A) True 
 B)False

Question 14

Excel's ____________________ feature gives you quick access to the SUM function and other similar functions.

Accepted Answer

AutoSum
Au

Question 15

In Excel, a spreadsheet is referred to as a(n) ____________________.

Accepted Answer

The answer of In Excel, a spreadsheet is referred to...

Question 16

The ____________________ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

Accepted Answer

The answer of The ____________________ Style button formats numbers with...

Question 17

In the SUM function, two cell references separated by a colon are referred to as a(n) ____________________.

Accepted Answer

The answer of In the SUM function, two cell references...

Question 18

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-Numeric values

Accepted Answer

A) Cell D7 
B) Cell D16 
C) Cells C12:D16 
D) Cell A7 
E) Cells D5:D8 
A) Cell D7 
B) Cell D16 
C) Cells C12:D16 
D) Cell A7 
E) Cells D5:D8

Question 19

Identify the letter of the choice that best matches the phrase or definition.
-Unrecognized text in a formula

Accepted Answer

A) ###### 
B) #N/A 
C) #VALUE! 
D) #DIV/0! 
E) #NAME?
F)#REF!
G)#NUM! 
A) ###### 
B) #N/A 
C) #VALUE! 
D) #DIV/0! 
E) #NAME?
F)#REF!
G)#NUM!

Question 20

B3:D3 represents ____.

Accepted Answer

A)  noncontiguous cells and/or constants 
B)  a range along a column 
C)  a range along a row 
D)  a two-dimensional range or a block of cells 
A)  noncontiguous cells and/or constants 
B)  a range along a column 
C)  a range along a row 
D)  a two-dimensional range or a block of cells

In the formula =$B$1B11C5, the cell reference $B$1 is a(n) ____________________ reference.

The function inputs are referred to as arguments. _________________________

To copy a formula from one cell to another, use the Copy button in the ____ group on the HOME tab to copy the cell contents to the Clipboard.

The Excel operator for addition is ____.

A cell formatted with the Proportion Style displays the % symbol following the value. _________________________

The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. _________________________

SUM calculates the minimum value in a list of values. _________________________

After clicking the AutoSum button and choosing the function you want, Excel presents a suggested range to include in the calculation based on ____.

The result of a formula can be a ____.

The ____ Style button formats numbers as percentages, displayed to the nearest percent, with no decimal places.

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

____________________ are predefined formulas that perform calculations.

A formula is an equation that performs calculations, the result of which can be either a value or a label.

Excel's ____________________ feature gives you quick access to the SUM function and other similar functions.

In Excel, a spreadsheet is referred to as a(n) ____________________.

The ____________________ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

In the SUM function, two cell references separated by a colon are referred to as a(n) ____________________.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -Numeric values

Identify the letter of the choice that best matches the phrase or definition. -Unrecognized text in a formula

B3:D3 represents ____.

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 1: Applying Fundamental Excel Skills and Tools in Problem Solving

In the formula =$B$1*B11*C5, the cell reference $B$1 is a(n) ____________________ reference.

The function inputs are referred to as arguments. _________________________

To copy a formula from one cell to another, use the Copy button in the ____ group on the HOME tab to copy the cell contents to the Clipboard.

The Excel operator for addition is ____.

A cell formatted with the Proportion Style displays the % symbol following the value. _________________________

The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. _________________________

SUM calculates the minimum value in a list of values. _________________________

After clicking the AutoSum button and choosing the function you want, Excel presents a suggested range to include in the calculation based on ____.

The result of a formula can be a ____.

The ____ Style button formats numbers as percentages, displayed to the nearest percent, with no decimal places.

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

____________________ are predefined formulas that perform calculations.

A formula is an equation that performs calculations, the result of which can be either a value or a label.

Excel's ____________________ feature gives you quick access to the SUM function and other similar functions.

In Excel, a spreadsheet is referred to as a(n) ____________________.

The ____________________ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

In the SUM function, two cell references separated by a colon are referred to as a(n) ____________________.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -Numeric values

Identify the letter of the choice that best matches the phrase or definition. -Unrecognized text in a formula

B3:D3 represents ____.

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

In the formula =$B$1B11C5, the cell reference $B$1 is a(n) ____________________ reference.