Brainscape's Knowledge GenomeTM

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


See full index

BCPT 123 (final exam prep) > EXCEL > Flashcards

EXCEL Flashcards

1
Q

alignement

A

the position the data between the cell margins

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

auto fill

A

enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells

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

cell

A

the intersection of a column or row

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

column width

A

the horizontal measurement of a column

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

fill color

A

the background color appearing behind data in a cell

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

fill handle

A

small green square in the lower-right corner of a selected cell or range of cells

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

formula

A

displays the content ( text, value, date, or formula) in the active cell

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

formula bar

A

displays the content ( text, value, date, or formula) in the active cell

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

input area

A

the background color appearing behind data in a cell

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

name box

A

identifies the address of the current cell

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

order of operations

A

rules that control the sequence in which Excel performs arithmetic operations

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

output area

A

a range of cells containing results based on manipulating the variables

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

range

A

a rectangular group of cells

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

row height

A

the vertical measurement of a row

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

sheet tab

A

displays the name of a worksheet within a workbook

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

text

A

includes letters, numbers symbols, and spaces

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

value

A

a number that represents a quantity or an amount

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

workbook

A

a file containing related worksheets

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

worksheet

A

a spreadsheet that contains formulas, functions, values, text, and visual aids

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

wrap text

A

formatting that enables a label to appear on multiple lines within the current cell

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

absolute cell reference

A

Indicates a cell’s specific location; the cell reference does not change when you copy the formula.

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

argument

A

an input, such as a cell reference or value, needed to complete a function

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

AVERAGE function

A

calculates the arithmetic mean, or average, of value in a range

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

COUNT function

A

tallies the number of cells in a range that contain values

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

IF function

A

evaluates a condition and returns one value if the condition is true and a different value if the condition is false

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

logical test

A

an expression that evaluates to true or false

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

lookup table

A

A range that contains data for the basis of the lookup and data to be retrieved

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

MAX function

A

identifies the highest value in range

29
Q

MEDIAN function

A

identifies the midpoint value in a set of values

30
Q

MIN function

A

displays the lowest value in a range

31
Q

mixed cell reference

A

Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula

32
Q

NOW function

A

displays the current date and time

33
Q

PMT function

A

calculates the periodic payment for a loan with a fixed interest rate and fixed term

34
Q

relative cell reference

A

indicates a cell’s location from the cell containing the formula; the cell reference changes when the formula is copied

35
Q

SUM function

A

calculates the total of values contained in two or more cells

36
Q

syntax

A

the set of rules for combining words into grammatically sensible sentences

37
Q

TODAY function

A

displays the current date

38
Q

VLOOKUP function

A

looks up a value in a vertical lookup table and returns a related result from the lookup table

39
Q

axis title

A

a label that describes either the category axis or the value axis

40
Q

bar chart

A

chart type that compares categories of data horizontally

41
Q

category axis

A

the area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis

42
Q

chart area

A

contains the entire chart and all of its elements

43
Q

chart title

A

a label that describes a chart

44
Q

cluster column chart

A

chart type that shows the relationship between two variables

45
Q

combo chart

A

Chart that contains two chart types, such as column and line, to depict two types of data, such as individual data points and percentages

46
Q

data labels

A

labels that identify each value in the data series

47
Q

data point

A

a value that originates in a worksheet cell and that is represented in a chart by a data marker

48
Q

data series

A

a group of related information in a column or row of a worksheet that is plotted on a chart

49
Q

gridline

A

the lines in a table that form the rows and columns

50
Q

legend

A

the key to a chart that explains what each data series represents

51
Q

line chart

A

a chart that uses points connected by a line to illustrate values in a worksheet

52
Q

pie chart

A

chart that shows each data point in proportion to the whole data series

53
Q

plot area

A

the area in the chart container that shows the data series compared to the chart’s gridlines

54
Q

sizing handle

A

A circle that enables you to adjust the height or width of a selected chart

55
Q

sparklines

A

miniature graphs that summarize data; typically used to graphically describe trends in data

56
Q

task pane

A

a window along the left side of the program window that contains options and commands

57
Q

value axis

A

horizontal or vertical grouping of values from the worksheet

58
Q

X Y (scatter) chart

A

shows the relationship between two variables

59
Q

which step is NOT part of planning a worksheet design?

a) decide what input values are needed
b) state the purpose of the worksheet
c) decide what outputs are needed to achieve the purpose
d) enter labels, values and formulas

A

c)

60
Q

given the formula =B1*B2+B3/B4^2, what operation is calculated first?

a) B1*B2
b) B2+B3
c) B3/B4
d) B4^2

A

d)

61
Q

how can you display formulas within the cells instead of the cell results?

a) press Crtl+G
b) press Crtl+ ‘
c) click cell reference on the home tab
d) press Crtl+C

A

d)

62
Q

which of the following is NOT an alignment option?

a) increase indent
b) merge and center
c) fill color
d) wrap text

A

c)

63
Q

what is a fast way to apply several formats at one time?

a) click each one individually
b) apply a cell style
c) use auto fill
d) use copy and paste option

A

b)

64
Q

if cell E1 5 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in the formula?

a) relative reference
b) absolute reference
c) mixed reference
d) syntax

A

b)

65
Q

what function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

a) =SUM(B5:F5)/5
b) =AVERAGE(B5:F5)
c) =MEDIAN(B5:F5)
d) =COUNT(B5:F5)

A

b)

66
Q

When you start to type =AV, what feature displays a list of functions and defined names?

a) function screentip
b) formula autocomplete
c) insert function dialog box
d) function argument dialog box

A

b)

67
Q

which of the following functions should be used to insert the current date and time in a cell?

a) TODAY()
b) CURRENT()
c) NOW()
d) DATE

A

c)

68
Q

which of the following is not an argument of the IF function?

a) value_if_true
b) value_if_false
c) logical_test
d) lookup_value

A

d)

69
Q

which of the following is NOT true about the VLOOKUP function?

a) the lookup table must be in ascending order
b) the lookup table must be in descending order
c) the default match type is approximate
d) the match type must be false when completing an exact match

A

b)

BCPT 123 (final exam prep) (3 decks)

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