Brainscape's Knowledge GenomeTM

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


See full index

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
Q

ALT+ENTER

A

Starts a new line in the same cell.

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

CTRL+ENTER

A

Fills the selected cell range with the current entry.

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

HOME

A

Moves to the beginning of a row in a worksheet.

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

CTRL+HOME

A

Moves to the beginning of a worksheet.

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

CTRL+SHIFT+HOME

A

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

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

CTRL+PAGE DOWN

A

Moves to the next sheet in a workbook.

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

CTRL+PAGE UP

A

Moves to the previous sheet in a workbook.

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

SPACEBAR

A

In a dialog box, performs the action for the selected button, or selects or clears a check box.

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

CTRL+SPACEBAR

A

Selects an entire column in a worksheet.

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

SHIFT+SPACEBAR

A

Selects an entire row in a worksheet.

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

TAB

A

Moves one cell to the right in a worksheet.

36
Q

SHIFT+TAB

A

Moves to the previous cell in a worksheet or the previous option in a dialog box.

37
Q

ALT + W, then F

A

Freeze Panes

38
Q

Financial

DB

A

Returns the straight line depreciation amount of an asset for a given period

39
Q

Financial

FV

A

Returns the future value of an investment based on periodic, constant payments and a constant interest rate

40
Q

Financial

PMT

A

Calculates the payment for a loan based on constant payments and a constant interest rate

41
Q

Financial

PV

A

Returns the present value of an investment. The total amount that a series of future payments is worth now

42
Q

Date & Time

TIME

A

Returns the number that represents a particular time

43
Q

Date & Time

TODAY

A

Today’s date

44
Q

Math & Trig

RAND

A

Returns a random number greater than or equal to 0 and less than 1, evenly distributed

45
Q

Math & Trig

RANDBETWEEN

A

Returns a random number between the numbers you specify

46
Q

Math & Trig

ROUND

A

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
Q

Math & Trig

ROUNDDOWN

A

Rounds a number down, toward zero

48
Q

Math & Trig

ROUNDUP

A

Rounds a number up, away from zero

49
Q

Math & Trig

SUM

A

Adds all the numbers in a range of cells (We use this a LOT to roll up trial balances and sub ledgers)

50
Q

Math & Trig

SUMIF

A

Adds the cells specified by a given criteria (We use this a LOT to roll up trial balances and sub ledgers)

51
Q

Math & Trig

SUMIFS

A

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
Q

Statistical

AVERAGE

A

Returns the average of its arguments, which can be numbers or names, arrays, or references that contain numbers.

53
Q

Statistical

AVERAGEIF

A

Finds average for the cells specified by a given condition or criteria

54
Q

Statistical

AVERAGEIFS

A

Finds average for the cells specified by a given set of conditions or criteria

55
Q

Statistical

CORREL

A

Returns the correlation coefficient between two data sets

56
Q

Statistical

COUNT

A

Counts the number of cells in a range that contain numbers

57
Q

Statistical

COUNTIF

A

Counts the number of cells within a range that meet the given condition

58
Q

Statistical

COUNTIFS

A

Counts the number of cells specified by a given set of conditiosn or criteria

59
Q

Statistical

LARGE

A

Returns the k-th largest value in a data set

60
Q

Statistical

MAX

A

Returns the maximum value in a list of arguments

61
Q

Statistical

MEDIAN

A

returns the median, or the number in the middle of the set of given numbers

62
Q

Statistical

MIN

A

Returns the smallest value in a list of arguments

63
Q

Statistical

RANK

A

Ranks the rank of a value within a list of values

64
Q

Statistical

SMALL

A

Returns the k-th smallest value in a data set

65
Q

Lookup & Reference

COLUMN

A

Returns the column number of a reference

66
Q

Lookup & Reference

GETPIVOTDATA

A

Returns data stored within a PivotTable

67
Q

Lookup & Reference

HLOOKUP

A

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
Q

Lookup & Reference

INDIRECT

A

Returns the reference specified by a text value

69
Q

Lookup & Reference

ROW

A

Returns the row number of a reference

70
Q

Lookup & Reference

TRANSPOSE

A

Converts a vertical range of cells to a horizontal range, or vise versa

71
Q

Lookup & Reference

VLOOKUP

A

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
Q

Text

CONCATENATE

A

Joins several text strings into one text string

73
Q

Text

LEFT

A

Returns the specified number of charters from the start of a text string

74
Q

Text

LEN

A

Returns the number of characters in a text string

75
Q

Text

MID

A

Returns a specific number of characters from a text string starting at the position you specify

76
Q

Text

TRIM

A

Removes all spaces from text string, except for single spaces between words

77
Q

Logical

AND

A

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE

78
Q

Logical

IF

A

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

79
Q

Logical

IFERROR

A

Returns value_if_error if expression is an error and the value of the expression itself otherwise

80
Q

Logical

IFNA

A

Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.

81
Q

Logical

OR

A

Checks whether any of the arguments are TRUE, and then returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE

82
Q

Information

ISBLANK

A

Checks whether a reference is to an empty cell, and returns TRUE or FALSE

83
Q

Information

ISERROR

A

Checks whether a value is an error, and returns TRUE or FALSE

84
Q

Information

ISEVEN

A

Returns TRUE if the number is even

85
Q

Information

ISODD

A

Returns TRUE if the number is odd

Acc 401 - AIS (6 decks)

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