Question description

Case Problem 2 it. Data file needed for this Case LKE.xlsx ( LKE Distribution LKE Distr n in North Platte, Nebraska, sells everything needed to outfit an office from basic offices lies to high-end office equipment and technology to furniture. Accounts Receivable (the amount customers owe LKE Distribution). She has entered the billi information in an Excel workbook. She wants you to enter formulas that will help her to ana the data. Complete the following: 1. Open workbook located in the ExcelS> Case2 folder included ~ith your Data Files, and save the workbook as LKE Receivables in the location specified by your instructor. 2. In the Documentation worksheet, enter your name and thep ate. 3. In rhe Invoices worksheet, in cell B1, enter 7/1/2017 ~e current date. Note the defined name CurrentDate has been assigned to cell B1. 0 Troubleshoot 4. The sales rep commission rate varies for each sales rep. In column E, Laura used a VLOOKUP function to look up the commission rate for each sales rep and then multiplied the commission rate by the invoice amount to calculate the commission. Although the first row in column E of the Excel table named Aging displays the correct commission, all the other cells display a number, "-",or #N/A. Find the problem with the formulas in the Commission column and fix it

CourseLover

(12)

Status NEW Posted 04 Jun 2017 07:06 AM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer