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

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

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 Databases Questions!