0 of 2 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
You must sign in or sign up to start the quiz.
You must first complete the following:
Quiz complete. Results are being recorded.
0 of 2 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)
-
Current
-
Review
-
Answered
-
Correct
-
Incorrect
-
Question 1 of 2
Insert the following information in a new worksheet:
|
A
|
B
|
|
Salesperson
|
Invoice
|
|
Buchanan
|
15,000
|
|
Buchanan
|
9,000
|
|
Suyama
|
8,000
|
|
Suyama
|
20,000
|
|
Buchanan
|
5,000
|
|
Dodsworth
|
22,500
|
- In the following blank cell, enter the following formula: =SUM(B2:B3, B5) Adds two invoices from Buchanan, and one from Suyama (44,000)
- In the following blank cell, enter the following formula: =SUM(B2,B5,B7) Adds individual invoices from Buchanan, Suyama, and Dodsworth (57,500)
- The SUM function can include up to 30 cell or range references
-
Question 2 of 2
Grading can be reviewed and adjusted.
Grading can be reviewed and adjusted.