Q3. Write the excel function and output By using the below table (6 points) A. Calculate...

Transcribed Image Text:

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 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