### Create a StudySoup account

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

Already have a StudySoup account? Login here

# Test 1 (Cheat Sheet) BUS 150

UM

### View Full Document

## About this Document

## 42

## 0

## Popular in Business Analytics

## Popular in Business

This 3 page Study Guide was uploaded by Joseph Tanefo on Tuesday February 23, 2016. The Study Guide belongs to BUS 150 at University of Miami taught by Emil Diego in Fall 2015. Since its upload, it has received 42 views. For similar materials see Business Analytics in Business at University of Miami.

## Reviews for Test 1 (Cheat Sheet)

### 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: 02/23/16

Ross Newman – C11217187 Views – normal – normally used; page layout – see page breaks & margins; page break preview – easily change where page breaks are & easy to set print area. Constant – text too large spills into next cells; numbers to large automatically increase the column unless the column size had already been changed; date & time do the same as numbers. Formulas & Functions – always begin w/ “=”. Typing v. Pointing – pointing allows a much lower risk of entering an incorrect cell address; much more accurate. Inserting & Deleting – when inserting and deleting, everything shifts up or to the left. Hiding/Unhiding – values can still be used in calculations; things are hidden if they are private or if they clutter the spreadsheet; to unhide, highlight neighboring columns and select unhide. Clearing (Erasing) v. Deleting – erasing empties contents; deleting moves things in the spreadsheet. Copying v. Moving entries – absolute addresses stay the same while relative addresses change; when cells are moved, the formula moves with the cell and it stays the same; relative & absolute only matter when copying. Assumptions – used for variables so that you don’t have to edit formulas; also lets the reader see what you’re thinking when creating a spreadsheet. Functions v. Equivalent Arithmetic Formulas – functions adjust to addition/deletion of cells while formulas don’t. Date Arithmetic – dates act as numbers; subtract the larger date from the smaller date; you can simply add a number to a date. Conditional Formatting – used to highlight/emphasize certain values in a range of cells. Cell Errors - #value – occurs if a formula contains different data types (ex. =H2+hello); #ref – occurs if a cell reference isn’t valid (deleted an element of a formula); #num – occurs when nonnumeric characters are found in a formula (ex. $1000 instead of 1000). Precedents & Dependents – precedents – cells that the formula uses; dependents – formulas that depend on a certain cell; they help you find errors in formulas. Functions – COUNT – counts the cells in a given range that have numbers; COUNTA – counts the cells in a given range with numbers and text (only doesn’t include blank cells); MEDIAN – only to be used if outliers occur; IF – IF(condition, value if true, value if false); PMT – PMT(interest rate per period, number of periods, negative loan amount) [deposits & down payments are subtracted from the loan amount]; TODAY & NOW – show current date, NOW also shows time; RAND – generates random number; RANDBETWEEN(0,100) – generates random number between 0 & 100; ROUND(number, number of decimal places); INT(number) – rounds down to nearest integer (ex. 8.9 goes to 8). Print Titles – rows/columns that print on every page; Chart Types – column – comparing data to which is the largest and which is smallest; line – shows trend over time; pie – percentage, can’t have multiple data series; XY chart – compares two numeric variable; combination chart – two chart types on the same graph, usually have two y-axis; all charts should source data; charts can usually be moved anywhere. Category Labels & Data Series – if category labels are in rows, data series are in rows. Legend - always required if there are multiple data series. Creating A Chart – if there are more columns than rows, the column headings will be the category labels (the x-axis will have the column headings) & vice versa; if there are the same number of columns and rows, the category labels will be column headings. Sparklines – mini charts that have no chart elements; fit in a cell. Object – any document created in one program that is placed into another. Server – provides tools & commands for which you create the object. Client – program that accepts the object & places it into a document. Source Document – document in which the object is physically created. Destination Document (compound document, container) – document in which the object is placed. Clipboard – temporary storage unit. Linking – paste special paste link; making a change in the source document leads to a change in the container; once the link is broken, object becomes a picture; deleting the source breaks the link (a broken link cannot be repaired). Embedding – paste special paste; the object can only be edited within the container. DAY 1 – ctrl + home puts you at A1; ctrl + end puts you in bottom right corner. Small black cross is a copier; it also completes a series. Ctrl allows you to select multiple areas at once. Use delete key to clear a section; not backspace. Numbers within a column should always have decimal aligned. Double clicking automatically makes the column fit. Always add borders, shading, and align columns titles with the data in them. DAY 2 – formatting stays unless you clear the formats; pressing the delete key will not clear the formatting. Never type blank spaces; use increase/decrease indent. To insert a new row, right click the row beneath and click insert. Spreadsheets need to be large as possible; make margins small and minimize white space. Always try to make scale large as possible. When printing cell formulas print the headlines; formatting isn’t required. Percent’s always need to show at least one decimal. Numbers can only be centered in a column if they have an equal number of digits. DAY 3 - Dates & numbers are always right aligned. Text is usually left aligned. Scaling should always be at least 70%. Spreadsheets should be centered horizontally on the page. Titles should be larger and bolded than the rest of the spreadsheet. Functions always ignore blank cells and text. DAY 4 – formulas calculate with blank cells while functions ignore them. Through the clipboard, you can collect up to 24 items & paste them at any time. Do not use =product/=quotient; use formulas to multiply & divide. Do not use commas/formulas within a function. DAY 5 – always cite sources for charts. Everything on the chart needs to have a reason for being there. Catergory labels & data series will always be parallel with one another. As soon as a change is made in the data, it is reflected in the chart. Every chart needs a title. DAY 6 – always make charts 2D. Data tables are only necessary if the chart is on its own sheet. Number can become text entries with a single apostrophe. Selected cell(s)- Cell(s) affected by the command executed. Assumptions- Used in spreadsheets to minimize the amount of editing that must be done when values change during “what if” analysis. File Save command- Used to save an existing workbook to disk under the same name and in the same location. Constant- Entry that stays the same until you edit it. Ctrl+End- Selects the cell in the bottom, right corner of active area of spreadsheet. Absolute Address- Cell address that does not change when you copy the formula. Scrolling with the keyboard- Causes the active cell to change as you scroll in the spreadsheet. Delete command- Removes the cell and its contents from the spreadsheet, moving other cells to fill its place. Function- Predefined mathematical formula. 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. Formula- Arithmetic expression that begins with an = and is a combination of numbers, cell addresses, arithmetic operators, and/or functions. Scrolling with the mouse- Does not change the position of the active cell as you scroll in the spreadsheet. Clear Contents command- Erases the entry from the cell. File Save As command- Used when you want to keep the original workbook in tact, and make a duplicate copy of the workbook to experiment with or when you want to save under a different file format (e.g., Excel 2003). Relative Address- Cell address that changes when you copy the formula. Active cell- Cell into which the entry will be made, if and when an entry is typed in. Ctrl+Home- Selects A1. Range- Rectangular unit of cells Reminder – Functions do not calculate using black cells, while formulas do. Formulas ignore text while functions receive a value error. Functions adjust to deleted rows while formulas give a reference error.

### 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

#### "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!"

#### "I used the money I made selling my notes & study guides to pay for spring break in Olympia, Washington...which was Sweet!"

#### "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!"

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

### Refund Policy

#### STUDYSOUP CANCELLATION 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 support@studysoup.com

#### STUDYSOUP REFUND POLICY

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: support@studysoup.com

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 support@studysoup.com

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.