WorksheetsQuiz Microsoft Word dan Excel
Total questions: 31
Worksheet time: 16mins
What is the main function of Microsoft Word?
Processing numbers
Processing presentations
Processing text documents
Processing databases
What is the shortcut to save a document?
Ctrl + P
Ctrl + S
Ctrl + O
Ctrl + N
What shortcut is used to make text bold?
Ctrl + I
Ctrl + U
Ctrl + B
Ctrl + T
Which menu is used to set page margins?
Insert
Home
Layout
Review
What feature is used to display page numbers?
Header
Footer
Page Number
Watermark
What is the function of Mail Merge?
Merging tables
Merging letters and recipient data
Merging images
Merging paragraphs
Which menu is used to create an automatic table of contents?
Insert
Home
References
Review
What is the shortcut for justify text?
Ctrl + L
Ctrl + R
Ctrl + E
Ctrl + J
What is the function of Track Changes?
Locking documents
Tracking document changes
Automatically deleting text
Saving document versions
What is the default file format for Microsoft Word?
.doc
.docx
.txt
Which menu is used to insert an image?
Home
Insert
Layout
View
Which menu is used to set line spacing?
Paragraph
Font
Styles
Editing
What is the function of Header and Footer?
Saving documents
Displaying information at the top and bottom of the page
Setting paper size
Editing tables
What is the shortcut to open a new document?
Ctrl + N
Ctrl + O
Ctrl + S
Ctrl + P
What is a watermark typically used for?
Providing a background for text
Deleting text
Setting margins
Editing tables
What is the main function of Microsoft Excel?
Processing text
Processing numbers and data
Processing images
Processing videos
What is the main function of Microsoft Excel?
Processing text
Processing numbers and data
Processing images
Processing video
The intersection of a row and a column is called?
Range
Cell
Sheet
Table
The formula to sum cells A1 to A5 is?
=ADD(A1:A5)
=TOTAL(A1:A5)
=SUM(A1:A5)
=COUNT(A1:A5)
The initial symbol of a formula in Excel is?
+
=
@
#
The IF function is used to?
Count numbers
Test logical conditions
Combine text
Sort data
The COUNT function is used to?
Count all cells
Count cells containing numbers
Count empty cells
Count text
The $ sign in an Excel formula functions to?
Lock cell reference
Delete cell
Change format
Calculate automatically
To create a chart, use the menu?
Data
Review
Insert
Formulas
The AVERAGE function is used to?
Find the largest value
Find the smallest value
Calculate the average
Calculate the sum
The MAX function is used to?
Smallest value
Largest value
Average value
Median value
The MIN function is used to?
Largest value
Smallest value
Data sum
Data count
The shortcut to save an Excel file is?
Ctrl + P
Ctrl + O
Ctrl + S
Ctrl + N
Excel files have the extension?
.docx
.pptx
.xlsx
To sort data, use the feature?
Filter
Sort
Conditional Formatting
Freeze Pane
Conditional Formatting is used to?
Change cell content
Format based on conditions
Delete data
Hide columns
