{ "@context": "https://schema.org", "@type": "Organization", "name": "Brainscape", "url": "https://www.brainscape.com/", "logo": "https://www.brainscape.com/pks/images/cms/public-views/shared/Brainscape-logo-c4e172b280b4616f7fda.svg", "sameAs": [ "https://www.facebook.com/Brainscape", "https://x.com/brainscape", "https://www.linkedin.com/company/brainscape", "https://www.instagram.com/brainscape/", "https://www.tiktok.com/@brainscapeu", "https://www.pinterest.com/brainscape/", "https://www.youtube.com/@BrainscapeNY" ], "contactPoint": { "@type": "ContactPoint", "telephone": "(929) 334-4005", "contactType": "customer service", "availableLanguage": ["English"] }, "founder": { "@type": "Person", "name": "Andrew Cohen" }, "description": "Brainscape’s spaced repetition system is proven to DOUBLE learning results! Find, make, and study flashcards online or in our mobile app. Serious learners only.", "address": { "@type": "PostalAddress", "streetAddress": "159 W 25th St, Ste 517", "addressLocality": "New York", "addressRegion": "NY", "postalCode": "10001", "addressCountry": "USA" } }

Excel Shortcuts Flashcards

(30 cards)

1
Q

CTRL+SHIFT+&

A

Applies the outline border
to the selected cells.

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

CTRL+SHIFT+$

A

Applies Currency

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

CTRL+SHIFT+%

A

Applies the % format

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

CTRL+`

A

Alternates between displaying cell values and displaying formulas in the worksheet

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

CTRL+’

A

Copies a formula from the cell above the active cell into the cell of the Formula Bar

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

CTRL+1

A

Displays the Format Cells dialog box

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

CTRL+D

A

Uses the Fill Down command to copy
the contents and format of the topmost cell
of a selected range into the cells below

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

ALT+I+M

A

Enters a Comment in a cell

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

CTRL+SHIFT+O

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

CTRL+R

A

Uses the Fill Right command to copy
the contents and format of the leftmost cell
of a selected range into the cells to the right.

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

CTRL+Y

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

CTRL+Z

A

Uses the Undo command to reverse
the last action

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

ALT+F1

A

Creates a chart of the data in the cur-
rent range

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

ALT+SHIFT+F1

A

Inserts a new worksheet

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

F9

A

Calculates the entire workbook

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

SHIFT+ARROW KEY

A

Extends the selection of
cells by one cell.

17
Q

CTRL+SHIFT+ARROW KEY

A

Extends the selec-
tion of cells to the last nonblank cell in the same
column or row as the active cell.

18
Q

DELETE

A

Removes the cell contents (data and
formulas) from selected cells without affecting cell
formats or comment

19
Q

CTRL+END

A

Moves to the last cell on a worksheet,
in the lowest used row of the rightmost used col-
umn

20
Q

ALT+ENTER

A

Starts a new line in the same cell

21
Q

CTRL+HOME

A

Moves to the beginning of a work-
sheet

22
Q

CTRL+SHIFT+HOME

A

Extends the selection of
cells to the beginning of the worksheet.

23
Q

CTRL+PAGE DOWN

A

Moves to the next sheet in a
workbook.

24
Q

CTRL+PAGE UP

A

Moves to the previous sheet in a
workbook

25
CTRL+SPACEBAR
Selects an entire column in a worksheet.
26
SHIFT+SPACEBAR
Selects an entire row in a worksheet
27
ALT+E+S+T
28
ALT+E+S+R
Pastes copied formulas and number formats only
29
ALT+E+S+U
30
ALT+E+S+C
Pastes copied Comments only