Question 1

The No Break button automatically wraps text within the cell, and the cell height adjusts accordingly. _________________________

Accepted Answer

A) True 
 B)False  False

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-Invalid numeric values in a formula or function

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!) G

Question 3

The COUNT function recognizes both text and number cells. _________________________

Accepted Answer

A) True 
 B)False  False

Question 4

If a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____.

Accepted Answer

A)  calculation 
B)  date 
C)  error 
D)  none of the above 
A)  calculation 
B)  date 
C)  error 
D)  none of the above

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-No answer

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

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

Question 7

The ____ function adds a list of values and/or cell ranges.

Accepted Answer

A)  SUM 
B)  RANGE 
C)  NAME 
D)  VALUE 
A)  SUM 
B)  RANGE 
C)  NAME 
D)  VALUE

Question 8

____ is/are first 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 9

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 10

The COUNT function ignores blank cells and cells with text.

Accepted Answer

A) True 
 B)False

Question 11

A function contains a list of inputs in a specific order, separated by ____.

Accepted Answer

A)  commas (,) 
B)  forward slashes (/) 
C)  backward slashes (\) 
D)  pound signs (#) 
A)  commas (,) 
B)  forward slashes (/) 
C)  backward slashes (\) 
D)  pound signs (#)

Question 12

Excel stores times as decimal fractions. _________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

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 15

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

Accepted Answer

The answer of In the formula =$B$1*$B11*C5, the cell reference...

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A)  argument 
B)  algorithm 
C)  syntax 
D)  code 
A)  argument 
B)  algorithm 
C)  syntax 
D)  code

Question 19

The Excel operator used for multiplication is ____________________.

Accepted Answer

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

Question 20

Two cell references separated by a colon are referred to as a ____.

Accepted Answer

A)  cell format 
B)  cell group 
C)  cell range 
D)  cell block 
A)  cell format 
B)  cell group 
C)  cell range 
D)  cell block

The No Break button automatically wraps text within the cell, and the cell height adjusts accordingly. _________________________

Identify the letter of the choice that best matches the phrase or definition. -Invalid numeric values in a formula or function

The COUNT function recognizes both text and number cells. _________________________

If a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____.

Identify the letter of the choice that best matches the phrase or definition. -No answer

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 ____ function adds a list of values and/or cell ranges.

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

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

The COUNT function ignores blank cells and cells with text.

A function contains a list of inputs in a specific order, separated by ____.

Excel stores times as decimal fractions. _________________________

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

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

Excel stores times as ____.

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

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

The Excel operator used for multiplication is ____________________.

Two cell references separated by a colon are referred to as a ____.

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 No Break button automatically wraps text within the cell, and the cell height adjusts accordingly. _________________________

Identify the letter of the choice that best matches the phrase or definition. -Invalid numeric values in a formula or function

The COUNT function recognizes both text and number cells. _________________________

If a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____.

Identify the letter of the choice that best matches the phrase or definition. -No answer

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 ____ function adds a list of values and/or cell ranges.

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

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

The COUNT function ignores blank cells and cells with text.

A function contains a list of inputs in a specific order, separated by ____.

Excel stores times as decimal fractions. _________________________

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

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

Excel stores times as ____.

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

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

The Excel operator used for multiplication is ____________________.

Two cell references separated by a colon are referred to as a ____.

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$1$B11C5, the cell reference $B11 is a(n) ____________________ reference.