Module 1
Accessed via File tab. Here you can SAve, Save As, Print, Open, Export to PDF, and check file info.
Backstage
This toolbar appears above the ribbon by default and holds the AutoSave, Save, Undo, and Redo commands. It can be customized to suit your needs.
In Excel terms, the positioning of content or objects horizontally or vertically, lining up with cell borders.
Alignment
This tab contains the Font, Alignment, and Number grouping.
Home
Copy
Ctrl + C
A master file that can be used to create new files.
Template
The place where copied data can be stored for future pasting purposes. It can hold up to 24 copied items from any Microsoft application.
Office Clipboard
The appearance properties of items or objects, including fonts, font size, colors, borders, and numbers.
Formatting
This tab contains tables, illustrations, and charts.
Insert
Undo
Ctrl + Z
A tool that helps you navigate to specific cells, ranges, elements, or cells within special attributes.
Go To
The function that freezes worksheet titles on screen, meaning if you move down or across to the right, the titles will remain on screen
Freeze panes
This command allows you to copy a vertical block and paste it somewhere else in the worksheet horizontally
Transpose
This tab contains Workbook Views and Window.
View
Cut
Ctrl + X
Special formatting applied to cells to display various crtieria.
Conditional Formatting
A function that allows you to paste special attributes of a cell, rather than just the contents of a cell.
Paste Special
This command allows you to copy formatting from one cell(s) to another cell(s).
Format Painter
Which grouping allows you to format cells, insert row/columns, and delete rows/columns.
Cells
Bold
Ctrl + B
This command allows you to save data as a new file name.
Save As
This command allows you to copy sequential data by dragging the cells.
AutoFill
This command allows you to wrap extra-long text so that you can see it in one cell clearly.
Wrap Text
Which grouping allows you to find, replace and clear?
Editing
Find
Ctrl + F