Question 1

Which of the following features is used to transpose columns and rows of data?

Options :

A : Sort

B : Charting

C : PivotTable

D : Transpose

Answer: D

Question 2

How can you easily remove blank rows in Excel?

Options :

A : Select the row, click the Home tab, choose Delete in the Cells group, and then select Delete Sheet Rows

B : Highlight the row, click the Home tab, choose Delete in the Cells group, and then select Delete Dialog Box

C : Highlight the columns, click on Conditional Formatting, choose New Rule, and then click Use a formula

D : Highlight the row, right-click, and select delete

Answer: A

Question 3

Which of the following formats displays negative numbers in parentheses in Excel?

Options :

A : Percentage

B : Accounting

C : Currency

D : None of the above

Answer: B

Question 4

Which of the following Excel functions can be used to extract data from a table based on certain criteria?

Options :

A : INDEX-MATCH

B : HLOOKUP

C : SUMIF

D : VLOOKUP

Answer: A

Question 5

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

Higher Test Marks with Free Online MO-211 Exam Practice