0% found this document useful (0 votes)
192 views63 pages

Answer Key MS OFFICE

Download as pdf or txt
Download as pdf or txt
Download as pdf or txt
You are on page 1/ 63

OFFICE

PRODUCTIVITY

ANSWER KEY

Computer Literacy Worktext


PART

Two

Microsoft
Word
Office Basics Chapter Test
Chapter 1
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which likely to happen when you clicked the start button and selected a program?
a. The selected program closes. c. The selected program opens a new window.
b. The selected program window remains open. d. The selected program automatically saves the data.
2. Which displays the name of the open file and the office program?
a. Quick Access Tool Bar c. Title Bar
b. Program Windows Control d. Status Bar
3. Which displays a menu of file commands?
a. File Tab Menu c. Quick Access Toolbar
b. Program Windows Control d. Status Bar
4. You are to use these buttons to minimize the program window, restore to full size or close the window.
a. File Tab Menu c. Quick Access Toolbar
b. Program Windows Control d. Status Bar
5. You are about to finish working on your English project. You wanted to print it but you don't know how. Which
office application can assist you to complete your task?
a. File Tab Menu c. Quick Access Toolbar
b. Program Windows Control d. Status Bar
6. Which describes the Quick Access Toolbar?
a. It offers quick assistance when you encounter problem with the program.
b. It offers a quick way to locate and execute commands.
c. It shows a command appearance and many of the same feature.
d. It offers quick access to save, undo and redo commands.
7. Which Microsoft command displays information
about the current worksheet or file?
Name:
a. Title Bar c. Status Bar
b. Quick Access Tool Bar d. Ribbon Year/Course: _________ Date:_________

8. Which likely happen when you accidentally click


the close button and failed to save your work yet?
a. Your work will be deleted immediately.
b. Your work will be eaten with virus.
c. The program prompt will appear asking you to
save it before exiting.
d. The program window will remain open.
9. You use this feature to zoom your view of a
document.
a. Work Area c. Zoom Control CK Childrens Publishing
b. Formula Bar d. Scroll Bar “Your Access to Visual Learning
and Integration”
10. You use this bar to type and edit formulas and
perform calculations in your worksheet.
Part
a. Work Area c. Zoom Control One
Common Office
b. Formula Bar d. Scroll Bar Features

Part 1 Common Office Features Chapter 1 Office Basics


11
Office Basics Chapter Test
Chapter 1
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. As you click the Customize Quick Access Toolbar button, the ribbon is displayed.
A. TRUE B. FALSE
2. The help window displays the article, enabling you to read more about the topic.
A. TRUE B. FALSE
3. You have to click the X to close a window.
A. TRUE B. FALSE
4. The ribbon offers quick access to save, undo or redo commands and appears on screen regardless of
what tab is currently shown.
A. TRUE B. FALSE
5. It is important to save your work before you close the program.
A. TRUE B. FALSE
6. The ribbon is used to minimize and maximize the window.
A. TRUE B. FALSE
7. The quick access toolbar displays the name of the open file and the office program.
A. TRUE B. FALSE
8. The status bar displays information about the current worksheet or file.
A. TRUE B. FALSE
9. The scroll bar is used to minimize or restore
the current document within the program
window. Name:
A. TRUE B. FALSE Level/Section: _________ Date:_________
10. Worksheet is an example of a work area.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
One
Common Office
Features

Part 1 Common Office Features Chapter 1 Office Basics


12
Working With Office Files Chapter Test
Chapter 2
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which is wrong in creating a file?
a) Click the type of file that you want to create. c) Click Print
b) Click the File tab d) Click Create
2. Lui would like to view two versions of a word document side by side to compare their contents in her computer. Which is
the best thing to do?
a) Select and drag the data to a new location.
b) Open two or more files, click the tab and click arrange all.
c) Click one side of the word and drag the cursor across the text.
d) Click the File tab and click Print.
3. Which is not a step in saving a file?
a) Click the File tab. c) Click Save or Save As
b) Click New d) Type a name for the file in the File name field.
4. The following steps are followed in opening a file that you have created and saved previously in order to continue
adding data or to edit existing data except.
a) In the navigation pane, click the library in which the file you want to open has been saved.
b) In the file list, locate and click the folder in which the file you want to open has been saved.
c) Click the name of the file that you want to open.
d) In the file list, navigate to the folder in which you want to save the file.
5. In performing different operations on data, such as deleting, changing its font or alignment, which step should be
followed?
a) Double click the word that you want to select. c) Click and drag the data to a new location.
b) Click the type of file that you want to create. d) On the Home tab, click the Paste button.
6. You use the Cut, Copy and Paste commands to ____________.
a) view multiple file at once
b) print office files
c) perform different operations on data Name:
d) move or copy data
7. _________________ allows you to store data for a period of Year/Course: _________ Date:_________
time for you to access to all the information stored in it.
a) Creating a New File c) Saving a File
b) Opening a File d) Printing a File
8. You can open the files that you have created and saved
previously in order to continue adding data or to edit
existing data.
a) Saving a File c) Creating a New File
b) Opening a File d) Selecting Data
9. You want to view two Excel workbooks to compare data.
a) Viewing Multiple Files c) Printing a File
CK Childrens Publishing
b) Opening a File d) Saving a File “Your Access to Visual Learning
and Integration”
10. In printing a file, a _____________ is connected to a
computer.
a) printer c) mouse Part
One
b) flash drive d) tab Common Office
Features

Part 1 Common Office Features Chapter 2 Working With Office Files


21
Working With Office Files Chapter Test
Chapter 2
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. You need to select the data that you want to cut or copy.
A. B. X
2. Printing a file definitely needs a printer that is disconnected to the computer.
A. B. X
3. To save the file you created, you simply click the page layout button.
A. B. X

4. When you click New, the Save As dialog box appears.


A. B. X
5. You can specify the number of copies to print using the copies spin box.

A. B. X

6. You can select text from the margin in Excel.


A. B. X

7. You can press Ctrl + V to paste data.


A. B. X

8. Ctrl + C is press to cut a data.


A. B. X
Name:
9. In order to copy a data, you press Ctrl + X. Level/Section: _________ Date:_________
A. B. X

10. You can split a log file into two scrollable


panes to view different parts of it.

A. B. X

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
One
Common Office
Features

Part 1 Common Office Features Chapter 2 Working With Office Files


22
Graphics Tools in Office Chapter Test
Chapter 3
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1) pre-made work art: ___________: : picture : photo
a) shape b) word art c) image d) clip art
2) _________: resize : : move : new location
a) drag inward - outward c) flip vertical - horizontal
b) drag handle d) drag crop handle
3) color adjustment : color button : : image correction : ____________
a) crop button c) correction setting button
b) color button d) effects button
4) word art object : click word art : : smart art : __________
a) click smart art c) click add shape
b) click crop d) click text box
5) __________: diagram : : interesting graphic : word art
a) smart art b) clip art c) shape art d) picture art
6) surround a graphic or picture with text : _____ : : interesting graphic : __
a) smart art - word art c) text wrapping - word art
b) text wrapping - clip art d) smart art - text wrapping
7) __: artistic effects to images : : ___: correction to clip art and images
a) artistic effect - cropping picture
b) artistic effect - image correction
c) picture effect - text effect
d) picture effect - copy picture Name:

8) smart art and word art : ________: :photos:________ Year/Course: _________ Date:_________
a) objects - pictures c) art - images
b) objects - graphics d) art - illustrations

9) crop : ____________ : : picture : effect :


___________
a) make corrections - adjust color tone
b) assign special interest effect - make corrections
c) remove vertical and horizontal edges - make
corrections
d) remove vertical or horizontal edges - assign
special interesting effect CK Childrens Publishing
10) _________: enhance images and clip art: “Your Access to Visual Learning
and Integration”
________: assign special effects to objects
a) text wrapping - cropping picture
b) image correction - color adjustments Part
One
c) picture effect - text wrapping Common Office
Features
d) artistic effect - picture effect

Part 1 Common Office Features Chapter 3 Graphics Tools in Office


33
Graphics Tools in Office Chapter Test
Chapter 3
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_______1. Word art is a new office tool.


A. TRUE B. FALSE
_______2. Colors apply artistic effects to images and clip art in order to enhance them.
A. TRUE B. FALSE
_______3. Text wrapping is an Excel feature that enables you to surround a picture with text.
A. TRUE B. FALSE
_______4. Artistic Effects is applied by clicking the picture that you want to edit.
A. TRUE B. FALSE
_______5. The image in a document can be resized or moved.
A. TRUE B. FALSE
_______6. Photoshop image editing features allow us to change and adjust color saturation, color tone and
recolor a picture.
A. TRUE B. FALSE

_______7. Tools in Artistic Effects are also found in Office 2007.


A. TRUE B. FALSE

_______8. The Word Art features can be used to create all kinds of diagrams to illustrate concepts in your
document.
A. TRUE B. FALSE Name:

_______9. Graphic organizer can be made using Smart Level/Section: _________ Date:_________
Art.
A. TRUE B. FALSE

_______10. Clip Arts can be searched from Office


Websites.

A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
One
Common Office
Features

Part 1 Common Office Features Chapter 3 Graphics Tools in Office


34
Starting Microsoft Word(MS Word) Chapter Test
Chapter 1
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which describes the Dialog Box Launcher?
a. It displays the document information.
b. It is the area where you type.
c. It contains buttons that perform the saving of document.
d. It is the button that opens the task pane and provides more
options.
2. All are Microsoft program except
a. Corel Draw b. Publisher c. Excel d. Word
3. What comes after you select Microsoft Office Word?
a. Saved document appears c. Close Icon appears
b. Blank document appears d. Snipping tool appears
4. Word makes typing easy. Which step should be followed in entering texts?
a. Type the text that you want to appear in the document.
b. Note the location of the insertion point.
c. Note the last visible line on screen.
d. Select the text.
5. Documents can be moved or copied. You move text by cutting and pasting it using these keyboard technique.
a. ctrl x and ctrl v c. ctrl x and ctrl y
b. ctrl c and ctrl v d. ctrl c and ctrl z

6. Which cannot be done using Microsoft Word?


a. Share text between documents c. Compute data
b. Move and copy text d. Undo changes
7. It is a multitasking software. It can open multiple
documents at the same time.
a. DOS c. Lotus Name:
b. Windows d. Kaspersky
Year/Course: _________ Date:_________
8. These are characters and symbols that are not found in
the keyboard. Which Microsoft feature allows you to
insert characters into your documents?
a. Inserting Symbol c. Sharing Text
b. Zooming In or Out d. Undoing Changes
9. Which Microsoft feature is useful in reversing actions
taken while working on a document?
a. Zooming In or Out c. Undoing Changes
b. Inserting Symbol d. Sharing Text

10. Which toolbar shows the program and document titles?


CK Childrens Publishing
“Your Access to Visual Learning
a. Scroll Bar c. Title Bar
and Integration”
b. Status Bar d. Access Toolbar

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 1 Starting Microsoft Word


47
Starting Microsoft Word (MS Word) Chapter Test
Chapter 1
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_________1. The ribbon displays the document information.


A. TRUE B. FALSE
_________2. The quick access toolbar appears in the lower right corner of a group of ribbon.
A. TRUE B. FALSE

_________3. In opening word, you have to click the close icon.


A. TRUE B. FALSE

_________4. The word window contains tools that you can use to work and create documents.
A. TRUE B. FALSE

_________5. Text can be removed from a document using delete or backspace.


A. TRUE B. FALSE

_________6. The backspace key reverses the effect of the last change made in the document.
A. TRUE B. FALSE

_________7. Text can be moved by dragging and dropping it to its new location.
A. TRUE B. FALSE

_________8. Word prompts to save before closing the document.


A. TRUE B. FALSE

_________9. Windows can open single document


Name:
at the same time.
A. TRUE B. FALSE Level/Section: _________ Date:_________

_________10. Zoom settings do not affect the


arrangement of text when you
print a document.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 1 Starting Microsoft Word


48
Starting Microsoft Word(MS Word) Chapter Test
Chapter 1
Directions : Label the parts of the Microsoft Word interface below. Choose from the
selections on the next page and answer it by shading the worksheet provided.

1. Ofce Icon

2.Quick Access Toolbar 3. Title Bar 4. Ribbon

Dialog Box
5. Launcher

Scroll Bar 6.

7. Document Area

8. Status Bar

Part 2 Microsoft Word Chapter 1 Starting Microsoft Word


49
Starting Microsoft Word (MS Word) Chapter Test
Chapter 1
Choices

1.
a. Office Icon b. Ribbon c. Title Bar d. Scroll Bar

2.
a. Ribbon b. Document Area c. Office Icon d. Quick Access ToolBar

3.
a. Ribbon b. Status Bar c. Title Bar d. Quick Access ToolBar

4.
a. Ribbon b. Document Area c. Title Bar d. Status Bar

5.
a. Ribbon b. Dialog Box Launcher c. Scroll Bar d. Quick Access ToolBar

6.6.
a. Ribbon b. Dialog Box Launcher c. Title Bar d. Scroll Bar

7.

a. Document Area c. Title Bar


b. Dialog Box Launcher d. Scroll Bar Name:
8. Year/Course: _________ Date:_________
a. Document Area c. Status Bar
b. Dialog Box Launcher d. Scroll Bar

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 1 Starting Microsoft Word


50
Formatting Text Chapter Test
Chapter 2
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Changing the font can help readers understand the document. Which step should be followed in changing
font?
a. Click the font color icon c. Click the font size pull down arrow
b. Click the font pull-down arrow d. Click anywhere outside the selection
2. It is a number, figure, symbol or indicator that appears smaller than the normal line of type.
a. Text Case c. Superscript or Subscript
b. Text Size d. Text Color
3. Which is correct?
a. Click Color Font Icon to change the color of the text. c. Click Font Size Icon to change the font.
b. Click Bold icon to assign a new case to the text. d. Click the Font Icon to change the size.
4. It is often used in the legal community to identify the text the reviewer proposes to delete.
a. Strikethrough formatting c. Superscript or Subscript
b. Text Case d. Text Color
5. Which should be the keyboard technique to double underline the text in your document?
a. CTRL+SHIFT+D c. SHIFT+D
b. CTRL+D d. CTRL+U
6. Which icon is helpful in changing the text color?
a. b. c. d.

7. Which is the first step in changing text case?


a. Click the change case icon. c. Click the home tab.
b. Select the text. d. Click close
8. Which appears faded in background when texts in
the document is selected? Name:
a. Word displays Year/Course: _________ Date:_________
b. Mini toolbar
c. Text Size Icon
d. Font Icon
9. You happen to click the strikethrough icon, which
possibly happens?
a. Cursor will not move
b. Text becomes smaller
c. Strikethrough formatting applied
d. Steps are repeated
10. These are used to insert trademark symbols.
CK Childrens Publishing
a. Strikethrough formatting “Your Access to Visual Learning
b. Bold, italics or underline and Integration”
c. Superscripting and subscripting
d. Font formatting
Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 2 Formatting Text


55
Formatting Text Chapter Test
Chapter 2
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

______1. Change case icon is used to underline a text.


A. TRUE B. FALSE
______2. Word is added in horizontal line at the middle of the selected text when subscripting.
A. TRUE B. FALSE
______3. The size of the text can be increased or decreased.
A. TRUE B. FALSE
______4. The home tab is clicked to use the ribbon in changing font.
A. TRUE B. FALSE
______5. It is necessary to click the close tab to continue working.
A. TRUE B. FALSE

______6. Color is effective in viewing a document on screen.


A. TRUE B. FALSE
______7. You can change the text case of the selected text by clicking the text size icon.
A. TRUE B. FALSE

______8. Clicking the home tab is the first step in formatting text.
A. TRUE B. FALSE
______9. Microsoft Word allows text formatting. Name:

A. TRUE B. FALSE Level/Section: _________ Date:_________

______10. Microsoft Word will still work without


installing the program in your
computer.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 2 Formatting Text


56
Proofreading Documents Chapter Test
Chapter 3
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which is the basic step in finding and replacing text?


a. Click Review Tab b. Click Home Tab c. Click File Tab d. Click Ok
2. While working on your English project, you noticed a wavy green underline in your work. What does it mean?
a. Possible spelling problems c. Possible grammatical problems
b. Text is substituted d. Find and replace window
3. Which describes the AutoCorrect feature?
a. Corrects common typing and spelling mistakes in a document
b. You can search for the misspelled words
c. Search and substitute the text
d. Checks spelling and grammar
4. The following describes spelling and grammar checker except
a. Correct spelling and grammar mistakes
b. Indicates possible grammatical error
c. Indicates possible spelling error
d. Indicates possible text substitution

5. Which function is used in searching misspelled words?


a. Spelling and Grammar Checker c. Finding a text icon
b. Auto Correct d. Replacing a text
6. It is Microsoft feature that allows substitution of words and phrases.
a. Finding Text c. Replacing a text
b. Correcting Grammar and Spelling d. Correcting Mistakes
7. The wavy red underlines indicate _________.
a) Possible grammar mistakes
b) Possible spelling problems Name:
c. Deleted texts
d. Closed Document Year/Course: _________ Date:_________
8. The following are the steps in correcting mistakes
automatically except.
a. Click the File Tab
b. Click Auto Correct Options
c. Click the Word Options
d. Click Review Tab
9. Which is not used in proofreading documents?
a. Changing the font
b. Replacing a text
c. Finding a text
d. Correcting Grammar
CK Childrens Publishing
10. Which is the basic command in correcting mistakes “Your Access to Visual Learning
automatically? and Integration”
a. Click the Word Options
b. Click the File Tab
Part
c. Click Auto Correction Options Two
Microsoft
d. Click Replace Word

Part 2 Microsoft Word Chapter 3 Proofreading Documents


61
Proofreading Documents Chapter Test
Chapter 3
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

________1. It is necessary to click the close button in searching files.


A. TRUE B. FALSE
________2. The word or phrase in a document can be selectively substituted.
A. TRUE B. FALSE
________3. Using the auto correct feature, you can search for the misspelled words and correct the spelling.
A. TRUE B. FALSE
________4. The cancel button in the find and replace window changes to close button.
A. TRUE B. FALSE
________5. When the replace button is clicked, word replaces the original word or phrase with the substitute.
A. TRUE B. FALSE
________6. To close the word option dialog box, the user should click the file tab.
A. TRUE B. FALSE
________7. Changing font size is among of the functions in proofreading a document.
A. TRUE B. FALSE
________8. You can click change to leave the selected word or phrase unchanged.
A. TRUE B. FALSE
________9. Using the AutoCorrect features, you can
add the corrections to the list of word
Name:
references.
A. TRUE B. FALSE Level/Section: _________ Date:_________

________10. Word does not identify a misspelling


when a word is correctly spelled but
misused.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 3 Proofreading Documents


62
Formatting Paragraph Chapter Test
Chapter 4
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
_______1. Which can be done in formatting paragraph?
a. Change text alignment c. Hide or display ruler
b. Create bulleted or numbered list d. Substitute word or phrase
_______2. Aligning the text in a paragraph is useful in organizing a document. Which is the first step in changing text
alignment?
a. Click the home tab c. Click alignment option
b. Select the text d. Click anywhere outside the selection
_______3. Teacher Jovit assigned the class to write a paragraph about your best friend. He instructed you on the double
space rule. How are you going to set the line space in your paragraph?
a. Select the lines of text, click the Home Tab and click the Line Spacing icon
b. Select the lines of text, click View Tab and click the ruler.
c. Select the lines of text, click the Home Tab and click the Paragraph icon
d. Select the lines of text, click the Home Tab and click the Alignment option.
_______4. You were working on a project in your school computer lab. Your teacher told you to indent the first line of your
paragraph. What is the best thing to do?
a. Click the Alignment Option c. Click the Numbering Icon
b. Click the Ruler d. Click the Indention box

_______5. It ensures that information lines up properly within a column.


a. Space Bar b. Tabs c. Enter Key d. Numbering Icon
_______6. The following are steps in creating a bulleted or numbered list except
a. Click the Numbering Icon c. Select the text
b. Click the Ruler d. Click the Home Tab
_______7. It helps the reader to follow information across
page.
a. Leader tabs c. Number icon
Name:
b. Space bar d. Ruler Year/Course: _________ Date:_________
_______8. It enhances the appearance of the document.
a. Line spacing icon c. Page icon
b. Text alignment d. Center tab
_______9. What happens after dragging the tab to the left
or right in formatting a paragraph?
a. Word automatically formats the entry.
b. A vertical line marks position as you drag
c. Word applies the setting to the selected
paragraph.
d. Word adds leading a character from the last
character.
CK Childrens Publishing
______10. You have to click the _____ to specify the “Your Access to Visual Learning
number of inches to indent in your paragraph. and Integration”

a. Number Icon
b. Indention Box
Part
c. Paragraph Icon Two
Microsoft
d. Alignment Option Word

Part 2 Microsoft Word Chapter 4 Formatting Paragraph


69
Formatting Paragraph Chapter Test
Chapter 4
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_______1. Word automatically displays the auto correct options button to undo or stop automatic
numbering as the spacebar or tab is pressed.
A. TRUE B. FALSE
_______2. The basic step in changing text alignment is selecting the text.
A. TRUE B. FALSE
_______3. The center icon aligns text with the right margin.
A. TRUE B. FALSE
_______4. The justifying icon aligns text with the right margin.
A. TRUE B. FALSE
_______5. Ruler can be used to indent paragraph or set tabs in the document.
A. TRUE B. FALSE
_______6. Upon clicking the line spacing icon, word applies the line spacing to the selected text.
A. TRUE B. FALSE
_______7. Word 2010 uses a different default line spacing than word 2003.
A. TRUE B. FALSE
_______8. The bullet icons will appear on the mini-toolbar when the numbering icon is clicked.
A. TRUE B. FALSE

_______9. Word places tabs every 15 inch across the


Name:
page between the left and right margins.
Level/Section: _________ Date:_________
A. TRUE B. FALSE

_______10. When you click the number icon, the text


moves with it.

A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 4 Formatting Paragraph


70
Working With Tables Chapter Test
Chapter 5
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which can be done in working with tables?


a. Change text alignment c. Resize a table
b. Create bulleted list d. Setting line space
2. Which is necessary to set up a table?
a. Click insert table c. Click delete rows
b. Click the layout tab d. Click insert right
3. If you found out that you have moved information in one cell, you can _______ the cell into 2 or more
columns.
a. Layout b. add c. merge d. split

4. _______ is the process of joining multiple cells in one larger cell.


a. adding b. deleting c. merging d. spliting
5. You can _________ columns to change the structure of a table to accommodate more information.
a. add b. delete c. merge d. split
6. Once the table is inserted in your document , you can _________ to adjust it.
a. Move b. Button c. Tab d. Enter
7. It is removing the column and any text it contained from the table.
a. Add color c. Delete a column
b. Merge cells d. Split cells
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

8. It is combining two or more cells to create one


large cell.
a. Add color c. Delete a column
b. Merge cells d. Split cells Name:

9. It is a grid of rows and columns costing boxes of Year/Course: _________ Date:_________


texts and graphs.
a. cell c. mouse
b. table d. Screen

10. You may _______a table to give room to a new


table design that suit better to your needs.
a. Add c. Delete
b. Merge d. Split

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 5 Working with Tables


77
Working With Tables Chapter Test
Chapter 5
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_______1. In deleting rows, word removes the row and any text it contained from the table.
A. TRUE B. FALSE

_______2. Word inserts a row and selects it when the layout tab is clicked.
A. TRUE B. FALSE

_______3. Word removes the table and its contents from a document if the delete rows is clicked.
A. TRUE B. FALSE
_______4. In creating a table, the mouse is dragged across the squares that represents the number
of rows and columns.
A. TRUE B. FALSE

_______5. Deleting a table means deleting its contents as well.

A. TRUE B. FALSE
_______6. Adding table columns is the exact opposite of merging table cells.
A. TRUE B. FALSE

_______7. Merging table cells is splitting into 2 or more columns or rows.

A. TRUE B. FALSE
_______8. Table can be resized from print layout
view. Name:

A. TRUE B. FALSE Level/Section: _________ Date:_________

_______9. Tables are in fix location in a document.

A. TRUE B. FALSE

_______10. Adding and deleting rows and


columns are possible with MS WORD.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 5 Working with Tables


78
Formatting Pages Chapter Test
Chapter 6
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which allows adjustment to the right, left and bottom margins of a document?
a. Page margin options c. Page number
b. Page orientation d. Page border
2. Marti is working on a brochure which his science teacher requires them. He wanted to create two columns
of texts in his brochure. Which could be done?
a. Click footer c. Select text
b. Click page border d. Click page layout
3. These are graphics or texts printed at the top of every page in a document.
a. tables b. headers c. fonts d. contents
4. Which is the first step in inserting table of contents?
a. Press + to place the insertion point at the top of the document. c. Click the reference tab.
b. Click table of contents layout. d. Click table of contents.
5. Ina added footer in her document. She followed all the steps. What likely happens after she clicked close
header and footer?
a. Word saves and redisplays the texts in your document
b. The table of contents gallery appears
c. Word applies the specified border
d. Word inserts table of contents
6. Which makes a way for a balanced and attractive layout?
a. Table b. header c. borders d. footer
7. These are the blank spaces around the edges of
the page.
a. Margins c. layout
b. borders d. headers Name:

8. The following are the steps in changing page Year/Course: _________ Date:_________
orientation except
a. Click anywhere in the document
b. Type a new margin setting
c. Click the page layout tab
d. Click orientation
9. What happens if you unintentionally click the page
number?
a. Page number options appear
b. Page number appears in the header and footer
c. Page number appears in the selected
formatting CK Childrens Publishing
d. Page number adjusts and formatting options “Your Access to Visual Learning
and Integration”
appear
10.Ilam wanted to add a page border in her
document. What should be clicked first? Part
Two
a. Page layout tab Microsoft
Word
b. Page borders
c. Click type of border
d. Click border line

Part 2 Microsoft Word Chapter 6 Formatting Pages


85
Formatting Pages Chapter Test
Chapter 6
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_________1. Borders separate and emphasize ideas.


A. TRUE B. FALSE
_________2. The page border tab is displayed when the page border is clicked.
A. TRUE B. FALSE
_________3. The table of contents should be done manually.
A. TRUE B. FALSE
_________4. Microsoft offers a variety of programs.
A. TRUE B. FALSE
_________5. You can click the line between line and column options.
A. TRUE B. FALSE
_________6. You can click or press the close button to scroll up and view the table of contents.
A. TRUE B. FALSE
_________7. Page orientation is the blank space around the edges of the page.
A. TRUE B. FALSE
_________8. The page number of the document can be in portrait or landscape.
A. TRUE B. FALSE
_________9. Word automatically print page numbers
Name:
on the pages of the document.
A. TRUE B. FALSE Level/Section: _________ Date:_________

_________10. You can resized a table in formatting


documents.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 6 Formatting Pages


86
Mass Mail and Printing Chapter Test
Chapter 7
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Creating a letter to mass mail is easy using a form letter and mailing list. Which icon is pressed so that the mail merge
button will appear on screen?
a) word document c)select recipients
b) margin tab d) edit recipients
2. There are many steps to follow in creating mass mails. Which step proceeds after the letter button is pressed.
a) word document c)select recipients
b) margin tab d) edit recipients
3. Which helps in speeding up the creation of a mass mail?
a) Add header and footer to a document c) Use form letter and mailing list
b) Add border around the page d) Preview the format
4. The following steps are followed in creating mass mail except
a) Click format to each recipients mail c) Click file counting the mails
b) Click a style for the border line d) Click select recipients

5. What happens when you click Edit Recipient List?


a) The mail merge recipients window appear
b) The insert address block dialog box appear
c) The select data source dialog box will appear
d) A merge field representing the greeting line appears in the letter.
6. Which appears on screen if the greeting line is pressed?
a) The mail merge recipients window appear
b) The insert address block dialog box appear
c) The insert greeting line dialog box appears
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

d) The select data source dialog box will appear

7. Which appears on screen if the greeting line is pressed?


a) The mail merger recipients window appear
Name:
b) The insert address block dialog box appears
c) The select data source dialog box will appear Year/Course: _________ Date:_________
d) The receive data source dialog box will appear

8. If you are to click the greeting line format, what appears


on the screen?
a) The insert address block dialog box appears
b) The select data source dialog box appears
c) A preview of the greeting appears.
d) The mail merger window appears

9. Which appears on the screen if you touch the edit


button?
a) The merge to new document dialog box appears
b) The insert address block dialog box appears CK Childrens Publishing
c) The select data source dialog box appears “Your Access to Visual Learning
d) A preview of greeting appears. and Integration”

10. Which is not possible in using mass mailing and


printing? Part
a) Make use of mail merge Two
Microsoft
b) Create letters to mass mail Word

c) Apply header and footer


d) Preview document before printing

Part 2 Microsoft Word Chapter 7 Mass Mail and Printing


91
Mass Mail and Printing Chapter Test
Chapter 7
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

______1. The insert address dialog box appears after clicking the greeting line.
A. TRUE B. FALSE
______2. You have to click the close button to exit from mass mail.
A. TRUE B. FALSE
______3. The preview results can be pressed to redisplay the merge fields.

A. TRUE B. FALSE
______4. After adding the merge fields, the recipients can be selected.
A. TRUE B. FALSE
______5. Excel merges the form letter with the mailing list information.
A. TRUE B. FALSE
______6. The current record options creates multiple letter for the recipients.
A. TRUE B. FALSE
______7. The letter cannot be merge directly to your printer and cannot be send as email messages.
A. TRUE B. FALSE
______8. Mail merge can be used in inserting page number.
A. TRUE B. FALSE
______9. The select data source appears on screen
after selecting recipients. Name:
A. TRUE B. FALSE Level/Section: _________ Date:_________
______10. A check box appears after editing the
recipient list.

A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Two
Microsoft
Word

Part 2 Microsoft Word Chapter 7 Mass Mail and Printing


92
PART

Three

Microsoft
Excel
The Basic of Microsoft Excel Chapter Test
Chapter 1
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. My mother owns a sari-sari store. She wants to keep daily inventory of her stocks. How can I help her?
a. I will help her organize an inventory worksheet using MS PowerPoint.
b. I will help her organize an inventory worksheet using MS Publisher.
c. I will help her organize an inventory worksheet using MS Excel
d. I will help her organize an inventory worksheet using MS Word
2. Your grandfather is very old but he wants to learn the basic computer commands. He wanted to learn MS Excel too.
What will you do?
a. Ignore your grand father c. Tell him to enroll ICT program
b. Tell him is very old to learn d. Help him familiarize the components of the Excel Program window
3. ____________: status information : : __________: file menu
a. worksheet – window frame c. file button – window frame
b. window frame – file button d. window frame – worksheet
4. view different worksheets: ________ : : ______________: title bar
a. worksheet tabs-name of the open workbook file c. worksheet tabs – formula bar
b. file menu – name of the open workbook file d. formula bar – file menu
5. active worksheet : __________ : : enter and edit formulas : __________
a. formula bar – appears highlighted c. file button – formula bar
b. appears highlighted – formula bar d. window frame – title bar
6. The excel program has many new tools that will help you accomplish your work except
a. Drop –Down Menus c. Mini bar
b. Galleries d. Mass Mail
7. Excel offers different views of worksheet, which step should be followed to change view?
a. Click the page layout view, page break preview and normal icon.
b. Click the start button, all programs and Microsoft
Office Excel
c. Click the page layout, close icon and yes to save Name:
d. Click the close icon and click yes to save
Year/Course: _________ Date:_________
8. Which describes Microsoft Excel?
a. It can store data in worksheets and workbooks.
b. It can create letter to Mass Mail.
c. It can format paragraph.
d. It can create table.
9. Which helps in making spreadsheet data easier to read
and interpret?
a. number crunching feature c. sharing data
b. data organizer d. formatting tools

10. The following are MS Excel functions except


a. sharing data c. formatting paragraph
b. organizing data d. presenting data CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 1 The Basics of Microsoft Excel


103
The Basic of Microsoft Excel Chapter Test
Chapter 1
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

______1. Workbooks are the data entered and stored in Excel.


A. TRUE B. FALSE
______2. Worksheet data can be shared in a mass mail.
A. TRUE B. FALSE
______3. The program window control allows the user to scroll the worksheet.
A. TRUE B. FALSE
______4. The active worksheet is used to view different worksheets.
A. TRUE B. FALSE
______5. The quick access toolbar displays the frequently used features.
A. TRUE B. FALSE
______6. When the Excel file button is clicked, it displays the file menu.
A. TRUE B. FALSE
______7. The worksheet consists of the sub and super script.
A. TRUE B. FALSE
______8. The formula bar displays the name of the file.
A. TRUE B. FALSE
______9. The formula bar performs calculations on Name:
worksheet data.
Level/Section: _________ Date:_________
A. TRUE B. FALSE
______10. The window frame displays the status
information of the file.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 1 The Basics of Microsoft Excel


104
Workbook Basics Chapter Test
Chapter 2
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which is the basic step in opening an existing workbook?
a. Click the file tab b. Click open c. click save or save us d. click New
2. Unwanted workbook oftentimes distracts attention and occupies disk space. Which steps are useful to permanently
remove the file without exiting the Excel program?
a. Click file tab, click save, type name for the workbook
b. Click file tab, click open, navigate the Excel file, press delete
c. Click file tab, click new, click blank workbook and click create
d. Click file tab, click open, click look – in and the name of the file
3. Miguel has a mini grocery. He keeps his inventory using Excel however one time, he forgot the file name and cannot
locate his work book so he decided to create another workbook and starts the work again. Later, he remembered the
file name but he has already the new one. He has no choice but to remove the old file. He followed the steps in
deleting a workbook. When he pressed delete something appeared on the screen. What could it be?
a. The normal window is displayed c. A new workbook windows appears
b. A confirm file delete box appears d. The open and save as dialog box appears
4. The following are the basic workbook features except.
a. Saving a workbook c. Proofreading a workbook
b. Starting a new workbook d. Opening an existing workbook
5. Closing unnecessary files frees up the processing power of the computer. Which command should be remembered in
closing a workbook?
a. Click close and the file tab icon c. Click close and create
b. Click close and type the name of file d. Click close and save as
6. Data can be reused or shared with others if you
a. Close a workbook b. Open an existing workbook c. start a workbook d. save a workbook
7. Which of the following is a command in deleting a workbook?
a. Click the file tab c. Click delete
b. Click blank workbook d. Click save or save as
8. The treasurer of the Student Body Organization was told
by the moderator to make a financial report. The Name:
president suggested that she will use the Excel program.
Year/Course: _________ Date:_________
Which steps she should follow creating the report?
a. Click file tab, click save, type name for the workbook
b. Click file tab, click open, navigate the Excel file, press
delete
c. Click file tab, click new, click blank workbook and click
create
d. Click file tab, click open, click look – in and the name
of the file
9. When does the workbook basic useful?
a. Creating a new workbook
b. Deleting unwanted workbook
c. Opening existing workbook
d. Proofreading a document CK Childrens Publishing
10. Which is the basic command in saving a workbook? “Your Access to Visual Learning
a. Click file tab, click save, type name for the workbook and Integration”
b. Click file tab, click open, navigate the Excel file, press
delete
c. Click file tab, click new, click blank workbook and click Part
Three
create Microsoft
Excel
d. Click file tab, click open, click look – in and the name
of the file

Part 3 Microsoft Excel Chapter 2 Workbook Basics


109
Workbook Basics Chapter Test
Chapter 2
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_______1. The arrow key is pulled down to navigate the folder to which the data is saved.
A. TRUE B. FALSE

_______2. Workbooks are the files created in Excel.


A. TRUE B. FALSE

_______3. A new workbook can be created by pressing control + N.


A. TRUE B. FALSE

_______4. Excel saves the workbook after typing the name of the workbook file without clicking the save
button.
A. TRUE B. FALSE
_______5. Excel opens a blank workbook containing 5 worksheets.
A. TRUE B. FALSE
_______6. The save as dialog box appears after pressing delete.
A. TRUE B. FALSE
_______7. The excel file is selected before deleting it.
A. TRUE B. FALSE
_______8. A unique filename can be use in naming your Excel file.
A. TRUE B. FALSE
Name:
_______9. You cannot open the workbook you
previously worked on once you close the Level/Section: _________ Date:_________
program.
A. TRUE B. FALSE

_______10. The save dialog box is useful in


accessing files.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 2 Workbook Basics


110
Entering Data Chapter Test
Chapter 3
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which Excel function allows you to change the size of the worksheet to accommodate the texts?
a. Entering data b. Resizing columns and rows c. Wrapping texts d. Selecting cells
2. Mistakes are inevitable, which Excel function allows you to change the wrong data entered in your worksheet?
a. Entering data b. Resizing columns and rows c. Editing data d. Selecting cells
3. Text wrapping makes the row size taller to fit the number of lines that wrap. Which steps should be followed in text
wrapping?
a. Position the mouse to pointer over the border, drag to desired size, release mouse button
b. Position the mouse arrow over the header, click column or row
c. Click the cell to edit, click home tap, click text wrap icon
d. Double click the cell containing the data to edit
4. The appearance of the worksheet can be improved by resizing the worksheet's columns and rows. Which steps should
be followed in resizing?
a. Position the mouse to pointer over the border, drag to desired size, release mouse button
b. Position the mouse arrow over the header, click column or row
c. Click the cell to edit, click home tap, click text wrap icon
d. Double click the cell containing the data to edit

5. The following are the steps in selecting cells except


a. Release the mouse button c. Double click the cell containing the data to edit.
b. Click the first cell in the range of cells d. Drag across the cells that are included in the range
6. The following are steps in entering data using the formula bar except
a. Type your data b. Click formula bar c. Click the cell to use d. Click the home tab
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

7. What happens after dragging the border to your desired size?


a. Excel applies text wrapping to the cell.
b. Excel enters the data in the worksheet.
c. The data appears in the formula bar and cell.
d. A dotted line marks the new border of the column and Name:
rows.
Year/Course: _________ Date:_________
8. What happens if the text wrap icon is clicked?
a. Excel applies text wrapping to the cell.
b. Excel enters the data in the worksheet.
c. The data appears in the formula bar and cell.
d. A dotted line marks the new border of the column and
rows.
9. Once the enter key is press after typing the data in the
formula bar, Excel automatically _____________.
a. applies text wrapping to the cell
b. enters the data in the worksheet
c. appears in the formula bar and cell
d. marks the new border of the column and rows
10. To select multiple columns or rows, it is necessary to CK Childrens Publishing
________. “Your Access to Visual Learning
a. drag across the column or row headings and Integration”
b. press and hold control
c. type over with new text
Part
d. click the backspace Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 3 Entering Data


115
Entering Data Chapter Test
Chapter 3
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_______1. Back space or delete characters are used to make corrections to data entries.
A. TRUE B. FALSE

_______2. The mouse and keyboard are not useful in selecting range.
A. TRUE B. FALSE

_______3. Columns are the group of cells in the worksheet that has to be selected.
A. TRUE B. FALSE

_______4. It is necessary to click the first cell in the range of cells to select.
A. TRUE B. FALSE

_______5. To select multiple columns or rows, the heading should be drag across.
A. TRUE B. FALSE

_______6. The active cell always appears highlighted with a darker border than the other.
A. TRUE B. FALSE

_______7. Text, row or column labels or numbers are called values in Excel.
A. TRUE B. FALSE

_______8. Numerical values are the only data that can be saved in Excel.
A. TRUE B. FALSE

_______9. In Excel, formulas are not values but


Name:
symbols.
A. TRUE B. FALSE Level/Section: _________ Date:_________

_______10. The data has to be saved to be


considered active data.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 3 Entering Data


116
Worksheets Chapter Test
Chapter 4
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. The following are methods in navigating worksheet except
a. using the mouse c. using the selecting commands
b. using the scroll bars d. using keyboard arrows and tab keys
2. Which mouse action selects any cells that are dragged across?
a. click a cell c. double-click a cell
b. click and drag across cells d. double-click a cell border
3. You wanted to navigate your worksheets using the keyboards. Which key should be used?
a. b. c. d.
4. Which worksheet navigation buttons scrolls to the previous sheet?
a. b. c. d.
5. Which worksheet navigation buttons scrolls to the first sheet in the workbook?
a. b. c. d.
6. __________: current cell : : __________: current worksheet
a. vertical scroll bar – horizontal scroll bar c. active cell – active worksheet
b. navigation buttons – view buttons d. vertical scroll bar – active cell

7. selects entire row : ________________: : selects entire column : __________


a. column letter – row number c. control + end – control + home
b. row number – column letter d. control + home – control + end
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

8. __________: move left to right : : ___________:


move up and down
Name:
a. active cell – active worksheet
b. navigation buttons – view buttons Year/Course: _________ Date:_________
c. vertical scroll bar – horizontal scroll bar
d. horizontal scroll bar – vertical scroll bar
9. page break view : ______________ : : move
worksheets: _____________
a. view buttons – navigation buttons
b. navigation buttons – view buttons
c. vertical scroll bar – horizontal scroll bar
d. horizontal scroll bar – vertical scroll bar
10. Which steps should be followed in adding a
worksheet?
a. Click the home tab, click insert and click insert CK Childrens Publishing
“Your Access to Visual Learning
sheet. and Integration”
b. Right click the worksheet tab and release the
mouse button.
c. Click the worksheet tab, press CTRL and drag the Part
Three
worksheet tab Microsoft
Excel
d. Click insert work sheet icon and type new name
for the worksheet

Part 3 Microsoft Excel Chapter 4 Worksheets


123
Worksheets Chapter Test
Chapter 4
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.
_____1. Consecutive columns can be selected by clicking the column letter.
A. TRUE B. FALSE
_____2. The vertical scroll bar moves the worksheet up and down.
A. TRUE B. FALSE
_____3. Excel deletes the worksheet after clicking the insert worksheet icon.
A. TRUE B. FALSE
_____4. The small black triangle icon keeps track of the sheet's location in the group while you drag.
A. TRUE B. FALSE
_____5. The worksheet can be copied within the work book.
A. TRUE B. FALSE
_____6. If the worksheet contains any data, excel prompts you to confirm deletion.
A. TRUE B. FALSE
_____7. The keyboard arrows can be used in moving large worksheets.
A. TRUE B. FALSE
_____8. The active worksheet can be moved using the view buttons.
A. TRUE B. FALSE
_____9. The page down key allows the cell to move
down. Name:
A. TRUE B. FALSE Level/Section: _________ Date:_________
_____10 . the mouse and the keyboard can be used
in navigating a worksheet.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 4 Worksheets


124
Formulas and Functions Chapter Test
Chapter 5
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. In calculating data, which controls how a formula group cells and ranges to perform calculations?
a. mathematical operators c. operators precedence
b. reference operators d. referencing cells
2. There are steps to follow using excel. Which are used in creating formulas?
a. Click the cell, type =, click the first cell, type the operator, click the next cell and enter.
b. Click the cell, insert function cycle, select a category, click function and Ok.
c. Click the cell, select the cell reference, press F4 and press enter.
d. Click the cell, click and drag the cell.
3. Which are common excel functions applied in your worksheet?
a. PMT, Tab, Merge c. SUM, ROUND, AVERAGE
b. Center, Left, Right d. Sum, Max, Bold
4. They are used to speed up excel calculations.
a. tables b. worksheets c. workbooks d. functions

5. Which automatically totals the contents of the cell?


a. AutoSum b. MAX c. MIN d. AVERAGE
6. It is statistical in category which pertains to the average of the series of arguments.
a. AutoSum b. MAX c. MIN d. AVERAGE

7. Which comes next after clicking the insert function in the formula bar?
a. excel inserts = sign c. description of functions appear
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

b. excel totals the selected cell d. excel built in functions are grouped
8. What comes next after clicking the AutoSum and
the enter key?
a. excel inserts = sign Name:
b. excel totals the selected cell Year/Course: _________ Date:_________
c. description of functions appear
d. excel built in functions are grouped
9. Which quickly copies formula across rows and
columns?
a. AutoSum c. Formula Bar
b. AutoFill d. Relative Cells
9. Which quickly copies formula across rows and
columns?
a. AutoSum c. Formula Bar
b. AutoFill d. Relative Cells
10. They are the driving force in Excel spreadsheet. CK Childrens Publishing
a. AutoSum and AutoFill “Your Access to Visual Learning
and Integration”
b. formulas and functions
c. workbook and worksheets
d. absolute referencing and reference cells Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 5 Formulas and Functions


135
Formulas and Functions Chapter Test
Chapter 5
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

____1. Formulas are used to perform all kinds of calculations on the data.
A. TRUE B. FALSE

____2. The cell reference is the unique cell address in the worksheet.
A. TRUE B. FALSE
____3. The excel formula begins with a + sign.
A. TRUE B. FALSE
____4. Spaces are allowed in range names.
A. TRUE B. FALSE
____5. Excel performs a series of operations from top to bottom.
A. TRUE B. FALSE
____6. The mathematical operators build formulas.
A. TRUE B. FALSE
____7. Excel treats formula in relative location in the worksheet.
A. TRUE B. FALSE
____8. You can click the enter key to cancel the formula.
A. TRUE B. FALSE
____9. Excel displays the formula in the active Name:
worksheet after typing the formula.
Level/Section: _________ Date:_________
A. TRUE B. FALSE
____10. Comma is used to separate the cell
addresses.

A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 5 Formulas and Functions


136
Worksheet Data Chapter Test
Chapter 6
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which allows sharing, copying and moving data in Excel?
a. cut, copy and paste commands c. adding columns and rows commands
b. delete columns and rows commands d. center data across columns
2. The title or heading in a worksheet can be placed at the center. How is it possible?
a. use the hide columns and rows c. use delete columns and rows
b. use cut, copy and paste d. use merge and center
3. The width of any column in the worksheet can be changed following certain steps. Which of these?
a. Click the column that you want to edit. c. Click the row height
b. Click hide or unhide d. Select the text
4. This tool is used to search a particular number and formula in the worksheet.
a. freeze column and rows tool c. excel find tool
b. home tab d. hide columns and rows
5. If you are done applying any excel applications in your worksheet and want to exit, which is the best thing
to do?
a. click the home tab b. select new c. click save d. click the close button
6. Which quickly turns column labels into row labels or vice versa?
a. find tool c. hide column and rows
b. transpose command d. select file tab

7. You wanted to add more data to your workbook. You have to ______
a. delete columns and rows
b. hide columns and rows
c. add columns and rows
d. transpose columns and rows Name:
8.What happens if you delete cells in your worksheet? Year/Course: _________ Date:_________
a. The data will be transferred to the worksheet
b. The existing cells shift over up and fill the gap
c. The data will be moved to the select data
d. The select data remains
9. Excel allows to _________ in a worksheet to keep
confidential information out of view.
a. cut, copy and paste
b. center a title
c. delete columns and rows
d. hide columns and rows
10. The _________ a column or row function is used to CK Childrens Publishing
keep the labels in view while scrolling down the “Your Access to Visual Learning
and Integration”
worksheet.
a. hide c. delete
b. transpose d. freeze Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 6 Worksheet Data


147
Worksheet Data Chapter Test
Chapter 6
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_____1. The area that on freeze is scrollable.


A. TRUE B. FALSE
_____2. In transposing columns and rows, the row becomes the column while the column becomes the
row.
A. TRUE B. FALSE

_____3. The replace tool instantly replaces the texts or number with the data.
A. TRUE B. FALSE

_____4. The worksheet centering the text command should be selected to enter the title.
A. TRUE B. FALSE

_____5. In setting the width of the column, the column width dialog box opens when the home tab is
clicked.
A. TRUE B. FALSE
_____6. You have to double click the column in order to insert a new column.
A. TRUE B. FALSE
_____7. You need to select the data that you want to move or copy.
A. TRUE B. FALSE
_____8. You can add formulas and functions in your
worksheet data.
A. TRUE B. FALSE Name:
Level/Section: _________ Date:_________
_____9. You can click wherever you want to insert
data.
A. TRUE B. FALSE

_____10. The worksheet data is fixed and cannot be


replaced.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 6 Worksheet Data


148
Formatting Worksheet Chapter Test
Chapter 7
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which formatting tool should be used in making the title of the worksheet into bold?
a. Font and Size c. Number Format
b. Bold, Italics and Underline d. Cell Format
2. Which can be used to copy formatting to other cells in your worksheet?
a. Copy Cell Format c. Rotating Cell Format
b. Change Data Color d. Insert decimal
3. The teacher is working on her students' grades. She noticed that some grades have 3 and 3 decimals. She
wanted to reduce it into 2. Which formatting tool is applicable in the situation?
a. increase or decrease decimals c. change data color
b. align cell data d. apply bold, italics and underline
4. __________: control alignment : : ___________ : change color
a. changing data coloring – aligning cell data c. increasing decimal – decreasing decimal
b. aligning cell data – change data color d. change font – change size
5. increase the number of decimals :__________ : : decrease number of decimals
a. increased decimal icon – decreased decimal icon c. aligning cell data – change data color
b. changing data coloring – aligning cell data d. change font – change size
6. What comes next after the Font Size icon is clicked?
a. scroll arrows appear on the screen c. excel immediately applies the new size
b. the format cells drag box opens d. the worksheet is closed
7. Which is not an aligning cell icon?
a. left align b. right align c. center align d. merge

8. It flips text sideways or prompts it from top to


bottom.
Name:
a. rotating cell data c. decrease decimal
b. copy format d. copy data Year/Course: _________ Date:_________
9. if you want to create the same look elsewhere in
the worksheet, you don't have to repeat the steps
but can do a short cut. Which of these?
a. select the cell, click home tab, format painter
and drag over the cells to copy.
b. select the cell, click home tab then, alignment
c. select the cell, click home tab and drag the cell
d. select the cell, click home tab and rotate
10. Which controls the alignment of data in your
worksheet?
CK Childrens Publishing
a. align cell data c. rotate data cell
“Your Access to Visual Learning
b. change data color d. change font and size and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 7 Formatting Worksheet


155
Formatting Worksheet Chapter Test
Chapter 7
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.
______1. The font color icon changes the color of the data.
A. TRUE B. FALSE
______2.the decimals in the numeric data can be decreased or increased.
A. TRUE B. FALSE
______3. The font and size formatting controls the numerical data in your worksheet.
A. TRUE B. FALSE
______4. The format cells dialog box after the number category format is clicked.
A. TRUE B. FALSE
______5. The center icon vertically aligns the data at the center.
A. TRUE B. FALSE
______6. The middle alignment icon horizontally aligns the data at the center.
A. TRUE B. FALSE
______7. The rotating cell data can keep the column width shorter.
A. TRUE B. FALSE
______8. The format painter feature can copy formatting to other cells in the worksheet.
A. TRUE B. FALSE
______9. The basic step in copying cell format is Name:
selecting the cell or range.
Level/Section: _________ Date:_________
A. TRUE B. FALSE
______10. The alignment options pop on the screen
when the format cell dialog box appears.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 7 Formatting Worksheet


156
Previewing and Printing Chapter Test
Chapter 8
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Which of the following steps is followed in adding header in a worksheet?
a. Click file tab, header and footer, and header and select a header
b. Click insert tab, header and fonts, header and select header
c. Select cell, click header and select a header
d. Select cell, click file tab and select a header

2. In adding headers and footers, which comes after the header and footer is clicked?
a. Excel opens the worksheet in Print Preview Mode.
b. Excel adds the field to the header box.
c. The cursor is active at the center.
d. Excel displays Page Layout view

3. Maria wants to print a range of cells in her document. How can she define the print area to prevent printing
the whole worksheet?
a. Select the cell in the print area, click page layout, print area and set print area.
b. Select the cell in the print area, click set print area and page layout
c. Select the cell in the print area, click insert tab, header and print
d. Select the cell in the print area, click header, and page layout
4. In ____________, you can see how your worksheet will look when printed.
a. print preview b. add header c. add footer d. print area

5. Which appears on the screen after clicking the set print area?
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

a. The print dialog box is open.


b. Excel sends the file to the printer.
c. Excel saves the print area. Name:
d. Excel displays the page layout view Year/Course: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 8 Previewing and Printing


161
Previewing and Printing Chapter Test
Chapter 8
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

______1. Variety of excel tools can be used to improve the appearance of the worksheet to print.
A. TRUE B. FALSE
______2. Header appears at the bottom of page.
A. TRUE B. FALSE
______3. A footer text appears at the top of the page outside the text margin.
A. TRUE B. FALSE
______4. Margins appear as dotted lines on the page.
A. TRUE B. FALSE
______5. The page setup is click to access the page setup options.
A. TRUE B. FALSE

Name:
Level/Section: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Three
Microsoft
Excel

Part 3 Microsoft Excel Chapter 8 Previewing and Printing


162
PART

Four
Microsoft
PowerPoint
The Basic of PowerPoint Chapter Test
Chapter 1
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. Your teacher requires you to report on a topic in class. You want your report to be very impressive. Which Microsoft
program can help you communicate your ideas with a very impressive visuals?
a. MS Word b. MS Publisher c. MS Power Point d. MS Excel
2. Power point enables the user to do the following except
a. build an outline b. format text c. calculate data d. organize slides
3. Power point offers several views that you can display to work on different aspects of your presentation. Which of the
following is the largest center pane that shows all the slide contents?
a. slide pane b. notes pane c. outline tab d. slides tab
4. After creating a presentation and have added text or other content, you should ______ the presentation to ensure that
you can use it later.
a. Build outline b. add content c. save the presentation d. run a slide show
5. You can start PowerPoint from the Windows start menu. When you open __________, a blank presentation appears
automatically.
a. Power Point b. Publisher c. Word d. Excel
6. Which of the following appears below the slide pane?
a. slide pane b. notes pane c. slides tab d. outline tab
7. It appears beside the Microsoft Office Button at the top of Power Point screen.
a. ribbon and galleries c. quick access toolbar
b. slide pane d. slides tab

8. Commands that you can execute immediately appear as buttons or check boxes on the ribbon. Which steps allow the
user to access the gallery or dialog box?
CUT AND SUBMIT IT TO YOUR TEACHER FOR RECORDING.

a. Click the desired button on the Quick Access toolbar


b. Click the file tab, save or save as, browse folder button and save.
c. Click the start button, all programs, Microsoft office and Microsoft power point.
d. Click the desired tab on the ribbon, check box, button
of gallery and desired choice.
Name:
9. Which applies preset design elements such as color,
background graphics and text styles to a slide? Year/Course: _________ Date:_________
a. slide design and layout c. work with masters
b. Organize slides d. format text

10. Saving power point file works much like saving any other
office program files. Which steps should be followed?
a. Click the desired button on the Quick Access toolbar
b. Click the file tab, save or save as, browse folder button
and save.
c. Click the start button, all programs, Microsoft office
and Microsoft power point.
d. Click the desired tab on the ribbon, check box, button
of gallery and desired choice.
CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft Power Point Chapter 1 The Basic of Power Point


173
The Basic of PowerPoint Chapter Test
Chapter 1
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

______1. Bullets convey the main points in each topic.


A. TRUE B. FALSE
______2. A set of tools on screen help control your presentation in organizing your slides.
A. TRUE B. FALSE
______3. The transition controls the movement of the elements on screen.
A. TRUE B. FALSE
______4. The animation controls how the content of a new slide appears on screen.
A. TRUE B. FALSE
______5. In formatting text, the selected text can be modified by applying bold, italics and underline.
A. TRUE B. FALSE
______6. In building outline, the slide and its title is represented by an icon.
A. TRUE B. FALSE
______7. The masters enable the user to add content in a particular location of the slide.
A. TRUE B. FALSE
______8. The desired tab on the ribbon is clicked to start a power point.
A. TRUE B. FALSE
______9. The slides tab is located at the right pane
showing the thumbnails of the presentation Name:
slides. Year/Course: _________ Date:_________
A. TRUE B. FALSE

______10. The location in which to save the file


should be specified in saving a
presentation.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft Power Point Chapter 1 The Basic of Power Point


174
Presentation Fundamentals Chapter Test
Chapter 2
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. After you saved and closed a presentation, you reopen it the next time you want to see it. Which is the
quickest way to open it?
a. click the list of the recently used files. c. click the file tab
b. open the dialog box d. select the file
2. If your presentation has out-of-date information, which is the best thing to do?
a. Make a back up of your file c. delete the presentation file
b. Open the presentation file d. open a blank presentation
3. There are few ways in creating a new power point presentation, which of these?
a. Open a dialog box c. open an existing presentation
b. use a template d. delete a presentation
4. Which of the following are the steps in closing a presentation?
a. Click the file tab, close, save
b. Click file tab, new, blank presentation and create
c. Click file tab, open, folder that holds the file , file name and open
d. Click file tab, open, browse the folder, select the file and yes
5. You want to clear your hard drive. You want it to be free from unneeded back up and files. Deleting a file
frees up space on your hard drive. Which step should you follow?
a. Click the file tab, close, save
b. Click file tab, new, blank presentation and create
c. Click file tab, open, folder that holds the file , file name and open
d. Click file tab, open, browse the folder, select the file and yes

Name:
Year/Course: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft PowerPoint Chapter 2 Presentation Fundamentals


179
Presentation Fundamentals Chapter Test
Chapter 2
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_____1. The list of the recently used file is the quickest way of opening your file.
A. TRUE B. FALSE
_____2. The open dialog box appears when you click the file tab.
A. TRUE B. FALSE
_____3. The power point will automatically close soon as you click close.
A. TRUE B. FALSE
_____4. In starting a presentation, you need to for a few seconds for the power point window to appear.
A. TRUE B. FALSE
_____5. You need to click and browse the folder that holds the file that you want delete.

A. TRUE B. FALSE

Name:
Level/Section: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft PowerPoint Chapter 2 Presentation Fundamentals


180
Working With Slide Content Chapter Test
Chapter 3
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which of these are the steps in importing an outline?


a. Select the slide, click home tab, layout button and new slide.
b. Click the file tab, open, all power point presentations and all outlines.
c. Type column heading, press tab key, make cell entries, click outside the table.
d. On the slide click insert table icon, set the number columns, set the number of rows and Ok.
2. In typing texts in a table, the following steps are followed.
a. Select the slide, click home tab, layout button and new slide.
b. Click the file tab, open, all power point presentations and all outlines.
c. Type column heading, press tab key, make cell entries, click outside the table.
d. On the slide click insert table icon, set the number columns, set the number of rows and Ok.
3. What likely happens after clicking the tab key as the user entered text on the table?
a. The spreadsheet window closes. c. The finished table appears on the slide.
b. The insert table dialog box appears. d. The insertion point moves to the next cell.
4. In inserting picture, which comes next after clicking insert?
a. The selected picture is inserted into the placeholder. c. The finished table appears on the slide.
b. The insertion point moves to the next cell. d. The insert table dialog box appears.
5. Which enables the users to insert text or graphical content?
a. outline b. layout c. content place holder d. table and chart
6. The smart graphic is
a. Click to insert a table. c. Click to insert a picture file.
b. Click to insert a diagram d. Click next to the place holder bullet and type.
7. Which is clicked to select an image from built-in
clipart collections?
a. bulleted list c. clip art Name:
b. smart graphics d. charts Year/Course: _________ Date:_________
8. In inserting a chart, which comes next after clicking
the content placeholder?
a. The selected picture is inserted into the
placeholder.
b. The finished table appears on the slide.
c. The create chart dialog box appears.
d. The insert table dialog box appears.
9. Which of the following can make changes in the
table data?
a. Click the cell to edit c. Click close button
b. Click the home tab d. Click OK CK Childrens Publishing
“Your Access to Visual Learning
10. In changing the slide layout, which comes after
and Integration”
clicking the layout button?
a. The selected picture is inserted into the
placeholder. Part
b. The insertion point moves to the next cell. Four
Microsoft
PowerPoint
c. The finished table appears on the slide.
d. The layout gallery appears.

Part 4 Microsoft PowerPoint Chapter 3 Working with Slide Content


189
Working With Slide Content Chapter Test
Chapter 3
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

____1. If the slide is changed, the original layout remains.


A. TRUE B. FALSE
____2. A table enables to arrange information in rows and columns for easy comparison.
A. TRUE B. FALSE
____3. As the close button is clicked, the spreadsheet window closes.
A. TRUE B. FALSE
____4. The placeholder content can be replaced as needed.
A. TRUE B. FALSE
____5. The insertion point move after the chart type thumbnail is clicked.
A. TRUE B. FALSE
____6. As the insert chart icon is clicked, the insertion point move to replace.
A. TRUE B. FALSE
____7. Media clips include photos and line drawings.
A. TRUE B. FALSE
____8. Tables illustrate and enhance the presentation of slides.
A. TRUE B. FALSE
____9. The address bar can help in navigating
address bar. Name:
A. TRUE B. FALSE Level/Section: _________ Date:_________
____10.The power point recognizes media clips in
different forms
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft PowerPoint Chapter 3 Working with Slide Content


190
Themes Chapter Test
Chapter 4
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.
1. The teacher asks you to create a slide presentation choosing your own theme. Which of these cannot be applied?
a. design to selected slides b. text box c. texture, picture, background d. media clips, clip arts
2. You can apply different theme to the currently selected slide or slides. Why it is important that the theme will
complement with the design of the slide?
a. So that the transition will not jar the viewers c. So that custom color be created
b. So that you can focus on the content d. So that digital photo is used
3. If you think that a plain text box lacks excitement, you can create a text box by ________you have already drawn.
a. enlarging or shrinking b. adding background c. adding text to a shape d. applying texture
4. You can push design limits even further using texture or digital picture as a background? How could this be done?
a. Select the slides, click design tab, format background, picture or textile fill.
b. Select picture or textile fill, click design tab, format background and select the slides.
c. Select picture or textile fill, click home tab, format background and select the slides.
d. Select picture or textile fill, click picture background, format background and select the slides.
5. Which are the steps in applying design to selected slide?
a. Select the slide, click design tab, click gallery button, choose them thumbnail, click apply
b. Click the design tab, click gallery button, click thumbnail of the chosen theme.
c. Select the slide, click tab, click colors, desired scheme, apply to elected tiles.
d. Click the design applying n tab, click colors, click desired theme.
6. Which steps are applicable in applying color theme?
a. Select the slide, click design tab, click gallery button, choose them thumbnail, click apply
b. Click the design tab, click gallery button, click thumbnail of the chosen theme.
c. Select the slide, click tab, click colors, desired scheme, apply to elected tiles.
d. Click the design applying n tab, click colors, click desired theme.
7. Luisa wants to apply picture background in her slides. Which comes after she clicks the format background?
a. The format background dialog box appears.
b. Power point displays a texture gallery.
c. The insert picture dialog box appears.
d. The insert picture dialog box closes. Name:
8. Andrea wanted to add a textbox that behaves like a Year/Course: _________ Date:_________
slide layout place holder anywhere on a slide. Which
comes after she clicks the text box?
a. The format background dialog box appears.
b. Mouse pointer changes upside down cross.
c. The insert picture dialog box appears.
d. The insert picture dialog box closes.
9. In applying a texture background, which appears on the
screen after clicking the texture content?
a. The format background dialog box appears.
b. Power point displays a texture gallery.
c. The insert picture dialog box appears.
d. The insert picture dialog box closes.
10. Which of these are the steps in importing picture CK Childrens Publishing
“Your Access to Visual Learning
background.
and Integration”
a. Select the slide, click home tab, layout button and
new slide.
b. Click the file tab, open, all power point presentations
Part
and all outlines. Four
Microsoft
c. Type column heading, press tab key, make cell entries, PowerPoint
click outside the table.
d. Click file, navigate the folder, click picture file, insert
button

Part 4 Microsoft PowerPoint Chapter 4 Themes


199
Themes Chapter Test
Chapter 4
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_________1. The format background dialog box appears after clicking the design Tab
A. TRUE B. FALSE

_________2. The design of the slide cannot be touched or change.


A. TRUE B. FALSE

_________3. You cannot push design limits.


A. TRUE B. FALSE

_________4. The shape box automatically enlarges or shrinks.


A. TRUE B. FALSE

_________5. In duplicating a slide, home tab is click.


A. TRUE B. FALSE

_________6. In adding a text to shape, the edit text is clicked and the insertion point appears inside shape.
A. TRUE B. FALSE
_________7. The themes are the animation applied in the presentation.
A. TRUE B. FALSE
_________8. Clicking the home tab is the basic step in duplicating a slide.
A. TRUE B. FALSE
_________9. To add a text box, click the insert tab.
A. TRUE B. FALSE
Name:
_________10. In applying texture, moving the mouse
pointer over a font theme previews the Level/Section: _________ Date:_________
theme in the slide.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft Power Point Chapter 4 Themes


200
Slide Content Action Chapter Test
Chapter 5
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which are animations?


a. Cut, copy, paste b. Delete, enter c. fade, wipe fly d. increase, decrease
2. The ______________ on the ribbon is used to apply animation to the selected object in the slide.
a. File tab b. animations tab c. home tab d. preview
3. Which allows more control over the animation effect applied on the selected slide?
a. Animation tab b. custom animation c. preview d. animation pane
4. Which provides a quick and easy way to jump to a slide with related content while delivering a slide show?
a. Animation tab b. custom animation c. action buttons d. animation pane
5. To make the slide show more lively, movie and sound clip can be inserted on the slide during the show. Which are the
steps to follow?
a. Display the slide to which the clip is to be inserted, click insert tab, movie or sound, navigate the folder holding the
file, click the clip and insert.
b. Display the slide, insert tab, shapes, button style and drag diagonally
c. Click the slide show tab, rehearse timings, next, click yes or no
d. Display the slide, click animation tab, animate and none.

6. Standard and custom animations can be both removed from slide objects. Which of the following are the steps to
follow in removing animation?
a. Display the slide to which the clip is to be inserted, click insert tab, movie or sound, navigate the folder holding the
file, click the clip and insert.
b. Display the slide, insert tab, shapes, button style and drag diagonally
c. Click the slide show tab, rehearse timings, next, click yes or no
d. Display the slide, click animation tab, animate and none
7. What happens to the mouse pointer after the button style is clicked in inserting action button?
a. The action button and the action dialog box appear.
b. The custom animation task pane appears.
c. Power point removes the animation. Name:
d. The pointer turns into a crosshair.
Year/Course: _________ Date:_________
8. Which command time a practice run of the presentation
to ensure that it does not take too long to deliver?
a. rehearsal timings
b. advancing a slide after a set time interval
c. adding transition to slides
d. adding custom animation
9. ___________ from the random category tells power point
to apply a different transition from each slide in the
presentation.
a. rehearsal timings
b. advancing a slide after a set time interval
c. adding transition to slides
d. adding custom animation CK Childrens Publishing
“Your Access to Visual Learning
10. Which is the basic step applied in inserting movie and and Integration”
sound clips?
a. Display the slide on which you want to insert a clip
b. Click the slide show tab Part
c. Click the animation tab Four
Microsoft
d. Click the transition tab PowerPoint

Part 4 Microsoft Power Point Chapter 5 Slide Content Action


211
Slide Content Action Chapter Test
Chapter 5
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. The spinner arrow sets the interval in advancing a slide.


A. TRUE B. FALSE
2. A half moon appears beside the slide thumbnail that indicates transition is applied.
A. TRUE B. FALSE
3. To remove transitions from all slides in the presentation, click delete all.
A. TRUE B. FALSE
4. In removing animation, power point removes the animation effect from the object after remove is
selected.
A. TRUE B. FALSE

5. The animations can be removed both in animations tab and delete tab.
A. TRUE B. FALSE

6. Previewing the animations applied is necessary to ensure appropriate slide content.


A. TRUE B. FALSE

7. You can preview the animations by running the entire slide show.
A. TRUE B. FALSE

8. In previewing animation, power point applies the effect and preview pressing the effect icon.
A. TRUE B. FALSE

9. You can play the slide show by pressing F4. Name:


A. TRUE B. FALSE
Level/Section: _________ Date:_________
10. In inserting action button, the action button and
the action setting dialog box appear when the
mouse cursor is dragged diagonally.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft Power Point Chapter 5 Slide Content Action


212
Running and Printing Slide Show Chapter Test
Chapter 6
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which icon displays slide show?


a. Slide show b. end show c. navigation menu d. slide rotate

2. Which follows after the print icon is clicked?


a. The custom animation task pane appear c. The pointer turns into a crosshair.
b. Power point removes the animation d. The printer dialog box appear

3. It means you can pause, stop, hide or add annotations in the slide show.
a. end the show c. navigate the presentation
b. display your presentation d. interact with the presentation

4. It is the time to set back and accept the congratulations coming your way for a great presentation.
a. end the show c. navigate the presentation
b. display your presentation d. interact with the presentation

5. It includes all the menus, toolbar and panes and the slide content.
a. end the show c. navigate the presentation
b. display your presentation d. interact with the presentation

Name:
Year/Course: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft Power Point Chapter 6 Running and Printing Slide Show
217
Running and Printing Slide Show Chapter Test
Chapter 6
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. Slides will print according to the orientation specified in the design tab.
A. TRUE B. FALSE
2. The print out appears differently depending on the selected printer.
A. TRUE B. FALSE
3. To change the number of copies needed, turn off the printer and add number or copies.
A. TRUE B. FALSE
4. The annotation feature uses a technology called ink.
A. TRUE B. FALSE
5. It is a good practice to check what your slides look like on screen before you print.
A. TRUE B. FALSE

Name:
Level/Section: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Four
Microsoft
PowerPoint

Part 4 Microsoft Power Point Chapter 6 Running and Printing Slide Show
218
PART

Five

Microsoft
Publisher
Publisher Basics Chapter Test
Chapter 1
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which is a useful tool in business communities especially in creating and designing marketing and communication
materials?
a. MS Word b. MS Excel c. MS Power point d. MS Publisher
2. Which does not belong to the group?
a. Formula b. margin guide c. rotate handle d. object size
3. Creating ____________ in publisher is different in creating document in word.
a. table c. worksheets c. publication d. presentation
4. All are steps in creating a new publication except
a. click create or down load c. click file tab
b. click left, right and center alignment d. click publication design
5. Which application is capable of creating all kinds of publication like brochures and flyers.
a. Excel b. Publisher c. Word d. Power point
6. Which are the steps to follow in creating a blank publication?
a. Click file tab, new, publication design and click create or down load.
b. Click file tab, new, click more blank pages, page size and click create
c. Click the area to be zoomed, click view tab, zoom and click a percentage
d. Click file tab, choose save as, choose the location type the title of the publication and save.
7. Which likely follows after the percentage is indicated in the zoom field?
a. Publisher displays a preview of the selected design. c. Publication changes the magnification setting.
b. Publisher duplicates the page to be inserted. d. Publisher displays the selected size.
8. Publisher installs with a wide variety of publication types. Which of the following steps are to following creating a
publication from template?
a. Click file tab, new, publication design and click create or down load.
b. Click file tab, new, click more blank pages, page size and click create
c. Click the area to be zoomed, click view tab, zoom
and click a percentage
d. Click file tab, choose save as, choose the location Name:
type the title of the publication and save.
Year/Course: _________ Date:_________
9. When publisher's pre-designed publication templates do
not suit your needs, you can create a blank publication.
Which steps are to be followed?
a. Click file tab, new, publication design and click create
or down load.
b. Click file tab, new, click more blank pages, page size
and click create
c. Click the area to be zoomed, click view tab, zoom
and click a percentage
d. Click file tab, choose save as, choose the location
type the title of the publication and save.
10. One of the most tasks to complete your publication is
to save it in a storage device. Which steps will guide us in CK Childrens Publishing
saving the publication created? “Your Access to Visual Learning
and Integration”
a. Click file tab, new, publication design and click create
or down load.
b. Click file tab, new, click more blank pages, page size
Part
and click create Five
Microsoft
c. Click the area to be zoomed, click view tab, zoom Publisher
and click a percentage
d. Click file tab, choose save as, choose the location
type the title of the publication and save.

Part 5 Microsoft Publisher Chapter


Chapter1 Publisher
1 Office Basics
Basics
231
Publisher Basics Chapter Test
Chapter 1
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. The page margin of the publication should match with the minimum margin supported by the printer.
A. TRUE B. FALSE

2. In adding a page in the publication, you need to click the file button,
A. TRUE B. FALSE

3. Not all the content in the publication is deleted even if the page it contains is already deleted.
A. TRUE B. FALSE

4. Under margin guides, type the maximum margin values to set the margins in the publication.
A. TRUE B. FALSE

5. The close master page button must be click to return to the publisher's normal view.
A. TRUE B. FALSE

6. In adding a page in the publication, it is necessary to type the name of the publication and choose the
type of the file.
A. TRUE B. FALSE
7. Select insert blank page to insert a new blank page after the currently selected page.
A. TRUE B. FALSE
8. Select insert page to bring up the insert page dialog box.
A. TRUE B. FALSE
9. Click the master page box to return to a normal Name:
view of the publication. Level/Section: _________ Date:_________
A. TRUE B. FALSE

10. To avoid turning the current right-hand pages


into left-hand pages , delete an even number of
pages.
A. TRUE B. FALSE

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 1 Publisher Basics


232
Working with Text Chapter Test
Chapter 2
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which is correct about adding text in a publication?


a. Publisher can correct the problems on overflow text. c. Publisher conveys readers the message.
b. Publisher can scale, track and kern the characters. d. Publisher inserts a layout for the texts.

2. All is about MS publisher. Which of the statements tells about flowing text in the text boxes?
a. Publisher can correct the problems on overflow text. c. Publisher conveys readers the message.
b. Publisher can scale, track and kern the characters. d. Publisher inserts a layout for the texts.

3. You can add new text boxes to a publication and type your own text. Which of the following steps are likely
followed in adding a new text box?
a. Select the text, click character spacing, select type of tracking, select type of kerning, select the kern
text and click ok.
b. Click the home tab, click the draw text box button, drag the text box to its desired size, and type the text.
c. Press CTRL+C, create text boxes, click and paste, and click the next frame.
d. Click the text box, click text box tool format and break button.

4. Which is the basic step in tweaking your text?


a. Select the kern text at the check box. c. Select the text to improve
b. Select the type of kerning d. Select more spacing

5. Which pertains to the texts and displays in the text boxes?


a. Frames b. tables c. shapes d. smartart

Name:
Year/Course: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 2 Working with Text


239
Working with Text Chapter Test
Chapter 2
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. After adding text in the publication, formatting and resizing can be applied.

2. Clicking the file tab is the basic step in adding a new text box in a publication.

3. You can copy a text by pressing Ctrl +V.

4. In breaking a text link, the first text box to disconnect is clicked.

5. You need to scroll down the arrows in order to add text effects.

Name:
Level/Section: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 2 Working with Text


240
Designs and Layouts Chapter Test
Chapter 4
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which set of steps is followed in creating a newsletter?


a. Click file tab new, calendars and create.
b. Click file tab, new, newsletter and create
c. Click file tab, click new and greeting card
d. Click file tab, click new, labels and click create.
2. The following are steps in creating a brochure except
a. click file tab c. click create or download
b. click new d. click brochure

3. Publisher is a helpful tool especially in making brochures, business cards and others. Which set of commands is helpful
in making a greeting card?
a. Click file tab new, calendars and create.
b. Click file tab, new, newsletter and create
c. Click file tab, click new and greeting card
d. Click file tab, click new, labels and click create.
4. Which set of steps is followed in creating a newsletter?
a. Click file tab new, calendars and create.
b. Click file tab, new, newsletter and create
c. ck new and greeting card
d. Click file tab, click new, labels and click create.
5. Which set of steps is followed in creating award certificates?
a. Click file tab new, calendars and create.
b. Click file tab, new, newsletter and create
c. Click file tab, click new and greeting card
d. Click file tab, click new, award certificates and click
create.
Name:
6. The following is not possible in MS Publisher.
a. Create post card c. Create formulas Year/Course: _________ Date:_________
b. Create banners d. create calendars

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 4 Designs and Layouts


255
Designs and Layouts Chapter Test
Chapter 4
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

1. It is important to save the publication before closing the program.


A. TRUE B. FALSE
2. MS publisher is capable of creating formula.
A. TRUE B. FALSE
3. Publisher displays a preview of the selected design.
A. TRUE B. FALSE
4. Publisher displays the preview even the file is not done yet.
A. TRUE B. FALSE
5. Calculating numeric data is easy in publication.
A. TRUE B. FALSE

Name:
Level/Section: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 4 Designs and Layouts


256
Finishing Touches Chapter Test
Chapter 5
A. Multiple Choice: Shade the letter of the best answer in the answer sheet provided.

1. Which is considered engine in publisher?

a. Worksheet b. design checker c. formatting d. tables

2. Which is selected to spell check?

a. Worksheet c. design checker


b. spelling and grammar checker d. formatting buttons

3. Which is the basic step in adding table of contents?

a. Draw the text box button in the home tab.


b. Complete and save the publication
c. Click text box to check.
d. Click file tab.
4. Which describes MS Publisher?

a. Can create own formula


b. Create a mass mail
c. Create word document
d. Produce high- quality publication
5. Which does not belong the group?

a. File tab c. grammar and spelling checker.


b. design checker d. excel

Name:
Year/Course: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 4 Designs and Layouts


261
Finishing Touches Chapter Test
Chapter 5
B. True or False. Shade A if the statement is correct and B if not, in the answer sheet provided.

_____1. The design checker checks the grammar and spelling.


A. TRUE B. FALSE

_____2. The table of contents can automatically create a table.


A. TRUE B. FALSE

_____3. It is not necessary to save the publication made.


A. TRUE B. FALSE

_____4. In printing publication, the number of copies should be specified.


A. TRUE B. FALSE

_____5. MS word and MS Publisher have the same formatting tools


A. TRUE B. FALSE

Name:
Level/Section: _________ Date:_________

CK Childrens Publishing
“Your Access to Visual Learning
and Integration”

Part
Five
Microsoft
Publisher

Part 5 Microsoft Publisher Chapter 4 Designs and Layouts


262

You might also like