info@uceagra.com
Student Enquery: +91 79005 25060
Franchise Enquery: +91 80771 91427
Work With Us
Home
(current)
Exam Portal
Online Test
Downloads
CCC Admit Card
CCC Form Apply
CCC Certificate
CCC Result
Typing Test
English Typing
Hindi Typing
Gallery
Videos
Contact us
Join us
About Us
Feedback
FAQ's
50 MCQ of Microsoft Excel
Question 1
____ appear at the bottom of the Excel window.
(A) Title bar
(B) Formula bar
(C) Work sheet tabs
(D) Name box
Question 2
What are the basic rectangular building blocks of a spreadsheet ?
(A) Cells
(B) Zoom slider
(C) Help button
(D) All of these
Question 3
Which of the following is not a term pertaining to spreadsheets ?
(A) Cell
(B) Character
(C) Browser
(D) Formula
Question 4
Another name for a pre-programmed formula in Excel is
(A) Cell
(B) Graph
(C) Function
(D) Range
Question 5
Excel is a program that is used to prepare a
(A) Slide presentation
(B) Spreadsheet
(C) Text document
(D) Database
Question 6
In which tab wrap text feature is present in MS Excel 2007 ?
(A) Formulas
(B) View
(C) Insert
(D) Home
Question 7
Which of the following identifies a cell in Excel ?
(A) Address
(B) Formula
(C) Name
(D) Label
Question 8
Which term is used to join the selected cells in to one cell ?
(A) Filter
(B) Wrap
(C) Pivot
(D) Merge
Question 9
Which of the following Excel charts represents only one value for each variable ?
(A) Bar
(B) Pie
(C) Line
(D) Function
Question 10
A formula in Excel always begins with an ____
(A) Equal sign
(B) Colon
(C) Comma
(D) Space
Question 11
When the CPU detects an interrupt, then it saves its
(A) Previous state
(B) Next state
(C) Current state
(D) All of the above
Question 12
A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
(A) List
(B) Section
(C) Range
(D) Area
Question 13
What is the extension of saved file in MS Excel ?
(A) .xls
(B) .xks
(C) .xos
(D) .xbs
Question 14
Which command is used to close the window of Excel ?
(A) Alt+ F4
(B) Ctrl + W
(C) Ctrl +R
(D) Ctrl+ C
Question 15
What is the total region surrounding the chart ?
(A) Chart area
(B) legend
(C) Clipart area
(D) Plot area
Question 16
____ returns the least common multiple.
(A) LCCM()
(B) LCM()
(C) TLCM()
(D) RTLCM()
Question 17
This is not a function category in Excel.
(A) Logical
(B) Text
(C) Financial
(D) Data series
Question 18
How many columns are there in old version of MS Excel ?
(A) 250
(B) 256
(C) 265
(D) 269
Question 19
Which bar show the used formula of selected active cell ?
(A) Formula bar
(B) Ribbon
(C) Menu bar
(D) Scroll bar
Question 20
Typed text showed in active cell and also in ___
(A) Formula bar
(B) Ribbon
(C) Title bar
(D) Scroll bar
Question 21
What is the default row height of MS Excel ?
(A) 10
(B) 12
(C) 13
(D) 15
Question 22
Excel documents are stored as files called
(A) Workgroups
(B) Worktables
(C) Worksheets
(D) Workforce
Question 23
What refers to the horizontal cells which can contain information ?
(A) Ribbon
(B) Rows
(C) Columns
(D) Horizontal scrollbar
Question 24
Today motherboard typically use
(A) 70 pin modules
(B) 72 pin modules
(C) 74 pin modules
(D) 76 pin modules
Question 25
To minimize the currently selected window, press
(A) Ctrl+ F11
(B) Ctrl+ F12
(C) Ctrl+ F9
(D) Ctrl+ F10
Question 26
To maximize the currently selected window, press
(A) Ctrl+ F9
(B) Ctrl+ F10
(C) Ctrl+ F11
(D) Ctrl+ F12
Question 27
Which of the following is the default numbers of worksheet in MS Excel ?
(A) 2
(B) 3
(C) 4
(D) 5
Question 28
Formulas in Excel are made up of ___
(A) Arithmetical operators and functions
(B) Only arithmetic operators
(C) Only symbols
(D) Only functions
Question 29
The result is a ___ value either TRUE or FALSE.
(A) Logical
(B) Arithmetic
(C) Algorithm
(D) Logarithm
Question 30
Which of the following is the comparison operator ?
(A) *
(B) ^
(C) =
(D) +
Question 31
On an Excel sheet, the active cell is indicated by
(A) A dark wide border
(B) A dotted border
(C) A blinking border
(D) None of the above
Question 32
The letter and number of the intersecting column and row is the
(A) Cell location
(B) Cell position
(C) Cell address
(D) Cell coordinates
Question 33
The ____ helps to identify various plotted data series.
(A) X-axis
(B) Y-axis
(C) Gridlines
(D) Legend
Question 34
Which sign indicate to multiplication ?
(A) Asterisk
(B) Caret
(C) Percent sign
(D) Forward slash
Question 35
In a spreadsheet, a ____ is a number you will use in a calculation
(A) Value
(B) Cell
(C) Field
(D) Label
Question 36
____ is a powerful tool used to create and format spreadsheets.
(A) Adobe Photoshop CS
(B) Mozilla Firefox
(C) Microsoft Office PowerPoint
(D) Microsoft Office Excel
Question 37
Workbook is a collection of
(A) Worksheets
(B) Page set-up
(C) Buttons
(D) Diagrams
Question 38
The worksheet names appear on tabs at the ____ of the workbook window.
(A) Bottom right
(B) Bottom left
(C) Top left
(D) Top right
Question 39
The result of a formula in a cell is the
(A) Displayed value
(B) Range
(C) Value
(D) Label
Question 40
____ is the intersection of a row with a column.
(A) Cell
(B) Row
(C) Column
(D) All of these
Question 41
To display the save as dialog box, press
(A) F2
(B) F3
(C) F5
(D) F12
Question 42
The default file extension of MS-Excel is
(A) xlr
(B) xls
(C) exe
(D) exl
Question 43
The fill series dialog box in Excel has ____ sections.
(A) 1
(B) 2
(C) 3
(D) 4
Question 44
Which of the following is an active cell in excel ?
(A) Cell address
(B) Range
(C) Formula
(D) Current cell
Question 45
What is the pictorial representation of worksheet data ?
(A) Chart
(B) Clipart
(C) WordArt
(D) All of these
Question 46
Which function displays row data in a column or column data in a row ?
(A) Rows
(B) Transpose
(C) Hyperlink
(D) Index
Question 47
___ operator, combines multiple references into one reference.
(A) Ampersand
(B) Space
(C) Comma
(D) Colon
Question 48
DOS based spreadsheet package is
(A) Smartsheet
(B) Excel
(C) Spread PRO
(D) Lotus 1-2-3
Question 49
When we can create a chart on a separate sheet in the same workbook, it is called a
(A) Chart sheet
(B) Embedded chart
(C) View sheet
(D) View chart
Question 50
____ sign is used to create an absolute cell reference.
(A) $
(B) @
(C) &
(D) %