MS Office Applications
1. Which of the following is not an application in MS Office suite?
A) Word
B) Excel
C) PowerPoint
D) Access
E) Photoshop
Answer: E
2. Which feature allows users to check spelling and grammar in a document in MS Word?
A) AutoCorrect
B) AutoFormat
C) Spell Check
D) Thesaurus
Answer: C
3.Which of the following is not a chart type in MS Excel?
A) Bar Chart
B) Line Chart
C) Pie Chart
D) Radar Chart
E) All of the above are chart types in MS Excel
Answer: E
4.Which feature allows users to apply a specific formatting to a range of cells in MS Excel?
A) Cell Styles
B) Conditional Formatting
C) Data Bars
D) Icon Sets
Answer: A
5.Which of the following is not a slide layout in MS PowerPoint?
A) Title Slide
B) Content Slide
C) Picture Slide
D) Comparison Slide
Answer: C
6.Which feature allows users to create a hyperlink to a webpage or file in MS Word?
A) Hyperlink
B) Insert Object
C) Bookmark
D) Cross-reference
Answer: A
7.Which of the following is not a type of alignment in MS Excel?
A) Left
B) Center
C) Right
D) Justified
Answer: D
8.Which feature allows users to view multiple worksheets at the same time in MS Excel?
A) Window Split
B) Freeze Panes
C) View Side by Side
D) Group Worksheets
Answer: C
9.Which of the following is not a design theme in MS PowerPoint?
A) Office
B) Civic
C) Integral
D) Equity
Answer: B
10.Which feature allows users to apply a specific design to a document in MS Word?
A) Theme
B) Style
C) Font
D) Format Painter
Answer: A
11.Which of the following is not a function in MS Excel?
A) Sum
B) Average
C) Multiply
D) Concatenate
E) All of the above are functions in MS Excel
Answer: E
12.Which feature allows users to merge cells in MS Excel?
A) Merge and Center
B) Split Cells
C) Wrap Text
D) Text Orientation
Answer: A
13.Which of the following is not a view in MS Word?
A) Print Layout
B) Draft
C) Outline
D) Design
Answer: D
14.Which feature allows users to insert a picture or clipart in MS PowerPoint?
A) Picture
B) Clip Art
C) Shapes
D) SmartArt
Answer: B
15.Which of the following is not a type of page orientation in MS Word?
A) Portrait
B) Landscape
C) Square
Answer: C
16.Which feature allows users to insert a table in MS Word?
A) Insert Table
B) Table Styles
C) Table Tools
D) All of the above
Answer: D
17.Which of the following is not a type of chart element in MS Excel?
A) Data Series
B) Chart Title
C) Chart Area
D) Chart Background
Answer: D
18.Which feature allows users to create a custom animation in MS PowerPoint?
A) Animation Painter
B) Animation Pane
C) Slide Master
D) Design Ideas
Answer: B
MS Word
1. What is the file extension used by Microsoft Word?
A) .docx
B) .xlsx
C) .pptx
D) .pdf
Answer: A
2. What is the purpose of the Home tab in Microsoft Word?
A) To access formatting options
B) To access document properties
C) To insert images and graphics
D) To view document statistics
Answer: A
3.What is the purpose of the Page Layout tab in Microsoft Word?
A) To adjust margins and page orientation
B) To access document templates
C) To insert hyperlinks and bookmarks
D) To view document properties
Answer: A
4. What is the purpose of the References tab in Microsoft Word?
A) To add footnotes and endnotes
B) To insert images and graphics
C) To create tables of contents
D) To access document statistics
Answer: A
5. Which of the following is not a commonly used text formatting option in Microsoft Word?
A) Bold
B) Italics
C) Underline
D) Strikethrough
Answer: D
6. Which of the following is not a commonly used paragraph formatting option in Microsoft Word?
A) Alignment
B) Line spacing
C) Font color
D) Indentation
Answer: C
7. What is the purpose of the Find and Replace feature in Microsoft Word?
A) To search for specific text in a document
B) To replace specific text with new text
C) To correct spelling errors
D) To adjust font formatting
Answer: A and B
8. Which of the following is not a commonly used table formatting option in Microsoft Word?
A) Cell borders
B) Cell shading
C) Cell animation
D) Cell merging
Answer: C
9. What is the purpose of the Insert tab in Microsoft Word?
A) To insert images and graphics
B) To insert tables and charts
C) To insert page breaks and section breaks
D) All of the above
Answer: D
10.Which of the following is not a commonly used image formatting option in Microsoft Word?
A) Size and position
B) Border and shading
C) Alt text
D) Animation
Answer: D
11.What is the purpose of the Review tab in Microsoft Word?
A) To access document statistics
B) To check spelling and grammar
C) To insert comments and track changes
D) To adjust formatting options
Answer: B and C
12.Which of the following is not a commonly used chart type in Microsoft Word?
A) Line chart
B) Bar chart
C) Pie chart
D) 3D chart
Answer: D
13.What is the purpose of the Mailings tab in Microsoft Word?
A) To create envelopes and labels
B) To merge data from a data source
C) To access document statistics
D) To adjust formatting options
Answer: A and B
14.Which of the following is not a commonly used list formatting option in Microsoft Word?
A) Bulleted list
B) Numbered list
C) Multilevel list
D) Table list
Answer: D
15. What is the purpose of the Quick Access Toolbar in Microsoft Word?
A) To access frequently used commands
B) To create new documents
C) To insert images and graphics
D) To view document statistics
Answer: A
16. Which of the following is not a commonly used header or footer formatting option in Microsoft Word?
A) Page number
B) Document title
C) Date and time
D) Table of contents
Answer: D
17. What is the purpose of the File tab in Microsoft Word?
A) To access document properties
B) To save and open documents
C) To print and share documents
D) All of the above
Answer: D
18. Which of the following is not a commonly used document layout option in Microsoft Word?
A) Portrait
B) Landscape
C) Columns
D) Table of contents
Answer: D
MS Excel
1.What is the extension for an Excel spreadsheet file?
A. .xls
B. .doc
C. .pdf
D. .ppt
Answer: A
2. Which function is used to add up a range of cells in Excel?
A. COUNT
B. SUM
C. MAX
D. MIN
Answer: B
3. Which menu is used to insert a new worksheet in Excel?
A. File
B. Edit
C. View
D. Insert
Answer: D
4. Which function is used to find the average of a range of cells in Excel?
A. AVG
B. SUM
C. MAX
D. MIN
Answer: A
5. Which ribbon contains the “Merge & Center” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: A
6. Which function is used to find the highest value in a range of cells in Excel?
A. COUNT
B. SUM
C. MAX
D. MIN
Answer: C
7. Which ribbon contains the “Sort” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: D
8. Which function is used to find the lowest value in a range of cells in Excel?
A. COUNT
B. SUM
C. MAX
D. MIN
Answer: D
9. Which ribbon contains the “Conditional Formatting” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: A
10. Which function is used to find the number of cells in a range that contain data in Excel?
A. COUNTA
B. COUNTIF
C. SUMIF
D. AVERAGEIF
Answer: A
11. Which ribbon contains the “Wrap Text” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: A
12. Which function is used to find the number of cells in a range that meet a specific criterion in Excel?
A. COUNTA
B. COUNTIF
C. SUMIF
D. AVERAGEIF
Answer: B
13. Which ribbon contains the “Filter” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: D
14. Which function is used to concatenate (join) two or more text strings in Excel?
A. CONCAT
B. CONCATENATE
C. JOIN
D. TEXTJOIN
Answer: B
15. Which ribbon contains the “Chart” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: B
16.Which ribbon contains the “Freeze Panes” option in Excel?
A. Home
B. Insert
C. Page Layout
D. View
Answer: D
17. Which ribbon contains the “Page Break Preview” option in Excel?
A. Home
B. Insert
C. Page Layout
D. View
Answer: C
18. Which ribbon contains the “Sort” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: D
19. Which function is used to find the rank of a number within a range of numbers in Excel?
A. RANK
B. PERCENTRANK
C. COUNTIF
D. SUMIF
Answer: A
20.Which ribbon contains the “Conditional Formatting” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: A
21. Which ribbon contains the “Data Validation” option in Excel?
A. Home
B. Insert
C. Page Layout
D. Data
Answer: D
22. Which function is used to find the largest value in a range of cells in Excel?
A. MAX
B. MIN
C. AVERAGE
D. COUNT
Answer: A
MS Power Point
1. Which of the following is a feature of PowerPoint that allows users to create visually appealing presentations?
A) Clip Art
B) Chart Wizard
C) Slide Master
D) Presenter View
Answer: A
2. Which view allows users to see a thumbnail of all slides in their presentation?
A) Slide Sorter View
B) Normal View
C) Slide Master View
D) Reading View
Answer: A
3. Which feature allows users to add animation to individual elements on a slide?
A) Transition
B) Custom Animation
C) SmartArt
D) Themes
Answer: B
4. Which of the following is not a type of slide layout in PowerPoint?
A) Title Slide
B) Picture and Text
C) Two-Column
D) Bullet Point List
E) All of the above are types of slide layouts
Answer: E
5. Which of the following is a feature of PowerPoint that allows users to add sound effects, music, or voiceovers to their presentations?
A) Animation
B) Transition
C) Audio
D) Slide Master
Answer: C
6. Which of the following is a view that allows users to edit the overall design and formatting of their presentation?
A) Normal View
B) Slide Sorter View
C) Slide Master View
D) Reading View
Answer: C
7. Which feature allows users to create a continuous loop of their presentation?
A) Custom Animation
B) Slide Show
C) Presenter View
D) Rehearse Timings
Answer: B
8. Which of the following is not a type of PowerPoint slide transition?
A) Fade
B) Dissolve
C) Wipe
D) Clip Art
Answer: D
9. Which of the following is a feature of PowerPoint that allows users to create interactive, clickable graphics?
A) Clip Art
B) SmartArt
C) Animation
D) Hyperlinks
Answer: D
10. Which of the following is not a type of PowerPoint animation?
A) Entrance
B) Emphasis
C) Exit
D) Sound
Answer: D
11. Which feature allows users to preview their presentation before presenting it to an audience?
A) Slide Sorter View
B) Presenter View
C) Rehearse Timings
D) Animation Pane
Answer: B
12. Which of the following is a feature of PowerPoint that allows users to create 3D models and diagrams?
A) SmartArt
B) Clip Art
C) Charts
D) 3D Models
Answer: D
13. Which feature allows users to customize the color, font, and layout of their PowerPoint presentation?
A) Themes
B) Slide Transitions
C) Clip Art
D) Hyperlinks
Answer: A
14. Which of the following is a view that allows users to see how their presentation will look when printed?
A) Normal View
B) Reading View
C) Slide Sorter View
D) Print Preview
Answer: D
15. Which feature allows users to add text, graphics, and other elements to a slide without affecting the layout of the slide?
A) Slide Layout
B) SmartArt
C) Text Box
D) Clip Art
Answer: C
16. Which feature allows users to automatically arrange and align objects on a slide?
A) Snap to Grid
B) Distribute Horizontally
C) Align Middle
D) Group Objects
Answer: A
17. Which feature allows users to add video to their PowerPoint presentation?
A) Animation
B) Transition
C) Audio
D) Media
Answer: D
18. Which of the following is not a type of PowerPoint chart?
A) Line Chart
B) Bar Chart
C) Pie Chart
D) Gantt Chart
E) All of the above are types of PowerPoint charts
Answer: E
19. Which feature allows users to create a custom color scheme for their PowerPoint presentation?
A) Themes
B) Slide Transitions
C) Color Picker
D) Format Painter
Answer: C
20. Which view allows users to see a full-screen preview of their PowerPoint presentation?
A) Slide Sorter View
B) Normal View
C) Reading View
D) Slide Show View
Answer: D
21. Which feature allows users to add a watermark to their PowerPoint presentation?
A) Clip Art
B) SmartArt
C) Background Styles
D) Page Setup
Answer: C
22. Which feature allows users to create interactive quizzes in their PowerPoint presentation?
A) Hyperlinks
B) Action Buttons
C) SmartArt
D) Animation
Answer: B
23. Which feature allows users to add comments to a PowerPoint presentation for collaboration purposes?
A) Review Comments
B) Slide Transitions
C) Hyperlinks
D) Slide Master
Answer: A
24. Which feature allows users to insert a table into their PowerPoint presentation?
A) Tables
B) SmartArt
C) Charts
D) Clip Art
Answer: A
25. Which of the following is a feature of PowerPoint that allows users to create a custom slide show from a larger presentation?
A) Custom Show
B) Presenter View
C) Rehearse Timings
D) Animation Pane
Answer: A
26. Which feature allows users to create a graph or chart directly from their PowerPoint presentation?
A) Chart Wizard
B) SmartArt
C) Clip Art
D) Themes
Answer: A
MS Access
1. Which of the following is not a type of database object in MS Access?
A) Tables
B) Forms
C) Reports
D) Macros
E) All of the above are types of database objects
Answer: E
2. Which of the following is not a data type in MS Access?
A) Text
B) Number
C) Currency
D) Picture
Answer: D
3. Which feature allows users to search for specific data within a table in MS Access?
A) Find
B) Search
C) Query
D) Filter
Answer: D
4. Which of the following is a function in MS Access that allows users to perform calculations on data in a table?
A) Expression Builder
B) Function Wizard
C) Aggregate Function
D) Math Function
Answer: C
5. Which feature allows users to create a relationship between two tables in MS Access?
A) Join
B) Lookup Wizard
C) Relationship Wizard
D) Table Design View
Answer: C
6. Which of the following is not a query type in MS Access?
A) Select Query
B) Update Query
C) Append Query
D) Delete Query
E) All of the above are query types in MS Access
Answer: E
7. Which feature allows users to group and summarize data in a table or query in MS Access?
A) Filter
B) Sort
C) PivotTable
D) Join
Answer: C
8. Which of the following is not a report layout in MS Access?
A) Columnar
B) Tabular
C) Form
D) Justified
Answer: D
9. Which feature allows users to specify criteria to filter data in a report in MS Access?
A) Grouping
B) Sorting
C) Parameters
D) Totals
Answer: C
10. Which of the following is not a type of form in MS Access?
A) Single Form
B) Split Form
C) Tabbed Form
D) Query Form
Answer: D
11. Which feature allows users to create a custom calculation in a query in MS Access?
A) Expression Builder
B) Query Wizard
C) Function Builder
D) Aggregate Function
Answer: A
12. Which of the following is not a data validation rule in MS Access?
A) Required Field
B) Unique Value
C) Range Check
D) Referential Integrity
Answer: D
13. Which feature allows users to create a backup copy of their MS Access database?
A) Save As
B) Backup Database
C) Export
D) Compact and Repair
Answer: B
14. Which of the following is not a join type in MS Access?
A) Inner Join
B) Outer Join
C) Cross Join
D) Self Join
E) All of the above are join types in MS Access
Answer: E
15. Which feature allows users to specify how data should be displayed in a field in a table or query in MS Access?
A) Format
B) Validation Rule
C) Input Mask
D) Default Value
Answer: A
16. Which of the following is not a way to create a new table in MS Access?
A) Table Design View
B) Table Wizard
C) Import Table
D) Export Table
Answer: D
17. Which feature allows users to automatically sort data in a table or query in MS Access?
A) Sort Ascending
B) Sort Descending
C) Sort A to Z
D) Sort Z to A
Answer: A
