CIS 105 Assignment: Manipulating Data in Excel Spreadsheets (UOP)
For more course tutorials visit
www.tutorialrank.com
Tutorial Purchased: 3 Times, Rating: A+
Assignment: Manipulating Data in Excel Spreadsheets
• Resources: Appendix D, Appendix E, and Appendix F
• Due Date: Day 7 [Individual forum]
CIS 105 Survey of Computer Information Systems
Course Syllabus Page 20
• Use the chart tutorial in Appendix E and Appendix F to familiarize yourself with creating
charts and graphs in Excel.
• Continue to manipulate the data in the Appendix D Excel spreadsheet from the previous
CheckPoint in the following ways:
o Use the sum function to find the total number of gifts and the total value of the gifts.
o Use the average function to find the average number of gifts per person and the
average value of the gifts per person.
o Use a formula to find the average cost per gift for Mom. Then, use the fill handle to fill
in that formula for the remaining friends and family.
---------------------------------------
CIS 105 Assignment: PowerPoint® (UOP)
For more course tutorials visit
www.tutorialrank.com
Tutorial Purchased: 3 Times, Rating: A+
Assignment: PowerPoint®
• Resources: Ch. 8 (pp. 312-316) in Computing Fundamentals and the Computer
Applications Tutorial
• Due Date: Day 7
• Complete the PowerPoint® portion of the Computer Applications Tutorial at
http://corptrain.phoenix.edu/office_tools/index.htm then create a PowerPoint®
presentation for the following scenario:
You work for a large retailer of consumer electronics that is constantly seeking to add the
latest technologies to its product lines. Find one new electronics product that you think
the company should consider incorporating into its line of merchandise using resources
such as http://www.engadget.com/ and http://www.cnet.com/ and
http://www.pcworld.com/
• Create an 8- to 10-slide presentation for upper managem
---------------------------------------------------
CIS 105...