ABC Spreadsheet in Excel

Skyview Middle School Website


Click the title for each subject's assignments.

Intro to Excel
# 1a USA / #1bCalculations	# 2 Video	# 3 ABC Video	# 4 ABC Charts	# 5 ABC (2)	# 6 GPA

In Excel create on document and 3 Sheets within the one document. Save as Last_FirstName_ABC
	Open a NEW Excel document. Save as LastName_FirstName_ABC. #1a C.W. - USA cw CLASSWORK only Part 1 CW ~ At the bottom of the sheet rename Sheet > USA. Follow along in class with the instruction. #1b Click for the Calculations Spreadsheet Recreate the Calculations Spreadsheet starting in Cell O1 of the USA Spreadsheet. Program the Total cells with the formulas. Do not just type a number in. 1. Type the formulas listed below in the first box under the word Total. 2. Then fat plus to skinny plus > Click Hold drag > down two boxes. Addition Formula =O3+P3 or =SUM(O3:P3) Multiplication Formula =S3T3 or =Product(S3:T3) Division Formula* =O8/P8 Subtraction Formula =S8-T8
.
	Create a new Sheet by clicking the plus + at the bottom of Sheet USA. Rename Sheet > name it Formulas. Follow along with the video. #2 Click > Formulas Video on Youtube or Click to download the video. Program the Total cells with the formulas. Do not just type a number in. 1. Type the formulas listed below in the first box under the word Total. 2. Then fat plus to skinny plus > Click Hold drag > down two boxes. Addition Formula =b4+c4 or SUM(b4:c4) Subtraction Formula =b8-c8 Multiplication Formula =b12c12 or Product(b12:c12) Division Formula* =b16/c16

When you download videos there are two possible windows that might open. Below are the window options follow the instrutctions. or If you can not find the video check your folder in your PC Folder on your desktop..
.
	Create a new Sheet for Assignments #3 and #4. Click the plus at the bottom of the Formulas Sheet. Rename the new sheet ABC. Follow along with the videos.
	#3 ABC on Youtube Follow along with the video in order to create a spreadsheet in Excel that uses an Auto SUM formula (fx) to calculate the totals of doughnuts sold for each month.	10:00 min.	ABC Spreadsheet

	#4a - BAR Chart Video on Youtube 11:13 min. Create 2 very informative, creative and visually pleasing charts. Don't forget to change the titles. #4a - Chart Video on Youtube 11:53 min.NO Sound	10:38 min	4a EXCEL Chart 1 Make the Bar Chart Pretty
	#4b EXCEL Chart 2 Insert a Pie Chart	5:36 min	4b EXCEL Chart 2 Insert a Pie Chart


Chart Problems Video 1 Chart Problems Video 2		8:43 min

Click to watch the video about the below chart. 1. This chart needs the months not 1, 2, 3, 4, 5, 6. 2. This chart needs the doughnut names not Series 1, Series 2, Series 3, Series 4, Series 5, Series 6. Pie Chart in Google Sheets How To Create A Pie Chart In Google Sheets (With Percentages!) .
Click to learn How to duplicate a Sheet in Excel	#5a Duplicate the Sheet ABC & Rename the Sheet ABC (2) Follow the directions to duplicate a sheet.

	Delete the bar chart and the pie chart on Sheet ABC (2). #5b Insert 3 rows, 3 columns into the table & create 1 new UNIQUE Chart. Right Click in the middle of the table (C4) & Insert 3 rows & 3 columns. Make sure that you are on the NEW ABC Spreadsheet called ABC(2). #5c Insert the new data to fill out the table and make sure that the formulas function. #5d Drop your Excel file into your Google Drive. The Excel document will convert to a Google Sheet document.

#5e - Create a Pie chart in Google Sheets.
Pie Chart in Google Sheets
How To Create A Pie Chart In Google Sheets (With %'s)

5:00
min

5e Google Sheets
Pie Chart

Intro to Google Sheets In your Google Drive create one document and put it in your Shared Biz Folder. Save as Last_FirstName_GPA
	# 6 GPA Sheet in Google Sheets

	Frequently Asked Questions


	Where is the AUTO SUM button? a.k.a. Where is the FX button?

	Where is the Chart Button?

	Frequently Asked Questions

	Where is the FX button?

	Frequently Asked Questions

	Where is the Chart Button?

	Frequently Asked Questions

	Where is the Text Wrap Button?	Where is the Merge and CenterButton?

	Frequently Asked Questions

	Where is the Settings and Print Preview? Special Note - This version there is no Print Preview Settings.

	Where is the Merge Button?

	Where is the Conditional Formatting Button?
	Ms. Church show me how to Conditional Format cells.

	Frequently Asked Questions

	Where is the Chart Button?

G.P.A.	Frequently Asked Questions

	Where is the Merge and Conditional Formatting Button?