CUNY Borough of Manhattan Community College Smart Energy Services Excel

In case you need high-quality essay, we are here to help you. Would you like us to handle your paper? Use our writing services for better grades and meet your deadlines.


Order a Similar Paper Order a Different Paper

Description

GETTING STARTED

Open the file IL_EX19_11a_FirstLastName_1.xlsx, available for download from the SAM website.

  • Save the file as IL_EX19_11a_FirstLastName_2.xlsx by changing the “1” to a “2”.
  • To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
  • With the file IL_EX19_11a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

oIf you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

oSupport_EX19_11a_Substations.xlsx

oIf cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

  • Darius Beckman is the service manager for SmartEnergy Services in Tampa, Florida. The company provides electrical energy equipment and services to cities and other organizations. In an Excel workbook, Darius is tracking the service contracts he manages in Tampa and Orlando. He asks for your help in analyzing the contract data and correcting errors.
    Go to the Tampa worksheet. Correct the errors in the worksheet as follows:
    • In cell G6, trace the errors in the formula to identify the cause of the error message. Correct the formula so that the IF function tests whether the contract date (the range named Contract_Tampa) is less than the date in cell B3. If it is, multiply the standard price (cell F6) by the sale price rate (cell G3) and return the result. If it is not, return the standard price (cell F6) in cell G6.
    • Copy the formula in cell G6 into the range G7:G14 to fix the errors in that range.
    • In cell G15, use Error Checking to find the formula error, and then correct the formula.
  • After entering the equipment code data in the range D6:D14, Darius applied data validation to the range to make sure he and others entered the correct codes. Check for data-entry errors and correct them as follows:
    • Circle invalid data in the worksheet.
  • In the range A18:B23, Darius has created an area for analyzing the service agreements for specific types of equipment. He wants to analyze the sales of substation agreements because they are the most expensive.
    Create formulas to analyze this data as follows:

d.Correct the formula error in cell F15.

b.Change the circled value to 104 to use the correct equipment code.

As a student, I know you sometimes get frustrated working on school projects or even struggle to complete assignments on time. You need online writing help to rid you off such troubles. And since we understand your needs, we provide you with reliable and professional academic writers to complete your projects on time and at an affordable price.


Order a Similar Paper Order a Different Paper

Looking for this or a Similar Assignment? Order a Paper Now