Question 1

What allows you to summarize large amounts of data in Microsoft Excel?

Accepted Answer

Pivot table

Answer

IF function

Answer

SUM formula

Answer

VLOOKUP

Question 2

What function in Microsoft Excel allows you to create graphical representations of data from a pivot table?

Accepted Answer

Pivot Chart

Answer

Line chart

Answer

Bar chart

Answer

Scatter chart

Question 3

What is the keyboard shortcut to refresh a pivot table in Microsoft Excel?

Accepted Answer

Alt + F5

Answer

F5

Answer

Ctrl + Alt + F9

Answer

Ctrl + R

Question 4

Which of the following statements about a pivot table in Microsoft Excel is true?

Accepted Answer

It can help you analyze large amounts of data quickly

Answer

It can only be used with numerical data

Answer

It is only used for basic calculations

Answer

It is not compatible with functions such as sorting and filtering

Question 5

What is the difference between a pivot table and a pivot chart in Microsoft Excel?

Accepted Answer

A pivot table is a table that summarizes data while a pivot chart is a graphical representation of the pivot table

Answer

There is no difference between a pivot table and a pivot chart in Microsoft Excel

Answer

A pivot table is used for numerical data while a pivot chart is used for text data

Answer

A pivot table is a graphical representation of data while a pivot chart is a table that summarizes data

Question 6

What is the purpose of data validation in Microsoft Excel?

Accepted Answer

To restrict the type of data that can be entered in a cell or range of cells

Answer

To create a pivot table from a range of data

Answer

To merge and center cells in a worksheet

Answer

To calculate the sum of a range of cells

Question 7

What is the function of the COUNT formula in Microsoft Excel?

Accepted Answer

It counts the number of cells in a range that contain numbers.

Answer

It inserts a page break into the worksheet.

Answer

It calculates the median value of a range of cells.

Answer

It changes the background color of selected cells.

Question 8

What is the function of the VLOOKUP formula in Microsoft Excel?

Accepted Answer

It searches for a value in the first column of a table and returns a corresponding value from a specified column.

Answer

It deletes the contents of a selected cell.

Answer

It formats selected cells as bold text.

Answer

It inserts a new worksheet into the workbook.

Question 9

What is the function of the AVERAGE formula in Microsoft Excel?

Accepted Answer

It calculates the arithmetic mean of a range of cells.

Answer

It deletes a worksheet from the workbook.

Answer

It changes the font size of selected cells.

Answer

It inserts a hyperlink into the worksheet.

Question 10

What is the function of the LEFT formula in Microsoft Excel?

Accepted Answer

It returns a specified number of characters from the beginning of a text string.

Answer

It rounds a number up to the nearest integer.

Answer

It converts a text string to uppercase.

Answer

It multiplies a range of cells by a specified number.

Question 11

What is the function of the NOW formula in Microsoft Excel?

Accepted Answer

It returns the current date and time.

Answer

It sorts data in descending order.

Answer

It fills a range of cells with a series of numbers.

Answer

It converts a number to a percentage.

Question 12

Which function in Microsoft Excel capitalizes the first letter of each word in a text string?

Accepted Answer

Proper

Answer

Trim

Answer

Lower

Answer

Upper

Question 13

What does the TRIM function in Microsoft Excel do?

Accepted Answer

Removes extra spaces from a text string

Answer

Converts text to lowercase

Answer

Capitalizes the first letter of each word in a text string

Answer

Converts text to uppercase

Question 14

Which function in Microsoft Excel converts text to lowercase?

Accepted Answer

Lower

Answer

Trim

Answer

Proper

Answer

Upper

Question 15

Which function in Microsoft Excel changes the capitalization of all letters in a text string to uppercase?

Accepted Answer

Upper

Answer

Lower

Answer

Trim

Answer

Proper

Question 16

What is conditional formatting in Microsoft Excel?

Accepted Answer

Changing the appearance of cells based on specific criteria

Answer

Formatting text to lowercase

Answer

Capitalizing the first letter of each word in a text string

Answer

Removing extra spaces from a text string

Question 17

What is the syntax of the PROPER function in Microsoft Excel?

Accepted Answer

=PROPER(text)

Answer

=LOWER(text)

Answer

=TRIM(text)

Answer

=UPPER(text)

Question 18

What is the syntax of conditional formatting in Microsoft Excel?

Accepted Answer

=IF(condition, formatting)

Answer

=PROPER(text)

Answer

=LOWER(text)

Answer

=UPPER(text)

Question 19

What is the syntax of the LOWER function in Microsoft Excel?

Accepted Answer

=LOWER(text)

Answer

=UPPER(text)

Answer

=TRIM(text)

Answer

=PROPER(text)

Question 20

What does the UPPER function in Microsoft Excel do?

Accepted Answer

Changes all letters in a text string to uppercase

Answer

Capitalizes the first letter of each word in a text string

Answer

Removes extra spaces from a text string

Answer

Converts text to lowercase

Related quizzes

Related quizzes