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

From 286 to 300 of 563

Q. Right clicking something in Excel

a. Deletes the object

b. Nothing the right mouse button is there for left handed people

c. Opens a shortcut menu listing everything you can do to the object

d. Selects the object

  • c. Opens a shortcut menu listing everything you can do to the object

Q. In Excel Documentation should include

a. Destination and users of the output data

b. Source of input data

c. Information on the purpose of the workbook

d. All of the above

  • d. All of the above

Q. Files created with Lotus 1-2-3 have anextension

a. DOC

b. XLS

c. 123

d. WK1

  • c. 123

Q. In Excel to delete an embedded objects, first

a. Double click the object

b. Select the object by clicking it

c. Press the Shift + Delete keys

d. Select it and then press the delete key

  • d. Select it and then press the delete key

Q. In Excel comments can be added to cells using

a. Edit > Comments

b. Insert > Comments

c. File > Comments

d. View > Comments

  • b. Insert > Comments

Q. In Excel which of the following is not a worksheet design criterion?

a. Efficiency

b. Aditibility

c. Description

d. Clarity

  • c. Description

Q. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

a. Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

b. Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

c. Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.

d. All of above

  • a. Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

Q. In Excel a fast way to add up this column of number is to click in the cell below the numbers and then

a. Click subtotals on the data menu

b. View the sum in the formula bar

c. Click the autosum button on the standard toolbar, then press enter

d. All of above

  • c. Click the autosum button on the standard toolbar, then press enter

Q. In Excel which of the following is an absolute cell reference?

a. !A!1

b. $A$1

c. #a#1

d. A1

  • b. $A$1

Q. In Excel what symbol is used before a number to make it a label?

a. “ (quote)

b. = (equal)

c. _ (underscore)

d. ‘ (apostrophe)

  • b. = (equal)

Q. In Excel which of the following formulas is not entered correctly?

a. =10+50

b. =B7*B1

c. =B7+14

d. 10+50

  • d. 10+50

Q. In Excel which of the following formulas will Excel not be able to calculate?

a. =SUM(Sales)-A3

b. =SUM(A1:A5)*.5

c. =SUM(A1:A5)/(10-10)

d. =SUM(A1:A5)-10

  • a. =SUM(Sales)-A3

Q. In Excel typical worksheet has …. Number of columns

a. 128

b. 256

c. 512

d. 1024

  • b. 256

Q. In Excel how many characters can be typed in a single cell?

a. 256

b. 1024

c. 32,000

d. 65,535

  • d. 65,535
Subscribe Now

Get All Updates & News