Excel Quiz

What is A cell range?

• A group of selected cells

• It Returns the Value

• It multiples

• None of these

What does the SQRT Functions do?

• It Returns the sum of the value

• It Returns the

  Square root of the given number

• It multiples

• It divides

What does the AVERAGE function do?

• It calculates the median of a set of numbers

• It returns the average of a set of values

• It counts the number of entries

• It finds the maximum value

What is a formula in spreadsheet software?

• A set of instructions to perform calculations

• A type of cell formatting

• A way to sort data

• None of these

What does the COUNT function do?

• It counts the number of cells that are empty

• It counts the number of cells that contain numbers

• It sums up all the values in a range

• It finds the average of a set of numbers

Which function is this?

• Text function

• Mathematical function

• Logical function

• Date and time function

What does the MAX function do?

• It finds the minimum value in a set of numbers

• It returns the maximum value from a range of values

• It calculates the average of a set of numbers

• It counts the total number of entries

What is a pivot table used for?

• To create charts and graphs

• To summarize and analyze data

• To format cells

• To sort data alphabetically

What does the CONCATENATE function do?

• It joins two or more text strings into one string

• It splits a text string into multiple parts

• It converts text to uppercase

• It finds the length of a text string

What does the IF function do?

• It checks whether a condition is met and returns one value for TRUE and another for FALSE

• It calculates the sum of a range of cells

• It formats a cell based on its value

• It counts the number of cells that meet a certain condition