NEW
Font size
WorksheetsSummative Test in EMPTECH 3rd
Total questions: 20
Worksheet time: 10mins
What is the document that contains the main body of the message we want to convey or send?
Word Document
Form Document
Place Holders
List or Data File
2. How to add new records in MS Word?
open a Microsoft word
click the Customize Columns button on the dialog box
Insert the fields you need in the letter
press TAB key after inputting the last field
It marks the position on the form document where the individual data or information will be inserted.
Mail Merge
Place Holders
List or Data File
MS Word
Aside from Microsoft Word, what other MS Office applications that can incorporate data and allows you to create multiple documents at once?
MS Word
MS Excel
MS Power Point
MS Publisher
What feature of MS Word application that allows you to create documents and combine or merge them with another document or data file?
Insert Graphics
Mail Merge
Layout
Formatting Text
What component of mail merge includes the individual information or data of the recipient’s information that needs to be merged to the form document?
Mail Merge
Place Holder
Form Document
List or Data File
Which of the following is not a component of a mail merge?
address
file name
form document
list or dat file
What type of document can you not create using mail merge?
posters
envelopes
labels
letters
What does a double-headed arrow (<< >>) denote?
list file
information
place holder
label generation
How to save main document in mail merge?
Ctrl + O
Ctrl + X
Ctrl + L
Ctrl + S
Which of the following terms refers to a file made of rows and columns that enables you to sort data, arrange data easily, and calculate numerical data?
Document
One Note
Publisher
Spreadsheet
Which of the following application software is NOT s spreadsheet program?
Calc
Google Sheets
MS Excel
MS Office
If you opt to use spreadsheet to check account information, budgets, taxes, etc. To what field is spreadsheet used?
Education
Finance
Office Management
Sports
What do we call the collection of worksheets in Microsoft Excel?
Interface
Program
Sheets
Workbook
This part of the Excel 2016 contains all the commands needed to perform common tasks. What is this part?
Name Box
Quick Access Toolbar
Ribbon
Tell Me
Teacher Jean has five students in her Nursery class. She wants to Capitalize the Last Name of her students. What text function will she use?
Len ( )
Find ( )
Proper ( )
Upper ( )
What will be the formula to get the total number of characters of each Given Name starting from Maria?
=LEN(A2)
=TRIM(A2)
=MID(A2))
=CONCATENATE(A2)
If you want to get the Middle Initial of Maria, you will use the Left ( ) text function. What is the syntax of this function?
left(text,num_char)
=left(num_char,text)
=left(text,num_char)
left(num_char,text)
Which of the following commands will NOT save a worksheet or workbook?
Alt + S
Ctrl + S
File Menu, Save
Quick Access Toolbar, Save
It is the intersection of a row and a column—in other words, where a row and column meet.
Cell
Row
Column
Sheet
