NEW
Font size
WorksheetsReview Quiz TLE ICT
Total questions: 60
Worksheet time: 30mins
It is an application that allows users to create, edit, and print documents.
Word Processor
Spreadsheet
Slide Presentation
Database
One of the most widely used word processors.
MS PowerPoint
MS Word
MS Excel
Java
It is a user interface element which was introduced by Microsoft.
Tab
Status bar
Ribbon
Scroll bars
It is the default tab in Microsoft Word. It has five groups of related commands: Clipboard, Font, Paragraph, Styles, and Editing.
File Tab
Insert Tab
View Tab
Home Tab
It allows you to access the Open, Save, Close, Properties, and Recent file options. This is also where you can save, share, and print your document.
File Tab
View Tab
Home Tab
Insert Tab
It is used to insert or add features in your document. It is used to add charts, tables, pictures, clipart, shapes, page number, etc.
View Tab
Insert Tab
File Tab
Home Tab
This tab is used to format your document like page border and page color.
Layout Tab
File Tab
Design Tab
Insert Tab
It provides access to common commands such as undo, redo, save, and start from the beginning.
Title bar
Colors
Font
Quick Access
This displays the name of the current open document, when opening a new file is always displays Document1 (or 2, 3, 4 etc.) until you save and name the file.
Title bar
Font
Colors
Ruler
This displays the page number, page count, document view buttons, and zoom control.
Font
Status bar
Ruler
Color
Displays a list of all the available colors and lets you change the color component of the active theme.
Font Size
Font Color
Colors
Fill Colors
Displays a list of all the available fonts and lets you change the font component of the active theme.
Fill Colors
Colors
Group
Font
The text color shows grammatical error.
Blue wavy color
Orange wavy color
Red wavy color
Green wavy color
The text color shows spelling error.
Orange wavy color
Red wavy color
Green wavy color
Blue wavy color
A keyboard shortcut used to save documents.
CTRL + A
CTRL + B
CTRL + S
CTRL + Z
A keyboard shortcut is used to copy a selected text or object.
CTRL + F
CTRL + D
CTRL + V
CTRL + C
A keyboard shortcut is used to paste a selected text or object.
CTRL + S
CTRL + U
CTRL + C
CTRL + V
A shortcut key used to boldface a font.
CTRL + L
CTRL + O
CTRL + B
CTRL + R
A shortcut key is used to align center the selected text or object.
CTRL + S
CTRL + E
CTRL + N
CTRL + P
A keyboard shortcut to cut a selected text or object.
CTRL + X
CTRL + O
CTRL + B
CTRL + R
21. Identify the part of the MS Word Ribbon presented as pointed by an arrow.
Cut
Paste
Copy
Font Size
22. Identify the part of the MS Word Ribbon presented as pointed by an arrow.
Copy
Font size
Paste
Font Color
23. Identify the part of the MS Word Ribbon presented as pointed by an arrow.
Alignment
Font size
Copy
Underline
24. Identify the part of the MS Word Ribbon presented as pointed by an arrow.
Underline
Superscript
Increase font size
Font size
25. Identify the part of the MS Word Ribbon presented as pointed by an arrow.
Boldface
Copy
Underline
Font Color
26. Identify the part of the MS Word Ribbon presented as pointed by an arrow. Select your answer on the choices provided below. Write the letter of your choice.
Superscript
Subscript
Font size
Copy
27. Identify the part of the MS Word Ribbon presented as pointed by an arrow. Select your answer on the choices provided below. Write the letter of your choice.
Boldface
Underline
Strikethrough
Font color
28. Identify the part of the MS Word Ribbon presented as pointed by an arrow. Select your answer on the choices provided below. Write the letter of your choice.
Paste
Cut
Increase font size
Decrease font size
29 . Identify the part of the MS Word Ribbon presented as pointed by an arrow. Select your answer on the choices provided below. Write the letter of your choice.
Superscript
Underline
Alignment
Copy
30. Identify the part of the MS Word Ribbon presented as pointed by an arrow. Select your answer on the choices provided below. Write the letter of your choice.
Copy
Cut
Paste
Font color
It is represented by letters
Cell
Row heading
Asterisk
Column heading
It is represented by numbers
Asterisk
Cell
Row heading
Equal sign
The intersection of row and column.
Fill handle
Cell
Equal sign
Sum function
What feature in Excel allows users to quickly copy formulas or data?
Fill handle
Equal sign
Cell
Ampersand (&)
Which arithmetic operator in Excel is used for multiplication?
Cell
Asterisk (*)
Colon (;)
Equal sign (=)
Which symbol is used to concatenate or join two or more text strings?
Equal sign
Ampersand
Semi colon (;)
Asterisk
The first part of an excel formula that tells Excel to perform calculations.
Asterisk
Equal sign
Colon
Cell
Adds values in a specified range.
QUOTIENT
PRODUCT
SUM
POWER
Return the average of a set of values.
SUM
SUM
POWER
AVERAGE
An example of a reference operator.
Colon
Asterisk
Minus sign
Plus sign
What is the cell reference of Jenifer’s grade in Math?
A. E2
B. C2
C. D2
D. A2
Which is the correct formula?
SUM(B3:B4)
PRODUCT(B3:B4)
=SUM(C4:C7)
QUOTIENT(D4:D7)
What is the cell reference of the total score in English?
C. C3
B. F3
C. D3
D. A3
Which of the following is the cell reference of science subject.
B4
C4
D4
A4
Which is the correct formula to add 353 and 343?
(353+343)
=SUM(F2:F3)
(F2+F3)
(F3+F2)
Which is the correct formula to multiply 76 and 78?
=(D3*E6)
=(D3+E6)
=(D3-E6)
=PRODUCT(D3,E6)
Which is the correct formula to add or sum up the score of all students in Economics.
=SUM(B1:E1)
=SUM(B5:E5)
=SUM(B2:B6)
=PRODUCT(B5:E5)
Which is the correct formula to find the average score of Harry.
=Average(D2:D6)
=Average(B4:E4)
=Quotient(D2:D6)
=Sum(D2:D6)
Which is the correct formula to multiply Jenifer score in Math and Economics.
=Product(B2,B5)
=Product(C2,C5)
=Product(E2,E5)
=Product(E1:E5)
Which is the correct formula to divide the score of Ron in Science to John’s score in English.
=Quotient(C4,B3)
=Product(C4,B3)
=Sum(C4,B3)
=Quotient(B5,C3)
Which is the correct formula to find the largest score in Accounts.
=Count(B6:E6)
=Max(B6:E6)
=Min(B6:E6)
=IF(B6:E6)
What Microsoft application which primarily purpose of is to perform calculations such as addition and subtraction?
Microsoft Excel formula always begins of what symbol?
=
What is the total number of rows available in an Excel spreadsheet?
1,000,000
500,000
2,000,000
1,048,576
What is the maximum number of columns available in an Excel spreadsheet?
16,384
1,024
4,096
What arithmetic operator in Excel is used to perform division?
In Excel, quotient function is used to perform what type calculations?
Division calculations
Addition calculations
In Excel, MAX function is used to find the what number in a series of cell references?
In Excel, MIN function is used to find the what number in a series of cell references?
In Excel, what function is used to find the total number of entries in a range of cells?
COUNT
