Research Skills for Business (RSB) Flashcards
An ability to locate, evaluate, analyze, and report information and data on a given topic
Research Skills
Removes conditional formatting from only the selected data or from the entire worksheet
Clear Rules
Used to format cells that meet a certain criterion.
Conditional formatting
Appears next to each table heading and opens the drop down where you can choose how to sort or filter your data
filter button
Shows the sum or average of all records in the outline
Grand Total
Allows to create custom conditional formatting rule that meets the specific needs
New Rule
Horizontal look up, an excel function to look up and retrieve data from a specific row in a table
HLOOKUP
Allows to edit and reorder existing rules in the worksheet
Manage Rules
Chart or graph that shows info from the Pivot table
Pivot Chart
Summarizes data from a more extensive table and may include sums, averages, and other statistics chosen by the user
Pivot table
A data filter with convenient buttons that filters pivot table data
Slicer
Shows the sum or average of all data belonging to their own outline level
Subtotal
Vertical look up, an Excel function to look up and retrieve data from a specific column in a table
VLOOKUP
7 basic steps of any research project
1) identify research goal
2) identify research goal
3) What research tools can and should you use
4) Search for info
5) Evaluate sources and info
6) Create your research document
7) Proofread
4 basic categories of electronic research tools used for locating data and info (already existing):
1) Search Engine
2) Electronic Database
3) Electronic Journal
4) Electronic Book (E-Book)
Search system designed to search the World Wide Web in a systematic way
Search Engine
Software great for locating general info and deep info search
- keywords
- ex: Google
Search Engine
Software is great for SPECIALIZED research
- ex: GoogleScholar
- scientific/reliable evidence
Electronic Databases
Software used on a regular basis to keep up with industry trend and news
E-journals
Software provides an in-depth coverage of the topic
- typically business related topics
E-books
How many quintillions of bytes are created every day?
2.5
FUNCTION:
AND
Returns only results containing BOTH terms
FUNCTION:
OR
Returns results containing EITHER term. Often used with synonoyms
FUNCTION:
NOT
Returns results containing the first term but EXCLUDES any results that also contain the second term
FUNCTION:
/s
Returns results with both terms in the same SENTENCE