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…