Microsoft Excel TEST
Directions:
You have the ENTIRE period to complete this test.
No talking, please.
Do not use the lessons from the class blog. This is not an "open book" test. Cheating will result in a zero on the exam. Using google to search for answers IS cheating.
*************
PART I. Please make a chart using the following information.
100 Students were polled to find out how many people thought Ms Luzzi is awesome.
58 Students said Ms Luzzi is Awesome!
3 Students said Ms Luzzi is Not Awesome.
12 Students said Ms Luzzi is Mad Awesome.
15 Students said Ms Luzzi is So Awesome it is Not Even Funny (SANEF).
12 Students said Ms Luzzi is the Most Awesome Person on this Earth (MAPE).
***
Your chart should be either a pie chart or a bar graph.
Please make a chart that includes labels with the percentages.
PART II.
Create a NEW Spreadsheet
Create a spreadsheet with the following information
Clothing you would need to buy for a tropical vacation.
Include AT LEAST 5 items. Include colors, sizes, where you can buy these things and approximate costs.
Use the AutoSum function to figure out the TOTAL cost of your items.
********************************
You will email me 2 Excel documents: The chart about how awesome I am and the spreadsheet of vacation clothing.
Once everyone has completed their exam, follow this link to your reward.
