Advance excel - take the quiz | Take the Quiz

What is the shortcut key to open the Format Cells dialog box in Excel?

Ctrl + Shift + F

Ctrl + F

Alt + F4

Ctrl + Alt + F

Which function is used to find the highest value in a range of cells in Excel?

MAX

SUM

AVERAGE

COUNT

How can you freeze panes in Excel? (Select all those are correct)

Go to the View tab and click on Freeze Panes

Right-click on a cell and select Freeze Panes

Press Ctrl + F

Use the Freeze Panes button on the Home tab

Which formula is used to count the number of cells that contain numbers in a range in Excel?

COUNT

SUM

AVERAGE

MAX

How can you create a pivot table in Excel? (Select all those are correct)

Select the data range and go to the Insert tab, then click on PivotTable

Right-click on a cell and select Create PivotTable

Press Ctrl + P

Use the PivotTable button on the Home tab

What is the function of VLOOKUP in Excel?

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

It calculates the average of a range of cells

It counts the number of cells that meet a certain condition

It finds the highest value in a range of cells

How can you insert a new worksheet in Excel? (Select all those are correct)

Right-click on a worksheet tab and select Insert

Go to the Home tab and click on Insert

Press Ctrl + I

Use the Insert Worksheet button on the View tab

Which function is used to calculate the total number of characters in a cell in Excel?

LEN

COUNT

SUM

AVERAGE

How can you sort data in Excel? (Select all those are correct)

Select the data range and go to the Data tab, then click on Sort

Right-click on a cell and select Sort

Press Ctrl + S

Use the Sort button on the Home tab

What is the purpose of conditional formatting in Excel?

It allows users to format cells based on specific criteria or rules

It calculates the average of a range of cells

It counts the number of cells that meet a certain condition

It finds the highest value in a range of cells

How can you protect a worksheet in Excel? (Select all those are correct)

Go to the Review tab and click on Protect Sheet

Right-click on a worksheet tab and select Protect Sheet

Press Ctrl + P

Use the Protect Worksheet button on the Home tab

Which function is used to calculate the average of a range of cells in Excel?

AVERAGE

COUNT

SUM

MAX

How can you insert a chart in Excel? (Select all those are correct)

Select the data range and go to the Insert tab, then click on the desired chart type

Right-click on a cell and select Insert Chart

Press Ctrl + C

Use the Chart button on the Home tab

What is the purpose of the IF function in Excel?

It allows users to perform logical tests and return different values based on the result

It calculates the average of a range of cells

It counts the number of cells that meet a certain condition

It finds the highest value in a range of cells

How can you merge cells in Excel? (Select all those are correct)

Select the cells to be merged and go to the Home tab, then click on Merge & Center

Right-click on a cell and select Merge Cells

Press Ctrl + M

Use the Merge Cells button on the Format tab

Which function is used to calculate the sum of a range of cells in Excel?

SUM

COUNT

AVERAGE

MAX

How can you insert a hyperlink in Excel? (Select all those are correct)

Select the cell where you want to insert the hyperlink and go to the Insert tab, then click on Hyperlink

Right-click on a cell and select Insert Hyperlink

Press Ctrl + H

Use the Hyperlink button on the Home tab

What is the purpose of the CONCATENATE function in Excel?

It combines multiple text strings into one string

It calculates the average of a range of cells

It counts the number of cells that meet a certain condition

It finds the highest value in a range of cells

How can you remove duplicates in Excel? (Select all those are correct)

Select the data range and go to the Data tab, then click on Remove Duplicates

Right-click on a cell and select Remove Duplicates

Press Ctrl + D

Use the Remove Duplicates button on the Home tab

Which function is used to calculate the product of a range of cells in Excel?

PRODUCT

COUNT

SUM

MAX

Advance excel - take the quiz

More Quizzes