Level 10 Level 12
Level 11

Formulas and Names


14 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
alt+=
Insert the AutoSum formula.
shift+f3
Display the Insert Function dialog box.
ctrl+a
Display Formula Window after typing formula name.
ctrl+shift+a
Insert Arguments in formula after typing formula name. .
ctrl+shift+enter
Enter a formula as an array formula.
f4
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
f9
Calculate all worksheets in all open workbooks.
shift+f9
Calculate the active worksheet.
ctrl+alt+f9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
ctrl+alt+shift+f9
Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
ctrl+shift+u
Toggle expand or collapse formula bar.
ctrl+f3
Define a name or dialog.
ctrl+shift+F3
Create names from row and column labels.
f3
Paste a defined name into a formula.