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



StudyGuideExam2.pdf BUS 150

Marketplace > University of Miami > BUS 150 > StudyGuideExam2 pdf

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

Class Notes
25 ?





Popular in Department

This 7 page Class Notes was uploaded by YALIN ZHANG on Monday March 30, 2015. The Class Notes belongs to BUS 150 at University of Miami taught by MARYANN BARBER in Spring2015. Since its upload, it has received 385 views.

Similar to BUS 150 at UM


Reviews for StudyGuideExam2.pdf


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: 03/30/15
BUS150 Spring 2015 TOPICS TEST 2 Study Guide for Exam 2 Simple Tables Structured Data 0 Data vs Information 1 Data numbers text result of calculation dates and time Row Fact Information Data rearrange processed 2 Data Input Information Output 3 Based on information we made decision 0 Processing data Sequencing sorting Selecting ltering ll Calculating ll 1 Sorting sequencing 1 In Alphabetical numerical or chronological DDDDDD 2 When you sort ascending or descending order 3 Ascending smallest to largest 4 Descending Largest to smallest 5 Note a When you have text in alphabetical text goes in ascending order b Numbers put in either order Date in order 1 Dates in ascending order smallest number at top Which means older time is consider smaller 2 Dates in descending order most recent date at top current date is longer than older date 2 Filtering selecting 1 Based on the criteria can have many criteria as you want 2 Ex only shows female 3 Calculating 1 Calculate formulas and functions 0 Field record table entity 1 Field 1 Are the characters or attribute of the entity 2 Field Name The name of each column 2 Table Entity 1 Is a planned organized Where you store your data in rows and column 2 Simple Table and Excel Table 3 Store data on a single entity type 4 Table stores data on a specific occurrence of the entity BUS150 Spring 2015 TOPICS TEST 2 3 Record 1 Specific Occurrence Record layout Record layout are the same for every record 0 Unique vs nonunique elds 1 2 Unique 1 One of the kind cannot be duplicated 2 If a field name is unique they cannot be duplicated Within that file 3 You should have one filed is unique for one table Non unique 1 If can be duplicated that is non Unique 0 Keep 3 things in mind 1 2 Data must store in smallest useful unit Ex we don t put number in the same column put last name and first name in separate column We store data in the form of the least amount of make Ex store birthday instead of age so you don t have to update every year Store number as text if you don t need for calculate Ex Phone number zip code Put 0 before the number make it text Or before enter the data select column go to format change to text format 0 Simple table structured data vs Excel table 1 2 Simple table and Excel table both can filter and sort Excel table contains row name and column names for formulas 0 Excel s rules for creating tables It is best to have one table for one sheet 1 2 Every record go to separate row and every record should be unique 3 No complete blank rows or columns 4 You can have blank cell not entire rows or column 5 6 7 8 9 Do not start With blank cell and no blank cell at the end Data need to be consistent in its formatting throughout the table You must have one blank row above the header row You must have one blank row below the last row You don t need a blank column is left begins at Column A same as rows BUS150 Spring 2015 TOPICS TEST 2 0 Excel s rules for creating elds Field names first row in the table Field name describe the data of the column Field name must be unique Field name can be letter text numbers special character Field name should be formatted differently than the data record underline bold Row containing field names is called the header row Subsequent rows are the data record NQMPWP 0 Filtering data Filter icon 1 Filter icon do not print a Applying filters to one or more fields 1 One field Ex FL or GA from one or other One person cannot from FL and GA Understand the language In the same field you can do OR As well as means OR 2 Different fields when have condition with two different fields the command Will be AND Ex People from FL Who are Male b Clearing filters 1 You can clear the single filter or clear all the filters 0 Text filters number filters date filters 1 Text filters Begins with Ends with Equal to Do not equal to Contains Do not contain Custom filter 2 Dates filters Year month and week You can filter dates before after next month next quarter next week next year between period 3 Number filters equal greater less than top 10 between above average below average 0 Sequencing data 1 Select one cell of the column for last name 2 According to the column sort or filter 3 Only need to select one single cell of the column you can sort and filter 4 Don t select the entire column or row to sort and filter BUS150 Spring 2015 TOPICS TEST 2 0 Ascending vs descending order text numbers dates 1 One column 1 Sort Major Name first name last name Alphabetic order Ascending 2 Sort two or three No more than three usually 3 Sort Financial Aid A to Z alphabetic and ascending order 4 Sort GPA descending order from better to lower 5 Custom sort Ex a Geographic order North Central South b Student year Freshmen sophomore Junior Senior 2 Multiple columns primary vs secondary sort keys 1 Use dialog box to sort field Do Primary Secondary and Treasury From most important to least important 2 Use Keyboard to sort field Do Treasury Secondary and Primary From least important to most important 0 Subtotals 1 Done quickly give you quick information SUM MIN MAX AVERAGE COUNT no different between count and counta Subtotal for groups 2 Sequence the major first 3 For the group you can do sum or min or countcount anything text and numbers PivotTables and Pivot Charts 0 Purpose of a PivotTable 1 Best use for very large table 2 Useful for the business 3 To summaries the table 4 Allow to change the data very quickly in order to make decision Drawback When you want to change the data in the main table the pivot table does not automatically update You must update it you must refresh it manually 0 Value fields 1 You can sum average min max count BUS150 Spring 2015 TOPICS TEST 2 If you check the numerical drag to value area And it Will be sum Drag a text field to value area you Will get count Drag a numerical field to value you Will get sum If you have multiple value field is easier to read if the field is in row area You can bring the different field to the value area When you have multiple value fields you can drag one value to the row NQP PPP 0 Row Column Filter elds 1 If you check the text field drag to rows area 2 If you check the date field drag to column area 3 Filter field Will be above the pivot table 4 You can bring the same field twice 0 Creating and rearranging the PivotTable 1 AddingRemoving fields 1 Drag the field out or drag Where you want them to go 2 Rearranging fields 1 Drag 2 We need to show 0 3 Sorting and filtering fields 1 You can filter either column and rows 2 4 Grouping items 1 You can group data EX you can group data to Months 2 When the amount or values are too much you can create the group EX set up interval ranges 0999 10009999 3 After grouping you need to format by typing 0 Refreshing PivotTable data 1 You Will not get format automatically you need to format by manually Do it from the HOME TAB 2 If you are doing the interval for dollar you have to type the dollar sign manually 3 You can refresh the data manually 0 Creating and modifying PivotCharts 0 Slicers BUS150 Spring 2015 TOPICS TEST 2 Logical Functions IF function Nested IF function VLOOKUP function approximate vs exact match IFERROR function AND function OR function Conditional formatting Finding duplicates through Highlight Cells Rules New Rule based on a formula Conditional Summary Functions COUNTIFS SUMIFS AVERAGEIFS Advanced Filter command Advantages Criteria Range Entering simple and complex criteria Compound conditions With ANDOR Upperlower boundaries Within a field Filtering inplace vs Copy To range Defined Names Purposeadvantages Naming Rules Define Names command vs Create from Selection command Using names in formulas amp Applying names to formulas Pasting a list of names Deleting and editing names Database Functions DSUM DCOUNT DCOUNTA DAVERAGE DMAX DMN BUS150 Spring 2015 TOPICS TEST 2 Working with Multiple Worksheets amp Workbooks Working with worksheets addingdeleting renaming selecting moving amp copying hiding Displaying multiple worksheets at one time Displaying multiple workbooks at one time Grouping worksheets CreatingUpdating formulas that reference cells in other worksheets CreatingUpdating 3D references CreatingUpdating formulas that reference cells in other workbooks external references Source workbook Dependent destination workbook ModifyingBreaking the links Miscellaneous DATEDIF function CreatingEditingRemoving Hyperlinks Creating and working with templates Purpose Excel s templates vs custom template Freeze Panes You may bring one and only one 812 x 11 sheet of notes to the exam You may however use both sides of the sheet for your notes which can be anything you want Please note that you will be required to hand in the note sheet with your name on it when you hand in your exam


Buy Material

Are you sure you want to buy this material for

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

Jennifer McGill UCSF Med School

"Selling my MCAT study guides and notes has been a great source of side revenue while I'm in school. Some months I'm making over $500! Plus, it makes me happy knowing that I'm helping future med students with their MCAT."

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

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.