Question 1

____ is/are last in the order of precedence rules.

Accepted Answer

A)  Addition and subtraction from left to right 
B)  Exponentiation 
C)  Multiplication and division from left to right 
D)  Operations in parentheses 
A)  Addition and subtraction from left to right 
B)  Exponentiation 
C)  Multiplication and division from left to right 
D)  Operations in parentheses

Question 2

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is ____.

Accepted Answer

A)  0 
B)  1 
C)  11/10 
D)  4 
A)  0 
B)  1 
C)  11/10 
D)  4

Question 3

The Excel operator used for division is ____________________.

Accepted Answer

The answer of The Excel operator used for division is...

Question 4

When Excel rounds the display, it does so by rounding any number ____ down to the next value.

Accepted Answer

A)  greater than half 
B)  less than half 
C)  equal to or less than half 
D)  equal to or greater than half 
A)  greater than half 
B)  less than half 
C)  equal to or less than half 
D)  equal to or greater than half

Question 5

The Excel operator for subtraction is ____.

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

Describe the difference between the three predefined styles in the Number group on the HOME tab or the Mini toolbar.

Accepted Answer

The Accounting Number Format button form

Question 8

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 9

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 10

A paper spreadsheet is simply a sheet organized into columns and headings. _________________________

Accepted Answer

A) True 
 B)False

Question 11

A(n) ____________________ is an equation that performs calculations.

Accepted Answer

The answer of A(n) ____________________ is an equation that performs...

Question 12

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.
-The chart shows that 30 appliques can be attached for a cost of $10/hour. If there are 6 appliques per shoe (cell B12), how much is the cost per shoe for applying the appliques?

Accepted Answer

A)  $0.02 
B)  $0.20 
C)  $2.00 
D)  $0.33 
A)  $0.02 
B)  $0.20 
C)  $2.00 
D)  $0.33

Question 13

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

Accepted Answer

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

Question 14

When working with multiple worksheets in a workbook, it's a good idea to ____ each worksheet tab.

Accepted Answer

A)  rename 
B)  delete 
C)  reorder 
D)  make a duplicate of 
A)  rename 
B)  delete 
C)  reorder 
D)  make a duplicate of

Question 15

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 16

The Accounting Number Format displays ____.

Accepted Answer

A)  the dollar sign at the left edge of the cell 
B)  commas 
C)  two decimal places for the numeric value, with a column of values aligned on the decimal point 
D)  all of the above 
A)  the dollar sign at the left edge of the cell 
B)  commas 
C)  two decimal places for the numeric value, with a column of values aligned on the decimal point 
D)  all of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-Calculated 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

Excel stores dates as sequential numbers starting with January 1st of the year ____.

Accepted Answer

A)  1000 
B)  1900 
C)  2000 
D)  2007 
A)  1000 
B)  1900 
C)  2000 
D)  2007

Question 20

Jane has just started a job at a local shoe retailer. One of her first tasks was to compile the above worksheet, showing the first quarter. Her boss has reviewed the worksheet and asked her to add some functions and formulas to the worksheet.
-What formula would yield the correct results for cell C18?

Accepted Answer

A)  =C8-(C14+C16) 
B)  =C8-C14-C16 
C)  either a or b 
D)  neither a nor b 
A)  =C8-(C14+C16) 
B)  =C8-C14-C16 
C)  either a or b 
D)  neither a nor b

____ is/are last in the order of precedence rules.

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is ____.

The Excel operator used for division is ____________________.

When Excel rounds the display, it does so by rounding any number ____ down to the next value.

The Excel operator for subtraction is ____.

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

Describe the difference between the three predefined styles in the Number group on the HOME tab or the Mini toolbar.

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

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

A paper spreadsheet is simply a sheet organized into columns and headings. _________________________

A(n) ____________________ is an equation that performs calculations.

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

When working with multiple worksheets in a workbook, it's a good idea to ____ each worksheet tab.

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

The Accounting Number Format displays ____.

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

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

Excel stores dates as sequential numbers starting with January 1st of the year ____.

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

____ is/are last in the order of precedence rules.

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is ____.

The Excel operator used for division is ____________________.

When Excel rounds the display, it does so by rounding any number ____ down to the next value.

The Excel operator for subtraction is ____.

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

Describe the difference between the three predefined styles in the Number group on the HOME tab or the Mini toolbar.

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

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

A paper spreadsheet is simply a sheet organized into columns and headings. _________________________

A(n) ____________________ is an equation that performs calculations.

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

When working with multiple worksheets in a workbook, it's a good idea to ____ each worksheet tab.

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

The Accounting Number Format displays ____.

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

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

Excel stores dates as sequential numbers starting with January 1st of the year ____.

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