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