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


by: Hali Marie Harrison
Hali Marie Harrison
GPA 2.89
Computer Applications for Business
Radhika Kaula

Almost Ready


These notes were just uploaded, and will be ready to view shortly.

Purchase these notes here, or revisit this page.

Either way, we'll remind you when they're ready :)

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

Computer Applications for Business
Radhika Kaula
75 ?




Popular in Computer Applications for Business

Popular in Department

This 1 page Bundle was uploaded by Hali Marie Harrison on Monday September 28, 2015. The Bundle belongs to CIS 201-904 at Missouri State University taught by Radhika Kaula in Fall 2015. Since its upload, it has received 13 views.


Reviews for 5/6


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/28/15
Chapter 5 continued Chart graphical representation of the data Column Chart is useful when you want to compare the values across a single category Bar Chart the only difference between a bar chart and a column chart is that column charts are horizontal and bar charts are vertical Pie Chart useful when you want to show individual relationships as compared to a whole Area Chart useful for cumulative results When you create a chart 2 new tabs will pop up in the ribbon Use these 2 tabs to edit your chart Charts have buttons called sizing handles to make your graph bigger or smaller There will also be 3 tools to the right of your chart if you put your cursor on your chart Those tools can be used quickly to edit your chart as well Legend shows what each color in the chart represents To move a chart to another sheet Go to the design tab located in the ribbon click move chart a dialogue box with options will pop up go from there Do not copy and paste Chapter 6 Scenario Analysis process used to create different scenarios to make decisions while using a decision support model Critical Numbers in a Scenario Analysis The assumption values excel allows us to assign names to those critical numbersquot those are known as Range Names Rule to follow when using range names names can only start with a letter abc an underscore or a back slash If you wish to delete the name you ve created for a range you have to go to the Formulas tab in your ribbon then in the defined names group you will find a manage names button That button will cause a dialogue box to pop up giving you the option to delete any range names you have created To create a What if Analysis select highlight the assumptions then select the Data Tab in the ribbon then go to the Data Tools Group and click What If Analysis Once the dialogue box pops up clikc scenario manager From here you can create as many different scenarios as you wish When you ve finished creating those scenarios you have the option to create a scenario analysis summary that will put all of the scenarios is an easy to readunderstand chart With scenario analysis there are Changing Cells which are the cells that have values that you will change to create the different scenarios There will also be Result Cells which are the cells that have values that will only change as a result of one of the values in a changing cell being different An example of a result cell is the cell that is indicating a grand total or sales revenue or profit etc


Buy Material

Are you sure you want to buy this material for

75 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."

Anthony Lee UC Santa Barbara

"I bought an awesome study guide, which helped me get an A in my Math 34B class this quarter!"

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Parker Thompson 500 Startups

"It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

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.