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

BUS 150, Exam #1 Study Guide

by: Alexandra Notetaker

BUS 150, Exam #1 Study Guide BUS 150

Marketplace > University of Miami > Business > BUS 150 > BUS 150 Exam 1 Study Guide
Alexandra Notetaker

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

This study guide covers what will be on our first exam next week.
Business Analytics
Maryann Barber
Study Guide
50 ?




Popular in Business Analytics

Popular in Business

This 6 page Study Guide was uploaded by Alexandra Notetaker on Friday September 23, 2016. The Study Guide belongs to BUS 150 at University of Miami taught by Maryann Barber in Fall 2016. Since its upload, it has received 69 views. For similar materials see Business Analytics in Business at University of Miami.

Similar to BUS 150 at UM


Reviews for BUS 150, Exam #1 Study Guide


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/23/16
BUS 150 EXAM #1 STUDY GUIDE SPREADSHEETS  Spreadsheet Views o Normal: what it is usually in o Page Layout: shows you how it will print, can edit it in here as well o Page Break Preview: blue borders, can change print format here and what will print, can work in it ***know how to set print area***  Ranges: rectangular unit of cells  Scrolling with mouse vs. keyboard o Scrolling with the mouse keeps the current cell selected o Scrolling with the keyboard causes the active cell to change  Constant o Text, number, date, time o Entry that stays the same until you delete it  Formulas & Functions o Formula:  a mathematical calculation; always begins with =  Keep editing formulas to a minimum  Absolute addresses don’t change in a formula (ex: $B$4) o Functions:  =word; example: =SUM( )  Arithmetic expression that begins with an = and is a combination of numbers, cell addresses, arithmetic operators, and/or functions  Entering Formulas: Typing vs Pointing o Pointing  Method of entering a formula which is recommended as it is more accurate than typing in that it helps ensure that correct cell addresses are used in the formula o Typing  Manually typing in cell addresses; much more room for error  Mathematical Order of Operation o Excel will follow the orders of operation  Inserting and deleting cells/columns/rows o To insert a row above row 11: select row 11, right click, and insert or press insert command on top o Inserted rows go above; inserted columns go above  Hiding/Unhiding Columns and Rows o Right click and hide so that some information will not print, but the values are still used  If you have information you don’t want others to see when printed, or you just don’t need to see o To unhide, click and drag two columns next to the column you hid and right click and click unhide o If you had to unhide column A, Format  unhide column  Clearing (Erasing) vs. Deleting o Clearing: erases entry from cell, keeps empty cell there, use backspace on keyboard o Deleting: removes cell and its contents from spreadsheet, moving other cells to fill its space; right click and press delete  Copying vs. Moving entries o Copying and Moving constants  To copy constants, get little plus in lower right corner of cell and drag down to the cells you want it to be copied down to  To move it get the 4 arrow black symbol and drag the cell to its new location o Copying and moving formulas – absolute and relative references  If you are copying a formula, you must make whatever cell address you don’t want to change an absolute address ($B$4)  Reasons for Using Assumptions o Less room for error o If you need to change something in your assumption area, the formulas will update based on your new value  Functions vs. Equivalent Arithmetic Formulas o Functions (ex: =sum) adjusts when you add/delete rows within the range of the function  Date Arithmetic o Can add to a date and get a date in the future o Can subtract from a date and get one in the past o Type in the date = a constant o Or =TODAY () will change everyday  Conditional Formatting o Highlight certain cells based on if their values are above or below a certain value  Cell errors o #VALUE  Text string is inserted into a formula that is using a mathematical function o #REF  When a formula refers to a cell that is not valid o #DIV/O  Using a reference to a blank cell or a cell that contains 0, which causes something to be divided by 0 in a formula or function that performs division o #NUM  No number can be produced; a formula uses a function that iterates/repeats (ex: RATE), and can’t find a result  Tracing Precedents/Dependents o In formula tab o Can see what cells are being used for a certain formula/function  FUNCTIONS o SUM: adds up a range of cells o AVERAGE: takes average of a range of cells o COUNT: counts value in a certain range o COUNTA: counts text entries in certain range (ex: how many workers) o MAX: highest value in certain range o MIN: lowest value in certain range o MEDIAN: median value in a range o RAND: gives u a random number between 0 and 1 o RANDBETWEEN: generates a set of random integers, and doesn’t change when spreadsheet recalculates o INT: displays integer portion of a number o IF & Nested IF: if(value, true, false); nested IF is when one IF function is placed inside another IF function to test an additional condition; second IF is the false of the first IF o PMT: (interest rate, term, -(loan amount)  Loan amount=purchase price-deposit o TODAY(): will give you date and change everyday o NOW(): gives date and time and updates when you make an entry  Printing o Get rid of gridlines; just put borders on o Scaling never below 70% o Margins small, change column widths to fit main body of spreadsheet; minimize white space o If small spreadsheet and it doesn’t fit page, switch to portrait o Printing cell formulas: can cut off text, just make sure all formulas show o Print important titles (ex: on main body) and print on every page o Fit spreadsheet width wise on one sheet usually  Goal Seek o Data tabWhat-If AnalysisGoal Seek o Allows you to set answer to formula by change ONE input at a time (ex: if you want to figure out what to do if you want monthly payment to be certain amount) CHARTS  Appropriate Chart Type for Message o To rank/compare= cluster column chart (F11)  Ex: what year had best/worst sales o Compare salesman each year= multi column chart (3 different data series) o Which year had total best sales? Stacked column chart  Shows you relative contribution  Total at each occurrence of the category label  Must add up to a meaningful number o Trend= line chart (same 3 data series)  Are things improving/declining?  Combo Charts o Usually need 2 y-axis o Get secondary y-axis by right-clicking, or change chart type check off secondary axis  Chart Location o Doesn’t matter where put the chart, it is still connected to the cells; change cells, you change charts o Chart sheet, prints alone o Chart on spreadsheet  Can print alone  Or print w spreadsheet  When you have fewer rows than columns selected, the FIRST ROW will be used for category labels and the rest are separate data series  Fewer columns in a selected area, then the FIRST COLUMN will be used for category labels  =number of columns and rows, FIRST ROW used for category label  work with a chart the same way whether it is on the spreadsheet or on its own sheet  Design Tab (add chart element and/or format elements) o Change chart type (to change message) o Move chart between sheets o Switch rows/columns o Select data  When you click on the chart o We are not using chart filters or styles o Will use chart elements (first one)  Can use text box for subtitles, or any other text you need on a chart o NEED extra info on every chart (citation of where your information came from)  PROBLEM: when years go as numbers o Tab SELECT DATA  edit, add, remove, add category labels to data series  OR put ‘2011 (‘ before year)  Sparklines o Can mark high/low points o Can do lines and columns o Not entry, can’t delete them, you would go to clear sparklines o Select data only and click line and select where you want it OBJECT LINKING AND EMBEDDING (OLE)  OBJECT: data created using tools of 1 program which is then placed into a different program  SERVER: application you use to create object  CLIENT: program who accepts object and places it into compound document  SOURCE DOCUMENT: file in which that object is physically created (belongs to server)  DESTINATION DOCUMENT/CONTAINER/COMPOUND DOCUMENT: file into which object is placed (belongs to client)  Can exist between office programs and also non-office programs  Copy object from source document into windows clipboard (1 object at a time) (is it OLE compliant?)  LINKING o When you link, copy object, but what you paste isn’t really object, but is representation of object  2 hidden codes also placed: name of server, name of source document  object remains in source document; make change in source document, affects representation of object in destination doc = they are linked  EMBEDDING o You are placing a copy of the object in destination document o Also hidden: name of server only o Once you embed, connection to actual source doc is over (if you change object in source, it doesn’t change)  When you link/embed, must say worksheet object when you pasta  Wrap object so you can move object easily  If link object doesn’t auto update, right click update link  If you move/rename source document, you will have broken link WON’T WORK; fix it by changing source in “Links” (File Tab)  Putting on flash drive and emailing them, may have to change source document


Buy Material

Are you sure you want to buy this material for

50 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

Bentley McCaw University of Florida

"I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"

Amaris Trozzo George Washington University

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

Bentley McCaw University of Florida

"I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"


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