Question: Q3. Write the excel function and output By using the below table (6 points) A. Calculate grand total by using SUMPRODUCT refer to A

Q3. Write the excel function and output By using the below table

Q3. Write the excel function and output By using the below table (6 points) A. Calculate grand total by using SUMPRODUCT refer to A cell in table. B. what is cost where city = Jeddah and product =laptop. (You must fix required columns and row) refer to B cell in table? C. what is cost where city = Dammam and product =television. refer to C cell in table A B C D H | J K L No of 1 City Product order Cost Laptop Camera Printer Television 2 Riyadh Laptop 10 8 Jeddah B 3 Dammam Camera 5 2 Riyadh 4 Riyadh Laptop 9 8 Dammam C 5 Jeddah Television 5 3 60 Dammam Camera 5 2 7 Jeddah Laptop 5 1 A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!