Brainscape's Knowledge GenomeTM

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


See full index

ISTM > Excel 1-7 > Flashcards

Excel 1-7 Flashcards

1
Q

referencing a cell

A

Using the values stored in another cell of a worksheet

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

referencing a range

A

You can also refer to more than one cell at a time as long as the cells are in a continuous block

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

range

A

a group of cells in a continuous block

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

AutoFill

A

have Excel insert values into a range of cells by completing a pattern in previous cells

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

Quick sorting

A

an easy way to rearrange a data table, but it is limited to sorting just one column at a time

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

relative cell references

A

cell references that automatically update when a formula is pasted to a new cell

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

absolute cell reference

A

cell reference that remains constant when a formula is pasted into a new cell

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

To make a cell reference absolute

A

put a “$” character in front of the part of the reference that we wish to remain constant when a formula is pasted into a new cell

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

$A1

A

The column reference is absolute and will remain constant when copied and pasted to other cells. The row reference is relative and will change when copied and pasted to cells in other rows of the worksheet.

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

A$1

A

The column reference is relative and will change when copied and pasted to cells in other columns in the worksheet. The row reference is absolute and will remain constant when copied and pasted to other cells.

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

$A$1

A

Both the column and row references are absolute and will remain constant when the reference is copied and pasted to other cells.

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

function wizard

A

allows you to enter or select the inputs for the function, provides a description of the function and each argument, and lists the function result based on the inputs you enter

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

SUM function

A

the set of numbers you want to add together

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

COUNT

A

(value1, [value2], …) – counts the number of cells in a range of cells that contain numbers

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

COUNTA

A

(value1, [value2], …) – counts the number of cells in a range of cells that are not blank

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

AVERAGE

A

number1, [number2], …) – calculates the simple average of a set of numbers

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

MAX

A

(number1, [number2], …) – returns the largest value in a set of numbers

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

MIN

A

(number1, [number2], …) – returns the smallest value in a set of numbers

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

RATE

A

(nper, pmt, pv, [fv], [type], [guess]) – calculates the interest rate earned for an investment given the number of payments made as part of the investment, the payment amount, and the current value of the investment.

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

EFFECT

A

(nominal_rate, npery) – calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged.

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

NPER

A

(rate, pmt, pv, [fv], [type]) – calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount.

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

PMT

A

(rate, nper, pv, [fv], [type]) – calculates the payment amount for a loan given the interest rate, number of payments to be made to pay off the loan, and the original loan amount

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

PV

A

(rate, nper, pmt, [fv], [type]) – calculates the current value (accounting for compounding interest) of an investment given the interest rate, number of payments to be made, and the amount of the payment.

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

FV

A

(rate, nper, pmt, [pv], [type]) – calculates the future value of an investment given the interest rate, number of payments to be made, and the amount of the payment.

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

NPER

A

used to calculate the number of payments I will make on a loan before it is paid off.

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

PMT

A

used to calculate the payment amount for a loan

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

PV

A

used to calculate the current value of a loan or investment

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

FV

A

used to calculate the future value for a loan or investment after all of the payments are made or earned

29
Q

RATE and EFFECT

A

help you understand how much interest you will be paying on a loan

30
Q

Boolean logic

A

based on only two values 0 and 1. In Excel, the values 0 and 1 are represented by the values FALSE and TRUE, respectively

31
Q

AND

A

AND (logical1,[logical2],…)

(1+1 = 2) TRUE. Combining these expressions with the operator AND (1+2 = 3) will result in TRUE because both of the combined expressions are TRUE.

(1+1 = 2) TRUE. Combining these expressions with the operator AND (1+2 = 4) will result in FALSE because the second expression is FALSE (even though the first expression is TRUE).

32
Q

OR

A

OR (logical1,[logical2],…)

(1+1 = 2) TRUE. Combining these expressions with the operator OR (1+2 = 3) will result in TRUE
because both expressions are TRUE.

(1+1 = 2) TRUE. Combining these expressions with the operator OR (1+2 = 4) will result in TRUE
because the first expression is TRUE (even though the second expression is FALSE).

(1+1 = 1) FALSE. Combining these expressions with the operator OR (1+2 = 4) will result in FALSE
because both expressions are FALSE.

33
Q

NOT

A

NOT(logical)
used to evaluate negation, or the opposite of a Boolean expression

34
Q

IF

A

IF(logical_test,[value_if_true],[value_if_false])

35
Q

COUNTIF

A

=COUNTIF(range,criteria)

allows you to determine the number of cells within a range of cells that contain a specific value

first argument of the COUNTIF function is the range of cells within which you want Excel to count the number of matches. The second argument defines the specific value that you would like Excel to match to the cells in the range

36
Q

SUMIF

A

=SUMIF(range,criteria,[sum_range])

used to calculate the total for a set of values that match a specific criterion

first argument is the range of cells within which you want Excel to search for a match to the criterion you set. The second argument defines the criterion used to find matches

37
Q

AVERAGEIF

A

=AVERAGEIF(range,criteria,[average_range])

used to calculate the average for a set of values that match a specific criterion

38
Q

VLOOKUP

A

=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

39
Q

HLOOKUP

A

=HLOOKUP(lookup_value,table_array,row_index_number,[range_lookup])

VLOOKUP assumes that the first column of the reference table contains the values used to find a match for the “lookup_value”

40
Q

TODAY

A

returns the current date

41
Q

NOW

A

returns the current date and time formatted as a date and time.

42
Q

DAY (serial_number)

A

returns the day portion of a date (a number between 1 and 31)

43
Q

MONTH (serial_number)

A

returns the month portion of a date (a number between 1 and 12)

44
Q

YEAR (serial_number)

A

returns the year portion of a date (a number between 1900 and 9999)

45
Q

WEEKDAY (serial_number, [return_type])

A

returns the day of the week for a date

46
Q

WEEKNUM (serial_number, [return_type])

A

returns the week of the year for a date

47
Q

HOUR (serial_number)

A

returns the hour portion of a time as a number from 0 to 23

48
Q

MINUTE (serial_number)

A

returns the minute portion of a time as a number from 0 to 59

49
Q

SECOND (serial_number)

A

returns the second portion of a time as a number from 0 to 59

50
Q

LEN (text)

A

returns the length, in number of characters, of a block of text

51
Q

SEARCH (find_text, within_text, [start_num])

A

returns the position of a specific character, word, or phrase within a block of text

52
Q

LEFT (text,[num_chars])

A

returns a specified number of characters starting from the beginning of a block of text

53
Q

MID(text, start_num, num_chars)

A

returns a specified number of characters from the middle of a block of text

54
Q

UPPER (text)

A

converts a block of text to all uppercase characters

55
Q

LOWER (text)

A

converts a block of text to all lowercase characters

56
Q

PROPER (text)

A

converts a block of text to title case (the first letter of each new word is capitalized)

57
Q

CONCAT (text1,[text2],…)

A

combines blocks of text

58
Q

SUBSTITUTE (text, old_text, new_text,[instance_num])

A

replaces specified characters, words, or phrases within a block of text with new characters, words, or phrases

59
Q

Chart Title and Axis Titles

A

allow you to change where and how each of the titles in your chart will appear

60
Q

Axes group

A

used to format the appearance of each of the axes in your chart

61
Q

Column charts

A

used to compare different categories of items or the same category over time.

62
Q

data series

A

set of data that you want to include on your chart.

63
Q

Stacked Column Chart

A

used to compare categories of items or the same category over time

breaks the column bars into segments that represent subcategories that are consistent across the columns

64
Q

Pie charts

A

used to compare the parts of a category to the whole

Typically, each of the parts is expressed as a percentage of the whole

65
Q

line chart

A

compare the values of a particular category over time

66
Q

spreadsheet model

A

generally used to represent the logic of a more complicated logical process

three common elements: changeable inputs, outputs, and intermediate calculations

67
Q

changeable inputs

A

can be found in the customer information section

68
Q

Model outputs

A

represent the outcome of the process that is modeled in the spreadsheet

ISTM (20 decks)

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