Using and Sharing Data Flashcards
What are research skills?
an ability to:
- locate
- evaluate
- analyze
- report info & data on a given topic
Why do businesses invest in market research?
its a critical component of:
-business strategy
-operations
-success of any bussiness/organization
Removes conditional formatting from only the selected data or 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
button that converts the selected data into a table and allows you to add:
- table formatting
- filters
- total rows to data
Format as table
Shows the sum or average of all records in the outline
Grand Total
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 rues in the worksheet
Manage Rules
Allows to create custom conditional formatting rule that meets the specific needs
New Rule
Summary of selected data from a more extensive table and may include:
- sums
- averages
- other statistics
PivotTable
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
Slicer
Shows the some 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
The properties of a workbook, found under File and Properties provide meta-data or the information that describes the document, such as the title, author, name, subject, and keywords that identify the contents of the document, such as the document title, author name, and keywords that identify the contents of the document
Information & Properties
Connecting to a printer. If there is more tan one printer, yo ucan select the correct printer under File and Print, vio drop down menu. You can print to Adobe PDF
Printer Selection
By default Excel will print only the active worksheet that is currently displayed on your screen. If needed, you can you can choose to print all the worksheets in the workbook or even a particular selection of cells
Sheet Selection
Conditional Formatting options?
(4)
1) Highlight Cell Rules
2) Top/Bottom Rules
3) Data Bars
4) Color scales
