Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
47 Cards in this Set
- Front
- Back
F4 function key
|
F4 function key cycles through
e.g., Enter A1 in a formula F4 converts the cell reference to =$A$1 F4 again converts it to =A$1 F4 again displays =$A1 F4 again starts over |
|
Function Key F2?
|
F2 puts you in edit mode of a Range
e.g., in a cell and want to edit contents |
|
Ctrl + Shift + Arrow Key
|
Ctrl + Shift + Arrow Key
selects the rest of data down or up or sideways from the cell selected |
|
Alt key
|
Alt key shows what is available
when Alt + the letter are pressed e.g., Alt + H + other letters and numbers drills down |
|
Ctrl + Arrow Key
|
Ctrl + Arrow moves end or top of current region
Note, up or down and Left /Right arrow can be used Ctrl + Shift + Arrow key highlights, e.g., for copying Current Region means last cell with data, or last blank cell |
|
F1
|
F1 ==> Help
|
|
F2
|
F2 ==> Edit
|
|
F3
|
F3 ==> Past Name Formula
|
|
F5
|
F5 ==> Go To
|
|
F7
|
F7 ==> Spell check
|
|
F8
|
F8 ==> Extend Selection
|
|
F9
|
F9 ==> (Re) Calculate all
|
|
F10
|
F10 ==> Activate Menu
|
|
F11
|
F11 ==> New Chart
|
|
F12
|
F12 ==> Save As
|
|
Alt + =
|
Alt + = AutoSum
|
|
Populating a range with the same item
|
Populating a range with the same item:
Highlight the area Enter the item in the active cell Ctrl + Enter fills the highlighted area |
|
Ctrl + *
|
Ctrl + * Selects a whole region
For example, a column or row from where the cursor is located |
|
To name a cell or range:
Highlight the column or Cell Ctrl + Shift + F3 |
Ctrl + F3
to edit a Named Range |
|
Ctrl + 1 with a chart does what?
|
Ctrl + 1 formatting chart area
|
|
A chart title can be what is in a cell
|
A chart title can be what is in a cell
Insert/Edit a Title, then F2 to cell reference for a title |
|
To print only a selected area of a worksheet?
|
To print only a selected area of a worksheet
Select area Page Layout Set Print Area |
|
Alt+P+S+P
|
Alt+P+S+P sets up the area to be printed after the area has been selected
|
|
Ctrl+Tab
|
Ctrl + Tab
flips to other WorkbookS also opens |
|
Note: Enter enters data or formula,
then moves down one cell Shift + Enter does the above, BUT moves up 1-cell |
Note: Ctrl + Enter keeps you in the cell
without moving down Tab to go right Shift + Tab to go left |
|
Ctrl + Home
|
Ctrl + Home
Back to the A1 cell |
|
Double Clicking the Fill Handle does
|
Double Clicking the Fill Handle fills downward for a Region
|
|
Ctrl + L
turns a region into a list |
Ctrl + T
turns a region into a Table Right click to "un-Table" |
|
Alt + W + F
|
Alt + W + F
Freezes and Unfreezes columns & Rows |
|
Insert row: Alt + I and then R
|
Insert row: Alt + I and then R
Insert a column: Alt + I and then C |
|
Ctrl + Z
|
Ctrl + Z Undo
Ctrl +Y brings it back |
|
Ctrl + W
|
Ctrl + W closes workbook
|
|
Alt + F4
|
Alt + F4
Exit Excel |
|
F6
|
F6 switches through
various areas of a Worksheet |
|
Shift + F6
|
Shift + F6
switches back & forth when split-screen |
|
Ctrl + Pagedown
|
Ctrl + Pagedown
switches between WorksheetS |
|
Ctrl + Pagedown
|
Ctrl + Pagedown
switches between WorksheetS |
|
Ctrl + F6
|
Ctrl + F6
switches through WorkbookS |
|
Shift + F10
|
Shift + F10
is same as as using Right Mouse Button |
|
Ctrl + T
converts a region into a table Note: check mark for headers |
To convert a Table
back to a regular SS Right Click within tbl Select Tbl from drop-down Select Convert to Range |
|
Shift + F11
|
Shift + F11
insert a new sheet |
|
Alt + D + S
|
Alt + D + S
|
|
Alt + D + S
|
Highlight the region to be sorted
Alt + D + S Horz Sort Header NOT included |
|
Alt + O + D
|
Alt + O + D
gets you to the Conditional Set-up |
|
Alt + N + V + T
|
Alt + N + V + T
starts up Pivot Table |
|
Ctrl + Backspace
|
Ctrl + Backspace
jumps you back to the active cell |
|
ctrl + shift + 4
|
ctrl + shift + 4
makes a numeral entry currency formatted |