Brainscape's Knowledge GenomeTM

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


See full index

Spreadsheets Lessons 4-6 > Lessons 4-6 > Flashcards

Lessons 4-6 Flashcards

1
Q

What chart compares different categories of items or the same category over time, depicting the types of items (or diff years) across the horizontal axis and the values for each category as a pillar rising into the vertical axis?

A

Column chart

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

What is a column chart that breaks the column bars into segments that represent subcategories that are consistent across the columns?

A

Stacked column chart

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

What chart is used to compare the parts of category to the whole and each part is typically express as a percentage of the whole?

A

Pie chart

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

What chart compares the values of a particular category over time, and by connecting the dots, are helpful in uncovering trends in a dataset?

A

line chart

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

What date function returns the current date?

A

TODAY function

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

What date function returns the current date and time?

A

NOW function

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

What date function returns the day portion of a date?

A

DAY function

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

What date function returns the month portion of a date?

A

MONTH function

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

What date function returns the year portion of a date?

A

YEAR function

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

What date function returns the day of the week of a date?

A

WEEKDAY function

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

What date function returns the week of the year for a date?

A

WEEKNUM function

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

What time function returns the hour portion of a time?

A

HOUR function

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

What time function returns the minute portion of a time?

A

MINUTE function

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

What time function returns the second portion of a time?

A

SECOND function

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

What text function returns the length, in number of characters, of a block of text?

A

LEN function

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

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

A

SEARCH function

17
Q

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

A

LEFT function

18
Q

What text function returns a specified number of characters starting from a point you choose of a block of text?

A

MID function

19
Q

What text function returns a specified number of characters starting from the end of a block of text?

A

RIGHT function

20
Q

What text function makes all of the selected text upper case?

A

UPPER function

21
Q

What text function makes all of the selected text lower case?

A

LOWER function

22
Q

What text function converts a block of text to title-case?

A

PROPER function

23
Q

What text function combines blocks of text?

A

CONCATENATE/CONCAT function

24
Q

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

A

SUBSTITUTE function

25
Q

what is based on Boolean algebra and functions with only two values: 0 and 1?

A

Boolean logic

26
Q

What boolean function combines boolean expressions to determine if all of the combined expressions are TRUE, and if one of the expressions is false the function is FALSE?

A

AND function

27
Q

What boolean function combines boolean expressions to determine if all of the combined expressions are FALSE, and if one of the expressions is true the function is TRUE?

A

OR function

28
Q

What boolean function is used to evaluate negation, or the opposite of a boolean expression?

A

NOT function

29
Q

What function lets you display text other than TRUE/FALSE for boolean functions?

A

IF function

30
Q

What are calculations where the cell references used to compete the calculations depend on the values of other cells in a worksheet called?

A

Conditional functions

31
Q

What conditional function counts the number of times the entered criteria shows up?

A

COUNTIF function

32
Q

What conditional function is used to calculate the total for a set of values that match a specific criterion?

A

SUMIF function

33
Q

What conditional function calculates the average for a set of values that match a specific criterion?

A

AVERAGEIF function

34
Q

What are the functions that allow you to look up frequently used values on a reference table in Excel called?

A

Reference functions

35
Q

What reference function deals with vertical reference tables?

A

VLOOKUP function

36
Q

What reference function deals with horizontal reference tables?

A

HLOOKUP function

Spreadsheets Lessons 4-6 (1 decks)

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