ABC Spreadsheet in Excel

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 N1 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 for Assignments #2.
Click the plus at the bottom of the Sheet.
Double click the word Sheet or			right click to rename the new sheet Formula.
Increase the magnification from 100% to 150%
	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, #4 and #5.
Click the plus at the bottom of the Sheet.
Double click the word Sheet or Right Click to rename the new sheet ABC.
Increase the magnification from 100% to 150%
	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 Follow the directions to duplicate a sheet.
	Look at the pictures and follow the CLICKS.
	Step 1 - Right Click on the ABC Sheet at the bottom of any sheet.
	CLICK on the new sheet called ABC (2)
	Move the NEW ABC Spreadsheet called ABC(2) to the end of the list of sheets.
	Delete the bar chart and the pie chart on Sheet ABC (2).

	#5b Right Click in the middle of Column E to Insert 3 rows & 3 columns. Insert 3 rows, & 3 columns into the table. Insert entire row 3 times. Insert entire column 3 times. #5c Insert the new data to fill out the table and make sure that the formulas function. #5d Upload your Excel file into your Google Drive. The Excel document will convert to a Google Sheet document.

#5d Upload your Excel file into your Google Drive > _Biz Folder.

The Excel document will convert to a Google Sheet document.

#5e In Google Sheets create a pie chart on SHEET ABC(2).

#5e - Create a Pie chart in
Google Sheets on the ABC (2) Sheet.

How To Create A Pie Chart In Google Sheets (With %'s)

Pie Chart in Google Sheets

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?

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