home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shelly Cashman Series Ex…s - A Record of Discovery
/
Explore.bin
/
LAB4.TXT
< prev
next >
Wrap
Text File
|
1997-03-27
|
2KB
|
96 lines
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) ___________