I. Read each item properly and choose the best answer. Encircle the letter of your answer.
1. It is the basic document for a spreadsheet program.
A. document B. file
C. worksheet D. workbook
2. It contains the Quick Access Toolbar, Title of the workbook, and the Minimize, Maximize/Restore,
and Close buttons.
A. formula bar B. worksheet area
C. menu bar D. title bar
3. It displays the menu categories or titles of the sets of commands.
A. formula bar B. worksheet area
C. menu bar D. title bar
4. It displays the set of commands for a menu category.
A. formula bar B. worksheet area
C. menu bar D. tool bar
5. It shows the contents of an active cell. It contains the Name Box, the Formula text box, and the
Cancel, Edit, and Function buttons.
A. formula bar B. worksheet area
C. menu bar D. tool bar
6. It contains 5 rows (which are labeled using numbers) and columns (which are labeled using
letters).
A. status bar B. workbook
C. file menu D. worksheet area
7. These are horizontal or vertical bars that allow you to move through the document up, down, left, or
right.
A. status bar B. scroll bar
C. file menu D. worksheet area
8. It contains the zoom level and view options and shows when it is ready to take commands.
A. status bar B. scroll bar
C. file menu D. worksheet area
9. Allows you to create formulas from different categories like statistics, trigonometry, logical, and
financial.
Page 1 of 5
A. Calculation B. Function Library
C. Formula Auditing D. Sort and Filter
10. Shows tool that helps in checking if formula used is correct.
A. Calculation B. Function Library
C. Formula Auditing D. Sort and Filter
11. It lets you choose whether to calculate formula automatically or manually.
A. Calculation B. Function Library
C. Formula Auditing D. Sort and Filter
12. It arranges data from lowest to highest and from highest to lowest.
A. Filter B. Function Library
C. Formula Auditing D. Sort
13. Who were the developers of Microsoft PowerPoint?
A. Robert Gaskins and Dennis Austin B. Albert Canes and Daniel Jean
C. Charles Millkens and Joseph Gillis D. Robert Banker and Dennis Hall
14. In what year was Microsoft PowerPoint first released?
A. 1998 B. 1987
C. 1950 C. 1995
15. This is seen on the left part of the program screen and shows the thumbnail of all slides in the
presentation.
A. notes pane B. status bar
C. ribbon D. slide pane
16. This tab contains different PowerPoint background design templates called themes.
A. notes pane B. design menu
C. ribbon D. transition menu tab
17. This tab contains transition effects, which are graphic effects seen when switching between the
slides.
A. Animation menu tab B. Design menu
C. Ribbon D. Transition menu tab
18. This tab contains animation effects, which are settings that let you customize how or when a text
or picture appears on a slide.
A. Animation menu tab B. Design menu
C. Ribbon D. Transition menu tab
19. This tab contains commands used in the preview of the presentation.
Page 2 of 5
A. Animation menu tab B. Design menu
C. Slide show tab D. Transition menu tab
20. This inserts a slide with placeholders for a title and slide content, which may be in the form of text,
graphs, or pictures.
A. title and content B. title slide
B. title only D. two content
II. Match column A to its correct function in column B. Write the letter of your answer in the
space provided.
A B
21.
A. Changes the currency of the data.
22. B. Displays data in selected cell as
percent.
23. C. Decreases the number of decimals
displayed after the decimal point.
24. D. Displays large numbers with
commas as separator.
25. E. Increases the number of decimals
displayed after the decimal point.
A B
26.
Use for selection of most objects
27. Used to change the height of the entire
row
28. The text or the position can be
selected
Page 3 of 5
29. Used to drag a selected cell or cells to
a new location
30. Use to change the width of the entire
column
31. Used for graphics and other two
dimensional interaction
III. Write TRUE if the statement is correct and FALSE if it is not. Write your answer on the
space provided.
__________32.If the cell entry is a number; use the command buttons in the Number submenu.
__________33.Excel has row numbers and gridlines that will guide you when you need to move from
cell to cell.
__________34.MS PowerPoint main purpose was to make generating of group presentations in
business offices easier.
__________35.A slide reference number can be seen on the top left of each thumbnail slide,
indicating the sequence of the slides.
IV. 36 – 40. What is the importance of Microsoft Excel as tool for conducting a survey?
Essay Rubric
Points Criteria Score
5 5 or more sentences. Essay is on topic. Essay uses excellent ideas.
No punctuation or spelling errors.
4 Essay is not composed of five sentences. Most of the essay contents
tell ideas. There are few punctuation and spelling errors.
3 Essay is less than 4 sentences long. Essay tells a few ideas. There
are few punctuation and spelling errors.
2 2 sentence essay. No ideas being expressed. There are punctuation
and spelling errors.
__________________________________
Title
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
Page 4 of 5
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
V. 41 – 45. What is the importance of Microsoft PowerPoint as a tool for making presentation
for your reports?
__________________________________
Title
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
“Commit your work to the Lord, and your plans will succeed”
Proverbs 16:3
Page 5 of 5