Excel Crash Course Flashcards
(30 cards)
When you’re moving around using tab/arrows in a ribbon or menu, how do you open a button? Ex: open the different text colour options?
Atl + Down Arrow
What 2 excel settings changes should you make sure are enabled?
- Workbook Calculation: automatic except for data tables
- Workbook Calculation: enable iterative calculation
What is the shortcut for autosum?
Alt and Plus Sign
What is the shortcut to autofit the row height?
Alt h o a
What is the shortcut to open a new worksheet
Shift + F11
What is the shortcut to autofit column width?
Alt + H O I
How do you highlight entire columns?
Ctrl + Space
How do you highlight entire rows?
Shift + Space
How do you open format cells?
Ctrl + 1
How do you toggle check boxes on and off in excel?
Space
How do you change text color on excel?
- Ctrl 1
- Go to font
- Change the color
How do you open paste special?
Alt E S
When you are in the Format Cells dialog (Ctrl 1), what is the shortcut for moving across tabs (Number, Alignment, Font, Border, Fill)?
Ctrl Tab
How do you freeze a pane?
Alt W F F
How do you split a pane?
Alt W S
How do you get inside a cell?
F2
When inside a cell, how do you get to the front/back of the cell?
Ctrl Home and Ctrl End
Say you were editing a cell and you realized you made changes that you do not actually want to do, how could you bail out of the formula edit as if you never changed it in the first place?
Escape
Say you clicked F2 to enter a cell, now you want to use the arrows to navigate around the sheet and reference another cell, how do you get out of cell edit mode?
Hit F2 again
Say you wanted to delete a cell or series of cells, but not just the values, you want to delete the formulas, comments, and links. How would you do that?
Alt H E A
How do you add a column, where would it go?
Alt I C and it would go to the left of whatever cell you have highlighted
How can you use paste special to convert units?
Put the multiple that you want to convert the units by in one cell, then use Alt E S M to multiply them
How do you turn a vertical list of data to horizontal?
ALT E S E (Transpose)
How do you make a format with two decimal places?
Ctrl Shift Format
