Font size
WorksheetsFinal Exam in ICT (BSMT IA/IB/IC)
Total questions: 69
Worksheet time: 38mins
Reg No in full
What application is used to create, edit, and print documents?
MS Word
MS Excel
What tool in MS Word is this?
Format Painter
Brush
What is the short cut key for New document?
Ctrl + O
Ctrl + N
What do you call the hidden tabs that only pops out when an object is selected?
Screen Tip
Contextual
What is the short cut key for this tool?
Ctrl + K
Ctrl + L
What is the short cut key for Paste?
Ctrl + C
Ctrl + V
Which type of document is best suited for MS Word?
Resume
Accounting Ledger
Which part of the MS GUI allows you to access common commands no matter which tab is selected?
Ribbon
Quick Access Toolbar
Which information can be found in the Status Bar?
Word Count
Font Styles
What key in the keyboard should be pressed to show the screen tips?
Alt
F12
What kind of software is Excel?
Spreadsheet Software
Database Software
Word processing Software
In Excel, rows are labeled by
Letters
Numbers
Letters and numbers
In Excel, columns are labeled by
Letters
Numbers
Letters and numbers
Excel refers to files as
Databases
Workbook
Document
Where rows and columns meet are referred to as
Cells
Blocks
Boxes
When inserting a formula, always start with
-
*
+
=
To see what formulas are used in a cell, click on the
Formula button
Auto sum button
Math button
To allow you to evenly distribute a title over a table of numbers, use the
Center button
Merge and center button
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
Cells are identified by
Column Letter followed by their Row Number
Row Number followed by their Column Letter
Adding two cells,
A1+A3=SUM
SUM(_)
=SUM(A1+A3)
Total
Sum of all number divided by amount of number
maximum
median
minimum
average
___ are vertical
Row
Column
Excel spreadsheets that are already created and ready for you to edit are known as?
spreadsheets
data inputs
templates
pages
An arrow in bottom-right corner ot a group on the ribbon tells you that which of the following is available?
list of worksheets
dialog box
PMDAS stands for ___________.
Planes, Maps, Distance, Altitude, Slope
Points, Matrix, Diameter, Apex, Side
Parenthesis, Multiplicand, Divisor, Addition, Subtraction
Parenthesis, Multiplication, Division, Addition Subtraction
In solving a problem with series of operations, what operation you should perform first?
Division
Addition
Multiplication
Operation inside the parenthesis
What is the value of this expression?
54−30+(2×5)= ___________
50
40
30
20
208÷2−(6×3)= ___________
80
85
90
95
In 37+36÷3=n , what operation should be done first ?
Addition
Division
Any of the two
None
7+(5×3÷3) −6= _________
15
12
8
6
What operation should place in the blank to make the statement TRUE?
72÷9 ___ 4=4
×
−
÷
+
What number should place in the blank to make the statement TRUE?
45+6− ____ ÷3=42
30
29
28
27
(30÷5)+20−(5×3)= _________
10
11
12
13
"The product of 10 and 5 subtracted by the sum of 12 and 6 is _________."
32
42
52
None of the above
What does the button that is being pointed to let you do?
Change the size
Change the font
Add a new slide
Insert a picture
What tab do you click to change how the slides move?
Transitions
Home
Insert
Design
3. What tab do you click to change the background of your slide?
Design
Home
Insert
Transition
What does this button let you do?
Insert a picture
Insert Sound
Insert text
Insert shape
How do you animate your picture?
Click on Animation
Click on picture
click on design
Click on transition
How to save your file?
save as
save
open
export
What is the name of the graphic organizer that you can use to display information?
Word Art
Smart Art
Clipart
Bulleted List
To start a slide show using the keyboard, press _____
CTRL+S
CTRL+ENTER
F4
F5
The best way to get a slide show to stop is to:
Click STOP button
Exit PowerPoint
Press ESC
Tell the computer to STOP
When you apply a design template to a presentation, it will
be.
Applied along with another template to the same slide.
Applied to all slides.
Modified in slide show view.
None of the above.
In Microsoft Word, what would you see while spell checking the phratese "My Father is right".
There is grammar error
A red wavvy line underneat the word right "right" denotes a error in grammar
In the statement, "is" should be replaced with "was" to complete the sentence.
No errors.
