Answered step by step
Verified Expert Solution
Question
1 Approved Answer
based on the worksheet we need to answer the MCQ's Bonus DO NOT MODIFY THIS TABLE! Years Bonus Seniority 13 Vacation/wks Vacation Employee Bob Carol
based on the worksheet we need to answer the MCQ's
Bonus DO NOT MODIFY THIS TABLE! Years Bonus Seniority 13 Vacation/wks Vacation Employee Bob Carol Ted . Alice 0 5 4 Table1 24 10 15 9 10 Part 2.2 Description Price Discount Discounted Price Extended Cost Price 11 Part Number 12. 110 Oty 5 Table2 DO NOT MODIFY THIS TABLE! Part Number Description Supplier 110 Wing Nut 10 Able 112 Wing Nut 12 Baker 116 Wing Nut 16 Charlie 124 Wing Nut 24 Delta 13 15 16 17 18 DO NOT MODIFY THIS TABLE! Quantity Discount South North Vickup Bonus Questi East West Multiple Worksheets What O 110 Table2 112 Wing Nut 10 Wing Nut 12 Wing Nut 16 Wing Nut 24 116 124 CH D DO NOT MODIFY THIS TABLE! Quantity Discount 1 2 Table3 5 10 15 25 IF Multiple Worksheets North South East West Bonus Questi... *** NOTE: The Lookup tables provided have been obscured so that you cannot see the values they contain. USE THE TABLE NAMES PROVIDED at the left side of each table in your formulas. The names refer to the red outlined areas on each table. Part 2.1 uses Table1, Part 2.2 uses Table2 and Table3. Question 6 (2 points) Enter the Formulas for Column D in Part 2.1 - Be sure to use the named range Table 1 in your formula. What is Alice's BONUS amount? A) $0 B) $275 c) $75 D) $150 Question 7 (2 points) What is Bob's VACATION amount? A) 4 weeks B) 1 week C) 10 weeks D) 2 weeks Question 8 (2 points) In Part 2.2, enter the formulae for Columns D through H. Make sure that you use, as needed, the named ranges Table and Table3 in your formulae. Using the values originally entered for Part Number and Qty, what is the final Extended Cost? A) $5.65 OB) $5.70 OC) $6.20 D) $5.95 Question 9 (2 points) Set the Part number to 110 and the Qty to 6. What is the final Extended Cost? A) $6.84 B) $7.44 C) $7.14 D) $6.78 Question 10 (1 point) On the VLOOKUP worksheet, you are allowed to select the lookup tables, but not see the values in the cells. How did I do this? O A) Using the Cell Format settings, I set the cells to Read Only. B) I erased the cells before saving the worksheet, so there in nothing in the tables. O C) Using the Cell Format settings, I set the tables cells to Hidden to make them NOT show up in the formula bar, and then made them grey text on a grey background. OD I used the Protect Workbook command to set the cells to be invisible. Bonus DO NOT MODIFY THIS TABLE! Years Bonus Seniority 13 Vacation/wks Vacation Employee Bob Carol Ted . Alice 0 5 4 Table1 24 10 15 9 10 Part 2.2 Description Price Discount Discounted Price Extended Cost Price 11 Part Number 12. 110 Oty 5 Table2 DO NOT MODIFY THIS TABLE! Part Number Description Supplier 110 Wing Nut 10 Able 112 Wing Nut 12 Baker 116 Wing Nut 16 Charlie 124 Wing Nut 24 Delta 13 15 16 17 18 DO NOT MODIFY THIS TABLE! Quantity Discount South North Vickup Bonus Questi East West Multiple Worksheets What O 110 Table2 112 Wing Nut 10 Wing Nut 12 Wing Nut 16 Wing Nut 24 116 124 CH D DO NOT MODIFY THIS TABLE! Quantity Discount 1 2 Table3 5 10 15 25 IF Multiple Worksheets North South East West Bonus Questi... *** NOTE: The Lookup tables provided have been obscured so that you cannot see the values they contain. USE THE TABLE NAMES PROVIDED at the left side of each table in your formulas. The names refer to the red outlined areas on each table. Part 2.1 uses Table1, Part 2.2 uses Table2 and Table3. Question 6 (2 points) Enter the Formulas for Column D in Part 2.1 - Be sure to use the named range Table 1 in your formula. What is Alice's BONUS amount? A) $0 B) $275 c) $75 D) $150 Question 7 (2 points) What is Bob's VACATION amount? A) 4 weeks B) 1 week C) 10 weeks D) 2 weeks Question 8 (2 points) In Part 2.2, enter the formulae for Columns D through H. Make sure that you use, as needed, the named ranges Table and Table3 in your formulae. Using the values originally entered for Part Number and Qty, what is the final Extended Cost? A) $5.65 OB) $5.70 OC) $6.20 D) $5.95 Question 9 (2 points) Set the Part number to 110 and the Qty to 6. What is the final Extended Cost? A) $6.84 B) $7.44 C) $7.14 D) $6.78 Question 10 (1 point) On the VLOOKUP worksheet, you are allowed to select the lookup tables, but not see the values in the cells. How did I do this? O A) Using the Cell Format settings, I set the cells to Read Only. B) I erased the cells before saving the worksheet, so there in nothing in the tables. O C) Using the Cell Format settings, I set the tables cells to Hidden to make them NOT show up in the formula bar, and then made them grey text on a grey background. OD I used the Protect Workbook command to set the cells to be invisible Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started