Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 In the following table, row 3 to row 6 specify the amount spent on various activities (watch movie, swimming, visit museum, playing tennis,
Question 2 In the following table, row 3 to row 6 specify the amount spent on various activities (watch movie, swimming, visit museum, playing tennis, dancing) by Peter in 4 randomly selected weeks: A B Week Activities Nm 1 2 3 1 D E F Amount spent Movie Swimming Museum Tennis Dancing 0 17 0 42 36 0 19 50 0 38 0 24 34 36 65 17 10 0 0 4 Swimming:($17) Tennis:($42) Dancing:($36) Swimming:($19) Museum:($50) Dancing:($38) Museum:($24) Dancing:($36) Tennis:($34) Movie:($65) Swimming:($17) Museum:($10) w N 5 6 4 Write down what should be entered exactly in Cell-F5 to extract the amount spent. If no-information is provided for such-activity type in Column B-on that week. 0 should be returned. (10 marks) As an example, the following 3-lines show the format in cell B34 Activities Type(colon (open bracket)(S)number(close bracket)(space) Activities Type(colon (open bracket)(S)number(close bracket)(space) Activities Type(colon Lopen bracket)(S)number(close bracket) Cells B4, B5 and B6-are in the same format as B3
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