Question 1

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

Question 2

Which of the following formatting options is not available in the Format Cells dialog box in Excel?

Options :

A : Border

B : Alignment

C : Fill

D : Font

Answer: C

Question 3

What is the purpose of the CountA function in Excel?

Options :

A : To count the number of cells in a range that contain blank values.

B : To count the number of cells in a range that contain error values.

C : To count the number of cells in a range that are not empty.

D : To count the number of cells in a range that contain numerical values.

Answer: C

Question 4

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 5

Which of the following data types is not supported in a VBA macro?

Options :

A : Boolean

B : Complex

C : Text

D : Date

Answer: B