Excel Preintemediate Exam 1

Excel Preintemediate Exam 1

Download Excel_Exam_1

What to Do

1. In the «IF function» worksheet, find the sum of the Total Cost and Total Shipping (of the «Table» worksheet) if
No.Items less than 10, otherwise find the difference between the total shipping and total cost.

2.In the VLookup-Approximate worksheet find the Reduction Total of the Adj.Total value using the Reduction Rate Total table

3. In the Countif worksheet count the number, sum(revenue), and average cost of the items according to the categories.

4. Hide the «If function» worksheet with no possibility to unhide (protect the structure of the workbook)

5. Protect the Reduction Total column, so that the user can’t edit this column.