Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Acc 401 - AIS > Test 1 Excel Shortcuts and Formulas > Flashcards

Test 1 Excel Shortcuts and Formulas Flashcards

1
Q

CTRL+(

A

Unhides any hidden rows within the selection.

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

CTRL+9

A

Hides the selected rows.

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

CTRL+0

A

Hides the selected columns.

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

CTRL+A

A

Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

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

CTRL+B

A

Applies or removes bold formatting.

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

CTRL+C

A

Copies the selected cells.

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

CTRL+F

A

Displays the Find dialog box.

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

CTRL+I

A

Applies or removes italic formatting

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

CTRL+N

A

Creates a new, blank file.

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

CTRL+P

A

Displays the Print dialog box.

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

CTRL+S

A

Saves the active file with its current file name, location, and file format

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

CTRL+U

A

Applies or removes underlining.

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

CTRL+V

A

Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.

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

CTRL+W

A

Closes the selected workbook window.

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

CTRL+X

A

Cuts the selected cells.

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

CTRL+Y

A

Repeats the last command or action, if possible

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

CTRL+Z

A

Uses the Undo command to reverse the last command or to delete the last entry

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

F2

A

Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.

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

CTRL+Arrow Key

A

Moves to the edge of the current data region in a worksheet.

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

SHIFT+Arrow Key

A

Extends the selection of cells by one cell

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

CTRL+SHIFT+Arrow Key

A

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

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

CTRL+END

A

Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.

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

CTRL+SHIFT+END

A

Extends the selection of cells to the last used cell on the worksheet (lower-right corner).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
ALT+ENTER
Starts a new line in the same cell.
26
CTRL+ENTER
Fills the selected cell range with the current entry.
27
HOME
Moves to the beginning of a row in a worksheet.
28
CTRL+HOME
Moves to the beginning of a worksheet.
29
CTRL+SHIFT+HOME
Extends the selection of cells to the beginning of the worksheet.
30
CTRL+PAGE DOWN
Moves to the next sheet in a workbook.
31
CTRL+PAGE UP
Moves to the previous sheet in a workbook.
32
SPACEBAR
In a dialog box, performs the action for the selected button, or selects or clears a check box.
33
CTRL+SPACEBAR
Selects an entire column in a worksheet.
34
SHIFT+SPACEBAR
Selects an entire row in a worksheet.
35
TAB
Moves one cell to the right in a worksheet.
36
SHIFT+TAB
Moves to the previous cell in a worksheet or the previous option in a dialog box.
37
ALT + W, then F
Freeze Panes
38
Financial | DB
Returns the straight line depreciation amount of an asset for a given period
39
Financial | FV
Returns the future value of an investment based on periodic, constant payments and a constant interest rate
40
Financial | PMT
Calculates the payment for a loan based on constant payments and a constant interest rate
41
Financial | PV
Returns the present value of an investment. The total amount that a series of future payments is worth now
42
Date & Time | TIME
Returns the number that represents a particular time
43
Date & Time | TODAY
Today’s date
44
Math & Trig | RAND
Returns a random number greater than or equal to 0 and less than 1, evenly distributed
45
Math & Trig | RANDBETWEEN
Returns a random number between the numbers you specify
46
Math & Trig | ROUND
Rounds a number to a specified number of digits (Not only how to do it, but what is does.  This impacts when you have to foot and cross foot something in excel.  Easy to be off a dollar.)
47
Math & Trig | ROUNDDOWN
Rounds a number down, toward zero
48
Math & Trig | ROUNDUP
Rounds a number up, away from zero
49
Math & Trig | SUM
Adds all the numbers in a range of cells (We use this a LOT to roll up trial balances and sub ledgers)
50
Math & Trig | SUMIF
Adds the cells specified by a given criteria (We use this a LOT to roll up trial balances and sub ledgers)
51
Math & Trig | SUMIFS
Adds the cells specified by a given set of criteria or conditions (We use this a LOT to roll up trial balances and sub ledgers)
52
Statistical | AVERAGE
Returns the average of its arguments, which can be numbers or names, arrays, or references that contain numbers.
53
Statistical | AVERAGEIF
Finds average for the cells specified by a given condition or criteria
54
Statistical | AVERAGEIFS
Finds average for the cells specified by a given set of conditions or criteria
55
Statistical | CORREL
Returns the correlation coefficient between two data sets
56
Statistical | COUNT
Counts the number of cells in a range that contain numbers
57
Statistical | COUNTIF
Counts the number of cells within a range that meet the given condition
58
Statistical | COUNTIFS
Counts the number of cells specified by a given set of conditiosn or criteria
59
Statistical | LARGE
Returns the k-th largest value in a data set
60
Statistical | MAX
Returns the maximum value in a list of arguments
61
Statistical | MEDIAN
returns the median, or the number in the middle of the set of given numbers
62
Statistical | MIN
Returns the smallest value in a list of arguments
63
Statistical | RANK
Ranks the rank of a value within a list of values
64
Statistical | SMALL
Returns the k-th smallest value in a data set
65
Lookup & Reference | COLUMN
Returns the column number of a reference
66
Lookup & Reference | GETPIVOTDATA
Returns data stored within a PivotTable
67
Lookup & Reference | HLOOKUP
Looks for a value in the top row of a table or array of values and returns the value in the same column for a row you specify
68
Lookup & Reference | INDIRECT
Returns the reference specified by a text value
69
Lookup & Reference | ROW
Returns the row number of a reference
70
Lookup & Reference | TRANSPOSE
Converts a vertical range of cells to a horizontal range, or vise versa
71
Lookup & Reference | VLOOKUP
Looks for the value in the leftmost column of a table, and then returns a value in the same row from a column you specify.
72
Text | CONCATENATE
Joins several text strings into one text string
73
Text | LEFT
Returns the specified number of charters from the start of a text string
74
Text | LEN
Returns the number of characters in a text string
75
Text | MID
Returns a specific number of characters from a text string starting at the position you specify
76
Text | TRIM
Removes all spaces from text string, except for single spaces between words
77
Logical | AND
Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE
78
Logical | IF
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
79
Logical | IFERROR
Returns value_if_error if expression is an error and the value of the expression itself otherwise
80
Logical | IFNA
Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.
81
Logical | OR
Checks whether any of the arguments are TRUE, and then returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE
82
Information | ISBLANK
Checks whether a reference is to an empty cell, and returns TRUE or FALSE
83
Information | ISERROR
Checks whether a value is an error, and returns TRUE or FALSE
84
Information | ISEVEN
Returns TRUE if the number is even
85
Information | ISODD
Returns TRUE if the number is odd

Acc 401 - AIS (6 decks)

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