Brainscape's Knowledge GenomeTM

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


See full index

DEN 027 (P1) > Microsoft Excel > Flashcards

Microsoft Excel Flashcards

1
Q

Are predefined formulas in Excel and are ready for use.

A

Function

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

The names are based on the column letter and row number the cell belongs to.

A

Cell name

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

Is an expression that operates on values in a range of cells or a cell. It always starts with an equal (=) sign.

A

Formula

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

The value of a different cell or cell range on the current worksheet

A

Cell reference

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

Can be used as a variable in a formula

A

Cell formula

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

What are the three types of cell reference?

A
  • relative reference
  • absolute reference
  • mixed reference
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

They change based on the relative position of rows and columns. By default, all references are like this.

A

Relative Reference

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

Do not change when copied or filled. You can use this reference to keep a row and/or column constant.

It is also a designated in a formula by the addition of a dollar sign before the column and row.

A

Absolute Reference

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

An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both) then it is_______

A

Mixed reference

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

It refers to the file created in Excel in which you work and store your data

A

Workbook

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

It is an expression that operates on values in a range of cells or a cell

A

Formula

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

It is a collection of cells organized in rows and columns.

A

Spreadsheet

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

A function that returns the sum of two numbers

A

SUM

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

In order to determine that AVERAGE of cells E2, F2, and G2, the formula should be________.

A

=AVERAGE(E2:G2)

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

Refers to the range of cells in columns A through E and rows 10 through 20

A

A10:E20

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

C1 displays the product of A1 and B1. The correct formula that C1 should contain is__________.

A

=PRODUCT(A1,B1)

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

Is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a workshee

A

Cell

18
Q

It returns the number of characters in the middle of the text string starting at the position you specify.

A

Mid()

19
Q

It returns the number of character from the end of the text string.

A

Right()

20
Q

If the entry in A1 is greater than 12,000; B1 gives the result in dividing the number entered in A1 by 4000; and returns 500 otherwise. The formula is ________.

A

=IF(A1>12000,A1/4000,500)

21
Q

It is a function that joins several text strings into one text string.

A

Concatenate()

22
Q

The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is _______.

A

= (D4 + C2) * B2

23
Q

The formula in getting the smallest value from cell A1 through D5.

A

=MIN(A1:D5)

24
Q

What is the formula to add up the total?

A

SUM(cell range)

25
Q

To add up individual items, what is the formula?

A

=Value1 + Value2

26
Q

Subtract Formula?

A

=Value 1 - Value 2

27
Q

Multiply Formula?

A

=Value1 * Value2

28
Q

Division Formula?

A

=Value1 / Value2

29
Q

Exponent Formula?

A

=Value1 ^ Value2

30
Q

Median Formula?

A

=MEDIAN(cell range)

31
Q

Max formula?

A

=MAX(cell range)

32
Q

Min formula?

A

=MIN(cell range)

33
Q

To change a cell to proper case, what is the formula?

A

=PROPER(cell)

34
Q

To change the cell to upper case, what is the formula?

A

=UPPER(cell)

35
Q

To change a cell to lower case, what is the formula?

A

=LOWER(cell)

36
Q

To join a text string into one, what is the formula?

A

=concatenate(Value1, Value2)

37
Q

What is the formula of the left text string?

A

=left(B1,5)

B1 - cell
5 - number of lettters

38
Q

What is the formula of the right string?

A

Ex.
=right(B1,7)

B1 - cell
7 - number of letter starting from the right

39
Q

What is the formula of the mid string?

A

Ex. SOUTHWESTERN

=mid(B1,6,4) - WEST

40
Q

What is the formula of positive, negative?

A

Ex. IF(A1>0,”POSITIVE”,”NEGATIVE”)

41
Q

What is the formula of True or False?

A

Ex. =IF(condition,valueIfTrue,valueIfFalse)

DEN 027 (P1) (5 decks)

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