Question 1

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 2

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 3

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.
-Which cell would have the formula =C5*C6?

Accepted Answer

A)  C8 
B)  D8 
C)  E8 
D)  C16 
A)  C8 
B)  D8 
C)  E8 
D)  C16

Question 4

Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 5

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.
-Cell D11 can be calculated with what formula?

Accepted Answer

A)  =B11*D5*B1 
B)  =B11*D6 
C)  =D8-D14 
D)  =D8*D15 
A)  =B11*D5*B1 
B)  =B11*D6 
C)  =D8-D14 
D)  =D8*D15

Question 6

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 7

$B1 is an example of a(n) ____ reference.

Accepted Answer

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

Question 8

A function is always structured beginning with the function address and an opening parenthesis mark. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Excel stores times as decimal fractions. _________________________

Accepted Answer

A) True 
 B)False

Question 10

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 11

The ____ button formats numbers in the Accounting Number Format.

Accepted Answer

A)  $ 
B)  , 
C)  % 
D)  all of the above 
A)  $ 
B)  , 
C)  % 
D)  all of the above

Question 12

The Excel operator used for an exponent is ____________________.

Accepted Answer

The answer of The Excel operator used for an exponent...

Question 13

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

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

B3,C4, D5:D6, 6 represents ____.

Accepted Answer

A)  nonadjacent 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)  nonadjacent 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 15

If A1=2, the resulting value of =3*A1^3 is ____.

Accepted Answer

A)  9 
B)  12 
C)  18 
D)  24 
A)  9 
B)  12 
C)  18 
D)  24

Question 16

The Excel operator for multiplication is ____.

Accepted Answer

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

Question 17

____ 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 18

The word Component entered into a cell represents a ____.

Accepted Answer

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

Question 19

The ____________________ format displays the dollar sign immediately in front of the value and does not align values on the decimal point.

Accepted Answer

The answer of The ____________________ format displays the dollar sign...

Question 20

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!

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

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

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. -Which cell would have the formula =C5*C6?

Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet.

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. -Cell D11 can be calculated with what formula?

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

$B1 is an example of a(n) ____ reference.

A function is always structured beginning with the function address and an opening parenthesis mark. _________________________

Excel stores times as decimal fractions. _________________________

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

The ____ button formats numbers in the Accounting Number Format.

The Excel operator used for an exponent is ____________________.

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

B3,C4, D5:D6, 6 represents ____.

If A1=2, the resulting value of =3*A1^3 is ____.

The Excel operator for multiplication is ____.

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

The word Component entered into a cell represents a ____.

The ____________________ format displays the dollar sign immediately in front of the value and does not align values on the decimal point.

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

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

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

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

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. -Which cell would have the formula =C5*C6?

Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet.

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. -Cell D11 can be calculated with what formula?

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

$B1 is an example of a(n) ____ reference.

A function is always structured beginning with the function address and an opening parenthesis mark. _________________________

Excel stores times as decimal fractions. _________________________

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

The ____ button formats numbers in the Accounting Number Format.

The Excel operator used for an exponent is ____________________.

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

B3,C4, D5:D6, 6 represents ____.

If A1=2, the resulting value of =3*A1^3 is ____.

The Excel operator for multiplication is ____.

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

The word Component entered into a cell represents a ____.

The ____________________ format displays the dollar sign immediately in front of the value and does not align values on the decimal point.

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

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.

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