Practice Module 5 – Excel (Part 2)
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Time limit: 0
Practice Exercise Summary
0 of 5 Questions completed
Questions:
Information
You have already completed the practice exercise before. Hence you can not start it again.
Practice Exercise is loading…
You must sign in or sign up to start the practice exercise.
You must first complete the following:
Results
Practice Exercise complete. Results are being recorded.
Results
0 of 5 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- Review / Skip
- Answered
- Correct
- Incorrect
-
Question 1 of 5
1. Question
- Go to the Phi Delt Gates Fundraiser worksheet. This worksheet displays projections for an organization’s projected sales for an upcoming Friday night fundraiser.
- In F6, use a function to calculate the total projected revenue based on the Food Sold and Sales Price values. (HINT: You should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F9 and F10, use a function to calculate the total projected costs for Food and Labor based on the Items Sold values. (HINT: Once again, you should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F11, calculate the projected income by taking the projected revenue in F6 and subtracting the projected costs in F9 and F10 from it.
- Save your file.
CorrectIncorrect -
Question 2 of 5
2. Question
- Go to the Phi Delt Gates Fundraiser worksheet. This worksheet displays projections for an organization’s projected sales for an upcoming Friday night fundraiser.
- In F6, use a function to calculate the total projected revenue based on the Food Sold and Sales Price values. (HINT: You should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F9 and F10, use a function to calculate the total projected costs for Food and Labor based on the Items Sold values. (HINT: Once again, you should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F11, calculate the projected income by taking the projected revenue in F6 and subtracting the projected costs in F9 and F10 from it.
- Save your file.
CorrectIncorrect -
Question 3 of 5
3. Question
- Go to the Phi Delt Gates Fundraiser worksheet. This worksheet displays projections for an organization’s projected sales for an upcoming Friday night fundraiser.
- In F6, use a function to calculate the total projected revenue based on the Food Sold and Sales Price values. (HINT: You should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F9 and F10, use a function to calculate the total projected costs for Food and Labor based on the Items Sold values. (HINT: Once again, you should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F11, calculate the projected income by taking the projected revenue in F6 and subtracting the projected costs in F9 and F10 from it.
- Save your file.
CorrectIncorrect -
Question 4 of 5
4. Question
- Go to the Phi Delt Gates Fundraiser worksheet. This worksheet displays projections for an organization’s projected sales for an upcoming Friday night fundraiser.
- In F6, use a function to calculate the total projected revenue based on the Food Sold and Sales Price values. (HINT: You should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F9 and F10, use a function to calculate the total projected costs for Food and Labor based on the Items Sold values. (HINT: Once again, you should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F11, calculate the projected income by taking the projected revenue in F6 and subtracting the projected costs in F9 and F10 from it.
- Save your file.
CorrectIncorrect -
Question 5 of 5
5. Question
- Go to the Phi Delt Gates Fundraiser worksheet. This worksheet displays projections for an organization’s projected sales for an upcoming Friday night fundraiser.
- In F6, use a function to calculate the total projected revenue based on the Food Sold and Sales Price values. (HINT: You should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F9 and F10, use a function to calculate the total projected costs for Food and Labor based on the Items Sold values. (HINT: Once again, you should not be using SUM here. There is a specific formula you need to use to compute this easily.)
- In F11, calculate the projected income by taking the projected revenue in F6 and subtracting the projected costs in F9 and F10 from it.
- Save your file.
CorrectIncorrect