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

2. In Excel, which one denoted a range from B1 through E5

B1 - E5
B1:E5
B1 to E5
B1$E5

3. An Excel file is generally called a / an :

E-Spreadsheet
Woorksheet
Workbook
Sheet

4. It is a collection of data that is stored electronically as a series of records in a table.

spreadsheet
presentation
database
MS Word

5. On An Excel Sheet The Active Cell In Indicated By ?

A Dotted Border
A Dark Wide Border
A Blinking Border
By Italic Text

6. Which Of The Following Keyboard Shortcut Can Be Used For Creating A Chart From The Selected Cells ?

F11
F10
F4
F2

7. Which Key Is Used For Help In Ms Excel?

F2
F1
F3
None Of These

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

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

10. Which Key Is Used To "Goto" Tab In Ms Excel?

F9
F7
F6
F5

11. Which Of The Following Is Not A Valid Zoom Percentage In Excel ?

10
500
100
300

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

13. Which Of These Keys Are Used In Ms Excel To Insert Current Time In Workbook?

Ctrl+ :
Ctrl+ "
Ctrl+ ;
Ctrl+T

14. Which Function Calculates Your Monthly Mortage Payment ?

PMT
PV
NPER
All Of Above

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

16. 3-D Reference In A Formula ?

Can Not Be Modified
Spans Worksheets
Limits The Formatting Options
Only Appears On Summary Worksheets

17. Which Of These Keys Are Used In Ms Excel To Copy Value From Above Cell?

Ctrl+ ;
Ctrl+ "
Ctrl+ :
Ctrl+ D

18. To Minimize Workbook In Ms Excel:

Ctrl+ F8
Ctrl+ F7
Ctrl+ F9
Ctrl+ F6

19. Merge Cells Option Can Be Applied From ?

Formatting Toolbar
Format Cells Dialog Box Alignment Tab
Both Of Above
None Of Above

20. We Can Cancel Marquee By Pressing ?

Ctrl + Esc
Alt + Esc
Shift + Esc
Esc

21. VLOOKUP Function Used To ?

Finds Related Records
Looks Up Text That Contain "v"
Check If Two Cells Are Identical
None Of Above

22. Hyperlinks Can Be In:

Text
Pictures
Drawing Objects
All Of Above

23. _______________functionin Excel tells how many numeric entries are there.

COUNT
NUM
SUM
CHKNUM

24. Which one is not a function in ms excel?

SUM
AVG
MAX
MIN

25. Which of the following key is Used for help In Ms Excel?

F1
F2
F3
None of the above