Computer Concepts

Computer Concepts

There are 3 problems and one excel file for each one of them.

Any question requiring written explanations, please use empty cells at bottom of sheets and label question answers clearly!!(for example, Answer1.d for problem 1.d, etc …)

PROBLEM 1: (58%)

Use the excel file named �assignment1_problem1.xls’ that you can download from the student portal and follow the instructions below:

a. Use naming and labelling of cells according to the needs of this problem. (10 pts)

b. Use all the appropriate formulas in cells E8:M25 (filled with blue colours)

(Leave M17 as it is until after question d) (26 pts)

c. Add your full name and student id number to the Header. (2 pts)

d. Find the source of the �#VALUE’ error in the P&L sheet using the auditing tool. Explain what this error is due to. (2 pts)

e. The net profit in year 2003 appears large. Is there a problem? (2 pts)

f. Create base case, best case, and worst case scenarios for the P&L sheet using the