Computer Science MCQs – MS Office (Job Test Preparation in Pakistan)
What is MS Office?
MS Office is a collection of productivity software including Word, Excel, PowerPoint, Access, and Outlook.
Which program in MS Office is used to create documents?
MS Word is used for creating text documents like letters, reports, and essays.
Which MS Office application is used for creating spreadsheets?
MS Excel is used for data analysis, calculations, and organizing data in rows and columns.
Which MS Office tool is used for managing databases?
MS Access is a database management tool used to store, organize, and manage large datasets.
Which MS Office application uses slides to present information?
MS PowerPoint is used to create presentations using slides with text, images, and animations.
What is the purpose of MS Outlook?
MS Outlook is used to send, receive, and organize emails, calendar events, and contacts.
What is a template in MS Office?
A template is a pre-formatted file that can be used to create documents, presentations, or spreadsheets quickly.
Which MS Office application includes the use of slides and transitions?
MS PowerPoint allows adding animations and transitions between slides for professional presentations.
Which MS Office application is primarily used for sending and receiving emails?
MS Outlook is an email client that helps in communication and organizing emails efficiently.
Which MS Office program is best for calculations?
MS Excel is ideal for performing calculations, using formulas, and analyzing numerical data.
A file created in MS Word is called?
A document in MS Word is a file containing text, images, and formatting.
Which MS Office tool is used for charts?
MS Excel can create charts to visually represent numerical data.
MS Excel rows are identified by?
In Excel, rows are horizontal and are numbered 1, 2, 3, etc.
Which MS Office application is used for mail scheduling?
MS Outlook can schedule and manage emails, meetings, and appointments.
MS PowerPoint file extension is?
The default file extension for PowerPoint presentations is .pptx.
Which key is used to save a file?
Ctrl+S is the keyboard shortcut to save files in most MS Office applications.
The first slide in a presentation is called?
The first slide in a presentation is usually the title slide, containing the presentation title and subtitle.
Which MS Office program supports formulas?
Excel supports formulas and functions to perform calculations on data.
A collection of slides is called?
A set of slides in PowerPoint is called a presentation.
Which MS Office tool is used for printing letters in bulk?
MS Word's mail merge feature allows printing multiple letters or documents at once.
Mail merge is a feature of?
Mail merge in Word helps create personalized letters, labels, and emails efficiently.
Which view shows slide thumbnails?
Slide Sorter view displays all slides as thumbnails to easily rearrange them.
Cells in Excel are formed by intersection of?
A cell is the intersection of a row and a column in Excel.
Which MS Office app stores data in tables?
MS Access stores information in tables for database management.
The default font in MS Word is?
The default font in MS Word is Calibri, size 11.
Which option is used to insert pictures?
The Insert tab allows adding pictures, charts, shapes, and other objects.
Spreadsheet software is mainly used for?
Spreadsheet software like Excel is primarily used for calculations and data analysis.
Which MS Office program supports slide animations?
PowerPoint allows adding animations and transitions to slides for presentations.
The topmost bar in MS Office window is called?
The Title Bar displays the name of the application and the currently open file.
Which shortcut is used to copy text?
Ctrl+C is the keyboard shortcut to copy selected text or objects.
A worksheet is part of?
A worksheet is a single sheet within an Excel workbook.
Which MS Office feature checks spelling?
Spell Check is used to find and correct spelling errors in documents.
The bottom bar showing page info is called?
The Status Bar at the bottom shows page number, word count, and other information.
Which MS Office app can create forms?
MS Access allows creating forms to input and manage database records easily.
Slides are arranged vertically in which view?
Normal view in PowerPoint displays slides vertically along with editing options.
Which key deletes selected text?
The Delete key removes selected text or objects in a document.
The default page orientation in MS Word is?
MS Word's default page orientation is Portrait, which is vertical.
Which MS Office app is best for reports?
Word is used for creating reports, letters, and textual documents.
Graphs in Excel are also called?
Charts visually represent data in Excel using bars, lines, or pie diagrams.
Which option closes MS Office application?
The Close option exits the MS Office application.
A database is a collection of?
A database stores organized data that can be retrieved and managed efficiently.
Which MS Office tool helps in presentations during meetings?
PowerPoint is used for giving professional presentations in meetings and classrooms.
Rows in Excel run from?
Rows are horizontal lines in Excel that run from top to bottom.
Which option is used to underline text?
Ctrl+U is the shortcut to underline selected text in MS Office applications.
A column in Excel is identified by?
Columns in Excel are vertical and identified by letters A, B, C, etc.
Which MS Office feature protects a file?
Encrypting a file allows setting a password to protect sensitive information.
Notes added to slides are visible in?
Notes view in PowerPoint displays the speaker notes along with slides.
Which MS Office program can import data?
Excel allows importing data from databases, text files, and web sources.
The shortcut Ctrl+Z is used for?
Ctrl+Z reverses the last action in most MS Office applications.
Which MS Office application supports pivot tables?
Pivot tables in Excel summarize and analyze large datasets quickly.