Study Guide: Spreadsheets - Enter all labels and text

Click in cell A1 to make it the active cell. Enter the main title ‘STATE COLLEGE AND UNIVERSITY SYSTEM’ in cell A1. Do not include the single quotes.

Click in cell B2 to make it the active cell. Enter the column title ‘Entering Freshmen’ in cell B2.

Click in cell D2 to make it the active cell. Enter the column title ‘Four Year Graduates’ in cell D2.

Click in cell F2 to make it the active cell. Enter the column title ‘% Difference’ in cell F2.

Click in cell A3 to make it the active cell. Enter the following row titles and press the Enter key after each one. Major, Business, Computer Science, Education, Other, Undecided, Totals, Date. You should have a row title in each cell from A3:A10 (A3 through A10).

Click in cell B3 to make it the active cell. Enter the column title ‘Female’ in cells B3, D3, and F3.

Click in cell C3 to make it the active cell. Enter the column title ‘Male’ in cells C3, E3, and G3.

Compare your work to the sample below:

Choose a name for your spreadsheet and save it.