Question 1

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

Accepted Answer

A)  values 
B)  formulas 
C)  both a and b 
D)  neither a nor b 
A)  values 
B)  formulas 
C)  both a and b 
D)  neither a nor b

Question 2

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 you write to find the largest value in cells E11:E14?

Accepted Answer

A)  =MAXIMUM(E11:E14) 
B)  =MAX(E11:E14) 
C)  MAX(E11:E14) 
D)  MIN(E11:E14) 
A)  =MAXIMUM(E11:E14) 
B)  =MAX(E11:E14) 
C)  MAX(E11:E14) 
D)  MIN(E11:E14)

Question 3

The Excel operator used for an exponent is ____________________.

Accepted Answer

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

Question 4

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

Question 5

To correct the problem of the error message ######, ____.

Accepted Answer

A)  double-click the column dividing line to make the column as wide as the longest entry in the column 
B)  drag the column dividing line to the desired width 
C)  choose the Column option on the Format menu and then specify column width 
D)  any of the above 
A)  double-click the column dividing line to make the column as wide as the longest entry in the column 
B)  drag the column dividing line to the desired width 
C)  choose the Column option on the Format menu and then specify column width 
D)  any of the above

Question 6

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

The ____________________ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

Accepted Answer

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

Question 8

A(n) ____________________ in Excel always begins with an equal sign (=).

Accepted Answer

The answer of A(n) ____________________ in Excel always begins with...

Question 9

A range is considered to be ____ if it contains multiple rows and columns.

Accepted Answer

A)  one-dimensional 
B)  two-dimensional 
C)  multi-dimensional 
D)  mega-dimensional 
A)  one-dimensional 
B)  two-dimensional 
C)  multi-dimensional 
D)  mega-dimensional

Question 10

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

Accepted Answer

A)  insufficient width in the cell to display data, or negative date/time 
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, or negative date/time 
B)  an invalid cell reference 
C)  an invalid numeric value in a formula or function 
D)  no answer

Question 11

The ____ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

Accepted Answer

A)  Currency 
B)  Comma 
C)  Percent 
D)  all of the above 
A)  Currency 
B)  Comma 
C)  Percent 
D)  all of the above

Question 12

The Excel operator for multiplication is ____.

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

SUM calculates the minimum value in a list of values. _________________________

Accepted Answer

A) True 
 B)False

Question 15

The Excel operator for addition is ____.

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The result of a formula can be a ____.

Accepted Answer

A)  value 
B)  label 
C)  either a or b 
D)  neither a nor b 
A)  value 
B)  label 
C)  either a or b 
D)  neither a nor b

Question 18

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 19

Each function has its own output, which specifies the function name and order of the arguments. _________________________

Accepted Answer

A) True 
 B)False

Question 20

B3:D3 represents ____.

Accepted Answer

A)  noncontiguous 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)  noncontiguous 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

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

The Excel operator used for an exponent is ____________________.

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

To correct the problem of the error message ######, ____.

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

The ____________________ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

A(n) ____________________ in Excel always begins with an equal sign (=).

A range is considered to be ____ if it contains multiple rows and columns.

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

The ____ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

The Excel operator for multiplication is ____.

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

SUM calculates the minimum value in a list of values. _________________________

The Excel operator for addition is ____.

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

The result of a formula can be a ____.

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

Each function has its own output, which specifies the function name and order of the arguments. _________________________

B3:D3 represents ____.

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

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

The Excel operator used for an exponent is ____________________.

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

To correct the problem of the error message ######, ____.

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

The ____________________ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

A(n) ____________________ in Excel always begins with an equal sign (=).

A range is considered to be ____ if it contains multiple rows and columns.

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

The ____ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

The Excel operator for multiplication is ____.

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

SUM calculates the minimum value in a list of values. _________________________

The Excel operator for addition is ____.

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

The result of a formula can be a ____.

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

Each function has its own output, which specifies the function name and order of the arguments. _________________________

B3:D3 represents ____.

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