Welcome to your Microsoft Excel MCQ Set – 100 Beginner Questions
Are you looking to master Microsoft Excel for competitive exams or job-based assessments? This post presents 100 beginner-level multiple-choice questions (MCQs) for MS Excel carefully designed to cover the fundamental features of Excel, including formulas, functions, cell formatting, shortcuts, charts, and data management. These questions are ideal for those preparing for exams such as Loksewa Computer Operator (Nepal), CCC, NIELIT, PSC (India), PSBD (UAE), MOI (Qatar), SIRA (Dubai), and various IT certification tests globally. Whether you are a student, job seeker, or IT beginner, this Microsoft Excel MCQ set will help build a strong base in spreadsheet skills and boost your confidence for upcoming exams.
1.
Which of the following is the latest among these versions of Excel?
2.
What is the default extension of Excel files?
3.
Which of the following is a popular DOS based spreadsheet package?
4.
Which of the following is the oldest spreadsheet package?
5.
File created with Lotus 1-2-3 hav an extension ________
6.
How many characters can be typed in a single cell in Excel?
7.
A Worksheet can have a maximum of __________ numbers of rows
8.
A typical worksheet has _______ number of columns
9.
Comments put in cells are called ________
10.
Comments can be added to cell using ______
11.
Which menu option can be used to split windows into two?
12.
Getting data from a cell located in a different sheet is called ______
13.
Which of the following is not a valid data type in Excel?
14.
Which elements of a worksheet can be protected from accidental modification?
15.
A numeric value can be treated as label value if _______ preceded it.
16.
Concatenation of text can be done using
17.
Data can be arranged in a worksheet in an easy to understand manner by
18.
Which area in an Excel window allows entering values and formulas?
19.
Multiple calculations can be made in a single formula using ______
20.
An excel Workbook is a collection of ______
21.
What do you mean by workspace?
22.
MS Excel is based on _________
23.
In Excel, you can sum a large range of data by simply selection a tool button called____
24.
To select an entire column in MS-Excel, Press?
25.
To return the remainder after a number is divided by a divisor in Excel we use the function?
26.
Which function is not available in the Consolidate dialog box?
27.
Which is not the function of “Edit, Clear” command?
28.
Microsoft Excel is a powerful _____
29.
How do you rearrange the data in ascending or descending order?
30.
Which Chart can be created in Excel?
31.
What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
32.
How do you display current date and time in MS Excel?
33.
How do you display current date only in MS Excel?
34.
How do you wrap the text in a cell?
35.
What does COUNT () Function do?
36.
What is the shortcut key to highlight the entire column?
37.
In the formula, which symbol specifies the fixed columns or rows?
38.
Excel displays the current cell address in the ______
39.
What is the correct way to refer the cell A10 on sheet3 from sheet1?
40.
Which language is used to create macros in Excel?
41.
Which of the following is not a term of MS-Excel?
42.
How many worksheets can a workbook have?
43.
Which would you choose to create a bar diagram?
44.
Which Setting you must modify to print a worksheet using letter head?
45.
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
46.
The spelling dialog box can be involved by choosing spelling from _______ menu.
47.
Which key do you press to check spelling?
48.
To record a sequence of keystrokes and mouse actions to play back later we use:
49.
We can save and protect the workbook by
50.
The file extension for an EXCEL workbook is
51.
The first cell in Excel worksheet is labeled as
52.
What happens when dollar Signs ($) are entered in a cell address? (ex: $B$2:$B$10)
53.
What are the tabs that appear at the bottom of each workbook called?
54.
What is represented by the small, black square in the lower-right corner of an active cell or range?
55.
In Excel, a Data Series is defined as what?
56.
In Excel, the Fill Color button on the Formatting toolbar is used for what?
57.
In help menu of Excel, which of the following tabs are found?
58.
A ________ is a grid with labeled columns and rows.
59.
60. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
62.
The cancel and Enter buttons appear in the:
63.
\MS-Excel can be used to automate
64.
NOT, AND, OR and XOR are
65.
In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a _______
66.
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:
67.
You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?
68.
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
69.
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ________
70.
In order to perform a calculation in a spreadsheet, you need to use a:
71.
The box on the chart that contains the name of each individual record is called the _________
72.
If you want all of the white cats grouped together in the database, you need to sort by ______
73.
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
74.
How do you tell one cell from another?
75.
When a row and a column meet, what do you call that?
76.
An example of a cell address
77.
Which is an example of a function?
78.
Which is an example of a function?
79.
What is the symbol for multiplying?
80.
What is the symbol for dividing?
81.
Which is the spreadsheet application?
82.
Which is not an Excel Term?
83.
Which is not the correct cell reference?
84.
What will be the formula in D10 on copying the formula 'A$5*5' from cell B4
85.
What will be the result if you format a cell containing value 5000.4 as "0#,###.00'?
86.
There are formula ‘=A1+B1’ and ‘=A2+B2’ in cells C1 and C2 respectively. What will be the formula in C1,C2,C3 on inserting a row before C2?
87.
There are values 5 and 2 cells A1 and B1 respectively and formula ‘=A1 * B1 ‘ in cell C1. What will be the resulting values in A1, B1, and C1 when you use Goal Seek with set cell as C1, To value as 50 and By Changing Cell as B1?
88.
How to unhide the hidden column B?
89.
What tool is capable of calculating monthly rainfall amounts and creating graphs based on that data?
90.
To define border in the cell, select:
91.
To delete cell entry, select:
92.
To merge the cells which tab do you use from the format, cells menu?
93.
In goal seek, the 'by changing cell' refers to"
94.
Which is the correct expression to find the average of the range named “units”?
95.
How do you magnify your worksheet window?
96.
With which of the following all formulas in excel starts?
97.
In MS Excel to delete duplicate values which menu is used?
98.
The placeholder cell through which excel feeds the input variable is called:
99.
The common wild characters that excel recognizer are
