Excel Functions and Data Analysis Quiz

What is a cell reference in Excel?

• A tool for sorting data

• A combination of a column letter and a row number

• A chart displaying numeric data

• A formula to calculate averages

Which symbol is used to create an absolute reference in Excel?

• *

• ^

• $

• #

What formula adds up the values in cells A1 and A2?

• =SUM(A1:A2)

• =ADD(A1:A2)

• =A1+A2

• =A1&A2

What does the function =AVERAGE(A1:A10) do?

• Sums up the numbers in A1 through A10

• Finds the largest value in the range A1:A10

• Returns the average of numbers in A1 through A10

• Counts the number of cells in A1 through A10

How does the COUNT function work in Excel?

• Counts all blank cells in a range

• Counts only numbers in a list of arguments

• Adds all numeric values in a range

• Returns the average of numeric values in a range

What does =SUMIF(A1:A10,">5") do?

• Sums all values in A1:A10

• Sums all values in A1:A10 greater than 5

• Counts all values in A1:A10 greater than 5

• Finds the maximum value in A1:A10 greater than 5

What is the role of parentheses in Excel formulas?

• Change cell references

• Denote priority in calculations

• Specify cell colors

• Indicate text values

What does the formula =LEFT("Excel",2) return?

• "Excel"

• "Ex"

• "cel"

• "El"

Which function returns the smallest number in a set?

• MAX

• COUNT

• MIN

• SUM

What does =PROPER("excel functions") return?

• EXCEL FUNCTIONS

• Excel Functions

• excel functions

• eXcel fUNCTIONS