# [BMGT 301] - Midterm Exam Guide - Everything you need to know! (12 pages long)

252 views12 pages
7 Feb 2017
School
Course
Professor

UMD
BMGT 301
MIDTERM EXAM
STUDY GUIDE
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.

Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.

BMGT 301: Information Systems
January 26th, 2017
Databases
A database is a table or collection of assorted things complied together.
Step 1: Understand the data
Step 2: Organize the data
Step 3: Summarize the data
Data Information & Knowledge
Apply knowledge to data to turn it into information
10 Bites - Excel
Pattern Recognition Techniques
“Power Pivot”
Flash Fill 2013 & up
Case insensitive
Functions
Ex: =Average, = IF, put the function after the equal sign, then place a
(arg1,arg2,…arg[n])
Anything in square brackets will be optional, not necessary. No spaces between comma
and arg.
All the functions will have the same syntax.
Power Functions
= AverageIF
= SumIF
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.

= CountIF
= AverageIFS
= SumIFS
= CountIFS
These are considered compound functions. Excel executes from the inside out. Apply
criteria, take the records that match and average it out.
First, separate out the accounts you need then apply the formula
=AVERAGEIF(C:C, “AVERAGE Management”,G:G)
Text needs to be put in quotes because it’s not part of Excel’s dna.
Homework: Find the average salary of employees in the account management
department whose salaries are more than \$50,000. Use =AverageIFS
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.