Name: Pushpa Gupta By checking the Declaration box to the

Student #: 4387620 understand it is an offence to submit an

Instructions
1. Format the data in the Inventory sheet in an appealing way using a Table. This should
a. Include a Total Row.
b. In the Total Row, include the sum of the Quantity column and the average
2. Create a Lookup worksheet.
3. On the Lookup worksheet, create an interface that allows a user to input an item numb
a. Product
b. Manufacturer
c. Description
d. Manufacture Year
e. Cost
f. Quantity
4. Add Named Ranges of the following:
a. name B2:B60 Products
b. name C2:C60 Brands
c. name D2:D60 Details
d. name E2:E60 Years
e.
f. name G2:G60 Amounts
5. Put a statistics section in the Lookup tab that calculates the min, max, and average cos
6. Insert another column in your Inventory table called Order that will conditionally state
a. If the quantity of that item is less than 3, the Order column should state Yes
b. If the quantity of that item is greater than or equal to 3, the Order column s
c. In the Lookup tab, include a formula that determines the number of differen

Status Continue worki

ration box to the right, I am declaring that the work I am submitting is my own and that I
ence to submit another student's work.
Instructions
Table. This should be unique and not similar to someone else. Customize it.

mn and the average of the Cost column.

nput an item number with the following output describing the item:

x, and average costs using the appropriate named range.

conditionally state whether to order an item.
mn should state Yes.
he Order column should state No.
number of different item numbers that need to be ordered.

Continue working through this assessment.

TRUE

FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Item Number Product Manufacturer Description Stock Year
11498 Mouse Ctech Wired 2020
93402 Mouse Ctech Wired 2019
39040 Mouse AccessoriesInc Wired 2020
21766 Mouse AccessoriesInc Wireless 2021
64372 Mouse Integral Wireless 2020
70357 Mouse Integral Wired 2021
36479 Mouse Integral Wired 2021
98392 Keyboard Ctech Wireless 2018
69640 Keyboard Ctech Wireless 2019
27644 Keyboard AccessoriesInc Wired 2018
49345 Keyboard AccessoriesInc Wired 2019
81292 Keyboard AccessoriesInc Wireless 2020
21549 Keyboard Integral Wireless 2021
14390 Tower Integral i5 2020
18432 Tower Integral i5 2021
40331 Tower Integral 5500 2021
69636 Tower Ctech 3100 2021
49696 Monitor Ctech 27" 2020
14766 Monitor AccessoriesInc 27" 2020
24736 Monitor Integral 31" 2021
41076 Monitor Integral 31" 2020
20967 Speakers Newtech Wired 2019
49681 Speakers AccessoriesInc Wired 2019
62943 Speakers AccessoriesInc Wired 2018
27932 Speakers Newtech Wired 2021
51274 Mic Newtech Wired 2019
30997 Mic AccessoriesInc Wired 2019
15391 Blank Paper Stock Essentials White 2020
37649 Lined Paper Stock Essentials White 2021
54392 Grid Paper Stock Essentials White 2022
80767 Ball Point PensVibrant Blue 2022
96557 Ball Point PensVibrant Black 2021
82546 Gel Pens Vibrant Blue 2021
27766 Gel Pens Vibrant Black 2022
53683 Gel Pens Vibrant Red 2022
74835 Felt Tip Pens Artistic Plus Black 2023
17487 Felt Tip Pens Artistic Plus Green 2022
78268 Clear Ruler Stock Essentials Clear 2023
47964 Solid Ruler Stock Essentials Black 2023
74137 Solid Ruler Stock Essentials Purple 2023
92183 Stapler Stock Essentials Black 2022
67346 Stapler Offex Black 2022
69954 Stapler Offex Black 2022
94588 Staples Stock Essentials Silver 2021
94614 Staples Stock Essentials Red 2020
80505 Staples Offex Silver 2023
22183 Staples Offex Black 2021
 96658 3 Hole Punch Supplize Silver 2021
61086 3 Hole Punch Offex Gray 2021
36727 1 Hole Punch Supplize Silver 2022
77874 1 Hole Punch Offex Red 2023
97739 Desk Chair ErgoDen Gray 2023
39507 Desk Chair ErgoDen Black 2023
82000 Desk Chair Comfort+ Black 2022
38321 Desk Chair Comfort+ Gray 2023
60093 Office Desk ErgoDen Brown 2022
41467 Office Desk Comfort+ Maple 2023
95957 Office Desk Official Black 2022
75353 Office Desk ErgoDen Chestnut 2022

Total
Cost Quantity Order
$ 49.99 4 No
$ 44.99 5 No
$ 25.99 3 No
$ 29.99 10 No
$ 69.99 2 Yes
$ 75.99 1 Yes
$ 79.99 1 Yes
$ 45.99 6 No
$ 54.99 2 Yes
$ 34.99 4 No
$ 39.99 5 No
$ 44.99 11 No
$ 59.99 4 No
$ 499.99 1 Yes
$ 549.99 2 Yes
$ 649.99 1 Yes
$ 499.99 1 Yes
$ 109.99 2 Yes
$ 149.99 2 Yes
$ 199.99 5 No
$ 249.99 3 No
$ 39.99 3 No
$ 29.99 2 Yes
$ 24.99 1 Yes
$ 45.99 1 Yes
$ 19.99 2 Yes
$ 24.99 1 Yes
$ 4.00 35 No
$ 4.00 19 No
$ 4.00 10 No
$ 2.25 44 No
$ 2.25 24 No
$ 1.99 27 No
$ 1.99 13 No
$ 1.99 21 No
$ 3.50 15 No
$ 3.50 6 No
$ 1.50 8 No
$ 1.25 8 No
$ 1.25 15 No
$ 20.00 7 No
$ 29.99 5 No
$ 39.99 3 No
$ 3.00 11 No
$ 3.50 10 No
$ 4.50 18 No
$ 5.50 4 No
$ 15.00 10 No
$ 10.00 3 No
$ 4.00 3 No
$ 3.00 4 No
$ 25.00 6 No
$ 32.00 10 No
$ 38.00 12 No
$ 28.00 9 No
$ 50.00 3 No
$ 46.00 2 Yes
$ 51.00 2 Yes
$ 39.00 4 No
Yes
$ 71.77 456
 Feel free to change the look or placement of anything here.

Item Number Product Manufacturer Description

11498 #NAME? #NAME? #NAME?

Statistics
Min Cost $ 1.25
Max Cost $ 649.99
Average Cost $ 71.77
# of Orders 1
or placement of anything here.

Stock Year Cost Quantity

#NAME? #NAME? #NAME?
 Inventory Table Copy

Item NumbProduct ManufacturDescriptionStock Year Cost Quantity Order

11498 Mouse Ctech Wired 2020 $ 49.99 4 No
93402 Mouse Ctech Wired 2019 $ 44.99 5 No
39040 Mouse AccessoriesWired 2020 $ 25.99 3 Yes
21766 Mouse AccessoriesWireless 2021 $ 29.99 10 Yes
64372 Mouse Integral Wireless 2020 $ 69.99 2 Yes
70357 Mouse Integral Wired 2021 $ 75.99 1 No
36479 Mouse Integral Wired 2021 $ 79.99 1 Yes
98392 Keyboard Ctech Wireless 2018 $ 45.99 6 No
69640 Keyboard Ctech Wireless 2019 $ 54.99 2 No
27644 Keyboard AccessoriesWired 2018 $ 34.99 4 No
49345 Keyboard AccessoriesWired 2019 $ 39.99 5 No
81292 Keyboard AccessoriesWireless 2020 $ 44.99 11 Yes
21549 Keyboard Integral Wireless 2021 $ 59.99 4 Yes
14390 Tower Integral i5 2020 $ 499.99 1 Yes
18432 Tower Integral i5 2021 $ 549.99 2 Yes
40331 Tower Integral 5500 2021 $ 649.99 1 Yes
69636 Tower Ctech 3100 2021 $ 499.99 1 Yes
49696 Monitor Ctech 27" 2020 $ 109.99 2 No
14766 Monitor Accessories27" 2020 $ 149.99 2 No
24736 Monitor Integral 31" 2021 $ 199.99 5 No
41076 Monitor Integral 31" 2020 $ 249.99 3 Yes
20967 Speakers Newtech Wired 2019 $ 39.99 3 Yes
49681 Speakers AccessoriesWired 2019 $ 29.99 2 Yes
62943 Speakers AccessoriesWired 2018 $ 24.99 1 Yes
27932 Speakers Newtech Wired 2021 $ 45.99 1 Yes
51274 Mic Newtech Wired 2019 $ 19.99 2 No
30997 Mic AccessoriesWired 2019 $ 24.99 1 No
15391 Blank PapeStock Essen White 2020 $ 4.00 35 No
37649 Lined PapeStock Essen White 2021 $ 4.00 19 No
54392 Grid Paper Stock Essen White 2022 $ 4.00 10 No
80767 Ball Point Vibrant Blue 2022 $ 2.25 44 No
96557 Ball Point Vibrant Black 2021 $ 2.25 24 No
82546 Gel Pens Vibrant Blue 2021 $ 1.99 27 No
27766 Gel Pens Vibrant Black 2022 $ 1.99 13 No
53683 Gel Pens Vibrant Red 2022 $ 1.99 21 No
74835 Felt Tip Pe Artistic Plu Black 2023 $ 3.50 15 No
17487 Felt Tip Pe Artistic Plu Green 2022 $ 3.50 6 No
78268 Clear RulerStock Essen Clear 2023 $ 1.50 8 No
47964 Solid RulerStock Essen Black 2023 $ 1.25 8 No
74137 Solid RulerStock Essen Purple 2023 $ 1.25 15 No
92183 Stapler Stock Essen Black 2022 $ 20.00 7 No
67346 Stapler Offex Black 2022 $ 29.99 5 No
69954 Stapler Offex Black 2022 $ 39.99 3 No
94588 Staples Stock Essen Silver 2021 $ 3.00 11 No
 94614 Staples Stock Essen
Red 2020 $ 3.50 10 No
80505 Staples Offex Silver 2023 $ 4.50 18 No
22183 Staples Offex Black 2021 $ 5.50 4 No
96658 3 Hole PunSupplize Silver 2021 $ 15.00 10 No
61086 3 Hole PunOffex Gray 2021 $ 10.00 3 No
36727 1 Hole PunSupplize Silver 2022 $ 4.00 3 No
77874 1 Hole PunOffex Red 2023 $ 3.00 4 No
97739 Desk ChairErgoDen Gray 2023 $ 25.00 6 No
39507 Desk ChairErgoDen Black 2023 $ 32.00 10 No
82000 Desk ChairComfort+ Black 2022 $ 38.00 12 No
38321 Desk ChairComfort+ Gray 2023 $ 28.00 9 Yes
60093 Office DeskErgoDen Brown 2022 $ 50.00 3 Yes
41467 Office DeskComfort+ Maple 2023 $ 46.00 2 No
95957 Office DeskOfficial Black 2022 $ 51.00 2 Yes
75353 Office DeskErgoDen Chestnut 2022 $ 39.00 4 No

Total $ 71.77 456