Excel Functions and Charts Quiz

Which function involves loans?

• AND

• PMT

• UPPER

• concat

Which of these functions returns the largest value?

• min

• max

• countif

• sumif

Which chart type is used to show the relationship between two variables in Excel?

• Stacked bar Chart

• Scatter chart

• Pie chart

• Line chart

What does the COUNTIF function in Excel do?

• Counts cells

• Adds cells depends on a condition

• Counts the numbers of cells based on a condition that has already been set before

• Counts the number of cells that meet a specific condition

Which function is used to combine the text from two or more cells into one cell in Excel?

• TEXTCONCAT

• CONCAT

• COMBINE

• AND

What does the AVERAGE function in Excel do?

• Returns the sum of the cells divided by the numbers of cells

• Returns the count of numbers in a range

• Returns the smallest number in a set of values

• Returns the average number of cells that are found

Which function is used to check a value in a range and then return a corresponding value from another column in Excel?

• HLOOKUP

• LOOKUP

• VLOOKUP

• XLOOKUP

What does the UPPER function in Excel do?

• Converts text

• Converts text to another size

• Converts text to another font

• Converts text to another case

Which chart type is used to show the trend of a data set over time in Excel?

• Line chart

• Pie chart

• Scatter chart

• Bar chart

What does the SUMIF function in Excel do?

• Returns the sum of a range of cells

• Counts the number of cells that meet a specific condition

• Returns the maximum value in a range of cells

• Converts text to uppercase