Embedded Files
Creating a Simple Spreadsheet
Creating a Simple Spreadsheet
In this part of the tutorial you will create a simple spreadsheet to keep track of checking account transactions.
Do the following:
➤ From within Google Sheets, go to the File menu and select New from the menu options. Select the Spreadsheet option from the menu. A new blank spreadsheet should appear.
➤ If necessary, resize and position the Spreadsheet window next to the tutorial.
➤ Click on the "Untitled spreadsheet" title and rename the sheet as "Checking".
All changes will automatically be saved in your Google Drive.
➤ Insert the following dates in column A, starting in cell A1:
Date:
7/14
7/15
7/18
7/20
➤ Type Description in cell B1
It would be best if the total sum of the grades was beneath the last grade. You need to insert a column between column A and column B so you don't have to retype all the numbers.
Changing Column Widths
Changing Column Widths
Do the following:
➤ Position your cursor between the column headings for column A and column B
The cursor should change shape to show a double arrow as you position the cursor between the two column headings. When the cursor changes shape, you can change the width of the column by dragging to the right or left.
➤ Click and drag to the left until the width of column A better fits the text.
You can simply double click in between the two column headings (while the cursor shows a double arrow) to automatically fit the column width to the text.
Do the following:
➤ Enter the following data into your spreadsheet:
➤ Continue to change the column widths as necessary.
Before you add more to your "Checking" spreadsheet, you will need to learn how to write formulas using arithmetic operators and functions.
Page updated
Google Sites
Report abuse