Microsoft Excel Quiz

What does the function =COUNTIF(A1:A10, ">50") do?

How do you insert a new row in Excel?

• Right-click and select "Insert"

• Press Ctrl + R

• Press Ctrl + I

• Press Ctrl + Shift + R

What does the function =TODAY() do in Excel?

• Returns the current date and time

• Returns the current time

• Returns the current date

• Returns the current month

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

• MAX

• MIN

• SUM

• AVERAGE

Which function is used to combine text from different cells into one cell in Excel?

• CONCATENATE

• AVERAGE

• MAX

• IF

Answer explanation

The function used to combine text from different cells into one cell in Excel is CONCATENATE.

How do you apply a border to selected cells in Excel?

• By using the AutoSum function

• By using the IF function

• By selecting the cells and clicking on "Borders" in the Home tab

• By using the CONCATENATE function

Answer explanation

By selecting the cells and clicking on "Borders" in the Home tab

How do you create a PivotTable in Excel?

• By selecting the data and clicking on "PivotTable" in the Insert tab

• By using the SUM function

• By applying conditional formatting

• By using the VLOOKUP function

Answer explanation

By selecting the data and clicking on "PivotTable" in the Insert tab

What is the purpose of the Freeze Panes feature in Excel?

• Lock specific rows or columns so they remain visible while scrolling

• Insert a new row or column

• Delete rows or columns

• Hide rows or columns

Answer explanation

Lock specific rows or columns so they remain visible while scrolling

What is the keyboard shortcut for saving an Excel workbook?

• Ctrl + S

• Ctrl + V

• Ctrl + A

• Ctrl + P

Answer explanation

The keyboard shortcut for saving an Excel workbook is Ctrl + S.

What is the keyboard shortcut for copying selected cells in Excel?

• Ctrl + C

• Ctrl + X

• Ctrl + V

• Ctrl + P

Answer explanation

The keyboard shortcut for copying selected cells in Excel is Ctrl + C.