Excel Unit 1

Formatting

100

What does formatting do? 

Changes how a cell looks

200

Tool that puts data in alphabetical or numerical order.

Sort

300

This process joins cells together.

Merge

400

A tool that copies formatting from one cell and applies it to another.

Format painter

500

Formatting that is applied to a cell only if certain conditions are met.  

Conditional Formatting

Charts and Graphs

100

Type of chart used to display parts of a whole or show how things are divided

Pie chart

200

What is the very first step when creating a chart?

Highlight the data that you want in the chart

300

This is a single piece of data in a chart.

Data point

400

Tool to help readers understand the data in a chart

Legend

500

Chart element that displays information about a data point such as value or category name.  

Data label

Random

100

What tool will display all formulas used in a woksheet.

Show Formulas

200

Tool you click to see a list of all Functions

Fx button 

or

Functions button

300

Function button that holds shortcuts to the most commonly used functions:  Sum, Average, Count, Max, and Min

AutoSum

400

This is a cell reference that cannot be copied.

Absolute

500

This tool allows you to extract data from a spreadsheet.  Using this tool, you will see only the data that you choose.

Filter

Basic Formulas & Functions

100

Write the formula or function that will add cells A1 and A2

=A1+A2

200

Write the formula or function that will calculate the average of cells A1, B1, and C1.

=AVERAGE(A1:C1)

300

Write the formula or function that will add cells A1 through A20

=SUM(A1:A20)

400

Write the formula or function that pull out the highest number in the cell range A1:A20

=MAX(A1:A20)

500

Write the formula that will calculate 25% of cell A1

=A1*0.25 

or

=A1*.25

Basic Excel

100

What is the intersection of a column and a row called?

Cell

200

What is an Excel file called? 

Workbook

OR

Spreadsheet

300

What is the file extension for Excel? 

.xls

OR

.xlsx

400

What term describes a highlighted group of cells? 

Range

500

What does it mean if you see ##### in a cell instead of the data that should be in the cell?

The Column width is too narrow

OR

The Row height is too low