Formula Flashcards
1
Q
Begin entering a formula
A
= or +
2
Q
Toggle absolute and relative references (in cell edit mode)
A
F4
3
Q
Open the Insert Function Dialog Box
A
SHIFT + F3
4
Q
Autosum
A
ALT + =
5
Q
Toggle displaying formula on and off
A
CTRL + ‘
6
Q
Insert function arguments
A
CTRL + SHIFT + A
7
Q
Insert function arguments
A
CTRL + SHIFT + A
8
Q
Enter array formula
A
CTRL + SHIFT + ENTER
9
Q
Calculate worksheets
A
F9
10
Q
Calculate active worksheet
A
SHIFT + F9
11
Q
Force calculate all worksheets
A
CTRL + ALT + F9
12
Q
Evaluate part of a formula (in cell edit mode)
A
F9
13
Q
Expand or collapse the formula bar
A
CTRL + SHIFT + U
14
Q
Display function arguments dialog box
A
CTRL + A
15
Q
Open name manager
A
CTRL +F3
16
Q
Create name from values in row(s)/column(s)
A
CTRL + SHIFT + F3
17
Q
Paste name into formula
A
F3
18
Q
Accept function with auto-compete
A
Tab
