Home/File
Insert/ Page Layout
Formulas
Data
Review/View
100
Hide/Unhide rows and columns
What is Format?
100
Contains elements such as page number, file path, file name, and sheet name.
What is Header & Footer Design tab?
100
To add a name to a cell
What is Define Name?
100
Sort the data in alphabetical order
What is Sort?
100
Allows you to split the sheet horizontally or vertically into 2 separate panes.
What is Split the Document?
200
Lets you copy the format of one cell to another
What is Format Painter?
200
A chart that shows the data in each row
What is Sparklines?
200
=___(number1,number2)
What is SUM?
200
Allows you to strain the data by the values
What is Filter?
200
View the document to see where the pages begin and end and to view any headers or footers on the page
What is Page Layout View?
300
Turns multiple cells into one cell and aligns text to the middle
What is Merge and Center?
300
To repeat rows in every section
What is Print Tiles?
300
=__(logical_test, value_if_true, value_if_false)
What is IF?
300
Allows you to delete rows that have the same value
What is Remove Duplicates?
300
Where you can design your own view with a new name, print settings, and hidden rows, columns, and filter settings.
What is Custom View?
400
To change the format of a title/heading.
What is Modify?
400
Lets you place a cell reference in the current document
What is Hyperlink?
400
Shows you all of the accessible functions
What is Function Library?
400
Helps you start from scratch
What is Refresh All?
400
Change the size of the document
What is Zoom?
500
Allows you to remove Comments & Annotations and Document Properties and Personal Information
What is Check for Issues?
500
Contains filters such as Marker, Watercolor Sponge, and Pencil Sketch
What is Artistic Effects?
500
Helps you create, delete, and find names located in the workbook.
What is Name Manager?
500
Prevents invalid data from being entered into a cell
What is Data Validation?
500
Keeps a portion of the sheet visible while the rest of the sheet scrolls.
What is Freeze Panes?
M
e
n
u