ICT Tower3rd Floor, Agnibina Road, Jhenaidah (MTA)

Email: mtajnd@[Link] Mobile: 01717-171166, 01915-903003

[Link] STP-JHE-001590

Part 1: Multiple Choice Questions (10 Marks)

1. Which function in Microsoft Excel is used to count the number of cells that contain numbers
only?
a) =COUNTA()
b) =COUNT()
c) =COUNTIF()
d) =SUM()
2. In Microsoft Word, what is the shortcut key to insert a Page Break?
a) Ctrl + Enter
b) Alt + Enter
c) Shift + Enter
d) Ctrl + Shift + Enter
3. Which of the following is NOT a valid data type in Microsoft Access?
a) Short Text
b) Currency
c) Graph
d) Yes/No
4. In PowerPoint, which view is best used for reordering slides easily?
a) Normal View
b) Slide Sorter View
c) Reading View
d) Slide Master View
5. What is the default file extension for a macro-enabled Word document?
a) .docx
b) .docm
c) .dotx
d) .rtf
6. Which feature in Excel allows you to freeze the top row so it remains visible while scrolling?
a) Split Window
b) Freeze Panes
c) Arrange All
d) View Side by Side
7. What is the maximum zoom percentage available in Microsoft Word?
a) 100%
b) 300%
c) 400%
d) 500%
8. Which key is used to start a slideshow from the current slide in PowerPoint?
a) F5
b) Shift + F5
c) Ctrl + F5
d) Alt + F5
 ICT Tower3rd Floor, Agnibina Road, Jhenaidah (MTA)
Email: mtajnd@[Link] Mobile: 01717-171166, 01915-903003
[Link] STP-JHE-001590

9. Which network protocol is primarily used for sending emails?

a) HTTP
b) FTP
c) SMTP
d) POP3
10. The process of combining a main document with a data source (like a list of names) in Word is
called:
a) Data Merge
b) Mail Merge
c) Consolidation
d) Link Embedding

Part 2: Fill in the Gaps (10 Marks)

11. _________ memory is a volatile memory that stores data temporarily while the computer is
running.
12. In Excel, the intersection of a row and a column is called a _________.
13. The _________ Painter tool in MS Word is used to copy formatting from one text selection to
another.
14. A _________ is a small image displayed in the browser tab that represents a website (often
called a "favorite icon").
15. _________ is the database object in MS Access used to retrieve specific data from tables based
on defined criteria.
16. The _________ function in Excel is used to join several strings of text into one text string.
17. In PowerPoint, a _________ is a pre-designed set of colors, fonts, and effects that can be applied
to your entire presentation.
18. _________ software helps to protect a computer system from viruses and malicious attacks.
19. The keyboard shortcut _________ is used to "Redo" the last undone action in most Windows
applications.
20. A _________ chart in Excel is often used to show trends over time (years, months, days) or
categories.

Part 3: True or False (10 Marks)

21. [ T / F ] You can insert a video directly into a Microsoft Word document and play it.
22. [ T / F ] An "Absolute Cell Reference" in Excel (e.g., $A$1) changes when the formula is copied to
another cell.
23. [ T / F ] The "Slide Master" in PowerPoint controls the look of all slides in a presentation.
24. [ T / F ] 1 Gigabyte (GB) is equal to 1024 Kilobytes (KB).
25. [ T / F ] You can use the "Track Changes" feature in Word to see edits made by other users.
26. [ T / F ] In MS Access, a "Primary Key" field allows duplicate values.
27. [ T / F ] "Ctrl + H" is the shortcut key to open the Replace dialog box in Word and Excel.
28. [ T / F ] A Pie Chart is best used for comparing more than 10 different categories of data.
29. [ T / F ] The "Recycle Bin" stores deleted files permanently and they cannot be restored.
 ICT Tower3rd Floor, Agnibina Road, Jhenaidah (MTA)
Email: mtajnd@[Link] Mobile: 01717-171166, 01915-903003
[Link] STP-JHE-001590

30. [ T / F ] "Landscape" refers to the page orientation where the page is wider than it is tall.

Part 4: Matching (10 Marks)

Match the Term in Column A with the correct Description in Column B.

Column A (Term) Column B (Description)

31. Gutter Margin A. A tool to copy formatting from one place to another.

32. PivotTable B. The main circuit board of a computer.

33. Thesaurus C. A margin added to the binding side of a page for printing.

34. Motherboard D. An Excel tool used to summarize and analyze large datasets.

35. Format
E. A temporary storage area for copied or cut data.
Painter

36. Clipboard F. A built-in tool used to find synonyms for words.

37. Hyperlink G. A communication standard for connecting devices like printers/mice.

38. USB H. A clickable link that directs to a webpage or file.

39. Watermark I. A faint text or image behind the content of a document.

J. An interface that allows users to interact with electronic devices using

40. GUI
icons.

Part 5: Short Questions with Answers (10 Marks)

41. What is the difference between "Save" and "Save As"?
o Answer: "Save" updates the current file with the latest changes, keeping the same name
and location. "Save As" allows you to save a copy of the file with a new name, new file
type, or in a new location.
42. Define "Mail Merge" in Microsoft Word.
o Answer: Mail Merge is a feature that allows users to create a batch of documents (like
letters or labels) that are personalized for each recipient. It combines a main document
(template) with a data source (recipient list).
43. What is the purpose of "Conditional Formatting" in Excel?
 ICT Tower3rd Floor, Agnibina Road, Jhenaidah (MTA)
Email: mtajnd@[Link] Mobile: 01717-171166, 01915-903003
[Link] STP-JHE-001590

o Answer: Conditional Formatting automatically changes the appearance (color, font,

border) of cells based on specific conditions or values (e.g., highlighting all cells with
values greater than 50 in red).
44. What is a "Query" in a database context (MS Access)?
o Answer: A Query is a request for data results from a database. It is used to retrieve,
filter, sort, or modify specific data from one or more tables based on user-defined
criteria.
45. Explain the function of the "Control Unit" (CU) in a CPU.
o Answer: The Control Unit directs the operation of the processor. It tells the computer's
memory, arithmetic/logic unit, and input and output devices how to respond to the
instructions that have been sent to the processor.
46. What is the difference between a "Header" and a "Footer"?
o Answer: A Header is the section of the document that appears in the top margin of
every page, while a Footer appears in the bottom margin. Both are used for repeating
information like page numbers, dates, or titles.
47. What does the "VLOOKUP" function do in Excel?
o Answer: VLOOKUP (Vertical Lookup) searches for a value in the first column of a table
range and returns a value in the same row from a specified column.
48. Describe the purpose of "Transitions" in PowerPoint.
o Answer: Transitions are visual effects that occur when you move from one slide to the
next during a presentation (e.g., Fade, Push, Wipe).
49. What is a "Macro"?
o Answer: A Macro is a series of commands and instructions that you group together as a
single command to accomplish a task automatically. It is often used to automate
repetitive tasks.
50. What is the full form of PDF and why is it used?
o Answer: PDF stands for Portable Document Format. It is used to present documents in a
manner independent of application software, hardware, and operating systems,
ensuring the document looks the same on any device.

Answer Key
Part 1: Multiple Choice
1. b (=COUNT)
2. a (Ctrl + Enter)
3. c (Graph)
4. b (Slide Sorter View)
5. b (.docm)
6. b (Freeze Panes)
7. d (500%)
8. b (Shift + F5)
9. c (SMTP)
10. b (Mail Merge)
 ICT Tower3rd Floor, Agnibina Road, Jhenaidah (MTA)
Email: mtajnd@[Link] Mobile: 01717-171166, 01915-903003
[Link] STP-JHE-001590

Part 2: Fill in the Gaps

11. RAM (Random Access Memory)
12. Cell
13. Format
14. Favicon
15. Query
16. CONCATENATE (or CONCAT)
17. Theme
18. Antivirus
19. Ctrl + Y
20. Line (or Bar)
Part 3: True or False
21. True (Modern Word versions support online/offline video embedding)
22. False (Absolute references like $A$1 remain constant when copied)
23. True
24. False (1 GB = 1024 Megabytes (MB), not KB)
25. True
26. False (Primary Keys must be unique)
27. True
28. False (Pie charts are best for a small number of categories, usually 5-7 max)
29. False (Files in Recycle Bin can be restored until emptied)
30. True
Part 4: Matching
31-C, 32-D, 33-F, 34-B, 35-A, 36-E, 37-H, 38-G, 39-I, 40-J.
Learn more about Office Applications here: Advanced Excel Tutorial
This video is relevant because it covers the foundational concepts of computer office applications which
directly relates to the exam topics above.