Morgan Community College – Ag and Business Management 08/14/04
File:Study Guide - Spreadsheets.doc Page 7
Test your Knowledge
Spreadsheet Essentials
Test Your Knowledge
Name _____________________________________________
Date__________________________
Instructions: This test will help you determine what you know about spreadsheets.
Underlined items indicate the content of a spreadsheet cell. Follow the instructions for
each of the sections below. This assessment extends to a second page. Good luck.
Multiple-Choice: Read the statement and select the best answer by placing the letter
beside the answer in the blank space provided. Each question is worth 10 points.
1) ____ In a spreadsheet cell a number such as 3.1416 is considered to be a/an:
a) range
b) formula
c) label
d) value
e) None of the above
2) ____ If a spreadsheet cell contained =(72-27)*2 what number would the cell display?
a) 36
b) 18
c) 90
d) 3888
e) None of the above
True/False: Indicate whether the statement is true or false by placing a T or F in the
space by the statement. Each question is worth 10 points.
3) ____ Clicking on Format => Cells => Border allows the user to change the
background color of the spreadsheet cell.
4) ____ The formula =C$35*$A5G is a valid formula (in other words, it will NOT
result in an error message).
