Shopping Cart
Your shopping cart is empty!
Categories
CIS 105 Week 6 Assignment Manipulating Data in Excel Spreadsheets
$4.00

CIS 105 Week 6 Assignment Manipulating Data in Excel Spreadsheets

This Tutorial was purchased 4 times & rated A+ by student like you.

 

This Tutorial contains following Attachments

  • CIS 105 Week 6 Assignment Manipulating Data in Excel Spreadsheets.xlsx

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 formula for the remaining friends and family.
o Use a formula to find the number of days, early or late, Mom presented her gift. Then,
use the fill handle to fill in that formula for the remaining friends and family.
o Format the total value of gifts, average cost per gift, and monthly income columns as
currency.
o Format the % of monthly income spent on gifts column as percentages.
o Create at least one chart to illustrate your analysis.
· Submit the spreadsheet as an attachment with the answer to the following question as a
post of 100 to 350 words: Based on the information in this spreadsheet, which of your
friends or family do you think loves you the most? Use the data to justify your answer.

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$6.00

This Tutorial was purchased 3 times & rated No rating by student like you.

CIS 105 Final Multimedia Tools in the Classroom ..
$3.00

This Tutorial was purchased 3 times & rated B+ by student like you.

Discussion Question 2 · Due Date: Day 4 [Main forum] · Post your response to the following: What is the importance of an operating system (OS)? What reasons would&nbs..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

Discussion Question 1 · Due Date: Day 2 [Main forum] · Post your response to the following: Most personal computers come equipped with a version of the Windows operat..
$3.00

This Tutorial was purchased 1 times & rated No rating by student like you.

Discussion Question 2 · Due Date: Day 4 [Main forum] · Post your response to the following after exploring Web sites such as http://www.foxnews.com/. After visiting several&nbs..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

Discussion Question 1 · Due Date: Day 2 [Main forum] · Post your response to the following after exploring one or more graphic programs available on your computer: Sh..
$4.00

This Tutorial was purchased 4 times & rated No rating by student like you.

CheckPoint: Formatting Excel Spreadsheets · Resource: Ch. 8 (pp. 308-311) in Computing Fundamentals, the Computer Applications Tutorial and Appendix D · Due Date: Day 4 [Individual&..
$4.00

This Tutorial was purchased 3 times & rated No rating by student like you.

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&n..
$4.00

This Tutorial was purchased 2 times & rated No rating by student like you.

CheckPoint: Cyber Security · Resource: Ch. 12 in Computing Fundamentals · Due Date: Day 4 [Individual forum] · Read the following scenario: James was traveling for his job.&n..
$4.00

This Tutorial was purchased 4 times & rated No rating by student like you.

CheckPoint: Types of Networks · Resource: Ch. 9 (pp. 346-347) in Computing Fundamentals · Due Date: Day 5 [Individual forum] · Refer to Ch. 9 (pp. 346-347) in Computi..
$4.00

This Tutorial was purchased 3 times & rated A by student like you.

CheckPoint: Microsoft® Word · Resource: pp.303-307 in Computing Fundamentals and the Computer Applications Tutorial · Due Date: Day 4 [Individual forum] · Refer to pp.303-307 in C..
$4.00

This Tutorial was purchased 3 times & rated No rating by student like you.

CheckPoint: Data Versus Information · Resource: Ch. 5 in Computing Fundamentals · Due Date: Day 4 [Individual forum] · Consider the following: Computers use a completely differ..
$4.00

This Tutorial was purchased 3 times & rated No rating by student like you.

CheckPoint: Computer Comparison · Resources: Ch. 1 (pp. 27-32) of Computing Fundamentals and PCWorld and Macworld Web sites · Due Date: Day 5 [post to the Individual forum..
$4.00

This Tutorial was purchased 3 times & rated No rating by student like you.

CheckPoint: Internet Scavenger Hunt · Resource: Appendix B · Due Date: Day 5 [Individual forum] · Choose a topic related to computer technology that interests you. Possible&nbs..
$4.00

This Tutorial was purchased 3 times & rated A by student like you.

Assignment: Security Systems · Resources: Symantec, McAffee, SonicWALL Web sites · Due Date: Day 7 [Individual forum] · Research two available security systems that provide total&nb..
$4.00

This Tutorial was purchased 5 times & rated No rating by student like you.

Assignment: Technology of the Future · Resources: Ch. 5 in Computing Fundamentals and the HowStuffWorks Web site · Due Date: Day 7 [Individual forum] · Read Ch. 5 (pp..
$2.00

This Tutorial was purchased 4 times & rated No rating by student like you.

Capstone Discussion Question · Due Date: Day 3 [Main forum] · Post your response to the following: What did you learn from this course that is new and helpful to..
$25.00

This Tutorial was purchased 6 times & rated A+ by student like you.

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 Check..
Cis105Mentor © 2017 All Rights Reserved.Powered by:Webzindagi.