Font size
WorksheetsComputer final practice
Total questions: 22
Worksheet time: 27mins
True or False: Multilevel List helps in creating nested lists in word.
False
True
Fill in the blank: To use the Mail Merge task pane, you need to click on ____________, and then on Start Mail Merge.
None of the above
Design menu
Mailing menu
View menu
Correct the Sentence: The AND operator returns TRUE when all conditions mentioned within a block are False.
The AND operator returns FALSE when all conditions mentioned within a block are False.
The AND operator returns FALSE when all conditions mentioned within a block are True.
The AND operator returns TRUE when all conditions mentioned within a block are True.
Data is used for searching text within a worksheet.
Choose the correct choice: In which menu are the table Borders present?
Home menu
Design menu
None of the above
View menu
Write the syntax for the following: Average
=COUNT()
=AVERAGE(range)
=MAX(num)
=SUM()
Fill in the blank: A ____________ list contains multiple addresses and recipients.
Mail merge
None of the above
Spelling
Split cell
Choose the correct choice: One byte is equal to ____________.
8 bits
6 bits
2 bits
4 bits
Correct the Sentence: Decoding refers to the process of identifying and correcting or removing errors.
Encoding refers to the process of identifying and correcting or removing errors.
The AND operator returns FALSE when all conditions mentioned within a block are False.
The AND operator returns TRUE when all conditions mentioned within a block are True.
Data is used for searching text within a worksheet.
Choose the correct choice: Which of the following enables you to send the same letter to different people?
All of the above
Sorting
Labels
Mail Merge
Which option is used to place the contents of more than one cell in a single cell
in the table?
Merge cell
Split cell
Spelling
None of the above
Repeated records can be deleted using .
Find and replace
Data validation
Remove duplicate
Substitute
Correct the Sentences. Data is used for searching text within a worksheet.
Merge cell is used to place the contents in a single cell.
Find is used for searching text within a worksheet
To unfreeze the panes, choose the unfreeze panes from the Home men
View menu
Design menu
Create and Print labels are used to create a ………………… address postage label
(a)
………………………. is present in the table layout menu
(a)
Define the Term Compiler:……………..
Define the Term interpreter: ………….
Write the syntax of operators AND / OR
Write the syntax of frequency
Write the syntax of IF
write the syntax for substitute
Sorting is used to arrange the data in the table in a sequential manner.
True
False
