Question 1

How many characters can a cell hold in Excel?

Options :

A : 32767

B : 256

C : 255

D : 1024

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

Which of the following functions in Excel is used to concatenate two or more text strings into a single string?

Options :

A : RIGHT

B : LEFT

C : MID

D : CONCATENATE

Answer: D

Question 4

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 5

What does the CONCATENATE function do in Excel?

Options :

A : Adds two or more cells

B : Joins two or more text strings into one

C : Returns the average of two or more cells

D : Multiplies two or more cells

Answer: B