MS Excel mcq Questions and Answer | Microsoft Excel-7
ms excell - 7
MS Excel mcq Questions and Answer | Microsoft Excel-7
Question 1
Which of the following is invalid regarding the Protection
in Excel?
Protect Sheet
Protect Workbook
Protect Workspace
All of above are valid
Question 2
The Trace Precedence on Auditing shows
Which cells are used in current formula
In which formula the current cell is used
Which cells are used in this formula and in which
formula this cell is used
) None of above
Question 3
The Trace Dependence in auditing shows
Which cells are used in current formula
In which formula the current cell is used
Which cells are used in this formula and in which
formula this cell is used
All of above
Question 4
The arrows created by Auditing can be removed by
Click on the arrow and press Delete '
Click on Remove All arrows on Formula Auditing
toolbar
Both of above
Press insert
Question 5
Which of the following options i not available to remove
arrows of Formula Auditing?
Remove all precedent arrows
Remove all dependent arrows
Remove all arrows
Remove all arrows for this cell
Question 6
Excel is a good application for What IF analysis. Which
of the following tool help you for this?
Formula Auditing
Research
Track Change
Goal Seek
Question 7
Which of the following tool you will use in Excel to see
what must be the value of a cell to get required result?
Formula Auditing
Research
Track Change
Goal Seek
None of these
Question 8
To apply Goal Seek command your cell pointer must be in
The Changing cell whose value you need to find
The Result Cell where formula is entered
The cell where your targeted value is entered
All of above
Question 9
Which of the following is not What IF analysis tool in
Excel?
Goal Seek
Scenarios
Macros
All of above
Question 10
You can set Excel in Automatic or Manual calculation
mode. If it is in manual mode which key you will press to
update the formula values?
F9
F5
F8
F11
Question 11
By default the cell pointer moves down when you press
Enter. From where can you change this setting?
Tools > > Options » View tab
Tools » Options » Calculation tab
Tools » Options » Edit tab
Tools » Options » Transition tab
Question 12
When you start typing the same value as of some cells
on same column, Excel automatically shows that text. This
feature is known as
AutoFill
AutoCorrect
AutoComplete
AutoFormat
Question 13
The default and maxium number of sheets for a new
workbook in Excel 2003 is
3 and 255
and 256
1 and 255
1 and 256
Question 14
When you enter Sunday and fill right, Excel fill in with
Monday, Tuesday and so on. From where Excel knows what
to fill in next?
Auto Complete
AutoFormat
Custom List
Calculation Automatic
Question 15
The minimum and maximum value you can set for Save
Auto Recovery Info in Excel are
1 and 120 minutes
O and 120 minutes
2 and 60 minutes
1 and 10 minutes
Question 16
Which of the following can not be hidden from Tools >> Options then View tab?
Start-up Task Pane
Formula bar
Status bar
Scroll Bar
Question 17
What happens if you remove the check mark from Row
& Column headers on Options dialog box?
This will remove row headings and column headings of
your data
This will remove the column headings
This will remove row and column heading of chart
This will remove row and column heading of table
Question 18
The default font size in Excel worksheet is
Arial
Algerial
Times New Roman
Preetl
Question 19
Comments put in cells are called.....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Question 20
Comments can be added to cells using.....
Edit-> Comments
Insert> Comment
File-> Qomments
Vlew> Comments
Question 21
Getting data from a cell located in a different sheet is
called.
Accessing
Referencing
Updating
Functioning
Question 22
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Question 23
Which elements of a worksheet can be protected from
accidental modification?
Contents
Objects
Scenarios
All of the above
Question 24
A numeric value can be treated as label value If......
precedes It.
Apostrophe (')
Exclamation (I)
Hash (#)
Tilde(~)
Question 25
Concatenation of text can be done using
Apostrophe (')
Exclamation (I)
Hash(#)
Ampersand (&)
Question 26
Which area In an Excel window allows entering values
and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Question 27
Multiple calculations can be made In a single formula
using....
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Question 28
An Excel Workbook is a collection of.......
Workbooks
Worksheets
Charts
Worksheets and Charts
Question 29
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Question 30
MS-EXCEL is based on .-.....-?
WINDOWS
DOS
UNIX
OS/2
Question 31
In EXCEL, you can sum a large range of data by simply
selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
Question 32
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
All of the above
Question 33
To return the remainder after a number Is divided by a
divisor In EXCEL we use the function?
ROUND ( )
FACT( )
MOD ( )
DIV()
Question 34
Which function Is not available In the Consolidate dialog
box?
Pmt
Average
Max
Sum
There are 34 questions to complete.
