Font size
WorksheetsQuiz Microsoft Office
Total questions: 22
Worksheet time: 24mins
What is the main function of Microsoft Word?
Manage data
Create presentations
Create text documents
Edit images
In Microsoft Excel, the formula used to sum numbers in cells A1 to A5 is:
=A1+A5
=SUM(A1:A5)
=TOTAL(A1:A5)
=ADD(A1:A5)
What is the main purpose of Microsoft PowerPoint?
Manage databases
Create financial reports
Create slide presentations
Compose text documents
In Microsoft Word, to insert an image, you must select the menu:
Insert → Table
Home → Picture
Insert → Picture
View → Image
What file format is used by Microsoft Excel to save workbooks?
.pptx
.xlsx
.docx
In PowerPoint, the animation effect used to change transitions between slides is called:
Transition
Animation
In PowerPoint, the animation effect used to change transitions between slides is called:
Transition
Animation
Slide Show
Insert
What is meant by cell in Microsoft Excel?
Rows and columns
Only rows
Only columns
The intersection of rows and columns
In Microsoft Word, to add page numbers to a document, we can use the menu:
Page Layout
References
Insert
View
The function of Microsoft Access is to:
Create documents
Create spreadsheets
Manage and organize data in a database
Create presentations
How to format text to bold in Microsoft Word?
Ctrl + I
Ctrl + B
Ctrl + U
Ctrl + T
In Microsoft Excel, to display formulas in a cell, we can use the button:
F1
F2
F3
F4
What is the function of the 'SmartArt' feature in Microsoft PowerPoint?
Add graphics
Create dynamic images
Arrange text in the form of diagrams or graphics
Add sound to slides
If you want to change the number format in Excel to currency, you can use the format option:
(a)
If you want to change the number format in Excel to currency, you can use the format option:
Currency
Text
Number
General
In Microsoft Word, the shortcut to open a new document is:
Ctrl + N
Ctrl + O
Ctrl + P
Ctrl + S
In PowerPoint, what is the function of the 'Slide Sorter' feature?
Display slides in order
Add animations
Insert graphics
Edit text on slides
Explain the difference between Microsoft Word and Microsoft Excel!
How to create a chart in Microsoft Excel? Explain the steps.
What is meant by 'slide master' in PowerPoint and how to use it?
In Microsoft Word, how to create an automatic table of contents? Explain with clear steps.
Microsoft Excel has SUM and AVERAGE functions. Explain the difference between these two functions and provide examples of their use.
