Font size
WorksheetsRemedial exam
Total questions: 111
Worksheet time: 58mins
Reg No in full
Which of the following is the second step in creating a macro?
A) Start recording
B) Using your mouse or keyboard, perform the task you want to automate
C) Assign a keyboard shortcut to the macro
D) Give the macro a name
A character that is raised and smaller above the baseline is known as
A) Outlined
B) Raised
C) Superscript
D) Subscript
Which file starts MS Word?
A) Winword.exe
B) Word.exe
C) Msword.exe
D) Word2003.exe
A ... is a specially formatted text that can be also be used as a Title of a document.
watermark
WordArt
wrap wext
Word Layout
The paragraph shown in ...
centre aligned
fully justified
left aligned
right aligned
Which of the following describes formatting done on the letter "O" in the paragraph shown?
Drop Caps
Drop Character
DropHat
Drop Text
Which is the correct keyboard shortcut to open a document?
Alt + P
Shift + O
Ctrl + N
Ctrl + O
Background color or effects applied on a document is not visible in
A) Web layout view
B) Print Layout view
C) Reading View
D) Print Preview
Which menu or tab contains the command to show or hide the ruler?
Insert
View
File
Format
What is the keyboard shortcut for Copy?
CTRL+C
CTRL+A
CTRL+V
CTRL+P
Portrait and Landscape are
A) Page Orientation
B) Paper Size
C) Page Layout
D) All of above
Which file extension is correct for a Word document?
.jpg
.pptx
.xlsx
.doc
The following options are example of font style, except?
Underline
Italic
Border
Bold
What is the default left margin in Word 2003 document?
A) 1"
B) 1.25"
C) 1.5"
D) 2"
. Which option is not available in Insert Table Autofit behavior?
A) Fixed Column Width
B) AutoFit to Contents
C) Autofit to Window
D ) Autofit to Column
25. Which of the following is not available on the Ruler of MS Word screen?
A) Tab stop box
B) Left Indent
C) Right Indent
D) Center Indent
. . _______ is used to covert from upper case to lower case and vice versa.
A. Toggle case
B. Sentence case
C. Lower case
D. Upper case
. The keystrokes Ctrl + I is used to
A) Increase font size
B) Inserts a line break
C) Indicate the text should be bold
D) Applies italic format to selected text
1. What company owns PowerPoint?
Apple
Microsoft
Nokia
None of the above
2. What is the proposed name for the presentation software before being changed into "PowerPoint"?
Presenter
Present
Presentation
Slide Share Tool
Making your presentation more interesting through the use of multimedia can help to improve the audience's ________.
Appetite
Eyesight
Focus
Talent
Times New Roman is an example of _____ typeface.
Serif
San Serif
Font
None of the above
These are distinguished by their lack of any serifs.
Serif
San Serif
Font
None of the above
A lot of text is good for a presentation
True
False
______ are important for better view of your slides. They should never ever overpower the words or information you are trying to present.
Fonts
Typefaces
Color
Background
The ____ and background should compliment each other and be easy to read through contrast and color.
Images
Color
Text
Font
Tab where you can find typefaces/fonts, change the size of text, and modify slides.
Home
Insert
Transition
Animation
Tab where you can check for presentation Views, Master Views, and show ruler, gridlines, guides and notes.
Slide Show
Review
Animation
View
Nikko will present their group report about the Life Cycle of a Butterfly. For him not to forget his explanation of the topic, to which part of the PowerPoint can he input all his ideas?
Slide Pane
Notes
Slide Navigation Pane
Ribbon
To play a slide of the presentation, which shortcut key should you press?
Shift + 5
Shift + 4
Shift + F2
Shift + F5
Michael wants to use laser pointers on his slide show presentation. Which slide show control should he click?
Microsoft PowerPoint is commonly used for ____.
It is used for video uploading and watching.
It is used for making spreadsheet programs to input data.
It is used to make and write essays for word processing.
It is used for making and presenting slide shows.
Noel is tasked to make a presentation that will propose their new products to the board member. Which application should he use?
What should you do to make your presentation more appealing to the audience?
Make your slides more colorful and add your pictures.
Fill your slides with pictures and graphics.
Add enough graphics and fewer texts.
Add more texts and drawings.
Which of the following situations shows a convenient way to lessen the size of the presentation?
Nikki fills her slide with large images and shapes.
Nina inserts an audio file for her music assignment.
Nick embeds a video about states of matter for his report.
Nicole adds a movie to her presentation as an example of her topic.
Joan embeds a YouTube Video in her PowerPoint to make it more entertaining. The underlined word is an example of ____.
Illustrations
Images
Media File
SmartArt
If you wish to add a table to your presentation, which part of the PowerPoint should you click?
Black
Green
Red
Blue
Mario can design his presentation in the _____.
Black
Green
Blue
Red
Special effects used to introduce slides in a presentation are called
effects
custom animations
transitions
present animations
What type of software is MS-PowerPoint considered to be?
Word Processing
Spreadsheet
Database
Presentation
How would I insert a text-box into a slide within my presentation?
Go to the 'insert' tab across to the 'text' link and select the 'textbox' option.
Go to the 'insert' tab across to the 'images' link and select the 'textbox' option.
Go to the 'home' tab across to the 'text' link and select the 'textbox' option.
Go to the 'insert' tab across to the 'text' link and select the 'wordart' option.
What instruction would I give the computer if I wanted to copy the same power-point slide again and again?
New Slide
Delete Slide
Duplicate Slide
Layout Slide
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
2. What tab do you click on to add a picture?
Home
Design
Insert
File
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 to save your file?
save as
save
open
export
How would you add a 'new slide' to your presentation?
Select the 'insert' tab then the drop-down arrow under the new slide option & make your selection.
Select the 'design' tab then the drop-down arrow under the new slide option & make your selection.Se
Select the 'Home' tab then select the drop-down arrow under the new slide option & make your selection.
Select the 'slide-show' tab then the drop-down arrow under the new slide option & make your selection.
MS-PowerPoint is a ____________software.
Documentation
Word Processor
Presentation
Spreadsheet
.pp is the file file extension of MS-PowerPoint files.
True
False
____________is a single unit of a PowerPoint Presentation.
Layout
Slide
View
Animation
________bar shows the name of the presentation.
Quick access toolbar
Title
Status
Name
Home tab contains the option for saving a Presentation.
True
False
_________is the shortcut to insert a new slide.
Ctrl+M
Ctrl+N
Ctrl+O
Ctrl+S
________-button is used to exit from the PowerPoint Application.
Ctrl
Alt
Close
Quit
Collection of slides is called Presentation.
False
True
A slide can only contain text and not images,audio,video,etc.
False
True
Name the highlighted bar shown in the image.
Status bar
Title bar
Scroll bar
Quick Access toolbar
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
The function COUNTA is used for counting cells that contain
numbers and logical values only
text, numbers and logical values only
text, numbers, logical values and error values only
text, numbers, logical values, error values, and empty text (" ")
What function is used to find the lowest data ?
MIN
MAX
SUM
AVERAGE
What function Is used to find the highest data ?
SUM
MIN
MAX
AVERAGE
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
@
=
'
#
The function COUNT is specific for counting _________________
text
numbers
cells
tables
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
row
column
label
cell address
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
In a worksheet, the vertical spaces with the headings A, B, C and so on
row
column
label
cell address
The function that allows you to combine text from different cells into one cell
CONCAT
COMBIN
COUNTA
COUNTIF
_______________ automatically fills your data when it senses a pattern
Copy cells
Fill formatting only
Fill without formatting
Flash fill
The Hyperlink function is used to create links to _______________________.
workbook locations
pages on the internet
files on network servers
all of the above
The Filter function icon can be found in _____________ tab.
Home
Insert
Data
View
The ______________ function is used to determine how many pupils were able to get a passing score in a test.
COUNT
COUNTA
COUNTIF
COUNTBLANK
A computer application that displays and organizes data is called __________.
PowerPoint Presentation
Publisher
Electronic Spreadsheet
Word
The rows in the spreadsheet represents the ___________.
Numbers
Letters
Vowels
Consonants
The columns represent the ____________.
Rows
Numbers
Letters
Columns
This is the intersection point of a column and row.
Cell Address
Cell Number
Cell
Cell Sheet
An individual box which contains data.
Cell Address
Cell Sheet
Cell
Cell Number
All of the following are the uses of MS Excel, EXCEPT:
Used for Calculations
Managing inventory
Presenting videos and audio
Collecting data from different sources
This is the file where data is stored in Excel.
Workbook
Folder
Worksheet
Publisher
Numeric data used in calculations is called _________.
Numeric
Value
Text
Formula
What do you call the entries that have no value associated with them?
Formula
Text
Value
Art
In which tab can you find the Merge and Center?
(a)
