Master Activity 1
Complete the following Master Activity and submit your completed project.
Google Sheets
You will need to be logged into Google account to complete this assignment. Since Google Sheets is web based, it changes frequently. The steps outlined here may be slightly different from what you see on your screen. If you do not already have a Google account, you will need to create one. Go to http://google.com and in the upper right corner, click Sign In. On the Sign in screen, click Create Account. On the Create your Google Account page, complete the form, read and agree to the Terms of Service and Privacy Policy, and then click Next step. On the Welcome screen, click Get Started.
- From the desktop, open your browser, navigate to http://google.com, and then sign in to your Google account. In the upper right corner of your screen, click Google apps, and then click Drive. If you are already logged into Google click Apps, then Sheets.
- Click Blank to open a new untitled sheet.
- In the left pane, click New, and then click Google Sheets to open a new tab in your browser and to start an Untitled sheet. At the top of the window, click Untitled sheet and then, using your own name as the file name, type Lastname_Firstname_ExcelMaster1 and then press Enter to change the file name.
- To the right of the file name, point to the small file folder to display the ScreenTip Move to. Click the file folder and notice that your file is saved in the OFTEC 108 folder.
- In cell A1, type My Budget By Month and press Enter.
- In cell A2 Type For the First Quarter and press Enter.
- In Cell A4, Type each of the following, pressing Enter after each:
- Housing
- Groceries
- Utilities
- Misc Expenses
- Monthly Total
- In cell B3, type January and press Enter.
- Select cell B3 and use the fill handle to drag to cell E3. Notice how the names of the months automatically generate. The fill handle enables auto fill, which generates and extends a series of values into adjacent cells based on the value of other cells.
- Select cell E3 and press the Delete key.
- Select the range B4:D7 and enter the following text, pressing the tab key after each number.
|
|
January |
February |
March |
|
Housing |
1200 |
1200 |
1200 |
|
Groceries |
200 |
250 |
275 |
|
Utilities |
85 |
80 |
90 |
|
Misc Expenses |
20 |
50 |
30 |
- With cell B8 active go to the Insert tab, Function and choose SUM. Click in cell B4 and drag down to cell B7 and press Enter. With cell B8 selected, notice the formula bar shows =SUM(B4:B7), and the formula result also displays here. Press Enter if necessary.
- With cell B8 selected, use the fill handle to fill the formula to cells C8 and D8.
- Select the range A3:D7, be sure not to include the Totals.
- On the Insert Tab, choose Chart, and notice how a clustered column chart is added.
- Resize and move the chart so that the upper left hand corner fits in cell A10 and the lower right hand corner fits in cell E21.
- Select the chart, and choose the Ellipsis, which is the three small dots in the upper right hand corner of the chart. This will open the Chart Editor.
- In the chart editor, under Setup, select the arrow next to Chart Type to display all chart types. If you do not have access to Setup, continue on to step 20.
- Select any chart other than the Clustered Column Chart. Close the Chart Editor.
- On the Format tab, select Theme and choose the Streamline theme. Close Themes.
- Select the range A1:D1 and merge the cells, and then align center. This is on the format tab.
- Select the range A2:D2 and merge the cells, and then align center.
- Select cell A2. On the Insert tab, select Image, Image in Cell. In the Insert Image dialog box, scroll to the right until you see Google Image Search. Select this, and in the Search For box type Money then press Enter. Select any picture and then click insert.
- Resize cell A2 by dragging the line between the 2 and 3 down. Center align the image in the cell.
- Select the range B8:D8 and format the text as Currency. This is under Format.
- Click Tools, Spelling, Spell Check. Verify Spelling and Grammar is correct.
- Take a moment to preview your document, and make any adjustments as necessary. Ensure your document will be saved automatically. Submit as instructed by your instructor.