Practice Module 1 – Excel (Part 1)
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Time limit: 0
Practice Exercise Summary
0 of 6 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 6 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 6
1. Question
- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester’s “Shipping” value to $3.25 in cell H8.
- Modify Samantha Tin’s number of orders from 10 to 9 in cell F6.
- Change Joe Smith’s “Price per Poster” to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: baileyjones@gmail.com
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!
CorrectIncorrect -
Question 2 of 6
2. Question
- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester’s “Shipping” value to $3.25 in cell H8.
- Modify Samantha Tin’s number of orders from 10 to 9 in cell F6.
- Change Joe Smith’s “Price per Poster” to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: baileyjones@gmail.com
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!
CorrectIncorrect -
Question 3 of 6
3. Question
- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester’s “Shipping” value to $3.25 in cell H8.
- Modify Samantha Tin’s number of orders from 10 to 9 in cell F6.
- Change Joe Smith’s “Price per Poster” to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: baileyjones@gmail.com
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!
CorrectIncorrect -
Question 4 of 6
4. Question
- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester’s “Shipping” value to $3.25 in cell H8.
- Modify Samantha Tin’s number of orders from 10 to 9 in cell F6.
- Change Joe Smith’s “Price per Poster” to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: baileyjones@gmail.com
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!
CorrectIncorrect -
Question 5 of 6
5. Question
- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester’s “Shipping” value to $3.25 in cell H8.
- Modify Samantha Tin’s number of orders from 10 to 9 in cell F6.
- Change Joe Smith’s “Price per Poster” to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: baileyjones@gmail.com
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!
CorrectIncorrect -
Question 6 of 6
6. Question
- Finish the instructions in the Sheet1 sheet.
- Navigate to the Posters & Co. sheet and complete the given instructions.
- In Posters & Co., make the following changes:
- Change Maslin Lester’s “Shipping” value to $3.25 in cell H8.
- Modify Samantha Tin’s number of orders from 10 to 9 in cell F6.
- Change Joe Smith’s “Price per Poster” to $10.50 in cell G4.
- Insert a new row above Maslin Lester with the following data:
- Date: 6/11/19
- First: Bailey
- Last: Jones
- Phone: 281-285-6849
- Email: baileyjones@gmail.com
- # of Posters: 5
- Price per Poster: $11.35
- Shipping: $7.25
- In J4 write a formula to determine the Date of Shipping. This is determined by adding 4 business days to the order date in column A. Autofill it for the rest of the rows.
- Save your file!
CorrectIncorrect