HOME
INSERT
PAGE LAYOUT
DATA
REVIEW
100

To combine most cells together in any direction

What is "Merge"?

100

To insert a photo 

What is "Picture"?

100

The look of the spreadsheet before and after you print it

What is "Orientation"

100

Allow you to quickly sort your data in alphabetical order 

What is "Custom Sort"

100

Allows you you to keep track of your workbooks

What is "Workbook Statistics"

200

A feature that allows you to Find, Replace, and Go to if you had made a mistake in any of the cells 

What is "Find and Select"?

200

To insert a link to a website with in the spreadsheet

What is "Hyperlink"?

200

The ability to change the cells length and width within the spreadsheet 

What is "Size"

200

Allows you to view specific row in the spreadsheet and hide other ones 

What is "Filter"

200

Allow you to check your  grammar and spelling 

What is Spell Check"

300

To Give the cell colors and styles

What is "Cell Styles"?

300

used to summarize, sort, reorganize, group, count, total or average data stored in a database

What is "PivotTable"?

300

To change the color scheme of the spreadsheet 

What is "Theme"

300

Allow you fill your data when it senses at pattern  

What is "Flash Fill"

300

Tool to finding missing ALT texts 

What is "Accessibility Checker" 

400

allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell

What is "Conditional Formatting"?

400

To quickly and easily make a visual representation of your information

What is "Smart Art"?

400

One or more ranges of cells that you would like to print instead of printing the whole spreadsheet

What is "Print area"

400

Allows you to collapses rows and columns and be able to expand them later   

What is "Group"

400

A tool used to translate a different language used in the spreadsheet 

What is "Translate" 

500

To give the table different colors and styles

What is "Format as Table"?

500

Used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells

What is "Function"

500

Allows you to print a particular row and column headings

What is "Print Titles"

500

To remove cells that have the same values 

What is "Remove Duplicates"

500

A tool used to define unknown terms 

What is "Smart Lookup"

M
e
n
u