Formulas Flashcards
1
Q
Toggle absolute and relative references
A
F4
⌘T
2
Q
Open the Insert Function Dialog Box
A
ShiftF3
Fn⇧F3
3
Q
Autosum selected cells
A
Alt=
⌘⇧T
4
Q
Toggle formulas on and off
A
Ctrl`
⌃`
5
Q
Insert function arguments
A
CtrlShiftA
⌃⇧A
6
Q
Enter array formula
A
CtrlShiftEnter
⌃⇧Return
7
Q
Calculate worksheets
A
F9
FnF9
8
Q
Calculate active worksheet
A
ShiftF9
Fn⇧F9
9
Q
Force calculate all worksheets
A
CtrlAltF9
10
Q
Evaluate part of a formula
A
F9
FnF9
11
Q
Expand or collapse the formula bar
A
CtrlShiftU
⌃⇧U
12
Q
Display function arguments dialog box
A
CtrlA
⌃A
13
Q
Open the Name Manager
A
CtrlF3
Fn⌃F3
14
Q
Define name using row and column labels
A
CtrlShiftF3
Fn⌃⇧F3
15
Q
Select name box
A
AltF3