lesson #6
In order to start the tutorial for lesson 6, you must prepare the workbook that you will be using to complete it. Please read the situation presented below and proceed to create the workbook as shown in the pictures.
Situation:
The Honor Society advisors from X school needed to raise funds in order to host an activity for infant children. The Honor Society students were asked to sell cookies to raise funds. To make this sale fun, attractive, and challenging, the advisors use it as a competition. They told students that there will be a prize for the group (girls & boys) who sells the greatest amount of cookies. The goal was to raise at least $200. Once, the competition was over, the advisors prepare a workbook in Excel to choose the winner of the competition and evaluate each student's performance.
Take the role of the advisor and prepare the competition sale workbook using Excel as shown in the following pictures:
Situation:
The Honor Society advisors from X school needed to raise funds in order to host an activity for infant children. The Honor Society students were asked to sell cookies to raise funds. To make this sale fun, attractive, and challenging, the advisors use it as a competition. They told students that there will be a prize for the group (girls & boys) who sells the greatest amount of cookies. The goal was to raise at least $200. Once, the competition was over, the advisors prepare a workbook in Excel to choose the winner of the competition and evaluate each student's performance.
Take the role of the advisor and prepare the competition sale workbook using Excel as shown in the following pictures:
Step #1:
|
Step #2:
Click the plus sign located in the sheet tabs two times to add two new sheets to the workbook.
Click the plus sign located in the sheet tabs two times to add two new sheets to the workbook.
Step #3:
- Use the picture provided to create the 2nd worksheet of your workbook.
- Add data to Sheet2
- For the title use: Merge, 20% Accent 5, Title Format, size 18
- Change row 1 height: 45 or 0.63"
- Categories: Bold, center align, size 12
- Change row 2 height: 30 or 0.42"
- For range F3:F4 add: accounting number format
Step #4:
- Use the picture provided to create the 3rd worksheet of your workbook.
- Copy the data of Sheet2 (A1:F14) & paste it in Sheet3
- Change row 1 height: 45 or 0.63"
- Change row 2 height: 30 or 0.42"
- Fix title: replace the word GIRLS for BOYS
- Clear all girls data
- Add the boys data
- Save workbook
Step #5:
- Use workbook (HScompetitionYour Initials) to complete the following tutorial.
Step #6
Vocabulary Words:
- Get your notebook and the Excel book
- Copy vocabulary words and definitions (use list below)
- Teacher must sign your notebook once you finish
Vocabulary Words:
- filter
- filter arrow
- sort
- descending sort
- ascending sort
- conditional formatting
- comment
- hyperlink
- picture
- shape
- screenshot
- SmartArt graphic
- object
- 3-D reference
- destination
- source
- worksheet range