Question: Question 2 (25 marks) Answer the tolowing questions based on the glven spreadsheet in Figure 1 a) Write the formula at the F3 to find

Question 2 (25 marks) Answer the tolowing questions based on the glven spreadsheet in Figure 1 a) Write the formula at the F3 to find total price tor the clent. [5 marks] b) Based on cel C10 as percentage price Increment, wrte a formula at cell G3 to [5 marks] 15 manks calculate the new dally rate. (This tormula could be coplied to cel G3 untl cell G6). c) DIscuSs the THREE (3) types of charts avallable In Excel. wuc 11303-Computers in a Networked Sodiety Customer oom lpe lotal Days Staed Daily Rafe lotal Price Nw Dalily Rate S 180.00 S 120.00 S 450.0o S 120.00 Deluve Standard Goh MuthuSuie lohn Standard Increment 10% Figure 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
