MCQs on Microsoft Excel
MCQs on Microsoft Excel
MCQ and Quiz online related to Microsoft Excel are available here.
MCQ and Quiz online related to Microsoft Excel are available here.
Q No.1 of 10
Which of the following is not a valid data type in Excel?
Option 1
|
Label
|
Option 2
|
Number
|
Option 3
|
Character
|
Option 4
|
Date/Time
|
Q No.2 of 10
Which menu option can be used to split windows into two?
Option 1
|
View -> Window-> Split
|
Option 2
|
Window -> Split
|
Option 3
|
Format -> Window
|
Option 4
|
View –> Split
|
Q No.3 of 10
Comments can be added to cells using
Option 1
|
Insert -> Comment
|
Option 2
|
View –> Comments
|
Option 3
|
File -> Comments
|
Option 4
|
Edit -> Comments
|
Q No.4 of 10
Comments put in cells are called
Option 1
|
Cell Tip
|
Option 2
|
Web Tip
|
Option 3
|
Soft Tip
|
Option 4
|
Smart Tip
|
Q No.5 of 10
How to start formula in excel?
Option 1
|
Start Formula
|
Option 2
|
=
|
Option 3
|
Formula:
|
Option 4
|
:
|
Q No.6 of 10
Which area in an Excel window allows entering values and formulas
Option 1
|
Menu Bar
|
Option 2
|
Title Bar
|
Option 3
|
Standard Tool Bar
|
Option 4
|
Formula Bar
|
Q No.7 of 10
What do you mean by a Workspace?
Option 1
|
Group of Workbooks
|
Option 2
|
Group of Columns
|
Option 3
|
Group of Rows
|
Option 4
|
Group of Worksheets
|
Q No.8 of 10
How do you rearrange the data in ascending or descending order
Option 1
|
Data, Table
|
Option 2
|
Data, Sort
|
Option 3
|
Data, Form
|
Option 4
|
Data Subtotals
|
Q No.9 of 10
MS-EXCEL is based on________Operating System.
Option 1
|
DOS
|
Option 2
|
WINDOWS
|
Option 3
|
OS/2
|
Option 4
|
DOS
|
Q No.10 of 10
An Excel Workbook is a collection of
Option 1
|
Worksheets
|
Option 2
|
Charts
|
Option 3
|
Worksheets and Charts
|
Option 4
|
Workbooks
|