Shortcuts
Workbook
Formulas
Workbook 2
Tables/Charts
100

Control Z

What is Cut?

100

Line effects around cell

What are borders?

100

Sum of 2 or more congruent cells

what is Auto sum? =sum()


100

Rename Tab

What is Right click on Tab and Rename?

100

Mini charts in single cells

What is sparkline?

200

Control V

What is paste?

200

Highlighting within a spreadsheet

What is selecting?

200

Todays date

What is =today()?



200

Control S

What is Save Workbook As?

200

A doughnut chart

What is another word for pie chart?

300

Control Z

What is undo?

300

The intersection of a column and a row

What is cell?

300

Currency

What is =Dollar(#.##) or =Dollar(A2) -> Highlight a particular cell A:2

300

Delete the contents of a cell

what is Delete Key?

300

Line chart

what is shows trends over time?

400

Control Y

What is Redo?

400

Used to begin a formula

what is =?

400

Time

What is =Time(#,#)

Ex 1: =Time(1,1) = 1:01AM

Ex 2 =Time(13,1) =1:01PM

400

Change sheet color

What is right click tab?

400

Hierarchy chart

What is shows parts of a whole?

500

Alt =

What is autosum?

500

A grouping of cells

what is range?

500

Backslash

What is symbol to divide?

500

columns are represented as

What are letters?

500

Combo chart

What is highlights different types of information?

M
e
n
u