ACCTG 5150 Short Cut Quiz 2 Flashcards

1
Q

Calculate

A

[F9]

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

Calculate Sheet

A

[Shift][F9]

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

Insert Table

A

[Ctrl][T]

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

Open the Quick Analysis Tool

A

[Ctrl][Q]

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

Enter current date

A

[Ctrl][;]

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

Enter the Current Time

A

[Shift][Ctrl][;]

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

Delete cell content

A

[Del]

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

Enter a Space/ Select item or checkbox

A

[Space]

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

Redo / Repeat

A

[Ctrl][Y]

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

Undo

A

[Ctrl][Z]

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

Copy Formula into Selected Cells

A

[Ctrl][Enter]

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

Copy

A

[Ctrl][C]

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

Cut

A

[Ctrl][X]

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

Paste Values

A

[Ctrl][Alt][V]

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

Paste

A

[Ctrl][V]

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

Copy Formula from cell above

A

[Ctrl][’]

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

Fill Down

A

[Ctrl][D]

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

Fill RIght

A

[Ctrl][R]

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

Flash Fill

A

[Ctrl][E]

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

Replace

A

[Ctrl][H]

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

Find

A

[Ctrl][F]

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

Enter a new line in the cell

A

[Alt][Enter]

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

Repeat Last Action / Absolute and Relative

A

[F4]

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

Toggles Edit / Enter Mode

A

[F2]

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

Save As

A

[F12]

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

Delete the Selected Cells / Rows / Columns

A

[Ctrl][-]

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

Close

A

[Alt][F][S]

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

Save

A

[Ctrl][S]

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

New Workbook

A

[Ctrl][N]

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

Print

A

[Ctrl][P]

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

Opens the Format Dialogue Box

A

[Ctrl][1]

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

Hide Columns

A

[Ctrl][0]

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

Show and Hide objects

A

[Ctrl][6]

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

Wrap Text

A

[Shift][Ctrl][W]

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

Hide Rows

A

[Ctrl][9]

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

Bold

A

[Ctrl][B]

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

Italics

A

[Ctrl][I]

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

Underline

A

[Ctrl][U]

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

Increase Decimals

A

[Ctrl][,]

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

Apply Comma Format

A

[Alt],[H],[K]

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

Paste Name

A

[F3]

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

Auto Sum

A

[Alt][=]

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

Select All

A

[Ctrl][A]

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

Open Name manager

A

[Alt],[M],[N]

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

Insert New worksheet

A

[Shift][F11]

39
Q

Open the context menu

A

[Shift],[F10]

40
Q

Switch between worksheets (right to left)

A

[Ctrl][Page Up]

40
Q

Switch between worksheets (Left to right)

A

[Ctrl][Page Down]

41
Q

Switch between workbooks

A

[Ctrl][Tab]

41
Q

Tab to next cell, tool, tab stop or object

A

[Tab]

41
Q

Switch between applications

A

[Alt][Tab]

42
Q

Moves between open windows

A

[Alt][Esc]

43
Q

Tab to previous cell, tool, tab stop or object

A

[Shift][Tab]

44
Q

Open GoTo Dialogue box

A

[F5]

45
Q

Move up one cell or item

A

[up]

46
Q

Enter and move up

A

[Shift][Enter]

47
Q

Jumps one page down

A

[Pg Dn]

48
Q

Jumps one page up

A

[Pg Up]

49
Q

Move down one cell

A

[Down]

50
Q

Move to the previous worksheet in the workbook

A

[Ctrl][Pg Up]

50
Q

Move to the next worksheet in the workbook

A

[Ctrl][Pg Dn]

51
Q

Move left one cell

A

[Left]

51
Q

Moves left to the next blank cell

A

[Shift][Ctrl][F4]

51
Q

Move right one cell

A

[Right]

51
Q

Moves to the bottom of an active area

A

[Ctrl][End]

51
Q

Moves to the bottom of the region or next region

A

[Ctrl][Down]

51
Q

Moves one screen to the left in a worksheet

A

[Alt][Pg Up]

51
Q

Moves one screen to the right in a worksheet

A

[Alt][Pg Dn]

52
Q

Moves right to the next blank cell

A

[Shift][F4]

52
Q

Hide Ribbons

A

[Ctrl][F1]

52
Q

Moves to the top of the spreadsheet

A

[Ctrl][Home]

52
Q

Select Cells to the next page

A

[Shift][Pg Dn]

52
Q

Moves to the front of the row

A

[Home]

53
Q

Moves to the top of the current region or next region

A

[Ctrl][up]

53
Q

Moves to the left of the region or next region

A

[Ctrl][Left]

53
Q

Select Cells while moving up

A

[Shift][up]

54
Q

Puts Excel in end mode

A

[End]

54
Q

Moves to the right of the region or next region

A

[Ctrl][Right]

55
Q

Select cells while moving left

A

[Shift][Left]

55
Q

Select the menu bar

A

[F10]

55
Q

Open a Menu or list

A

[Alt][Down]

55
Q

Select Visible cells

A

[Alt][;]

55
Q

Extended Selection mode

A

[F8]

55
Q

Add to selection

A

[Shift][F8]

56
Q

Select Cells to the previous page

A

[Shift][Pg Up]

56
Q

Select the active columns

A

[Shift][Space]

57
Q

Select Cells while moving down

A

[Shift][Down]

57
Q

Select the cells to the beginning of the row

A

[Shift][Home]

57
Q

Select cells while moving right

A

[Shift][Right]

57
Q

Select in end mode

A

[Shift][End]

58
Q

Select the current region

A

[Shift][Ctrl][8]

58
Q

Select the current and next sheet in a workbook

A

[Shift][Ctrl][Pg Dn]

58
Q

Select the current and previous sheet in a workbook

A

[Shift][Ctrl][Pg Up]

59
Q

Select the current Column

A

[Ctrl][Space]

60
Q

Select to the bottom of the region or next region

A

[Shift][Ctrl][Down]

60
Q

Select to the left of the region or next region

A

[Shift][Ctrl][Left]

61
Q

Select to the right of the region or next region

A

[Shift][Ctrl][Right]

62
Q

Next Pane or area

A

[F6]

62
Q

Minimize / Maximize Window

A

[Ctrl][F10]

62
Q

Select to the top of the current region or next region

A

[Shift][Ctrl][up]

62
Q

Hide Ribbons, tabs, and status bar

A

[Shift][Ctrl][F1]

63
Q

Opens the Selection pane

A

[Alt][F10]

63
Q

Expands and collapse the formula bar

A

[Shift][Ctrl][U]

64
Q

Previous Pane or area

A

[Shift][F6]

65
Q

Help

A

[F1]

65
Q

Escape out of edit mode

A

[Esc]

65
Q

Enter a formula into a cell or moves to the next cell

A

[Enter]

65
Q

Open Thesaurus

A

[Shift][F7]

65
Q

Spell Check

A

[F7]

66
Q

Minimize workbook

A

[Ctrl][F9]

67
Q

Open Context Menu

A

[Shift][F10]