Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel Short Cut Keys > Creating Formula Shortcuts > Flashcards

Creating Formula Shortcuts Flashcards

1
Q

Open The Insert Function Dialog Box

A

Shift + F3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Cycles Through Absolute and Relative References

A

F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Insert Functions Arguments Into Cell

A

Ctrl + Shift + A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Open The Insert Function Dialog Box From Within Cell

A

Ctrl + A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Sum Selected Cells

A

Alt + =

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Calculate Part Of A Formula

A

F9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Create Array Formula

A

Ctrl + Shift + Enter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly

Excel Short Cut Keys (20 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions