Shelly Cashman Series Lab - Working with Spreadsheets Lab


Name   ____________________________________


Course and Division _______________________


Date   ___________________       Page 1 of 2


As you step through the Interactive Lab, answer the following
questions in the spaces provided. For multiple choice
questions, enter the appropriate letter on the blank line.

1. A spreadsheet is a worksheet that resembles a table and is 
used for organizing numbers. (True or False) _____________

2. An electronic spreadsheet file can contain as many as  
_____ spreadsheets.

a. 125
b. 155
c. 225
d. 255

3. Columns and rows are used _____________.

a. as a formatting feature
b. for printing purposes
c. to organize data or information in a spreadsheet
d. for adding or inputting data

4. Cells are referenced by _____________.

a. column label
b. row label
c. labels defined by the user
d. column letter and row number

5. List 3 types of data you can enter into a cell.

a.  ___________________ 
b.  ___________________ 
c.  ___________________

6. When you change values in a spreadsheet, formulas are 
automatically ___________.

a. removed 
b. copied to an adjacent cell
c. recalculated
d. copied to another spreadsheet











Shelly Cashman Series Lab - Working with Spreadsheets Lab
Page 2 of 2

7. List 8 functions that come built-in with spreadsheet 
programs.

a.  ___________________ 
b.  ___________________ 
c.  ___________________
d.  ___________________
e.  ___________________
f.  ___________________
g.  ___________________
h. ___________________


8.  Columns are identified by  _____________.

a. letters ranging from A to IV
b. numbers from 1 to 256
c. letters from A to Z and numbers from 1 to 230
d. numbers from 1 to 230 and letters from A to Z


9. What-if analysis is a powerful tool for testing the impact 
of changing values in a formula.  (True or False) _________

10. A spreadsheet can convert numerical calculations into 
charts and graphs to show relationships graphically.  
(True or False)  ___________