Computer Literature 1

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