Shalem Grimaldo Enter your name in the shaded cell to the left $($B$2)$ Link to the Formula Errors worksheet

Instructions:

$1)$ Complete the 'Cell References' worksheet $-$ ensure all $5$ responses are correct before moving to the next set of tasks on the 'Formula Errors' worksheet

$2)$ Complete both steps on the 'Formula Errors' worksheet. HINT: the Key's course percentage should equal $100$ and Karter's course percentage $($bottom row$)$ should equal $63\mathrm{.}53$

$3)$ COPY the 'Financial Data' worksheet from the 'Source Data' Excel data file into this assignment file. On the 'Financial Data' worksheet, perform the following tasks:

Delete Column H and insert a row above row $3($so that the labels for the Income Statement are in row $4)$

Copy and transpose the income statement data $($A$4$:H$8)$ so that the year values are column labels $($instead of row labels$).$ Place the transposed data in the range A$10$:E$17.$

Use the select all button to format the worksheet with Calibri size $11$ font

$4)$ Complete the 'Financial Analysis' worksheet

Use $3-$D cell references to the 'Financial Data' worksheet to reference the income statement data for $2020-2023$ The formula in each cell should reference a single cell, not a range of cells $($do not spill references$)$

Insert formulas or functions to compute the Gross Profit, EBIT, EBT, and Net Income

Set the worksheet's print area to print the range A$1$:E$15$

$5)$ Group the worksheets and set each worksheet page layout to landscape and scale to fit one page wide by one page tall

Add a DYNAMIC custom page header with the worksheet name in the middle section and a DYNAMIC custom footer with the page number in the right section.

Set each worksheet's page layout settings so that the row and column headings print

$6)$ Reorder the worksheets to the following order $($left to right$)$: Instructions, Formula Errors, Financial Data, Cell References, Financial Analysis

$7)$ Change the 'Financial Data' worksheet tab color to red

$8)$ Add a hyperlink in cell T$2$ of the 'Instructions' worksheet that links to cell A$2$ of the 'Formula Errors' worksheet $-$ use the existing text as the hyperlink text.

$9)$ Add your name and major as a comment in cell T$3$ of the 'Instructions' worksheet.

$10)$ Add yourself $($Full first and last name$)$ as an Author of the document $($File Ribbon$)$

$11)$ Save this assignment file first as an Excel $.$xlsx file, then as a PDF file. The PDF file should contain only the 'Instructions' and 'Financial Analysis' worksheets $($same file name but with PDF extension$)$

$12)$ Submit the completed Excel worksheet.