Reading...
Play button
Play button
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;
119 Cards in this Set
- Front
- Back
|
TODAY
|
Returns the serial number of today's date
|
|
|
YEAR
|
Converts a serial number to a year
|
|
|
CELL
|
Returns information about the formatting, location, or contents of a cell
|
|
|
ISBLANK
|
Returns TRUE if the value is blank
|
|
|
ISERROR
|
Returns TRUE if the value is any error value
|
|
|
ISNONTEXT
|
Returns TRUE if the value is not text
|
|
|
ISNUMBER
|
Returns TRUE if the value is a number
|
|
|
ISTEXT
|
Returns TRUE if the value is text
|
|
|
AND
|
Returns TRUE if all of its arguments are TRUE
|
|
|
FALSE
|
Returns the logical value FALSE
|
|
|
IF
|
Specifies a logical test to perform
|
|
|
IFERROR
|
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
|
|
|
NOT
|
Reverses the logic of its argument
|
|
|
OR
|
Returns TRUE if any argument is TRUE
|
|
|
TRUE
|
Returns the logical value TRUE
|
|
|
ADDRESS
|
Returns a reference as text to a single cell in a worksheet
|
|
|
COLUMN
|
Returns the column number of a reference
|
|
|
COLUMNS
|
Returns the number of columns in a reference
|
|
|
HLOOKUP
|
Looks in the top row of an array and returns the value of the indicated cell
|
|
|
INDEX
|
Uses an index to choose a value from a reference or array
|
|
|
Highlight the entire table
|
CTRL + *
|
|
|
Unselect/ out of formula
|
ESC button
|
|
|
Bold Letters
|
CTRL + B
|
|
|
Italic Letters
|
CTRL + I
|
|
|
Underline Letters
|
CTRL + U
|
|
|
Format Box
|
CTRL + 1
|
|
|
Clear Cell
|
Alt + H + E + A
|
|
|
Outline Border
|
Shift + CTRL + &
|
|
|
Remove Border
|
Shift + CTRL + &
|
|
|
Insert a Comment
|
Shift + F2
|
|
|
Copy
|
Ctrl + C
|
|
|
Paste
|
Ctrl + V
|
|
|
Paste Special
|
Alt + H + V + S
OR Alt + E + S |
|
|
Cut
|
CTRL + V
|
|
|
Repeat
|
Ctrl + Y
|
|
|
Undo
|
CTRL + Z
|
|
|
Delete Selected Cells
|
CTRL + Minus Sign
|
|
|
Toggle Excel Workbooks
|
CTRL + Tab
|
|
|
Split Screen
|
Alt + W + S (F6 Jumps pane to pane)
|
|
|
Freeze pane
|
ALT + W + F
|
|
|
New Workbook
|
Alt + N
|
|
|
Print
|
Ctrl + P
|
|
|
Save workbook
|
Ctrl + S
|
|
|
Activate Menu Bar
|
Alt or F10
|
|
|
Min/Restore Ribbon
|
Ctrl + F10
|
|
|
Print Preview
|
Alt + F + W + V
|
|
|
Close window
|
Ctrl + W (Ctrl + F4)
|
|
|
Close Program
|
Alt + F4
|
|
|
Excel Options
|
Alt + F + T
|
|
|
Move/ Copy a Tab
|
Alt + H + O + M
|
|
|
Change Tab Name
|
Alt + H + O + R
|
|
|
Moving to left/right tabs
|
Ctrl + Pg Up / down
|
|
|
New Tab
|
Ctrl + F11
|
|
|
Select Column
|
Ctrl + Space
|
|
|
Select Row
|
Shift + Space
|
|
|
Delete Row
|
Ctrl + Minus Sign
|
|
|
Add A Row
|
Ctrl + Shift + plus sign
|
|
|
Group /ungroup Rows & Columns
|
Shift + Alt + left / right arrow key
|
|
|
Fit Column Width
|
Alt + H + O +I
|
|
|
Select All
|
Ctrl + A
|
|
|
Fill Down
|
Ctrl + D
|
|
|
Fill Right
|
Ctrl + R
|
|
|
Find
|
Ctrl + F
|
|
|
Replace
|
Ctrl + H
|
|
|
Edit Cell
|
F2
|
|
|
Start a formula
|
=
|
|
|
Insert AutoSum formula
|
Alt + "+"
|
|
|
Go to end of Continuous Range
|
Ctrl + Arrow Key
|
|
|
Select a cell range
|
Shift + Arrow key
|
|
|
Move to beginning of a line
|
home
|
|
|
Move to Cell "A1"
|
Ctrl + Home
|
|
|
Move to cell above
|
shift + enter
|
|
|
move cell to the right
|
tab
|
|
|
move cell to the lefts
|
shift + tab
|
|
|
Recalculate all workbooks
|
F9
|
|
|
Display Drop-down list
|
Alt + up/down arrow key
|
|
|
Display Insert function box
|
alt + I + F (shift F3)
|
|
|
Display "Name" box
|
Ctrl + F3
|
|
|
Enter array formula
|
shift + Ctrl + Enter
|
|
|
Trace immediate precedents
|
Alt + M + P
|
|
|
Trace immediate dependents
|
Alt + M + D
|
|
|
Remove tracing arrows
|
Alt + M + A +A
|
|
|
Evaluate formula
|
Alt + M + V
|
|
|
Track Changes
|
Alt + R + G
|
|
|
Zoom to selection
|
Alt + W + G
|
|
|
Go to precedent Cells
|
Ctrl + [
|
|
|
Go to dependent Cells
|
Ctrl + ]
|
|
|
Go Back to Original Cell
|
F5 + Enter
|
|
|
"Go to"
|
F5
|
|
|
Delete cell and get inside
|
BACKSPACE
|
|
|
Delet Cell/Selection
|
Delete
|
|
|
Show formula values
|
Ctrl + ~
|
|
|
Fill Selection with entry
|
Ctrl + Enter
|
|
|
Start New Line in Same Cell
|
Alt + Enter
|
|
|
Highlight within Cells
|
Shift + Arrow key
|
|
|
Highlight contiguous items
|
Shift + Ctrl + Arrow keys
|
|
|
Delete preceding character
|
backspace
|
|
|
Delete character to the right
|
delete
|
|
|
Anchor "Fix Cells"
|
F4
|
|
|
Cancel Cell Entry
|
ESC
|
|
|
Universal Application: Minimize all windows
|
Windows key + D
|
|
|
Windows Explorer
|
Windows Key + E
|
|
|
Close Windows Explorer
|
Alt + F4
|
|
|
Highlight Cell
|
Alt + "h" + "h"
|
|
|
Change Cell Font Color
|
Alt + "h" + "FC"
|
|
|
Select Special
|
F5 + then alt "s", then alt + "o", then alt x, g, e & ok
|
|
|
Good things about Account Cell Format
|
1. Dollar signs are fixed/ "floating
2. Decimals lined up |
|
|
Currency Format is good
|
Lets user decide how negative values are shown.
|
|
|
Insert Line Chart
|
Alt + N + N
|
|
|
Insert Bar Chart
|
Alt + N + C
|
|
|
Insert Pivot Table
|
Alt + N + V
|
|
|
Insert Scatter Chart
|
Alt + N + D
|
|
|
Print Preview
|
Ctrl + F2
|
|
|
Page Setup
|
Alt + P + S + P
|
|
|
Calculating Formulas are formulas that...
|
calculate a numerical answer
|
|
|
Lookup formulas are formulas that...
|
look up an item in a table (like looking up the tax rate or customer phone #)
|
|
|
Text Formulas are foulas that...
|
deliver a word to a cell or create labels for reports (like a an incomes statement label)
|
|
|
Logical Formulas are formulas that...
|
give you a logical value, either true or false
|
|
|
Array formulas are...
|
advanced formulas that act on arrays (ranges) instead of individual cell references
|
