Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Police Auditing Theories And Practices

Authors: Allan Y. Jiao

1st Edition

0398069808, 978-0398069803

More Books

Students also viewed these Accounting questions

Question

3. Identify cultural universals in nonverbal communication.

Answered: 1 week ago