Spreadsheets
MEMO TO THE STAFF
Mr. McGee used his spreadsheet application to prepare a company
budget. The spreadsheet shown below presents Mr. McGee's budget
estimates for the next three months. Note that the cells in the
row across the top of the spreadsheet show the column titles
(the months) and the cells in the column on the left show the
row titles (the budget categories). The cells in the body of the
spreadsheet show the dollar estimates.
Please note that the spreadsheet application has totaled the
estimates for each month. These totals are shown in the bottom row.
The application has also totaled the estimates for the three expense
categories. These totals are shown in the column on the right. The
grand total for the three months is shown in the bottom right-hand
cell.
| |
APRIL |
MAY |
JUNE |
TOTAL |
|
Salaries |
$30,000 |
$30,000 |
$32,000 |
$92,000 |
|
Equipment and Supplies |
$2,500 |
$2,250 |
$2,800 |
$7,550 |
|
Overhead |
$6,000 |
$6,000 |
$6,000 |
$18,000 |
|
Total |
$38,500 |
$38,250 |
$40,800 |
$117,550 |
WHAT DO YOU KNOW?
Read the preceding memo. Using context clues, determine the meaning of each italicized word. Then, from the following list, select the word that best completes each sentence and write the word in the blank space provided. Check the definition to verify your answer.
|
spreadsheet |
row |
column |
cell |
| 1 | The area in Mr. McGee's budget that contains the number $2,800 is called a _______________. |
|
A1:
| cell. Actually, each little square in the table is called a cell. |
| 2 | All of the salaries and their total are shown in one _______________. |
|
A2:
| row. The salaries and their total are listed horizontallyacross the tablein a row. |
| 3 | All of the expenses for April are shown in one _______________. |
|
A3:
| column. The expenses for April are listed verticallydown the tablein a column. |
| 4 | _______________ refers to the format of Mr. McGee's budget presentation and the application that made it. |
|
A4:
| spreadsheet. Mr. McGee's data is laid out in a spreadsheet format. Spreadsheets can be paper with the lines laid out in a grid, or spreadsheets can be electronic, that is, computer applications. |
|
TERMS RELATED TO SPREADSHEETS
spreadsheet
a table consisting of rows and columns; computer spreadsheet applications can do much more than simply display text and numbers; they can perform sophisticated calculations defined by users row
horizontal section; an area going across the sheet column
vertical section; an area going down the sheet cell
in a spreadsheet, the area where a row and a column intersect |
|