Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer

From 331 to 345 of 563

Q. If you want all of the white cats grouped together in the database, you need to sort by ________.

a. Color, then Gender

b. Pet Type, then Color

c. Pet Type, then Gender

d. Color, then Pet Name

  • b. Pet Type, then Color

Q. Where a row and a column meet, what do you call that?

a. A cell

b. A block

c. A box

d. None of the above

  • a. A cell

Q. How do you tell one cell from another?

a. By numbers

b. By letters

c. By its address

d. by color

  • c. By its address

Q. Give me an example of a cell address.

a. 11 25

b. 911

c. 41A

d. A21

  • d. A21

Q. Which is an example of a formula?

a. =A1+A2

b. =add(A1:A2)

c. A1+A2

d. SUM(A1:A2)

  • a. =A1+A2

Q. Which is an example of a function?

a. =add(A1:A2)

b. =A1+A2

c. =SUM(A1:A2)

d. A1+A2

  • c. =SUM(A1:A2)

Q. What is the symbol for multiplying?

a. >

b. /

c. !

d. *

Q. What is the symbol for dividing?

a. A ./

b. %

c. &

d. #

  • a. A ./

Q. A function inside another function is called _______

a. Nested function

b. Round function

c. Sum function

d. Text function

  • a. Nested function

Q. Which of the following is not an underline option in the format cells dialog box?

a. Double

b. Single Accounting

c. Double Accounting

d. Single Engineering

  • d. Single Engineering

Q. Formulas in Excel start with

a. %

b. =

c. +

d. -

Q. The default header for a worksheet is

a. Username

b. Date and Time

c. Sheet tab Name

d. None

  • d. None

Q. Which of the following is not an option of the spelling dialog box?

a. Ignore

b. Ignore all

c. Edit

d. Change

  • c. Edit
Subscribe Now

Get All Updates & News