Question 1

What is the keyboard shortcut to insert a new worksheet in an Excel workbook?

Options :

A : Ctrl + N

B : Shift + F11

C : Ctrl + W

D : Ctrl + Shift + N

Answer: D

Question 2

What is the formula to calculate the sum of cells that meet multiple criteria in Microsoft Excel?

Options :

A : SUMIF() and SUMIFS()

B : SUMIF()

C : AVERAGEIF() and AVERAGEIFS()

D : SUMIFS()

Answer: D

Question 3

Which Excel function can be used to remove spaces from the beginning and end of a text string?

Options :

A : LEFT

B : RIGHT

C : CLEAN

D : TRIM

Answer: D

Question 4

What feature in Excel allows you to format a chart element based on predefined criteria?

Options :

A : Chart layouts

B : Chart templates

C : Chart titles

D : Chart styles

Answer: D

Question 5

What chart type would you use to show the correlation between two variables?

Options :

A : Scatter chart

B : Pie chart

C : Bubble chart

D : Line chart

Answer: A