Microsoft Excel Basic MCQs (Long Quiz)
This is the quiz about basics of Microsoft Office Excel . Students and new learner's can test their knowledge.
Question 1 / 25
How many sheets are there, by default, when we create a new Excel file ?
1
3
5
10
Question 2 / 25
In Excel, which one denoted a range from B1 through E5
B1 - E5
B1:E5
B1 to E5
B1$E5
Question 3 / 25
An Excel file is generally called a / an :
E-Spreadsheet
Woorksheet
Workbook
Sheet
Question 4 / 25
It is a collection of data that is stored electronically as a series of records in a table.
spreadsheet
presentation
database
MS Word
Question 5 / 25
On An Excel Sheet The Active Cell In Indicated By ?
A Dotted Border
A Dark Wide Border
A Blinking Border
By Italic Text
Question 6 / 25
Which Of The Following Keyboard Shortcut Can Be Used For Creating A Chart From The Selected Cells ?
F11
F10
F4
F2
Question 7 / 25
Which Key Is Used For Help In Ms Excel?
F2
F1
F3
None Of These
Question 8 / 25
You Can Convert Existing Excel Worksheet Data And Charts To HTML Document By Using The ?
Intranet Wizard
Import Wizard
Export Wizard
Internet Assistant Wizard
Question 9 / 25
To Create An Interactive Pivot Table For The Web, You Use A Microsoft Office Web Component Called ?
HTML
Pivot Table Report
Pivot Table List
Pivot Table Field List
Question 10 / 25
Which Key Is Used To "Goto" Tab In Ms Excel?
F9
F7
F6
F5
Question 11 / 25
Which Of The Following Is Not A Valid Zoom Percentage In Excel ?
10
500
100
300
Question 12 / 25
How Can We Set Page Border In Excel ?
From Edit Menu
From Home
You Can Not Set Page Border In Excel
From Tools Menu
Question 13 / 25
Which Of These Keys Are Used In Ms Excel To Insert Current Time In Workbook?
Ctrl+ :
Ctrl+ "
Ctrl+ ;
Ctrl+T
Question 14 / 25
Which Function Calculates Your Monthly Mortage Payment ?
PMT
PV
NPER
All Of Above
Question 15 / 25
Which Types Of Charts Can Excel Produce ?
Line Graphs And Pie Charts Only
Bar Charts, Line Graphs And Pie Charts
Bar Charts And Line Graphs Only
Only Line Graphs
Question 16 / 25
3-D Reference In A Formula ?
Can Not Be Modified
Spans Worksheets
Limits The Formatting Options
Only Appears On Summary Worksheets
Question 17 / 25
Which Of These Keys Are Used In Ms Excel To Copy Value From Above Cell?
Ctrl+ ;
Ctrl+ "
Ctrl+ :
Ctrl+ D
Question 18 / 25
To Minimize Workbook In Ms Excel:
Ctrl+ F8
Ctrl+ F7
Ctrl+ F9
Ctrl+ F6
Question 19 / 25
Merge Cells Option Can Be Applied From ?
Formatting Toolbar
Format Cells Dialog Box Alignment Tab
Both Of Above
None Of Above
Question 20 / 25
We Can Cancel Marquee By Pressing ?
Ctrl + Esc
Alt + Esc
Shift + Esc
Esc
Question 21 / 25
VLOOKUP Function Used To ?
Finds Related Records
Looks Up Text That Contain "v"
Check If Two Cells Are Identical
None Of Above
Question 22 / 25
Hyperlinks Can Be In:
Text
Pictures
Drawing Objects
All Of Above
Question 23 / 25
_______________functionin Excel tells how many numeric entries are there.
COUNT
NUM
SUM
CHKNUM
Question 24 / 25
Which one is not a function in ms excel?
SUM
AVG
MAX
MIN
Question 25 / 25
Which of the following key is Used for help In Ms Excel?
F1
F2
F3
None of the above
What's Your Reaction?
Like
0
Dislike
0
Love
0
Funny
0
Wow
0
Sad
0
Angry
0
Comments (0)