Question 1

The calculations and their results are inputs.

Accepted Answer

A) True 
 B)False

Question 2

The Excel operator for division is ____.

Accepted Answer

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

Question 3

The ### signs indicate that the column width is insufficient to display the complete value in the cell.

Accepted Answer

A) True 
 B)False

Question 4

If there is insufficient room to display a label in a cell, the text may be displayed in a truncated format.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Case 1-2
   
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 should Peter do to correct the ###### error?

Accepted Answer

A)  Increase the column width. 
B)  Change the formula. 
C)  Delete the cell. 
D)  Change the column heading. 
A)  Increase the column width. 
B)  Change the formula. 
C)  Delete the cell. 
D)  Change the column heading.

Question 9

To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.

Accepted Answer

A) True 
 B)False

Question 10

Case 1-2
   
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

The calculations and their results are inputs.

The Excel operator for division is ____.

The ### signs indicate that the column width is insufficient to display the complete value in the cell.

If there is insufficient room to display a label in a cell, the text may be displayed in a truncated format.

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

Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.

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

Case 1-2 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 should Peter do to correct the ###### error?

To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.

Case 1-2 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?

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

The calculations and their results are inputs.

The Excel operator for division is ____.

The ### signs indicate that the column width is insufficient to display the complete value in the cell.

If there is insufficient room to display a label in a cell, the text may be displayed in a truncated format.

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

Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.

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

To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.

Case 1-2 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?

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