Use the following sheet to accomplish the tasks that follow:

https://drive.google.com/file/d/1lsyXnA7q5VWMpAPu8pDG-4lRI6DmhXoI/view?usp=sharing

Tasks

Task Number	Task Instructions
1	Ensure that the data in  columns in the sales sheet fit on 1 page. To do this: Change the layout of the page to “Landscape” (Page Layout–> orientation)
2	Change the view to “Normal”
3	Add borders for the table: Sales for the month of june
4	Format the vat rate as a percentage (use the number grouping from the home menu ribbon.
5	Format the price in the Price List table  as currency to 2 decimal places
6	Apply a similar formatting for Price Per Item
7	Use a vlookup to list the Price Per Item
8	Use a formula/function to fill in the Revenue Per Item . Format this column as currency
9	Calculate the vat Per item to be paid for each item row USING the vat rate provided
10	Show the total revenue  and the total vat to be paid. You will need to choose the cell locations to display this information and add lables yourself.

Note that these tasks can also be found on the second sheet within the spreadsheet file for easy reference

Solution

A solution from a previously recorded class is shown below:

© 2020  Vedesh Kungebeharry. All rights reserved.