• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/47

Click to flip

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