Lessons 4-6

Question 1

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?

Answer 1

Column chart

Question 2

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

Answer 2

Stacked column chart

Question 3

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?

Answer 3

Pie chart

Question 4

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

Answer 4

line chart

Question 5

What date function returns the current date?

Answer 5

TODAY function

Question 6

What date function returns the current date and time?

Answer 6

NOW function

Question 7

What date function returns the day portion of a date?

Answer 7

DAY function

Question 8

What date function returns the month portion of a date?

Answer 8

MONTH function

Question 9

What date function returns the year portion of a date?

Answer 9

YEAR function

Question 10

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

Answer 10

WEEKDAY function

Question 11

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

Answer 11

WEEKNUM function

Question 12

What time function returns the hour portion of a time?

Answer 12

HOUR function

Question 13

What time function returns the minute portion of a time?

Answer 13

MINUTE function

Question 14

What time function returns the second portion of a time?

Answer 14

SECOND function

Question 15

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

Answer 15

LEN function

Question 16

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

Answer 16

SEARCH function

Question 17

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

Answer 17

LEFT function

Question 18

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

Answer 18

MID function

Question 19

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

Answer 19

RIGHT function

Question 20

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

Answer 20

UPPER function

Question 21

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

Answer 21

LOWER function

Question 22

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

Answer 22

PROPER function

Question 23

What text function combines blocks of text?

Answer 23

CONCATENATE/CONCAT function

Question 24

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

Answer 24

SUBSTITUTE function

Question 25

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

Answer 25

Boolean logic

Question 26

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?

Answer 26

AND function

Question 27

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?

Answer 27

OR function

Question 28

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

Answer 28

NOT function

Question 29

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

Answer 29

IF function

Question 30

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

Answer 30

Conditional functions

Question 31

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

Answer 31

COUNTIF function

Question 32

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

Answer 32

SUMIF function

Question 33

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

Answer 33

AVERAGEIF function

Question 34

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

Answer 34

Reference functions

Question 35

What reference function deals with vertical reference tables?

Answer 35

VLOOKUP function

Question 36

What reference function deals with horizontal reference tables?

Answer 36

HLOOKUP function