Brainscape's Knowledge GenomeTM

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


See full index

CSE 2111 > Exam 1 Review > Flashcards

Exam 1 Review Flashcards

1
Q

Function
Use: the names listed on tabs of the worksheet

A

Worksheet Names

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

They do not need to be listed in the formula referencing cells within the same worksheet. They are needed when referencing cells in different worksheets

A

Worksheet Names

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

What must the worksheet be encased in when they include one or more spaces

A

’ ‘ and include ! after
=’Worksheet Name’!Cells

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

Function
Use: Formulas should be set up in such a way as to make creating formulas easy so they can be copied instead of having to be rewritten over and over

A

Cell Referencing

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

Cell with the information

A

Cell Referencing

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

A2

A

Single cell reference

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

A2:A9

A

Range along a column

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

A2:H2

A

Range along a row

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

A:A

A

Range along the entire column

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

A2:C8

A

Block Range

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

$ locks the referenced item preventing it from changing

A

Mixed Cell Reference

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

$A2

A

Locks the Column
Mixed Cell Reference

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

A$2

A

Locks the row
Mixed Cell Reference

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

Exact Cell

A

Absolute Cell Reference

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

$A$2

A

Locks the column and row
Absolute Cell Reference

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

Function
Use: Use a name for cell reference. Treated as an absolute cell reference

A

Named Ranges

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

Best to use when complex and/or long cell references. Also, helps with remembering the purpose of the formula

A

Named Ranges

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

Sales Tax instead of “A2*1.075”

A

Named Ranges

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

Function
Use: Pre- determine if you want __ ___ to be included in your calculation

A

Blank Cells

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

Included: Fill with 0 (zero)
Excluded: Leave Blank

A

Blank Cells

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

Syntax
Use: when using text items in cell references

A

Text

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

For Text what words do we not need to put quotes are

A

AND, OR, NOT, TRUE, FALSE

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

Syntax
Use: Cell references larger than

A

Greater Than

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

What 3 functions can be used for Greater Than

A

Sumif(s), Countif(s), and Averageif(s)

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

How to write something is greater than A2 in a function

A

”>”&A2

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

How to write something is greater than and equal to A2 in a function

A

”>=”&A2

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

Hard Coded
Greater than 2
In a function

A

“>2”

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

Greater than A2
In a formula

A

> A2

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

Greater than or equal to
In a formula

A

> =A2

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

Syntax
Use: Cell References small than

A

Less Than

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

What 3 functions can be used for Less Than

A

Sumif(s), Countif(s), and Averageif(s)

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

How to write something is less than A2 in a function

A

”<”&A2

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

How to write something is less than and equal to A2 in a function

A

”<=”&A2

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

Hard Coded
Less than 2
In a function

A

“<2”

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

Hard Coded
Less than or equal to
In a formula

A

”<=2”

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

Less than A2
In a formula

A

<A2

37
Q

Less than or equal to
In a formula

A

<=A2

38
Q

Syntax
Use: Has to be broken into an AND formula with each range defined separately. You cannot write: =50>=E2<=80

A

Between

39
Q

How to write =50>=E2<=80 in a function

A

=AND(E2>=50,E2<=80)

40
Q

Syntax
Use: To denote a character that will match any character or sequence of characters in a search

A

Wild Card

41
Q

Rules of Wildcard, you need an ______ within “”

A

Asterisk, *

42
Q

Formula
Use: adds the numbers in a range of cells

A

Sum

43
Q

How to add the range of A2:A9

A

=SUM(A2:A9)

44
Q

How to add the cells A2,A5,A7

A

=SUM(A2,A5,A7)

45
Q

Formula
Use: Calculates the arithmetic mean of a list of values

A

Average

46
Q

How to find the average of (A2:A5)

A

=AVERAGE(A2:A5)

47
Q

Formula
Use: Returns the smallest number of a range of values

A

Min

48
Q

Formula
Use: Returns the largest number of a range values

A

Max

49
Q

What function to use when you need the smallest number in a range?

A

Min

50
Q

What function to use when you need the largest number in a range

A

Max

51
Q

Formula
Use: Determines the number of cells in a range that contain numbers

A

Count

52
Q

What function to use when you need to count the numbers in a range

A

Count

53
Q

Does the Count formula ignore blank/empty cells

A

Yes

54
Q

Formula
Use: Determines the number of cells in a range that are not empty

A

CountA

55
Q

What function to use when you need to count all the characters in a range

A

CountA

56
Q

Does the CountA formula ignore blank/empty cell

A

Yes

57
Q

Formula
Use: Rounds a number to specified number of digits. When nesting use before other formulas

A

Round

58
Q

For Round Function, what does -2 =

A

Nearest Hundreds

59
Q

For Round Function, what does -1 =

A

Nearest Tens

60
Q

For Round Function, what does 0 =

A

Nearest Whole Number

61
Q

For Round Function, what does 1=

A

Nearest Tenth

62
Q

For Round Function, what does 2 =

A

Nearest Hundreths

63
Q

Conditional Statistical Functions
Use:Counts the number of items in a range that meets a specific criteria

A

COUNTIF

64
Q

Conditional Statistical Functions
Use: Counts the number of items in a range that meet a specific criteria for multiple criteria and ranges

A

COUNTIFS

65
Q

Conditional Statistical Functions
Use: Sums the number of items in a range that meet a specific criteria

A

SUMIF

66
Q

Conditional Statistical Functions
Use: Sums the number of items in a range that meet a specific criteria for multiple criteria and ranges

A

SUMIFS

67
Q

Conditional Statistical Functions
Use: Averages the number of items in a range that meet a specific criteria

A

AVERAGEIF

68
Q

Conditional Statistical Functions
Use: Averages the number of items in a range that meet a specific criteria for multiple criteria and range

A

AVERAGEIFS

69
Q

Conditional Statistical Functions
Use: Returns a specific value from the largest number in the array

A

Large

70
Q

Conditional Statistical Functions
Use: Returns a specific value from the smallest number in the array

A

Small

71
Q

Conditional Statistical Functions
Use: Returns the rank of a number in a list of numbers

A

Rank.Eq

72
Q

If you want to rank a list of numbers in a descending order, what needs to be included

A

0 or omitted number

73
Q

If you want to rank a list of numbers in a ascending order, what needs to be included

A

1

74
Q

Conditional Statistical Functions
Use: Multiplies corresponding components in the given arrays, and returns the sum of those products

A

SumProduct

75
Q

In the SumProduct function, are non numeric cells ignored or treated as 0

A

treated as 0

76
Q

What answers do Boolean Functions return

A

True/False

77
Q

Boolean Functions
Use: Returns true if all arguments are true

A

And

78
Q

Boolean Functions
Use: Returns true if one of the arguements is true

A

Or

79
Q

Boolean Functions
Use: Returns false when one arguement is false

A

And

80
Q

Boolean Functions
Use: Returns false when all arguments are false

A

OR

81
Q

Boolean Functions
Use: Changes false to true and true to false

A

NOT

82
Q

Boolean Functions
Use: Returns true when the arguments have been met
Ex: =Not(Or(F5:F7))

A

NONE

83
Q

Boolean Functions
Use: Returns true when the arguments have been met
Ex: =And(E5>=B2, Not(F8))

A

ONLY

84
Q

IF Functions
Use: Checks to see if a condition is true or false. If true one thing happens, if false another thing happens

A

IF

85
Q

Validates if a value is True or False

A

IF(True/False)

86
Q

What to do when you need the cell to say true or false in an IF function ?

A

=IF(A1,”Cell contains the word True”,”Cell contains the word False”)

87
Q

IF Functions
Use:Series of if formulas - If this is true, do this. else if this is true, do this, else do this. Can be nested up to 64 times

A

Nested IF

88
Q

IF Functions
Use: Solve in order based upon the highest to lowest or lowest to highest

A

Embedded IF

CSE 2111 (1 decks)

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