Excel Basics
Working with Data
Formulas & Functions
Charts and Visuals
Shortcuts and Navigation
100

The boxes where rows and columns meet are called____.

Cells


100
What key do you press to move from one cell to the next on the right?

Tab

100

Every formula in Excel must begin with what symbol?

Equal sign "="

100

What feature lets you turn numbers into a picture or graph?

Charts

100

Which keys do you press to COPY a cell?

Ctrl +C

200

What do we call the name of a cell, like A1 or B3?

Cell Reference
200

What type of data would you enter into Excel to do math: text, numbers, or pictures?

Numbers

200

Which function quickly adds numbers in a range?

=SUM

200

Which tab do you click to insert a chart?

Insert

200

Which keys do you press to PASTE a cell?

Ctrl + V

300

What are the horizontal lines in a spreadsheet called?

Rows

300

If you type 5+5 into a cell, will Excel add it automatically?

No, formulas must start with an "=" sign

300

What function shows the highest number in a list?

=MAX

300

Which type of chart is best for showing percentages of a whole?

Pie Chart

300

Which key do you press to undo your last action?

CTRL + Z

400

What are the vertical lines in a spreadsheet called?

Columns 

400

What tool can sort a list of names in ABC order?

Sort feature

400
What function quickly finds the average of numbers?

=AVERAGE

400

Which chart is best for comparing items side by side?

Bar Chart/Column Chart

400

Which key do you press to save your spreadsheet?

CTRL + S

500

What is the name of the file type that Excel saves by default?

.xlsx

500

If you enter "=10-4" into a cell, what will the result be?

6

500
What function shows the lowest number in a list?

=MIN

500

If you want to show how data changes over time, which chart should you use?

Line Chart

500

Which keys do you press to select all the data in a sheet?

CTRL + A