Study Guide: Spreadsheets - Enter all known or given values

<<Previous

Next>>

Step 2 - Enter all known or given values.

The State College and University System publishes data on enrollment and student majors. This data is available by race and gender and your supervisor has requested the data reported by gender. You copied the following state data on declared majors for entering freshmen and graduated students four years later:

	Entering Freshmen		Four Year Graduates
Major	Female	Male	Female	Male
Business	3465	4321	4213	5213
Computer Science	2123	3347	3287	4476
Education	1234	1000	3012	1413
Other	2132	1357	403	426
Undecided	4567	5678	0	0

Click in cell B4 to make it the active cell. Enter the known data starting B4:E8. Compare your work to the sample below. Proofread your entries to ensure accuracy.

Remember to save your work.