Microsoft Office: Important MCQs for Govt & Banking Exams
... minute read
In today's competitive job market, proficiency in Microsoft Office is a
crucial skill for government and banking job aspirants. Whether you're
preparing for an exam or looking to improve your skills, understanding the
basics of Microsoft Office applications is essential.
This post provides a comprehensive guide to Microsoft Office with a set of
multiple-choice questions (MCQs) to help you test your knowledge and prepare
effectively. The MCQs are taken from various exam previous year questions, so
you can have a good understanding which topics are repeatedly asked in exams.
PracticeShow All Answers
Q1: A collection of related files is called _______.
A. Character
B. Field
C. Data base
D. Record
A database is an organized collection of data stored and accessed electronically. Databases can contain a variety of information, such as records, fields, and tables, and are used to manage and retrieve data efficiently.
Q2: In which group do we work at the time of text formatting in word?
A. Table, Paragraph and Indexes
B. Paragraph, Indexes and Sections
C. Characters, sections and paragraphs
D. Indexes, Characters and Tables
Text formatting in Microsoft Word typically involves working with characters (font, size, color), sections (margins, headers, footers), and paragraphs (alignment, indentation, spacing). These elements are crucial for creating well-structured and visually appealing documents.
Q3: To save an existing file with a new name at a new location, we should use _______ command.
A. Save
B. Save and replace
C. Save as
D. New file
The "Save As" command in Microsoft Office applications allows you to save a copy of the current file with a new name and/or in a different location. This is useful for creating different versions of a document without overwriting the original.
Q4: Excel workbook is a collection of _______.
A. Chart
B. Word book
C. Worksheet
D. a and c
An Excel workbook is a file that contains one or more worksheets, which are individual spreadsheets within the workbook. Each worksheet can contain charts, tables, and other data. The workbook allows for organized and efficient data management.
Q5: In a spreadsheet program, the _______ contains related worksheets and documents.
A. Workbook
B. Column
C. Call
D. Formula
A workbook in a spreadsheet program like Microsoft Excel is a collection of related worksheets. Each worksheet can contain different sets of data, charts, and formulas, allowing for comprehensive data analysis and organization.
Q6: Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?
A. Data base
B. Document processor
C. Graphics package
D. Spreadsheet
Spreadsheet software, such as Microsoft Excel, is designed for performing numerical and statistical calculations. It allows users to organize data in rows and columns, apply formulas, and create charts and graphs for data analysis.
Q7: The background of any word document _______.
A. is always white colour
B. is the colour you preset under the option menu
C. is always the same for the entire document
D. Can have any colour you choose
In Microsoft Word, you can customize the background color of your document to any color you choose. This feature allows for personalized and visually appealing documents, enhancing readability and presentation.
Q8: What is a default file extension for all word documents?
A. TXT
B. WRD
C. FIL
D. DOC
The default file extension for Microsoft Word documents is .doc (or .docx in newer versions). This extension indicates that the file is a Word document and can be opened and edited using Microsoft Word.
Q9: Text in a column is generally aligned _______.
A. Justified
B. Right
C. Center
D. Left
In most spreadsheet programs, text in a column is generally aligned to the left by default. This alignment ensures that text entries are easily readable and consistent across the column.
Q10: A directory within a directory is called _______.
A. Mini directory
B. Junior directory
C. Part directory
D. Sub directory
A subdirectory is a directory within another directory. It helps in organizing files and folders hierarchically, making it easier to manage and locate specific files within a file system.
Q11: For opening and closing of a file in Excel, you can use which bar?
A. Formatting
B. Standard
C. Title
D. Formatting or Title
The Standard toolbar in older versions of Microsoft Excel (or the File tab in newer versions) contains commands for opening, closing, saving, and printing files. This toolbar provides quick access to essential file management functions.
Q12: You click at B to make the text _______.
A. Italics
B. Underlined
C. Italics and underlined
D. Bold
In Microsoft Word, clicking the "B" button in the toolbar applies bold formatting to the selected text. Bold text is used to emphasize important information and make it stand out.
Q13: For creating a document, you use _______ command at file menu.
A. Open
B. Close
C. New
D. Save
The "New" command in the File menu of Microsoft Word is used to create a new document. This command opens a blank document where you can start typing and formatting your content.
Q14: You can start Microsoft Word by using _______ button.
A. New
B. Start
C. Program
D. Control panel
In Windows operating systems, you can start Microsoft Word by clicking the "Start" button and selecting "Microsoft Word" from the list of programs. This action launches the Word application.
Q15: In Excel, charts are created using which option?
A. Chart wizard
B. Pivot table
C. Pie chart
D. Bar chart
In older versions of Microsoft Excel, the Chart Wizard is used to create various types of charts. It guides you through the steps of selecting data, choosing chart types, and customizing the chart's appearance.
Q16: In page preview mode _______.
A. You can see all pages of your document
B. You can only see the page you are currently working on
C. You can only see pages that do not contain graphics
D. You can only see the title page of your document
In page preview mode (or Print Preview) in Microsoft Word, you can see how the current page will look when printed. This mode allows you to check the layout, formatting, and appearance of the page before printing.
Q17: File extensions are used in order to _______.
A. Name the file
B. Identify the file
C. Answer the file name is not last
D. Identify the file type
File extensions are used to identify the type of file. For example, .docx indicates a Microsoft Word document, .xlsx indicates an Excel spreadsheet, and .pptx indicates a PowerPoint presentation. File extensions help the operating system and applications recognize and open files correctly.
Q18: Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?
A. Database
B. Document processor
C. Graphic package
D. Spreadsheet
Spreadsheet software, such as Microsoft Excel, is specifically designed for performing numerical and statistical calculations. It provides tools for data analysis, financial calculations, and creating charts and graphs.
Q19: Which elements of a word document can be displayed in colour?
A. Only graphics
B. Only text
C. All elements
D. All elements, but only if you have a colour printer
In Microsoft Word, you can display various elements of a document in color, including text, graphics, tables, and backgrounds. This feature enhances the visual appeal and readability of the document.
Q20: A collection of related information sorted and dealt with as a unit is a _______.
A. Disk
B. Data
C. File
D. Floppy
A file is a collection of related information stored as a unit. Files can contain text, images, data, and other types of information and are used to organize and manage data efficiently.
Q21: MS-Word is an example of _______.
A. An operating system
B. A processing device
C. Application software
D. An input device
Microsoft Word is an example of application software. It is designed to create, edit, and format text documents, providing tools for word processing, formatting, and document management.
Q22: The blinking point which shows your position in the text is called _______.
A. Blinker
B. Cursor
C. Causer
D. Pointer
The cursor is a blinking point or line that indicates the position in the text where the next character will be inserted. It helps users know where they are typing or editing in a document.
Q23: Which application is commonly used to prepare a presentation/slide show?
A. Photoshop
B. Power point
C. Outlook Express
D. Internet explorer
Microsoft PowerPoint is commonly used to prepare presentations and slide shows. It provides tools for creating slides, adding text, images, and multimedia, and delivering presentations effectively.
Q24: The quickest and easiest way in word, to locate a particular word or phrase in a document is to use the command.
A. Replace
B. Find
C. Lookup
D. Search
The "Find" command in Microsoft Word is used to locate a particular word or phrase within a document quickly. It allows users to search for specific text and navigate to its location in the document.
Q25: What kind of software would you most likely use to keep track of a billing account?
A. Word processing
B. Electronic publishing
C. Spreadsheet
D. Web authoring
Spreadsheet software, such as Microsoft Excel, is commonly used to keep track of billing accounts. It provides tools for data entry, calculations, and financial management, making it suitable for tracking and analyzing billing information.
Q26: What are bas, doc and htm examples of?
A. Data bases
B. Extensions
C. Domains
D. Protocols
File extensions such as .bas (Basic source code), .doc (Microsoft Word document), and .htm (HTML file) are used to identify the type of file. Extensions help the operating system and applications recognize and open files correctly.
Q27: A _______ is a unique name that you give to a file of information.
A. Device letter
B. Folder
C. File name
D. File name extension
A file name is a unique name given to a file to identify it. File names help users and the operating system locate and manage files efficiently.
Q28: Editing document consists of reading through the document you've created, then _______.
A. Correcting your errors
B. Printing it
C. Saving it
D. Defeating it
Editing a document involves reading through the content and correcting any errors, such as spelling, grammar, and formatting mistakes. This process ensures that the document is accurate and well-presented.
Q29: In a database, _______ fields store numbers used to perform calculation.
A. Next
B. Key
C. Alphanumeric
D. Numeric
In a database, numeric fields are used to store numbers that can be used in calculations. These fields allow for mathematical operations and data analysis, such as sums, averages, and statistical calculations.
Q30: All of the following terms are associated with spreadsheet software except _______.
A. Worksheet
B. Cell
C. Formula
D. Virus detection
Virus detection is not associated with spreadsheet software. Spreadsheet software, such as Microsoft Excel, includes terms like worksheet, cell, and formula, which are used for data entry, calculations, and analysis.
Q31: Which of the following is not true about computer files?
A. They are collections of data saved to a storage medium
B. Every file has a file name
C. A file extension is established by the user to indicate the files content
D. Files usually contain data
File extensions are not established by the user to indicate the file's content. File extensions are predefined and used by the operating system and applications to recognize and open files correctly.
Q32: To add or put into your document such as a picture or text use _______.
A. TV
B. Insert
C. Push in
D. Squeeze in
The "Insert" command in Microsoft Word is used to add elements such as pictures, text, tables, and other objects into a document. This command allows users to enhance their documents with additional content.
Q33: What is the main folder on a storage device called?
A. Platform
B. Interface
C. Root Directory
D. Home page
The main folder on a storage device is called the root directory. It is the top-level directory that contains all other folders and files on the storage device, providing a hierarchical structure for organizing data.
Q34: For creating a document, you use _______ command at file menu.
A. Open
B. Close
C. New
D. Save
The "New" command in the File menu of Microsoft Word is used to create a new document. This command opens a blank document where you can start typing and formatting your content.
Q35: A(n) _______ is created by an application.
A. Executable file
B. Software program
C. Document
D. Operating system
A document is created by an application, such as Microsoft Word, Excel, or PowerPoint. Documents contain text, data, images, and other content that can be edited, formatted, and saved using the application.
Q36: Two different files can have the same name if _______.
A. They are in different folders
B. They are on different drives
C. Never
D. The names are capitalized differently
Two different files can have the same name if they are located in different folders. This allows for organized and efficient file management, as files with the same name can be stored in separate locations without conflict.
Q37: Meaningful filename helps in easy file _______.
A. Storing
B. Accessing
C. Identification
D. Printing
Meaningful filenames help in easy file accessing. By using descriptive and relevant filenames, users can quickly locate and open the files they need, improving efficiency and organization.
Q38: A program that enables you to perform calculations involving rows and columns of numbers is called a _______.
A. Spreadsheet program
B. Word processor
C. Graphics package
D. Window
A spreadsheet program, such as Microsoft Excel, enables users to perform calculations involving rows and columns of numbers. It provides tools for data entry, formulas, and analysis, making it suitable for financial and statistical calculations.
Q39: To _______ a document means to make changes to its existing content.
A. Format
B. Save
C. Edit
D. Print
To edit a document means to make changes to its existing content. Editing involves adding, deleting, or modifying text, formatting, and other elements to improve the document's accuracy and presentation.
Q40: Periodically adding, changing and deleting file records is called file _______.
A. Updating
B. Upgrading
C. Restructuring
D. Renewing
Updating a file involves periodically adding, changing, and deleting file records to keep the information current and accurate. This process ensures that the file reflects the most recent data and changes.
Q41: How do you save a presentation under a new file name?
A. Select the file menu and choose save as
B. When you close powerpoint the file will automatically be saved
C. Select the file menu and choose save
D. The file will automatically be saved under the new name if you change the title
To save a presentation under a new file name, you select the File menu and choose "Save As." This command allows you to save a copy of the presentation with a new name and/or in a different location without overwriting the original file.
Q42: Saving is the process of _______.
A. copying a document from memory to a storage medium
B. making changes to a document's existing content
C. changing the appearance, or overall look, of a document
D. developing a document by entering text using a keyboard
Saving is the process of copying a document from the computer's memory to a storage medium, such as a hard drive or USB drive. This ensures that the document is preserved and can be accessed later.
Q43: When computer users _______ a document, they change its appearance.
A. Edit
B. Create
C. Save
D. Format
When computer users format a document, they change its appearance by adjusting elements such as font, size, color, alignment, and spacing. Formatting enhances the document's readability and visual appeal.
Q44: What menu is selected to print?
A. File
B. Tools
C. Special
D. Edit
The "File" menu in Microsoft Word contains the "Print" command, which is used to print the document. This menu provides options for printing, saving, opening, and closing documents.
Q45: A saved document is referred to as a _______.
A. File
B. Word
C. Folder
D. Project
A saved document is referred to as a file. Files contain the data and information that have been saved to a storage medium, allowing for future access and editing.
Q46: A command that takes what has been typed into the computer and can be seen on the screen and sends it to the printer for output on paper _______.
A. Print
B. Return
C. Jump
D. Attention
The "Print" command in Microsoft Word sends the document to the printer for output on paper. This command allows users to produce a hard copy of the document for physical distribution and review.
Q47: To find a saved document in the computer's memory and bring it up on the screen to view _______.
A. Reverse
B. Rerun
C. Retrieve
D. Return
To retrieve a saved document means to find it in the computer's memory and bring it up on the screen to view. This process allows users to access and work with previously saved documents.
Q48: Allows you to print _______.
A. Ribbon
B. Monitor
C. Go now
D. Control-P
The keyboard shortcut "Control-P" (Ctrl+P) in Microsoft Word allows you to print the document. This shortcut opens the Print dialog box, where you can select printing options and send the document to the printer.
Q49: The different styles of lettering in a word processing program _______.
A. Font
B. Calligraphy
C. Writing
D. Manuscript
In a word processing program, font refers to the different styles of lettering used for text. Fonts can vary in size, style, and weight, allowing users to customize the appearance of their documents.
Q50: To change written work already done _______.
A. File
B. Edit
C. Cut
D. Close
To edit written work already done, you use the "Edit" command. Editing involves making changes to the existing content, such as correcting errors, adding or deleting text, and adjusting formatting.
Q51: To exit the program without leaving the application _______.
A. File
B. Edit
C. Copy
D. Cart away
To exit the program without leaving the application, you use the "File" menu and select the "Exit" or "Close" command. This action closes the current document but keeps the application open for further use.
Q52: A command that saves what you are working on into the hard drive, or onto a disk _______.
A. View
B. Hold
C. Save
D. Go
The "Save" command in Microsoft Word saves the document you are working on into the hard drive or onto a disk. This command ensures that your work is preserved and can be accessed later.
Q53: A command to get a file you worked on from the memory where it was stored _______.
A. Close
B. Delete
C. Open
D. Get it
The "Open" command in Microsoft Word allows you to get a file you worked on from the memory where it was stored. This command brings the file up on the screen for viewing and editing.
Q54: A program that works like a calculator for keeping track of money and making budgets _______.
A. Calculator
B. Spreadsheet
C. Budgeter
D. Financier
A spreadsheet program, such as Microsoft Excel, works like a calculator for keeping track of money and making budgets. It provides tools for data entry, calculations, and financial analysis, making it suitable for budgeting and financial planning.
Q55: What menu is selected to save or save as?
A. Tools
B. File
C. Format
D. Edit
The "File" menu in Microsoft Word contains the "Save" and "Save As" commands. These commands allow you to save the current document or save a copy of the document with a new name and/or in a different location.
Q56: A(n) _______ in text that you want printed at the bottom of the page.
A. Header
B. Endonte
C. Footnote
D. Footer
A footer is a section at the bottom of a page that contains text or information that you want printed on every page. Footers are commonly used for page numbers, dates, and other repeated information.
Q57: To print a document, press _______ then press Enter.
A. Shift +P
B. Ctrl+P
C. Alt + P
D. Esc + P
The keyboard shortcut "Ctrl+P" in Microsoft Word is used to print a document. This shortcut opens the Print dialog box, where you can select printing options and send the document to the printer.
Q58: A(n) _______ in text that you want printed at the bottom of the page.
A. Header
B. Endonte
C. Footnote
D. Footer
A footer is a section at the bottom of a page that contains text or information that you want printed on every page. Footers are commonly used for page numbers, dates, and other repeated information.
Q59: A telephone number, a birth date, and a customer name are all examples of _______.
A. a record
B. data
C. a all
D. a database
A telephone number, a birth date, and a customer name are all examples of data. Data refers to individual pieces of information that can be stored, organized, and analyzed in a database.
Q60: Which of the following contains information about a single "entity" in the database-like a person, place, event or thing?
A. query
B. form
C. record
D. table
A record in a database contains information about a single entity, such as a person, place, event, or thing. Records are organized into fields, which hold specific pieces of data related to the entity.
Q61: Numbers in table columns are usually _______.
A. right-aligned
B. left-aligned
C. justified
D. centered
In most spreadsheet programs, numbers in table columns are usually right-aligned by default. This alignment ensures that numbers are easily readable and consistent across the column.
Q62: By default, your documents print in _______ mode.
A. Landscape
B. Portrait
C. Page Setup
D. Print View
By default, documents in Microsoft Word print in portrait mode, which is a vertical orientation. This mode is suitable for most text-based documents and ensures that the content fits well on the page.
Q63: Which type of file is created by word processing programs?
A. database file
B. storage file
C. worksheet file
D. document file
Word processing programs, such as Microsoft Word, create document files. These files contain text, formatting, and other content that can be edited, saved, and printed using the word processing software.
Q64: Data (information) is stored in computers as _______.
A. files
B. directories
C. fingers
D. matter
Data (information) is stored in computers as files. Files are organized collections of data that can be saved, accessed, and managed using various software applications and operating systems.
Q65: The name a user assigns to a document is called a(n) _______.
A. filename
B. program
C. record
D. data
The name a user assigns to a document is called a filename. Filenames help users and the operating system identify and locate specific files for access and management.
Q66: What is the main folder on a storage device called?
A. Platform
B. Interface
C. Root directory
D. device driver
The main folder on a storage device is called the root directory. It is the top-level directory that contains all other folders and files on the storage device, providing a hierarchical structure for organizing data.
Q67: In order to e-mail a Word document from within Word _______.
A. Go to file/Send To/Mail Recipient
B. Save the file as an e-mail attachment
C. Start Outlook and attach the file while open in Word
D. This is an impossible operation
To e-mail a Word document from within Word, you go to the File menu and select "Send To" and then "Mail Recipient." This command opens your e-mail client with the document attached, allowing you to send it directly from Word.
Q68: The _______ feature in Word automatically corrects certain spelling, typing, capitalization, or grammar errors.
A. AutoFix
B. AutoSpell
C. AutoMark
D. AutoCorrect
The "AutoCorrect" feature in Microsoft Word automatically corrects certain spelling, typing, capitalization, or grammar errors as you type. This feature helps improve the accuracy and consistency of your documents.
Q69: You organize files by storing them in _______.
A. archives
B. folders
C. indexes
D. lists
Files are organized by storing them in folders. Folders help users manage and locate files efficiently by providing a hierarchical structure for organizing data.
Q70: In order to create columnar data in Word you need to _______.
A. Tab consecutively until cursor reaches the desired place
B. Set tabs or use the Table menu
C. You need to use Excel
D. Press the space bar until your cursor reaches the desired place
To create columnar data in Microsoft Word, you need to set tabs or use the Table menu. Tabs allow you to align text in columns, while the Table menu provides tools for creating and formatting tables with columnar data.
Q71: When you want to move some text from one page to a different page, the best method is _______.
A. drag and drop
B. cut and past
C. delete and retype
D. find and replace
The best method to move text from one page to a different page in Microsoft Word is to cut and paste. This method ensures that the text is removed from its original location and placed in the new location accurately.
Q72: A red wavy line under a word indicates that the word _______.
A. is too long for the line of text
B. is not in the dictionary file and therefore might be spelt incorrectly
C. is not appropriate for that particular sentence
D. is a verb
A red wavy line under a word in Microsoft Word indicates that the word is not in the dictionary file and therefore might be spelled incorrectly. This feature helps users identify and correct spelling errors in their documents.
Q73: When creating a word-processed document, this step involves the user changing how words on the page appear, both on the screen and in printed form _______.
A. Editing text
B. Inserting tables and indexes
C. Formatting text
D. Proofing documents
Formatting text in a word-processed document involves changing how words on the page appear, both on the screen and in printed form. This step includes adjusting font, size, color, alignment, and spacing to enhance the document's readability and visual appeal.
Q74: When a file is saved for the first time _______.
A. a copy is automatically printed
B. it must be given a name to identify it
C. it does not need a name
D. it only needs a name if it is not going to be printed
When a file is saved for the first time, it must be given a name to identify it. This name helps users and the operating system locate and manage the file efficiently.
Q75: The acronym DBMS stands for what?
A. double-blind management setup
B. document binder management system
C. data binding and marketing structure
D. database methodology system
The acronym DBMS stands for Database Management System. A DBMS is a software system that uses a standardized approach to the creation, retrieval, update, and management of data in a database.
Q76: Software you can use to create a budget is called _______.
A. word processing software
B. graphics software
C. utility software
D. spreadsheet software
Spreadsheet software, such as Microsoft Excel, is commonly used to create a budget. It provides tools for data entry, calculations, and financial analysis, making it suitable for budgeting and financial planning.
Q77: Numbers and formulae entered in a cell are called _______.
A. labels
B. numeric entries
C. intersection
D. text
In a spreadsheet program, numbers and formulas entered in a cell are called numeric entries. These entries can be used in calculations and data analysis within the spreadsheet.
Q78: Microsoft Office is an example of a _______.
A. closed source software
B. open source software
C. horizontal market software
D. vertical market software
Microsoft Office is an example of closed source software. Closed source software is proprietary and its source code is not available to the public. It is developed and maintained by the software vendor, ensuring consistency and security.
Q79: You can use _______ to copy selected text; and _______ to paste it in a document.
A. CTRL+C, CTRL+V
B. CTRL+C, CTRL+P
C. CTRL+S, CTRL+S
D. SHIFT + C, ALT + P
In Microsoft Word, you can use "CTRL+C" to copy selected text and "CTRL+V" to paste it in a document. These keyboard shortcuts allow for efficient text manipulation and editing.
Q80: Numbers in table columns are usually _______.
A. right-aligned
B. left-aligned
C. justified
D. centered
In most spreadsheet programs, numbers in table columns are usually right-aligned by default. This alignment ensures that numbers are easily readable and consistent across the column.
Q81: Each box in a spreadsheet is called a _______.
A. cell
B. empty space
C. record
D. field
In a spreadsheet program, each box is called a cell. Cells are the individual units in a spreadsheet where data, formulas, and text can be entered. They are organized in rows and columns for data management and analysis.
Q82: To print a document _______.
A. select the Print command and then select OK
B. select the Ready Printer command then select OK
C. type Print and then press Enter
D. close the document, select the Print command, then select OK
To print a document in Microsoft Word, you select the Print command and then select OK. This action sends the document to the printer for output on paper, allowing for physical distribution and review.
Q83: A _______ is a collection of information saved as a unit.
A. folder
B. file
C. path
D. file extension
A file is a collection of information saved as a unit. Files can contain text, images, data, and other types of information and are used to organize and manage data efficiently.
Report Card
Total Questions Attempted: 0
Correct Answers: 0
Wrong Answers: 0
Keep Practicing!
Mastering Microsoft Office is a valuable skill that can enhance your
productivity and open up new opportunities in the government and banking
sectors. By understanding the key features and functionalities of each
application and practicing regularly, you can improve your score in your exams
and become proficient in using Microsoft Office.
Computer Awareness Chapters: Learn Key Concepts with MCQs
