I need the solutions for this excel assignment

Sigchi4life
Category:
Computer Science
Price: $50 USD

Question description

Spreadsheets for Business 
Final Exam    
June 2015    
Due Date: not later than Monday June 22.    
   
Name:  Date:    
   
1. Use Excel Formulas to calculate the amounts listed below. Do your calcuations in the Yellow cells
     
  90    
  78    
  77    
  61    
Average 21    
Count 84    
Minimum 20    
Maximum 34    
Sum 66    
Mean 49    
Median 29    
Standard Deviation 74    
  24    
  38    
  27    
      25    
      66    
      61    
   
2 a. Build  a line chart showing the following data
Year Date Employees    
1 1 2    
2 3 3    
3 5 5    
4 6 7    
5 7 7    
6 10 8    
7 12 10    
b. Build a  column chart showing the following data    
   
YEAR CATS DOGS    
2015 5 10    
2016 7 12    
2017 9 7    
2018 7 9    
   
c. Build two pie charts showing the data in part b.    
   
   
3 Use the AND, OR and NOT logic functions to calculate determine if the condition is TRUE or FAlSE
Salesman Cats  Dogs Food Supplies Over quota cats and dogs Under Quota on at least one item Did not meet quota on Supplies  
Tom $2,284 $1,147 $751 $3,644  
Mary $3,693 $2,369 $4,380 $619  
Jose $4,369 $2,057 $3,530 $4,337  
Maria $1,075 $4,974 $2,432 $1,969  
   
Sales Quota $1,000 $1,000 $1,000 $1,000    
   
   
4 Refer to the table in Question 3. Use the Exel Horizontal lookup to find:
   
Cat Sales Food Sales    
Maria     
Tom    
   
   
5 Calculate the missing values in the yellow cells.
PV FV PMT RATE NPER    
1000 2000 50 10    
1000 5000 8% 15    
6000 250 6% 8    
1500 500 8% 10    
12000 14000 500 4%    
   
   
6 List and explain the steps in the problem solving process used in this course.
Type your answer here:    

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Cornell University
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1831 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors