Time Started: _______________

STA. IGNACIA HIGH SCHOOL Time Completed: ____________

PRIVATE Time Elapsed: _______________
Santa Ignacia, Tarlac, 2303
2nd Final Examination Computer G7
October 18, 2019

Name: __________________________________ Year & Section: ______________________ Score:________

I. Matching Type. Match the specific “control keys from MS Excel” from Column A to the appropriate “task” from column B. Write
the letter of the correct answer on the space provided. (NO ERASURES).

COLUMN A COLUMN B

1. Page Down Key _____ a. Redo Data

2. Home Key _____ b. Undo Data
3. Page up key _____ c. Save workbook
4. CTRL + C _____ d. Paste Data
5. Ctrl Key _____ e. Copy Data
6. Up arrow key _____ f. It moves the active cell at the beginning of
the current row.
7. Shift Key _____ g. Move on page downward at a time.
8. Tab Key _____ h. Move one page upward at a time.
9. Down Arrow Key _____ i. If you hold down the ___ and then press the
Home key, you move to the beginning of the
worksheet
10. Right arrow key _____ j. If you hold down the ___ and then press the
Tab key to move to eh left, one cell at a
time.
11. Left arrow key _____ k. Move across the page to the right, one cell at
a time.
12. CTRL + S _____
l. Move to the left one cell at a time.
13. CTRL + Z _____
m. Move to the right at one cell at a time.
14. CTRL + Y _____
n. Move downward at one cell at a time.
15. CTRL + V _____
o. Move upward at one cell at a time.

I. Multiple Choice. Encircle the correct answer. (NO ERASURES).

1. Microsoft excel is a?
a. Worksheet application c. Typing application
b. Spreadsheet application d. None of these
2. It tells what excel is doing or ready to do or prompts you with some message or instructions.
a. Status bar c. Message bar
b. Scroll bar d. Prompt message
3. It is the name given to an excel file and contains one or more worksheets.
a. Single sheet c. Book area
b. Worksheet d. Workbook
4. It is a single page sheet in a file created with an electronic speadsheet program such as MS Excel.
a. Single sheet c. Workbook
b. Sheetpage d. Worksheet
5. Which of the following feature of excel when you need to save a presentation under a different name.
a. Save c. CTRL + S
b. Save as d. None of these
6. It performs many of the functions that were located in the File Menu.
a. Ribbon c. Microsoft office button
b. Home menu d. Quick access toolbar
7. Which of the following is used to add text in a drawing or paint program?
a. Add text and images c. Text box
b. Insert tab d. Clipboard
8. Which of the following special effects are used to introduce slides in a presentation?
a. Transitions c. Custom animations
b. Effects d. Annotations
9. You can create a new presentation by completing all of the following except.
a. Clicking the new button on the standard c. Pressing ctrl + n
toolbar d. Clicking the file open
b. Clicking file, new

10. How can we stop a slide show?

a. Press the right arrow b. Press ctrl + a
 c. Press escape d. Press ctrl + s
11. From where can we set the timing for each object?
a. Slide show, Slide transition c. View, slide sorter
b. Slide show, custom transition d. Slide show, Custom animation
12. Which program is used to create a presentation?
a. Excel c. Access
b. PowerPoint d. Outlook
13. A collection of electronic slides that can have text, pictures, graphics, tables, sound and video is called?
a. Presentations c. Presenter
b. PowerPoint Presentation d. Presents
14. It is a customizable toolbar that contains commands that you may want to use.
a. Ribbon c. Microsoft Office button
b. Home Button d. Quick access toolbar
15. To preview a motion path effect using the custom animation task pane, we should
a. Double click the motion path c. Click the play button
b. Click the show effect button d. None of the above

III. Classification. Write the following words in their respective table below. (NO ERASURES). 20Pts.

Online pictures Cut Zoom Copy Pictures

Custom Views Financial Text Date & Time Page Layout
Autosum Wrap Text Shapes Paste Page break Preview
Screenshot Logical Merge & Center Normal SmartArt

Insert Home View Formulas

1. 1. 1. 1.
2. 2. 2. 2.
3. 3. 3. 3.
4. 4. 4. 4.
5. 5. 5. 5.

IV. Identification. Identify the parts of MS Excel. Write the correct answer on the space provided. (NO ERASURES). 20Pts.

1. ____________________ 11. ____________________

2. ____________________ 12. ____________________
3. ____________________ 13. ____________________
4. ____________________ 14. ____________________
5. ____________________ 15. ____________________
6. ____________________ 16. ____________________
7. ____________________ 17. ____________________
8. ____________________ 18. ____________________
9. ____________________ 19. ____________________
10. ___________________ 20. ____________________

Prepared by: Nomar R. Lapitan