Using and Sharing Data

Question 1

What are research skills?

Answer 1

an ability to:
- locate
- evaluate
- analyze
- report info & data on a given topic

Question 2

Why do businesses invest in market research?

Answer 2

its a critical component of:
-business strategy
-operations
-success of any bussiness/organization

Question 3

Removes conditional formatting from only the selected data or the entire worksheet

Answer 3

clear rules

Question 4

used to format cells that meet a certain criterion

Answer 4

Conditional formatting

Question 5

appears next to each table heading and opens the drop down where you can choose how to sort or filter your data

Answer 5

filter button

Question 6

button that converts the selected data into a table and allows you to add:
- table formatting
- filters
- total rows to data

Answer 6

Format as table

Question 7

Shows the sum or average of all records in the outline

Answer 7

Grand Total

Question 8

Horizontal look up, an Excel function to look up and retrieve data from a specific row in a table

Answer 8

HLOOKUP

Question 9

Allows to edit and reorder existing rues in the worksheet

Answer 9

Manage Rules

Question 10

Allows to create custom conditional formatting rule that meets the specific needs

Answer 10

New Rule

Question 11

Summary of selected data from a more extensive table and may include:
- sums
- averages
- other statistics

Answer 11

PivotTable

Question 12

A data filter with convenient buttons that filters pivot table data

Answer 12

Slicer

Question 13

Shows the sum or average of all data belonging to their own outline level

Answer 13

Slicer

Question 14

Shows the some or average of all data belonging to their own outline level

Answer 14

Subtotal

Question 15

Vertical look up, an Excel function to look up and retrieve data from a specific column in a table

Answer 15

VLOOKUP

Question 16

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

Answer 16

Information & Properties

Question 17

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

Answer 17

Printer Selection

Question 18

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

Answer 18

Sheet Selection

Question 18

Conditional Formatting options?
(4)

Answer 18

1) Highlight Cell Rules
2) Top/Bottom Rules
3) Data Bars
4) Color scales