Q. In Excel, how do you create a chart from selected data?
A.
Insert > Chart
B.
Data > Chart
C.
Home > Chart
D.
View > Chart
Show solution
Solution
You create a chart from selected data by going to Insert > Chart in Excel.
Correct Answer:
A
— Insert > Chart
Learn More →
Q. In Excel, if you have the formula =SUM(A1:A10), what does it do?
A.
Counts the number of cells
B.
Calculates the average
C.
Adds up the values from A1 to A10
D.
Finds the maximum value
Show solution
Solution
The formula =SUM(A1:A10) adds up the values from cells A1 to A10.
Correct Answer:
C
— Adds up the values from A1 to A10
Learn More →
Q. In Excel, if you want to sum the values in cells A1 to A10, which formula would you use?
A.
=SUM(A1:A10)
B.
=ADD(A1:A10)
C.
=TOTAL(A1:A10)
D.
=SUMM(A1:A10)
Show solution
Solution
The correct formula to sum the values in cells A1 to A10 in Excel is =SUM(A1:A10).
Correct Answer:
A
— =SUM(A1:A10)
Learn More →
Q. In Excel, what does the function =AVERAGE(B1:B10) calculate?
A.
Sum of B1 to B10
B.
Count of B1 to B10
C.
Average of B1 to B10
D.
Maximum of B1 to B10
Show solution
Solution
The function =AVERAGE(B1:B10) calculates the average of the values in cells B1 to B10.
Correct Answer:
C
— Average of B1 to B10
Learn More →
Q. In Excel, what does the VLOOKUP function do? (2023)
A.
Looks up a value vertically
B.
Calculates the average
C.
Counts the number of cells
D.
Finds the maximum value
Show solution
Solution
The VLOOKUP function in Excel is used to look up a value vertically in a table.
Correct Answer:
A
— Looks up a value vertically
Learn More →
Q. In Excel, what function would you use to find the average of a range of cells?
A.
AVERAGE
B.
SUM
C.
COUNT
D.
MEDIAN
Show solution
Solution
The AVERAGE function is used to find the average of a range of cells in Excel.
Correct Answer:
A
— AVERAGE
Learn More →
Q. In Excel, which function would you use to find the average of a range of cells?
A.
=AVG()
B.
=MEAN()
C.
=AVERAGE()
D.
=SUM()/COUNT()
Show solution
Solution
The function used to find the average of a range of cells in Excel is =AVERAGE().
Correct Answer:
C
— =AVERAGE()
Learn More →
Q. In Excel, which of the following is NOT a valid data type?
A.
Text
B.
Number
C.
Date
D.
Image
Show solution
Solution
Image is not a valid data type in Excel; valid types include Text, Number, and Date.
Correct Answer:
D
— Image
Learn More →
Q. In Excel, which of the following is NOT a valid function?
A.
=COUNT()
B.
=SUM()
C.
=AVERAGE()
D.
=TOTAL()
Show solution
Solution
The function =TOTAL() is NOT a valid function in Excel.
Correct Answer:
D
— =TOTAL()
Learn More →
Q. In Excel, which symbol is used to start a formula? (2023)
Show solution
Solution
In Excel, the '=' symbol is used to start a formula.
Correct Answer:
B
— =
Learn More →
Q. In Microsoft Word, what is the shortcut key to save a document?
A.
Ctrl + S
B.
Ctrl + P
C.
Ctrl + C
D.
Ctrl + V
Show solution
Solution
The shortcut key to save a document in Microsoft Word is Ctrl + S.
Correct Answer:
A
— Ctrl + S
Learn More →
Q. In Microsoft Word, which shortcut key is used to save a document? (2023)
A.
Ctrl + S
B.
Ctrl + P
C.
Ctrl + C
D.
Ctrl + V
Show solution
Solution
The shortcut key 'Ctrl + S' is used to save a document in Microsoft Word.
Correct Answer:
A
— Ctrl + S
Learn More →
Q. In PowerPoint, how can you add a new slide?
A.
Right-click and select 'New Slide'
B.
Press Ctrl + N
C.
Click on 'Insert' then 'New Slide'
D.
All of the above
Show solution
Solution
You can add a new slide by right-clicking and selecting 'New Slide', pressing Ctrl + N, or clicking on 'Insert' then 'New Slide'.
Correct Answer:
D
— All of the above
Learn More →
Q. In PowerPoint, how can you insert a new slide?
A.
Right-click and select New Slide
B.
Press Ctrl + N
C.
Click on the Insert tab
D.
Click on the Home tab and select New Slide
Show solution
Solution
You can insert a new slide by clicking on the Home tab and selecting New Slide.
Correct Answer:
D
— Click on the Home tab and select New Slide
Learn More →
Q. In PowerPoint, what is the purpose of a slide master? (2023)
A.
To create animations
B.
To manage slide layouts
C.
To insert images
D.
To add audio
Show solution
Solution
A slide master is used to manage slide layouts and design elements across multiple slides.
Correct Answer:
B
— To manage slide layouts
Learn More →
Q. In PowerPoint, what is the purpose of the 'Slide Master'?
A.
To create a new presentation
B.
To edit individual slides
C.
To set a uniform style for all slides
D.
To add transitions
Show solution
Solution
The purpose of the 'Slide Master' in PowerPoint is to set a uniform style for all slides.
Correct Answer:
C
— To set a uniform style for all slides
Learn More →
Q. In PowerPoint, which feature allows you to add transitions between slides?
A.
Animations
B.
Design
C.
Transitions
D.
Insert
Show solution
Solution
The Transitions feature in PowerPoint allows you to add transitions between slides.
Correct Answer:
C
— Transitions
Learn More →
Q. In PowerPoint, which option allows you to change the design of all slides at once?
A.
Slide Master
B.
Layout
C.
Design
D.
Transitions
Show solution
Solution
The Slide Master option allows you to change the design of all slides at once in PowerPoint.
Correct Answer:
A
— Slide Master
Learn More →
Q. In PowerPoint, which view is best for adding animations to slides?
A.
Slide Sorter
B.
Normal View
C.
Reading View
D.
Slide Show
Show solution
Solution
Normal View is the best for adding animations to slides in PowerPoint.
Correct Answer:
B
— Normal View
Learn More →
Q. In PowerPoint, which view is used to see the presentation as it will appear to the audience? (2023)
A.
Slide Sorter
B.
Normal View
C.
Slide Show
D.
Outline View
Show solution
Solution
The 'Slide Show' view is used to see the presentation as it will appear to the audience.
Correct Answer:
C
— Slide Show
Learn More →
Q. In Word, what feature allows you to create a list of references at the end of your document?
A.
Table of Contents
B.
Bibliography
C.
Index
D.
Footnotes
Show solution
Solution
The Bibliography feature allows you to create a list of references at the end of your Word document.
Correct Answer:
B
— Bibliography
Learn More →
Q. In Word, which feature allows you to create a list of references at the end of your document?
A.
Table of Contents
B.
Bibliography
C.
Index
D.
Footnotes
Show solution
Solution
The Bibliography feature allows you to create a list of references at the end of your document in Word.
Correct Answer:
B
— Bibliography
Learn More →
Q. In Word, which option is used to check the spelling and grammar of a document?
A.
Review
B.
Home
C.
Insert
D.
Layout
Show solution
Solution
The Review tab is used to check the spelling and grammar of a document in Word.
Correct Answer:
A
— Review
Learn More →
Q. In Word, which tab would you use to change the font style?
A.
Home
B.
Insert
C.
Layout
D.
Review
Show solution
Solution
To change the font style in Word, you would use the Home tab.
Correct Answer:
A
— Home
Learn More →
Q. In Word, which tab would you use to change the page orientation?
A.
Home
B.
Insert
C.
Layout
D.
Review
Show solution
Solution
You would use the Layout tab to change the page orientation in Word.
Correct Answer:
C
— Layout
Learn More →
Q. In Word, which tab would you use to insert a table? (2023)
A.
Home
B.
Insert
C.
Design
D.
Layout
Show solution
Solution
You would use the 'Insert' tab to insert a table in Word.
Correct Answer:
B
— Insert
Learn More →
Q. What feature in Excel allows you to automatically fill a series of cells? (2023)
A.
AutoFill
B.
Fill Handle
C.
Series Fill
D.
Cell Fill
Show solution
Solution
The Fill Handle is a feature in Excel that allows you to automatically fill a series of cells.
Correct Answer:
B
— Fill Handle
Learn More →
Q. What is the default file extension for a PowerPoint presentation? (2023)
A.
.ppt
B.
.pptx
C.
.docx
D.
.xlsx
Show solution
Solution
The default file extension for a PowerPoint presentation is '.pptx'.
Correct Answer:
B
— .pptx
Learn More →
Q. What is the default file extension for a Word document? (2023)
A.
.doc
B.
.docx
C.
.txt
D.
.pdf
Show solution
Solution
The default file extension for a Word document is .docx since Word 2007.
Correct Answer:
B
— .docx
Learn More →
Q. What is the maximum number of rows in a single Excel worksheet? (2023)
A.
65,536
B.
1,048,576
C.
32,768
D.
256
Show solution
Solution
The maximum number of rows in a single Excel worksheet is 1,048,576.
Correct Answer:
B
— 1,048,576
Learn More →
Showing 1 to 30 of 41 (2 Pages)
MS Office - Word, Excel, PowerPoint Basics MCQ & Objective Questions
Understanding the basics of MS Office, including Word, Excel, and PowerPoint, is crucial for students preparing for exams. Mastering these tools not only enhances your productivity but also plays a significant role in scoring better in objective assessments. Practicing MCQs and objective questions related to MS Office helps reinforce your knowledge and boosts your confidence during exam preparation.
What You Will Practise Here
Key features and functionalities of MS Word, including formatting and editing tools.
Basic formulas and functions in MS Excel, such as SUM, AVERAGE, and IF statements.
Creating and designing effective presentations in MS PowerPoint.
Understanding the interface and navigation of MS Office applications.
Common shortcuts and tips to enhance efficiency in MS Office.
Practical applications of MS Office in academic and professional settings.
Exam Relevance
The knowledge of MS Office basics is frequently tested in various examinations, including CBSE, State Boards, and competitive exams like NEET and JEE. Students can expect questions that assess their understanding of software functionalities, practical applications, and problem-solving skills using MS Office tools. Common question patterns include scenario-based queries and direct application of features in objective formats.
Common Mistakes Students Make
Confusing similar functions in Excel, such as VLOOKUP and HLOOKUP.
Overlooking formatting options in Word, leading to poorly presented documents.
Neglecting to save presentations in the correct format in PowerPoint.
Misunderstanding the purpose of certain Excel functions, resulting in incorrect calculations.
FAQs
Question: What are the most important MS Office - Word, Excel, PowerPoint Basics MCQ questions for exams?Answer: Important questions often focus on the functionalities of each application, practical scenarios, and shortcuts that enhance productivity.
Question: How can I improve my understanding of MS Office for exams?Answer: Regular practice with objective questions and MCQs will help solidify your understanding and prepare you for exam scenarios.
Start solving practice MCQs today to test your understanding of MS Office - Word, Excel, PowerPoint Basics. This will not only prepare you for your exams but also equip you with essential skills for your academic and professional journey!
