Microsoft Excel mcq questions with answer – Set 3

Important Instructions:

• Total Number Of Questions : 10
• Passing Marks : 7
• Each Question Carry 1 Mark, No Negative Marking.
• Do Not Refresh The Page.
• This Is A FREE Online Test, DO NOT Pay Money To Anyone To Attend This Test.
• Best Of Luck…

Results

-

Congratulation…
You Have Passed The Test, You Should Try To The Next One…!!

Rate this post

You May Also Like :   Microsoft Excel mcq questions with answer - Set 1

Unfortunately…
You Did Not Pass. Why Not Try It Again?

Rate this post

You May Also Like :   Microsoft Excel mcq questions with answer - Set 1

#1. Which of the following should include during data documentation?

Destination and users of the output data

Destination and users of the output data

Source of input data

Source of input data

Information on the purpose of the workbook

Information on the purpose of the workbook

all of these

all of these

#2. Files created with Lotus 1-2-3 have an extension?

DOC

DOC

XLS

XLS

123

123

WK1

WK1

#3. What is the first step to delete an embedded objects?

Double click the object

Double click the object

Select the object by clicking it

Select the object by clicking it

Press the Shift + Delete keys

Press the Shift + Delete keys

Select it and then press the delete key

Select it and then press the delete key

#4. How to add comments into the cells?

Edit > Comments

Edit > Comments

Insert > Comments

Insert > Comments

File > Comments

File > Comments

View > Comments

View > Comments

#5. Which of the following is not a worksheet design criterion?

Efficiency

Efficiency

Aditibility

Aditibility

Description

Description

Clarity

Clarity

#6. The Chart wizard term data categories refers to?

A chart plot area

A chart plot area

A horizontal axis

A horizontal axis

The organization of individual values with a chart′s data series

The organization of individual values with a chart′s data series

The data range that supply chart data

The data range that supply chart data

#7. What is a worksheet range?

A command used for data modeling

A command used for data modeling

A range of values such as from 23 to 234

A range of values such as from 23 to 234

A group of cells

A group of cells

A group of worksheets

A group of worksheets

#8. Getting data from a cell located in a different sheet is called?

Accessing

Accessing

Referencing

Referencing

Updating

Updating

Functioning

Functioning

#9. Tab scrolling button

Allow you to view a different worksheet

Allow you to view a different worksheet

Allow you to view additional worksheet rows down

Allow you to view additional worksheet rows down

Allow you to view additional worksheet columns to the right

Allow you to view additional worksheet columns to the right

Allow you to view additional sheets tabs

Allow you to view additional sheets tabs

#10. A numeric value can be treated as a label value if it precedes with?

Apostrophe (')

Apostrophe (')

Exclamation (!)

Exclamation (!)

Hash (#)

Hash (#)

Ampersand (&)

Ampersand (&)

CHECK ANSWER