Keyboard Shortcuts
to save a document
Crtl + S
Bullets are located on
home tab in paragraph group
templates are located in
Backstage view
Active Cell
The cell in the worksheet in which you can type data.
Merge and Center
Click Home in Alignment Group click Merge & Center.
check spelling and grammar
F7
Pictures
Insert tab in Illustrations group
add a table
click Insert tab go to Tables group click down arrow and add a table
Formula Bar
A bar located between the ribbon and the worksheet in which users can edit the contents of a cell.
Sort and Filter
Home tab - Editing Group - Sort & Filter
Align center
ctrl + E
Watermark
Design tab in Page Background group
You need a table with two columns. On the left column it has two rows on the column on the right there are four rows. Which table option do you choose?
Draw table
AutoSum
a function that automatically adds the values in the cells directly above or to the left of the active cell
add a pie chart
Select data - Click Insert - Charts Group - Select a Pie Chart
redo
ctrl + y
Columns
Layout tab in Page Setup group
Add a comment
Click Review go to Comments Group click new comment
or
Highlight section you want to comment on and right click and select new comment
What does Freeze (in Excel) do
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
If Excel treats your formula as text
check for a space before the = sign
close a document
ctrl + w
Translate
Review tab in Language group
multiple pages
View Tab - Zoom group click Multiple Pages
Name Manager dialog box
used to edit, delete, and create range names
Open Name Manager dialog box
Ctrl + F3
or
On the Formulas tab of the ribbon, in the Defined Names group, select Define Name.