MS Excel mcq Questions and Answer | Microsoft Excel-7

MS Excel mcq Questions and Answer | Microsoft Excel-7

ms excell - 7

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

Leave a Comment