Name:     ID: 
 
Email: 

Quiz 7 - Excel Tutorial one

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

 1. 

Microsoft Excel 2010 stores spreadsheets in files called workbooks.
 

 2. 

The formula bar displays the value or formula of the active cell.
 

 3. 

If you click the Print Active sheet(s) option button in the Print tab, the entire workbook will be printed.
 

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

 4. 

By default, an Excel workbook is made up of ____ worksheets.
a.
two
c.
four
b.
three
d.
five
 

 5. 

Text data is any combination of ____.
a.
letters and numbers
c.
only letters
b.
letters, numbers, and dates
d.
letters, numbers, and symbols
 

 6. 

To complete a cell entry, press the ____ key.
a.
Enter
c.
Backspace
b.
Home
d.
Delete
 

 7. 

The characters +, -, *, and / are examples of ____.
a.
formulas
c.
arithmetic operators
b.
values
d.
calculations
 

 8. 

The expression used to calculate values displayed in a worksheet is called a(n) ____.
a.
formula
c.
operator
b.
equation
d.
relation
 

 9. 

The formula used to multiply cell A1 by cell C1 is ____.
a.
=A1*C1
c.
=A1/C1
b.
C1*A1
d.
A1*C1
 

 10. 

A(n) ____ is a group of cells.
a.
cluster
c.
selection
b.
adjunct
d.
range
 
 
nar001-1.jpg
 

 11. 

In the figure above, “Documentation” and “Customer Orders” are names of ____.
a.
worksheets
c.
workbooks
b.
files
d.
folders
 

 12. 

To view formulas, rather than the resulting values in a worksheet, switch to ____.
a.
formula view
c.
editing mode
b.
normal view
d.
AutoSum view
 

Essay
 

 13. 

Bonus:
1.      Where would you be if there was no East or West?

2.      Which is smaller,  19/64, or 9/16?
 



 
         Start Over