ACCTG 5150 Short Cut Quiz 2 Flashcards
(111 cards)
1
Q
Calculate
A
[F9]
2
Q
Calculate Sheet
A
[Shift][F9]
3
Q
Insert Table
A
[Ctrl][T]
4
Q
Open the Quick Analysis Tool
A
[Ctrl][Q]
5
Q
Enter current date
A
[Ctrl][;]
6
Q
Enter the Current Time
A
[Shift][Ctrl][;]
7
Q
Delete cell content
A
[Del]
8
Q
Enter a Space/ Select item or checkbox
A
[Space]
9
Q
Redo / Repeat
A
[Ctrl][Y]
10
Q
Undo
A
[Ctrl][Z]
11
Q
Copy Formula into Selected Cells
A
[Ctrl][Enter]
12
Q
Copy
A
[Ctrl][C]
13
Q
Cut
A
[Ctrl][X]
14
Q
Paste Values
A
[Ctrl][Alt][V]
14
Q
Paste
A
[Ctrl][V]
15
Q
Copy Formula from cell above
A
[Ctrl][’]
16
Q
Fill Down
A
[Ctrl][D]
17
Q
Fill RIght
A
[Ctrl][R]
18
Q
Flash Fill
A
[Ctrl][E]
19
Q
Replace
A
[Ctrl][H]
20
Q
Find
A
[Ctrl][F]
21
Q
Enter a new line in the cell
A
[Alt][Enter]
22
Q
Repeat Last Action / Absolute and Relative
A
[F4]
22
Q
Toggles Edit / Enter Mode
A
[F2]
23
Save As
[F12]
23
Delete the Selected Cells / Rows / Columns
[Ctrl][-]
24
Close
[Alt][F][S]
24
Save
[Ctrl][S]
25
New Workbook
[Ctrl][N]
26
Print
[Ctrl][P]
27
Opens the Format Dialogue Box
[Ctrl][1]
28
Hide Columns
[Ctrl][0]
28
Show and Hide objects
[Ctrl][6]
29
Wrap Text
[Shift][Ctrl][W]
30
Hide Rows
[Ctrl][9]
31
Bold
[Ctrl][B]
32
Italics
[Ctrl][I]
33
Underline
[Ctrl][U]
34
Increase Decimals
[Ctrl][,]
35
Apply Comma Format
[Alt],[H],[K]
36
Paste Name
[F3]
36
Auto Sum
[Alt][=]
37
Select All
[Ctrl][A]
38
Open Name manager
[Alt],[M],[N]
39
Insert New worksheet
[Shift][F11]
39
Open the context menu
[Shift],[F10]
40
Switch between worksheets (right to left)
[Ctrl][Page Up]
40
Switch between worksheets (Left to right)
[Ctrl][Page Down]
41
Switch between workbooks
[Ctrl][Tab]
41
Tab to next cell, tool, tab stop or object
[Tab]
41
Switch between applications
[Alt][Tab]
42
Moves between open windows
[Alt][Esc]
43
Tab to previous cell, tool, tab stop or object
[Shift][Tab]
44
Open GoTo Dialogue box
[F5]
45
Move up one cell or item
[up]
46
Enter and move up
[Shift][Enter]
47
Jumps one page down
[Pg Dn]
48
Jumps one page up
[Pg Up]
49
Move down one cell
[Down]
50
Move to the previous worksheet in the workbook
[Ctrl][Pg Up]
50
Move to the next worksheet in the workbook
[Ctrl][Pg Dn]
51
Move left one cell
[Left]
51
Moves left to the next blank cell
[Shift][Ctrl][F4]
51
Move right one cell
[Right]
51
Moves to the bottom of an active area
[Ctrl][End]
51
Moves to the bottom of the region or next region
[Ctrl][Down]
51
Moves one screen to the left in a worksheet
[Alt][Pg Up]
51
Moves one screen to the right in a worksheet
[Alt][Pg Dn]
52
Moves right to the next blank cell
[Shift][F4]
52
Hide Ribbons
[Ctrl][F1]
52
Moves to the top of the spreadsheet
[Ctrl][Home]
52
Select Cells to the next page
[Shift][Pg Dn]
52
Moves to the front of the row
[Home]
53
Moves to the top of the current region or next region
[Ctrl][up]
53
Moves to the left of the region or next region
[Ctrl][Left]
53
Select Cells while moving up
[Shift][up]
54
Puts Excel in end mode
[End]
54
Moves to the right of the region or next region
[Ctrl][Right]
55
Select cells while moving left
[Shift][Left]
55
Select the menu bar
[F10]
55
Open a Menu or list
[Alt][Down]
55
Select Visible cells
[Alt][;]
55
Extended Selection mode
[F8]
55
Add to selection
[Shift][F8]
56
Select Cells to the previous page
[Shift][Pg Up]
56
Select the active columns
[Shift][Space]
57
Select Cells while moving down
[Shift][Down]
57
Select the cells to the beginning of the row
[Shift][Home]
57
Select cells while moving right
[Shift][Right]
57
Select in end mode
[Shift][End]
58
Select the current region
[Shift][Ctrl][8]
58
Select the current and next sheet in a workbook
[Shift][Ctrl][Pg Dn]
58
Select the current and previous sheet in a workbook
[Shift][Ctrl][Pg Up]
59
Select the current Column
[Ctrl][Space]
60
Select to the bottom of the region or next region
[Shift][Ctrl][Down]
60
Select to the left of the region or next region
[Shift][Ctrl][Left]
61
Select to the right of the region or next region
[Shift][Ctrl][Right]
62
Next Pane or area
[F6]
62
Minimize / Maximize Window
[Ctrl][F10]
62
Select to the top of the current region or next region
[Shift][Ctrl][up]
62
Hide Ribbons, tabs, and status bar
[Shift][Ctrl][F1]
63
Opens the Selection pane
[Alt][F10]
63
Expands and collapse the formula bar
[Shift][Ctrl][U]
64
Previous Pane or area
[Shift][F6]
65
Help
[F1]
65
Escape out of edit mode
[Esc]
65
Enter a formula into a cell or moves to the next cell
[Enter]
65
Open Thesaurus
[Shift][F7]
65
Spell Check
[F7]
66
Minimize workbook
[Ctrl][F9]
67
Open Context Menu
[Shift][F10]
