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......
View the rest of this paper...
Approximate Word Count: 475
Approximate Pages: 2 (250 words per double-spaced page)
Why should you join Frat Files?
- - It's safe, secure, and private.
- - Instant access to over 100,000 papers. New papers are added hourly.
- - Fast and reliable customer support.
Similar Essays
-
Computer Concepts
Computer Concepts. There are 3 problems and one excel file for each one of
them. Any question requiring written explanations, please ... -
Personal Digital Assistants
... computer). It is designed to fit in a pocket, run on batteries and be used
while you're holding it (Computer Concepts, pg. 7). It ... -
Basic Concepts Of Windows
Basic Concepts of Windows. 1.1 Development ... 640K. This cause computer hangs
up easily as programs compete themselves for memory. d ... -
Information Systems &Amp; Hardware Concepts
Information Systems & Hardware Concepts. ... A computer is useless without some form
of a keyboard; therefore, it is the most logical choice for an input device. ... -
Network And Telecommunications Concepts
... Individual Assignment University of Phoenix Network and Telecommunications Concepts
NTC/360 ... controller to control the token; rather each computer knows the ...
