CIS 105 UOP Course Tutorial / Tutorialrank

CIS 105 UOP Course Tutorial / Tutorialrank

  • Submitted By: rank45
  • Date Submitted: 05/28/2014 11:38 PM
  • Category: English
  • Words: 493
  • Page: 2

CIS 105 Entire Course

For more course tutorials visit
www.tutorialrank.com

Tutorial Purchased: 5 Times, Rating: A

CIS 105 Capstone Discussion Question
CIS 105 Assignment: Technology of the Future
CIS 105 Assignment: Security Systems
CIS 105 CheckPoint: Internet Scavenger Hunt
CIS 105 CheckPoint: Computer Comparison
CIS 105 CheckPoint: Data Versus Information
CIS 105 CheckPoint: Microsoft® Word
CIS 105 CheckPoint: Types of Networks
CIS 105 CheckPoint: Cyber Security
CIS 105 Assignment: PowerPoint®
CIS 105 CheckPoint: Formatting Excel Spreadsheets
CIS 105 Assignment: Manipulating Data in Excel Spreadsheets
CIS 105 Week 1 DQ 1
CIS 105 Week 1 DQ 2
CIS 105 Week 3 DQ 1
CIS 105 Week 3 DQ 2
CIS 105 Week 5 DQ 1
CIS 105 Week 5 DQ 2
CIS 105 Week 7 DQ 1
CIS 105 Week 7 DQ 2

-----------------------------------------------------------------

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.
o Use a formula to find the percentage of monthly income Mom spent on the gift. Then,
use the fill handle to fill in that...

Similar Essays