Home >> MS Excel MCQs >>

MS Excel Set 08

MS Excel Set 08

Q.1 In MS Excel, Conditional Formatting is in ______ tab?
A. Home
B. View
C. Page Layout
D. Insert

ANSWER: A) Home
Explanation : Conditional formatting in MS Excel is provided in Home tab. Conditional formatting is used to format cells on the basis of given condition.

Q.2 Which of the following you can paste selectively using Paste Special Command?
A. Validation
B. Formats
C. Formulas
D. All of above

ANSWER: D) All of above
Explanation : The Paste Special command in Microsoft Excel selectively pastes validation, formats, formulas, comments

Q.3 Excel displays the current cells address in the __________?
A. Formula bar
B. Status bar
C. Name box
D. Title bar

ANSWER: C) Name box
Explanation : Name box in MS Excel is used to display the address of currently selected cell.

Q.4 The first cell in excel worksheet is labeled as _________?
A. AA
B. A1
C. Aa
D. None of these

ANSWER: B) A1
Explanation : the First cell in MS Excel is addressed or labeled as A1. A means first column and 1 refers to first row in worksheet.

Q.5 An excel workbook is a collection of __________?
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts

ANSWER: C) Charts
Explanation : An excel workbook is a collection of worksheets. A Worksheet is basic building block in MS Excel and used to enter data. Worksheets consists of rows and columns, forming Cells.

Q.6 Which of these keys are used in MS Excel to insert current time In workbook?
A. Ctrl + Shift + ;
B. Ctrl+!
C. Ctrl+*
D. None of these

ANSWER: A) Ctrl + Shift + ;
Explanation : To insert the current time, press Ctrl+Shift+; (semi-colon).

Q.7 Getting data from a cell located in a different sheet is called ___________?
A. Accessing
B. Referencing
C. Updating
D. Functioning

ANSWER: B) Referencing
Explanation : Getting data from a cell located in a different sheet is called reffering. We use cell reference to get data from other cells in ms excel.

Q.8 In MS Excel Readymade templates are available under _______ tab?
A. File
B. Insert
C. Design
D. None of Above

ANSWER: A) File
Explanation :  When considering Microsoft Word, Microsoft Excel, Microsoft Power Point, the templates are in file tab.

Q.9 You can edit existing Excel data by pressing the: ________ key?
A. F1 Key
B. F2 Key
C. F3 Key
D. F4 Key

ANSWER: B) F2 Key
Explanation : F2 Key is used to edit or rename in MS Windows environment.

Q.10 When you insert an Excel file into a word document, the data are?
A. Hyperlinked
B. Placed in a word table
C. Linked
D. Embedded

ANSWER: C) Linked
Explanation : When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked. In Embedded objects file become part of document and does not get updated when source file is updated.

Related Posts

More MCQs