Question 1

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 2

What is the benefit of using tables in Excel?

Options :

A : They allow you to add animations and transitions to data.

B : They allow you to sort, filter, and analyze data easily.

C : They allow you to convert data into charts easily.

D : They allow you to create complex formulas and macros.

Answer: B

Question 3

What is the keyboard shortcut to automatically fill a series of values into cells in Microsoft Excel?

Options :

A : Ctrl + D

B : Ctrl + Shift + D

C : Ctrl + R

D : Ctrl + Shift + R

Answer: A

Question 4

Which of the following is not a number format in Excel?

Options :

A : Duration

B : Long date

C : Scientific

D : Short date

Answer: A

Question 5

What is the shortcut key combination to insert a new worksheet in your workbook?

Options :

A : Ctrl+W

B : Ctrl+Shift+N

C : Ctrl+Shift+W

D : Ctrl+Alt+W

Answer: B

Higher Test Marks with Free Online MO-211 Exam Practice