Mr. Musser
Computer Literature 1
Spreadsheets, Day 1
Directions: From the packet, complete the following written activity. After completing the activity, do practices 1-3. Save Practice #1 as practice, Practice #2 as Grades and practice #3 as Test.
A______is simply rows and columns of data. They are used to organize any type of ______data. A______runs horizontally and a ______runs vertically. ______spreadsheets are able to perform ______on the data they story. Columns are lettered ______and then______for ______columns and rows are numbered ______for _____ number of rows. Normally spreadsheets are much smaller. The intersection of a row and column is called a ______. An entry in row 2 column 3 would be labeled______. Commands are accessed from menus in the ______bar. Spreadsheets can store three types of data in cells: ______, ______, and ______/______. ______are text and cannot be used in calculations, while ______are numberic and can be used in calculations.
There are several ways to move about a spreadsheet. The ______bars or the arrow keys allow the user to move up and down and left and right through a document. The ______pointer can also be used. Using the ______key moves the cursor left and right across a row and the ______key moves the user down a column.
The primary benefit of a spreadsheet is its ability to perform ______. To perform these ______, ______are used. Every formula must begin with an ______. Addition is denoted by a ___sign, subtraction a _____ sign, multiplication a _____, division a ____ and exponents by a _____. Word will evaluate a formula based on the ______. The number ______is displayed by the following formula =9+12/3. Word evaluates the formula from ______to ______. If a formula contains two operators of equal priority, the ______operator is performed first. The order of operations is ______, ______and ______, ______and ______unless parentheses are present in which case ______are performed first.
Enter the following formulas into a spreadsheet and save it math. Record the answers
a. =4+3^2 ______
b. =3+5*6/2 ______
c. =7+4*2 ______
d. =(7+4)*2 ______
e. =2*2+3*2 ______
f. =25*8/4 ______
g. =35+12/3 ______
h. =3+5*8+4 ______
i. (3+5)*(8+7) ______
j. 3^2*8+4 ______
k. 6+2^2 ______
l. (6+2)^2 ______
Stop at 8.8