Question 1

The ____ function ignores blank cells and text.

Accepted Answer

A)  AVERAGE 
B)  COUNT 
C)  COUNTA 
D)  both a and b 
A)  AVERAGE 
B)  COUNT 
C)  COUNTA 
D)  both a and b

Question 2

Excel formulas can contain ____.

Accepted Answer

A)  constants 
B)  cell references to previously entered values 
C)  cell references to other calculated values 
D)  all of the above 
A)  constants 
B)  cell references to previously entered values 
C)  cell references to other calculated values 
D)  all of the above

Question 3

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 4

The function inputs are referred to as ____________________.

Accepted Answer

The answer of The function inputs are referred to as...

Question 5

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

The pound sign (#) is the syntax used by Excel to indicate that a cell reference is absolute.

Accepted Answer

A) True 
 B)False

Question 7

The function inputs are referred to as ____.

Accepted Answer

A)  lists 
B)  data 
C)  arguments 
D)  syntax 
A)  lists 
B)  data 
C)  arguments 
D)  syntax

Question 8

The error message #REF! 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 9

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 10

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 11

The labels and values upon which Excel calculations are based are outputs.

Accepted Answer

A) True 
 B)False

Question 12

The Excel operator for subtraction is ____.

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

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 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 15

The default print format has ____________________ rather than formulas printed in the cells.

Accepted Answer

The answer of The default print format has ____________________ rather...

Question 16

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 17

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

Functions are predefined formulas that perform calculations. _________________________

Accepted Answer

A) True 
 B)False

Question 19

The ____ function calculates a minimum in a list of values.

Accepted Answer

A)  MIN 
B)  MINIMUM 
C)  LESS 
D)  LOWEST 
A)  MIN 
B)  MINIMUM 
C)  LESS 
D)  LOWEST

Question 20

When the formulas are displayed, the worksheet column widths and formats ____.

Accepted Answer

A)  do not change 
B)  are modified to accommodate the display 
C)  default to a standard format 
D)  all of the above 
A)  do not change 
B)  are modified to accommodate the display 
C)  default to a standard format 
D)  all of the above

The ____ function ignores blank cells and text.

Excel formulas can contain ____.

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

The function inputs are referred to as ____________________.

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

The pound sign (#) is the syntax used by Excel to indicate that a cell reference is absolute.

The function inputs are referred to as ____.

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

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

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

The labels and values upon which Excel calculations are based are outputs.

The Excel operator for subtraction is ____.

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

The default print format has ____________________ rather than formulas printed in the cells.

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

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

Functions are predefined formulas that perform calculations. _________________________

The ____ function calculates a minimum in a list of values.

When the formulas are displayed, the worksheet column widths and formats ____.

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 ____ function ignores blank cells and text.

Excel formulas can contain ____.

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

The function inputs are referred to as ____________________.

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

The pound sign (#) is the syntax used by Excel to indicate that a cell reference is absolute.

The function inputs are referred to as ____.

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

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

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

The labels and values upon which Excel calculations are based are outputs.

The Excel operator for subtraction is ____.

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

The default print format has ____________________ rather than formulas printed in the cells.

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

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

Functions are predefined formulas that perform calculations. _________________________

The ____ function calculates a minimum in a list of values.

When the formulas are displayed, the worksheet column widths and formats ____.

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