Question 1

To display formulas in a worksheet, click the FORMULAS tab on the ribbon and then click Show Formulas in the ____.

Accepted Answer

A)  Formula Editing group 
B)  Formula Show/Hide group 
C)  Formula Auditing group 
D)  Formula Now group 
A)  Formula Editing group 
B)  Formula Show/Hide group 
C)  Formula Auditing group 
D)  Formula Now group

Question 2

In the Format Cells dialog box, the Category box lists the available number formats.

Accepted Answer

A) True 
 B)False

Question 3

Identify the letter of the choice that best matches the phrase or definition.
-Invalid cell reference

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 4

The calculations and their results are inputs.

Accepted Answer

A) True 
 B)False

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-Insufficient width in cell to display data, or negative date/time

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 6

Changing the cell background, bolding the text, and applying a border can be accomplished using the buttons in the ____ group on the HOME tab.

Accepted Answer

A)  Cells 
B)  Text 
C)  Font 
D)  Color 
A)  Cells 
B)  Text 
C)  Font 
D)  Color

Question 7

Sheet names are only needed in formulas when the cell being referenced is on another worksheet.

Accepted Answer

A) True 
 B)False

Question 8

The ____ function calculates the average of a list of values.

Accepted Answer

A)  AVE 
B)  AVG 
C)  SUM/DIVIDE 
D)  AVERAGE 
A)  AVE 
B)  AVG 
C)  SUM/DIVIDE 
D)  AVERAGE

Question 9

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

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 10

Identify the letter of the choice that best matches the phrase or definition.
-Division by zero

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

When Excel rounds the display, it does so by rounding any number ____ up 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 13

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

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 14

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

Question 15

The Excel operator for division is ____.

Accepted Answer

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

Question 16

The Excel operator used for multiplication is ____________________.

Accepted Answer

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

Question 17

To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing. _________________________

Accepted Answer

A) True 
 B)False

Question 18

Excel stores times as ____.

Accepted Answer

A)  decimal fractions 
B)  whole numbers 
C)  mini clocks 
D)  all of the above 
A)  decimal fractions 
B)  whole numbers 
C)  mini clocks 
D)  all of the above

Question 19

The Excel error type for "wrong argument type or operand" is ____.

Accepted Answer

A)  #VALUE 
B)  #NAME 
C)  #VALUE! 
D)  #NAME? 
A)  #VALUE 
B)  #NAME 
C)  #VALUE! 
D)  #NAME?

Question 20

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

Accepted Answer

A) True 
 B)False

To display formulas in a worksheet, click the FORMULAS tab on the ribbon and then click Show Formulas in the ____.

In the Format Cells dialog box, the Category box lists the available number formats.

Identify the letter of the choice that best matches the phrase or definition. -Invalid cell reference

The calculations and their results are inputs.

Identify the letter of the choice that best matches the phrase or definition. -Insufficient width in cell to display data, or negative date/time

Changing the cell background, bolding the text, and applying a border can be accomplished using the buttons in the ____ group on the HOME tab.

Sheet names are only needed in formulas when the cell being referenced is on another worksheet.

The ____ function calculates the average of a list of values.

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

Identify the letter of the choice that best matches the phrase or definition. -Division by zero

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

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

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

The Excel operator for division is ____.

The Excel operator used for multiplication is ____________________.

To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing. _________________________

Excel stores times as ____.

The Excel error type for "wrong argument type or operand" is ____.

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

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

To display formulas in a worksheet, click the FORMULAS tab on the ribbon and then click Show Formulas in the ____.

In the Format Cells dialog box, the Category box lists the available number formats.

Identify the letter of the choice that best matches the phrase or definition. -Invalid cell reference

The calculations and their results are inputs.

Identify the letter of the choice that best matches the phrase or definition. -Insufficient width in cell to display data, or negative date/time

Changing the cell background, bolding the text, and applying a border can be accomplished using the buttons in the ____ group on the HOME tab.

Sheet names are only needed in formulas when the cell being referenced is on another worksheet.

The ____ function calculates the average of a list of values.

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

Identify the letter of the choice that best matches the phrase or definition. -Division by zero

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

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

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

The Excel operator for division is ____.

The Excel operator used for multiplication is ____________________.

To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing. _________________________

Excel stores times as ____.

The Excel error type for "wrong argument type or operand" is ____.

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

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