True/False
Indicate whether the sentence or statement is true
or false.


1.

A
formula can consist of a single cell reference.


2.

Formulas use numbers, cell references, and operators to add, subtract, multiply, and
divide.


3.

When
adding cell addresses in a formula, you must use uppercase letters.


4.

After
you enter a formula, you do not see the formula in the cell; you see the result of the
formula.


5.

If
Excel cannot properly perform a calculation, it will display an error value in the cell where you
entered the formula.


6.

You
can assume that the Excel AutoSum function will always pick the correct range to sum.


7.

Cell
references must be entirely absolute or entirely relative.


8.

You
can use the Function Arguments dialog box to help you construct a function formula.


9.

The
Average function is a mathematical function.


10.

The
Sum function is a statistical function.


11.

Charts are used to make data easier to read and understand.


12.

You
must create a chart on the same worksheet that contains the data for the chart.


13.

After
you change data in a worksheet used to create a chart, you must manually update the
chart.


14.

If
you want to change a bar chart to a column chart, you must start over and create a new chart from
worksheet data.


15.

Chart
options, formats, and types can all be changed at any time, even after the chart has been
created.

Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.


16.

The
sequence used to determine which calculations are carried out first in Excel is called the
____. a.  calculation
system  c.  order of
evaluation  b.  operation sequence  d.  evaluation sequence     


17.

The
symbol that tells Excel what mathematical operation to carry out is the ____. a.  operator  c.  argument  b.  operand  d.  function     


18.

A
formula that contains more than one operator is called a ____. a.  compound
formula  c.  complicated
formula  b.  function formula  d.  complex formula     


19.

To
see a formula after you have entered it, you must click in the cell containing the formula and then
view the formula in the ____. a.  Formula Bar  c.  Formula Toolbar  b.  Status
Bar  d.  Name
Box     


20.

To
edit a formula, you can ____. a.  doubleclick the cell and then edit the formula in the
cell  b.  select the cell,
press F2, and then edit the formula in the cell  c.  select the cell
and then edit the formula in the Formula Bar  d.  all of the
above   


21.

A
function formula contains the ____. a.  equal sign and the function name  b.  equal sign, the
function name, and the argument  c.  equal sign and the argument  d.  function name
and the argument   


22.

By
default, when you create formulas, the cell references are formatted as ____
references. a.  absolute cell
 c.  mixed cell
 b.  relative cell
 d.  function
    


23.

To
create an absolute cell reference, insert a(n) ____ before the column letter and/or row
number.


24.

When
a(n) ____ cell reference is copied to another cell, the cell references will be adjusted to their new
location. a.  absolute  c.  mixed  b.  relative  d.  none of the above     


25.

To
describe large quantities of data in a worksheet, you use a ____ function. a.  statistical  c.  logical  b.  mathematical  d.  none of the above     


26.

To
display the number of entries containing values in a range of cells, you would use the ____
function.


27.

The
____ function displays the minimum value within the specified range of cells. a.  Average  c.  Median  b.  Min  d.  Count     


28.

The
Function Arguments dialog box displays ____. a.  a description of the function  c.  the argument  b.  the current
result of the entire formula  d.  all of the
above     


29.

To
show how individual items relate to a whole unit, you would create a(n) ____ chart. a.  area  c.  bar  b.  pie  d.  scatter     


30.

After
you have created a chart, you can edit the position of the legend in the ____ dialog
box. a.  Legend  c.  Chart
Options  b.  Chart Type  d.  Chart Format     

Completion
Complete each sentence or
statement.


31.

To
view all available Excel functions, open the _________________________ dialog box.


32.

To
show comparisons among individual items, you would create a(n) ____________________
chart.


33.

A(n)
____________________ chart is created on the same sheet as the data used in the chart.


34.

The
symbol _____________________ is used to indicate division in an Excel formula.


35.

The
symbol to indicate multiplication in a formula is a(n) ____________________.


36.

In a
formula that contains both a multiplication and an addition operation, ____________________ will be
performed first.


37.

Excel
has more than 300 builtin ____________________ for performing calculations.


38.

You
usually create a chart from a(n) ____________________ of cells rather than the entire
worksheet.


39.

The
____________________ helps you identify chart options, including types of charts and data
labels.


40.

All
formulas begin with the ____________________ sign.


41.

Cell
references that contain both absolute and relative cell references are called ____________________
cell references.


42.

The
____________________ function totals a range of cells and then divides the total by the number of
entries in the range.


43.

The
number or cell reference in a formula is the _____________________.


44.

If
you want to be able to copy an Excel formula to other cells without the cell references changing, use
____________________ cell references.


45.

If
you see ##### displayed in a cell where you have entered a formula, it indicates a(n)
____________________.


46.

The
____________________ button is an exclamation point within a diamond that displays next to a cell
with a formula error.


47.

The
____________________ is a value, cell reference, range, or text that acts as an operand in a function
formula.


48.

The
Insert Function button is located on the ____________________.


49.

When
a function formula includes more than one argument, ____________________ are used to separate the
arguments.


50.

An
accurate worksheet allows you to draw ____________________ conclusions from the data
presented.
