Brainscape's Knowledge GenomeTM

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


See full index

Excel For Mac > Excel shortcut keys > Flashcards

Excel shortcut keys Flashcards

1
Q

Control + Shift + L

A

Add or remove the filter button for the tables titles

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

Control + T

A

Create a table ( make sure the cursor is in the table )

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

Move to the edge of table

A

Command + select arrow Up, down, left or right

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

If want to highlight/select the entire table or column or row

A

Command + shift + arrow left, up, down, or right

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

If you do shift + arrows left, up, down, or right what happens

A

Select the cell one by one

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

what is the command key on a Windows computer keyboard

A

Control

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

Command + 1

A

Format cells

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

AutoSum shortcut

A

Command + Shit + T

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

How do you paste special

A

Command + option + V

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

What is paste special?

A

Paste the selected value, either in formulas format or just value format, etc…

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

add a new line inside a cell

A

Be in the formula line and tap: option + return

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

Select entire data in a table for example, what is the shortcut

A

Click in the data set and then command + A

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

Expand ribbon

A

Command + Option + R

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

what is Control + Shift + U

A

expand the formula bar

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

How to get back to the first cell in the worksheet

A

FN + Control + left arrow

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

How to get to the last cell in the worksheet

A

FN+ Control + right arrow

17
Q

Control + Shift + 4

A

currency formatting

18
Q

To put the $ in the referencing formating in excel during a formula for example

A

Command + T

19
Q

In a table to get a total autosum / subtotal

A

Command + Shift + T

20
Q

Add Row

A

Command + Shit + “the + sign”

21
Q

Add Column

A

Control + Space Bar then Command + Shift + “the + sign”

22
Q

Delete Row

A

Command + “the - sign “

23
Q

Delete a column

A

Command + “the - sign “

24
Q

to do a + -

A

Option + Shift + “ the + sign “

25
Q
A

Excel For Mac (2 decks)

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