E-Tech Second Quarter Exam
E-Tech Second Quarter Exam
E-Tech Second Quarter Exam
Department of Education
Region X
Division of Misamis Occidental
Looc National High School
Lao Proper, Plaridel, Misamis Occidental
Directions: Read the statements carefully. Write T if the statement is TRUE and write the word/words
that make the statement FALSE on the space provided. (2 points in each item)
__________1. The columns in MS Excel window is identified by a number.
__________2. F4 key is used to edit the content of the active cell.
__________3. The type of chart commonly used in infographics in comparing data is the column, pie
and line chart.
__________4. A URL is the address you type in your web browser to find a particular page on the web.
__________ 5. Infographics makes complex data become more visually appealing to the average user.
__________6. The home page is the first page of your website.
__________7. WYSIWYG stands for What You Sense Is What You Get.
__________8. Online presentation does not allow a group of people work together in real-time over the
Internet.
__________9. Infographics URL example is www.piktochart.com.
__________10. Flaming text is an online platform that allows creation of free logo designs.
PART II. MULTIPLE CHOICE
Directions: Encircle the letter of the best answer.
1. The advantage of using a spreadsheet is:
A. Calculations can be done automatically
B. Changing data automatically updates calculations (as long as Excel is not set to calculate manually)
C. More flexibility
D. All of the above
2. A program designed to create spreadsheets which can later be used to analyze statistical data.
A. MS Excel B. MS Publisher C. MS Word D. MS PowerPoint
3. A function that adds a range of cells
A. ADD B. PLUS C. SUM D. TOTAL
4. A function that gets the average of a range of cells
A. AVERAGE B. SUM C. MEAN D. MEDIAN
5. The intersection of a row and column is called ___
A. Data B. A cell C. A file D. An equation
6. The _____ displays the name of the sheets in the workbook
A. Sheet tab B. Book tabs C. Menu bar D. Worksheets
7. A range in MS Excel refers to
A. Group of cells
B. A way of arranging data in a particular order
C. A calculation that describes the relationship between cells
D. All of the above
8. A worksheet is …
A. A symbol that represents a specific action
B. Refers to the change a formula makes when it is moved or copied to other cells with different data
C. A table of data that is organized into rows and columns
D. Any of the above
9. The cell labeled F4 refers to
A. Row F column 4 C. Function key F4
B. Column F row 4 D. Functions available in cells
10. When a formula is written in a cell, it appears in the active cell in which it is being written in the ______
bar as well
A. Formula B. Namebox C. Title D. Status
11. Which of the following would you use in an Excel formula to reference the cell located at column G row
17?
A. G (17) B. G17 C. Cg R17 D. 17G
12. What is the purpose of the Quick Access toolbar?
A. It provides shortcuts to functions you may use frequently as well as functions that may not be on the
Ribbon
B. You can only use it to save, redo, and undo, create new document, open documents and print
C. It displays functions you have recently used as well as frequently used functions
D. Any of the above
13. What’s the quick way to extend these numbers to a longer sequence, for instance 1 through 20?
A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
B. Select the range you want, including both cells, point to Borders on the Home Tab, and then click
C. Copy the second cell, click in the cell below it, on the quick access toolbar click the down arrow on the
paste button, and click paste
D. Select the first cell, and then drag the fill handle over the range you want, for instance 18 more rows
14. If you have data that runs across five columns from column A to column E, one way to center a title
across the top of the data would be to:
A. Type the data in C1
B. Type the data in A1 and merge cells A1:E1
C. Type the data in A1 and merge cells A1:A5
D. Choose Center from the alignment group in the Home tab
15. A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will
do this?
A. Click the Sheet tab and press delete C. Click the New Sheet button
B. Right click the sheet tab, then click delete D. Press Ctrl + Z on your keyboard
16. What happens if you select a cell that already contains text or numbers and you start typing or inserting
numbers?
A. The above action will add the additional text and/or numbers to the end of the existing contents of the cell
B. The above action will delete the current contents of the cell and replace it with the next typed text or
numbers
C. The text or numbers you type will automatically be appended to the end of the existing contents of the
cell
D. All of the above
17. How do you change column width to fit the contents?
A. Single click the boundary to the left of the column heading
B. Double-click the boundary the right of the column heading
C. Press Alt and single-click anywhere in the column
D. Drag the boundary to the right of the column heading
18. How do you create a new worksheet?
A. Press ctrl + N on the keyboard
B. Click File, then click New
C. Click the New button on the quick access toolbar
D. Click the New Sheet button beside the sheet tab
19. Which of the following should Publisher NOT be used for?
A. Designing a flyer
B. Designing a news letter
C. Creating a Holiday Card
D. Calculating money
20. What is the advantage of using MS Publisher instead of Word?
A. It is less complicated
B. It works on all devices
C. There are many templates for easy project creation
D. It is more complicated
23. MS Publisher has many pre-created documents that you can edit. These are called....
A. Edits B. Slides C. Templates D. Images
24. When a Publisher object is selected, _____ appears around the object
A. A red checkered border
B. A line with Multiple handles
C. A light blue dashed line
D. Arrows
25. A graphic may be _____ to remove a portion and customize for a publication.
A. Cropped B. Purged C. Cut D. Trimmed
26. How could you send out a colorful message about an upcoming company picnic?
A. create a flyer in Publisher
B. create a tri fold brochure in Word
C. create a flyer in PowerPoint
D. create a flyer in Excel
27. You want an image to go behind the text on your brochure, which command do you use?
A. Align B. Send backward C. Bring forward D. Rotate
37. What online platform does Google Drive, Trello, Skype applications represents?
A. Collaboration B. Blogging C. Cloud computing D. Web page creation
38. What type of online platform does Google Slides, Prezi, Slides.com, Visme, and Zoho Show represents?
A. Blogging C. Cloud computing
B. File management D. Presentation/Visualization
40. Which of the following options is less applicable on why do people blog?
A. To impress own-self privately
B. To sell their own products and services
C. To have an online presence and build a name of themselves
D. To promote their products and services
“What you learn today will be your guide to achieve your dreams someday, don’t look to the
paper of your classmate be honest to yourself.”
-Sir A.K.G.I.