New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

CIS105 Week 4 Notes

by: Sarah Booth

CIS105 Week 4 Notes CIS 105

Sarah Booth
View Full Document for 0 Karma

View Full Document


Unlock These Notes for FREE

Enter your email below and we will instantly email you these Notes for Computer Appls&Info Technology

(Limited time offer)

Unlock Notes

Already have a StudySoup account? Login here

Unlock FREE Class Notes

Enter your email below to receive Computer Appls&Info Technology notes

Everyone needs better class notes. Enter your email and we will send you notes for this class for free.

Unlock FREE notes

About this Document

These notes cover the importance of Excel and how it is used in workplace. I am a visual learner, so my notes contain images to further your understanding of the text. Check it out!
Computer Appls&Info Technology
Class Notes
Computer, ComputerInformationSystems, Excel, ASU, business, ComputerApplications Business




Popular in Computer Appls&Info Technology

Popular in Business

This 3 page Class Notes was uploaded by Sarah Booth on Monday September 26, 2016. The Class Notes belongs to CIS 105 at Arizona State University taught by Staff in Fall 2016. Since its upload, it has received 4 views. For similar materials see Computer Appls&Info Technology in Business at Arizona State University.


Reviews for CIS105 Week 4 Notes


Report this Material


What is Karma?


Karma is the currency of StudySoup.

You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 09/26/16
Computer Information Systems (CIS105) Arizona State University Sarah Booth Importance of mastering Excel: • It is a business illiteracy to not know Excel • Excel is used all the time in the professional workplace • Excel is the market leader today • Automates many tasks associated with spreadsheet creation and manipulation Spreadsheets • Spreadsheets are the heart and soul of accounting • Financial statements are presented on spreadsheets • Spreadsheets also store data for companies - EDGAR: Electronic Data Gathering, Analysis and Data Retrieval System - Operated by SEC: Securities and Exchange Commission • There website is where you can find: - 10-K Annual Report - 10-Q Quarterly Report Data Analysis: • Spreadsheets are used to answer the question “What is going on in my business?” Numeric Analysis • Sort, group, filter, highlight • Find the largest, the smallest, the average Graphical Analysis • Column • Bar • Pie • Plot • Spreadsheets are also used to answer “What if?” - What will change in our profit if our cost of raw materials increases by 10%? • Excel facilitates answering such questions by automatically recalculating everything that depends on x when you change its value - Modeling a situation with a set of equations Personal Finance • Budgeting • Buying vs. leasing a car - Monthly payments - Down payment • Buying a house - Mortgage payments - Down payment - Interest rate - How much can you afford? • Investment returns • Save or Spend - The importance of living within your means References Absolute and Otherwise • Look at Carpet Calculator • Mixed, absolute and relative addresses The Autofill Function • Copying formulas • Series construction - Numbers - Dates - Days


Buy Material

Are you sure you want to buy this material for

0 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

Why people love StudySoup

Jim McGreen Ohio University

"Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Amaris Trozzo George Washington University

"I made $350 in just two days after posting my first study guide."

Jim McGreen Ohio University

"Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."


"Their 'Elite Notetakers' are making over $1,200/month in sales by creating high quality content that helps their classmates in a time of need."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.