COMPUTER 1
What is the main purpose of a Word Processor?
a) Drawing pictures
b) Typing and editing text
c) Playing music
d) Sending emails
b) Typing and editing text
In MS Word, which tab is used to add pictures?
a) Home
b) Insert
c) View
d) Layout
b) Insert
What is the intersection of a row and a column in Excel called?
a) Chart
b) Cell
c) Box
d) Graph
b) Cell
What is the shortcut for saving a file in MS Word?
a) Ctrl + O
b) Ctrl + P
c) Ctrl + S
d) Ctrl + Z
c) Ctrl+S
What is Mail Merge used for in MS Word?
a) Sending emails
b) Creating personalized letters for multiple recipients
c) Checking spelling errors
d) Formatting text
b) Creating personalized letters for multiple recipients
What is a cell in MS Excel?
a) A part of a table
b) A box formed by the intersection of a row and a column
c) A chart
d) A type of formula
b) A box formed by the intersection of a row and a column
In MS Word, what tool checks spelling and grammar?
a) Grammar Wizard
b) Spelling & Grammar Tool
c) Dictionary
d) Writing Assistant
b) Spelling & Grammar Tool
Which formula calculates the sum of cells A1 to A5 in Excel?
a) =SUM(A1:A5)
b) =TOTAL(A1:A5)
c) =ADD(A1:A5)
d) =A1+A5
a) =SUM(A1:A5)
How do you quickly open an existing file in MS Word?
a) Ctrl + F
b) Ctrl + O
c) Ctrl + T
d) Ctrl + X
b) Ctrl + O
What happens when you click "AutoSum" in Excel?
a) The selected cells are added together.
b) The selected numbers are multiplied.
c) The selected numbers are averaged.
d) The selected cells are cleared.
a) The selected cells are added together.
In Word, which feature allows you to organize content into headings and subheadings?
a) Navigation Pane
b) Table of Contents
c) References
d) Index Builder
b) Table of Contents
What is the shortcut to open the Print dialog box in MS Word or Excel?
a) Ctrl + P
b) Ctrl + S
c) Ctrl + Z
d) Ctrl + T
a) Ctrl + P
Which MS Word feature allows you to send personalized letters to multiple recipients?
a) Hyperlink
b) Mail Merge
c) Formatting
d) Spell Check
b) Mail Merge
What does the AutoSum button in Excel do?
a) Multiplies selected numbers
b) Adds selected numbers
c) Subtracts selected numbers
d) Formats selected cells
b) Adds selected numbers
What is the correct cell address for the cell in the 3rd row and 2nd column?
a) 3B
b) B3
c) 2C
d) C2
b) B3
What does the Ctrl + D shortcut do in MS Word?
a) Deletes the document
b) Opens the font formatting dialog box
c) Duplicates the text
d) Saves the document
b) Opens the font formatting dialog box
Describe how to insert a table in MS Word.
Go to the Insert tab, click on "Table," and select the number of rows and columns from the dropdown grid.
Write the Excel formula to calculate the average of cells A1, B1, and C1.
=AVERAGE(A1:C1)
Explain the steps to create a Mail Merge document in MS Word.
Click the Mailings tab, select "Start Mail Merge," choose the type of document, select recipients, add placeholders, and finish by previewing and printing.
How do you apply a background color to a cell in Excel?
Select the cell, click on the "Fill Color" icon in the Home tab, and choose a color.