65 Project 8
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 65 Project 8 as PDF for free.
More details
- Words: 291
- Pages: 2
UNIT TITLE: Excel 2000 - Formulas NAME: Mr. Newton
DAY: 6 CONTENT AREA: Spreadsheets
24964347.doc
Page 1 of 2 Project 8
Project 8 Directions (pg. 224) 1.
Grading:
a)
Value: 10 pts.
b)
Each error results
Copy the formula across to the range of cells C10:F10.
7.
in –1 pt. c)
Talkers/cheaters will lose points.
Remember to use an absolute cell reference.
Talkers: -2 first offense Talkers: receive 0/10 for second offense.
8.
Right-align column headings and format columns B through E to the Comma format with zero decimal places.
9.
Format column F to Percentage format, with one decimal place.
10.
Change the column widths as necessary.
11.
Add the following to Properties Summary:
Cheaters: 0/10 first offense. 2.
Start MS Excel, if necessary.
3.
Enter the Labels and Values as shown in Illustration A.
4.
Format the first title to bold, 14 points. Format the second title to bold, 12 points. Bold the column and row headings. See Illustration A.
5.
Write a formula in cell E5 to calculate the total earnings for Region A. Copy the formula down to the other Regions.
Write a formula in cell F5 to calculate the percentage of earnings Region A is of the total earnings. Copy the formula down to the other Regions.
12.
•
Title: Project 8
•
Subject: Period #
•
Author: Your Name Proof read your work for
errors. 64_Excel_Exercise Write a formula in B10See-> to Dir to help with the logic calculate the total January earnings. 13. Raise your hand and sit Illustration on this formula. IllustrationAA quietly to have your work graded.
6.
UNIT TITLE: Excel 2000 - Formulas NAME: Mr. Newton 24964347.doc
DAY: 6 CONTENT AREA: Spreadsheets Page 2 of 2 Project 8
DAY: 6 CONTENT AREA: Spreadsheets
24964347.doc
Page 1 of 2 Project 8
Project 8 Directions (pg. 224) 1.
Grading:
a)
Value: 10 pts.
b)
Each error results
Copy the formula across to the range of cells C10:F10.
7.
in –1 pt. c)
Talkers/cheaters will lose points.
Remember to use an absolute cell reference.
Talkers: -2 first offense Talkers: receive 0/10 for second offense.
8.
Right-align column headings and format columns B through E to the Comma format with zero decimal places.
9.
Format column F to Percentage format, with one decimal place.
10.
Change the column widths as necessary.
11.
Add the following to Properties Summary:
Cheaters: 0/10 first offense. 2.
Start MS Excel, if necessary.
3.
Enter the Labels and Values as shown in Illustration A.
4.
Format the first title to bold, 14 points. Format the second title to bold, 12 points. Bold the column and row headings. See Illustration A.
5.
Write a formula in cell E5 to calculate the total earnings for Region A. Copy the formula down to the other Regions.
Write a formula in cell F5 to calculate the percentage of earnings Region A is of the total earnings. Copy the formula down to the other Regions.
12.
•
Title: Project 8
•
Subject: Period #
•
Author: Your Name Proof read your work for
errors. 64_Excel_Exercise Write a formula in B10See-> to Dir to help with the logic calculate the total January earnings. 13. Raise your hand and sit Illustration on this formula. IllustrationAA quietly to have your work graded.
6.
UNIT TITLE: Excel 2000 - Formulas NAME: Mr. Newton 24964347.doc
DAY: 6 CONTENT AREA: Spreadsheets Page 2 of 2 Project 8
Related Documents
65 Project 8
June 2020 2
Taxydromos 4-8-65
April 2020 2
Elefteria 12-8-65
April 2020 3
65
November 2019 58
65
May 2020 47
65
November 2019 63More Documents from ""
65 Project 8
June 2020 2
