Formula
Creating a Chart
Basics
Tool Bar
100

Each formula must begin with _____?

=

100

What must you do first when creating a chart?

Highlight the data you want in the chart.

100

Which directions do columns generally go?

Vertical // Up and Down

100

Which tab is generally considered your "Go To"?

Home Tab

200

Which function adds data in excel?

SUM

200

Which tab do you click to select your chart type?

Insert

200

Which general directions do rows go?

Horizontal // Left and Right
200

Which tab consist of the ability to bold, italicize, or underline your words in a cell?

Home Tab

300

What function finds the average of data in excel?

AVERAGE

300
Name at least 4 things you should include in your chart.

Chart Title, Axis, Axis Title, Legend, Gridlines.

300

Describe the difference between a workbook and a worksheet.

A workbook is the entire Excel file that contains one or more worksheets, while a worksheet is a single “sheet” or tab inside that file where you enter and organize data.

300

If I wanted to insert a table in excel using the data in the worksheet, which tab would I go to?

Insert Tab

400

What is missing?

=sumb4:b8

() Parenthesis


400

What is a legend?

Describes what each bar is on your chart.

400

How many cells are in the range B2:B3?

2

400

What should you always do once complete your workbook in excel?

SAVE IT!

500

What button do you press to calculate a formula once typed?

"Enter"

500

What is the purpose of a chart title?

To allow the person analyzing your chart to understand what the general topic is of your data/chart.

500

Describe how you can make conclusions/summaries in excel just by looking at data.

Teacher Opinion.

500

Describe how the toolbar in excel is useful.

Teacher Opnion.

M
e
n
u