Question 1

If 5% is displayed in a cell, the actual value that is stored is ____.

Accepted Answer

A)  .005 
B)  .05 
C)  .5 
D)  5 
A)  .005 
B)  .05 
C)  .5 
D)  5

Question 2

If a column shows the numbers 1, 2, and 3 as well as the SUM equaling 6, the number 6 is a ____.

Accepted Answer

A)  calculated value 
B)  numeric value 
C)  text label 
D)  submenu 
A)  calculated value 
B)  numeric value 
C)  text label 
D)  submenu

Question 3

A cell reference that has only one $ is referred to as a(n) ____ cell reference.

Accepted Answer

A)  mixed 
B)  alternative 
C)  absolute 
D)  relative 
A)  mixed 
B)  alternative 
C)  absolute 
D)  relative

Question 4

Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column.
-What does the #DIV/0 error in cell D15 indicate?

Accepted Answer

A)  insufficient column width to display data 
B)  division by zero 
C)  invalid numeric values in formula or function 
D)  no answer 
A)  insufficient column width to display data 
B)  division by zero 
C)  invalid numeric values in formula or function 
D)  no answer

Question 5

Describe three ways to correct the formatting problem of modifying column width as shown by the error message ###### in a calculated cell.

Accepted Answer

•Double-click the column dividing line t

Question 6

The Excel error message for "no answer" is ____.

Accepted Answer

A)  #N/A 
B)  #NA 
C)  !NA 
D)  ### 
A)  #N/A 
B)  #NA 
C)  !NA 
D)  ###

Question 7

The ____ function calculates the maximum in a list of values.

Accepted Answer

A)  MAX 
B)  MAXIMUM 
C)  MOST 
D)  MORE 
A)  MAX 
B)  MAXIMUM 
C)  MOST 
D)  MORE

Question 8

The Excel operator for exponent is ____.

Accepted Answer

A)  * 
B)  / 
C)  ^ 
D)  & 
A)  * 
B)  / 
C)  ^ 
D)  &

Question 9

The error message ###### means that there is ____.

Accepted Answer

A)  insufficient width in the cell to display data, or negative date/time 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  no answer 
A)  insufficient width in the cell to display data, or negative date/time 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  no answer

Question 10

The error message #DIV/0! means that there is ____.

Accepted Answer

A)  division by zero 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  a wrong argument type or operand 
A)  division by zero 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  a wrong argument type or operand

Question 11

The rules programmed into the function are referred to as the function's ____________________.

Accepted Answer

The answer of The rules programmed into the function are...

Question 12

The fill handle is a small square in the lower-right corner of a selected cell that you use to delete the contents of the selected cell.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  Summation 
B)  AddNow 
C)  AutoSum 
D)  AutoAdd 
A)  Summation 
B)  AddNow 
C)  AutoSum 
D)  AutoAdd

Question 14

____ are predefined formulas that perform calculations.

Accepted Answer

A)  Functions 
B)  Arguments 
C)  Rules 
D)  Codes 
A)  Functions 
B)  Arguments 
C)  Rules 
D)  Codes

Question 15

Range names, like text labels, are enclosed in quotation marks when used in formulas.

Accepted Answer

A) True 
 B)False

Question 16

The COUNT function ignores blank cells and cells with text.

Accepted Answer

A) True 
 B)False

Question 17

The error message #NUM! means that there is ____.

Accepted Answer

A)  insufficient width in the cell to display data 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  no answer 
A)  insufficient width in the cell to display data 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  no answer

Question 18

If A1=2, then the resulting value of =A1*(3+5) is ____.

Accepted Answer

A)  10 
B)  11 
C)  16 
D)  30 
A)  10 
B)  11 
C)  16 
D)  30

Question 19

B3:D7 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

Question 20

When you insert rows in a list of values that are being calculated, such as with a total, Excel most often includes the newly inserted values and recalculates the formulas affected. Depending on what values are in the list and how they are formatted, however, this might not always work as anticipated.
If you think additional rows will be needed, describe two ways to avoid potential problems.

Accepted Answer

1. Insert a new row or rows within the l

If 5% is displayed in a cell, the actual value that is stored is ____.

If a column shows the numbers 1, 2, and 3 as well as the SUM equaling 6, the number 6 is a ____.

A cell reference that has only one $ is referred to as a(n) ____ cell reference.

Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column. -What does the #DIV/0 error in cell D15 indicate?

Describe three ways to correct the formatting problem of modifying column width as shown by the error message ###### in a calculated cell.

The Excel error message for "no answer" is ____.

The ____ function calculates the maximum in a list of values.

The Excel operator for exponent is ____.

The error message ###### means that there is ____.

The error message #DIV/0! means that there is ____.

The rules programmed into the function are referred to as the function's ____________________.

The fill handle is a small square in the lower-right corner of a selected cell that you use to delete the contents of the selected cell.

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

____ are predefined formulas that perform calculations.

Range names, like text labels, are enclosed in quotation marks when used in formulas.

The COUNT function ignores blank cells and cells with text.

The error message #NUM! means that there is ____.

If A1=2, then the resulting value of =A1*(3+5) is ____.

B3:D7 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

If 5% is displayed in a cell, the actual value that is stored is ____.

If a column shows the numbers 1, 2, and 3 as well as the SUM equaling 6, the number 6 is a ____.

A cell reference that has only one $ is referred to as a(n) ____ cell reference.

Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column. -What does the #DIV/0 error in cell D15 indicate?

Describe three ways to correct the formatting problem of modifying column width as shown by the error message ###### in a calculated cell.

The Excel error message for "no answer" is ____.

The ____ function calculates the maximum in a list of values.

The Excel operator for exponent is ____.

The error message ###### means that there is ____.

The error message #DIV/0! means that there is ____.

The rules programmed into the function are referred to as the function's ____________________.

The fill handle is a small square in the lower-right corner of a selected cell that you use to delete the contents of the selected cell.

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

____ are predefined formulas that perform calculations.

Range names, like text labels, are enclosed in quotation marks when used in formulas.

The COUNT function ignores blank cells and cells with text.

The error message #NUM! means that there is ____.

If A1=2, then the resulting value of =A1*(3+5) is ____.

B3:D7 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