Question 1

What chart type would you use to show how individual parts contribute to the whole?

Options :

A : Line chart

B : Radar chart

C : Bubble chart

D : Pie chart

Answer: D

Question 2

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 3

Which keyboard shortcut can be used to quickly fill a series of dates?

Options :

A : Ctrl + Shift + #

B : Ctrl + Shift + :

C : Ctrl + :

D : Ctrl + ;

Answer: C

Question 4

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

Options :

A : Boolean

B : Complex

C : Text

D : Date

Answer: B

Question 5

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