60.1K

Verified Solution

Link Copied!

You work for a company called Pro-NET that design and install network solutions. You are required to provide a spreadsheet that will help cost 'individual jobs and provide a summary of completed jobs for the year. Download the instruction sheet and follow all instructions carefully.
PLEASE NOTE:
Do not use any rounding functions in formulas unless specifically requested.
Do not change the values or structure of the workbook in any way, i.e. do not move/add/remove sheets, columns or rows.
Only the contents of the light green cells should be changed and with the exception of the journal names, these should all contain formulas
Formulas should be flexible enough to work with different values and regardless of sort order
Do not create formulas or paste values in cells other than the ones indicated

Tools Data Window Help ACCG200 Excel Assessment 2019 S3 My Excel File Edit View Insert Format 10. AutoSave Of svar Home Insert Draw Page Layout Formulas Franklin Gothic Bo... 10 A A BIU A 127 x fx Take a photo with "iPhone" Use your iPhone's camera to take a photo. con Qu Search Sheet Share Insert DX Delete Editing E Format ormatting Ideas Cancel Pro-NET Network Equipment Inventory N Category Num in Stock On Backorder Cost Price $1.064.65 Premium? Retail Price ordero Standard Map Premium Markup: Minimum Stock cel - - Category

Answer & Explanation Solved by verified expert

See Answer