![beginner excel assessment beginner excel assessment](https://3rhv048ivse2zy4er2sbddh1-wpengine.netdna-ssl.com/wp-content/uploads/2020/06/Preview-Excel-test-TestGorilla-1024x514.png)
Subtotal the sheet by Date (Oldest to Newest), summing the Profit column. Place this new sheet to the right of the Sales by Product sheet.
![beginner excel assessment beginner excel assessment](https://db-excel.com/wp-content/uploads/2019/01/risk-assessment-spreadsheet-in-risk-matrix-template-excel-unique-great-risk-ysis-matrix-template.png)
Make a copy of the Sales sheet and rename it Subtotals by Date.Add a Total Row that includes the overall average for the Product Price, Product Cost, and Profit columns. Select both DETA100 and DETA200 in the slicer.Resize the height of the entire slicer to 2.09”. Move the top left corner of the slicer to the top left-hand corner of cell M1. Insert a slicer in the Sales by Product sheet for Product Sold.Place this new sheet to the right of the June Sales by Country sheet. Make another copy of the Sales sheet and rename it Sales by Product.Sort this sheet alphabetically (A to Z) by Country and then alphabetically by Name. Filter this sheet to only show June dates by using the Date Filter Between. Place this new sheet to the right of the Online Sales by Date sheet. Make a copy of the Sales sheet and rename it June Sales by Country.Sort the filtered data by Date Sold (oldest to newest). Filter out Retail in Sales Type, so that only Online Sales are displayed. Place this sheet to the right of the Sales sheet. Make a copy of the Sales sheet and rename it Online Sales by Date.You want to make sure your range starts with A3 here. BE CAREFUL HERE: Excel will try to insert a table starting with A2. Insert a table with headers for the range A3:K52. Format columns I, J, and K as currency with two decimal places.In K4, calculate Profit (Product Price – Product Cost).
![beginner excel assessment beginner excel assessment](https://www.edureka.co/blog/wp-content/uploads/2019/11/exact-match-VLOOKUP-in-Excel-Edureka.png)
This VLOOKUP function will be the same as the VLOOKUP function in I4 – EXCEPT THE COL_INDEX_NUM will be 3 instead of 4. In J4, enter a VLOOKUP function that will find the Product Cost for the Product in E4 in the table in the Product Table sheet and return it to J4.In your VLOOKUP function, fill in the required parameters using Figure 5.32 below. In I4, enter a VLOOKUP function that will find the Product Price for the Product in E4 in the table in the Product Table sheet and return it to I4. Open the data file SC5 Data and save the file to your computer as SC5 Dynamite Customer Sales.
Beginner excel assessment how to#
This exercise illustrates how to use the skills presented in this chapter to generate the data needed on a daily basis by a retail company. Retail companies with today’s online, as well as, in-store sales have a lot of data to keep track of! Keeping track of sales, costs, and profits on a daily basis is essential to making the most of a business. 5.5 Scored Assessment Tables for a Retail Companyĭownload Data File: SC5 Data Figure 5.31 Completed Exercise