MS Office MCQ Online Test Quiz With Answers
(189).jpg "MS Office MCQ Online Test Quiz With Answers - Quiz")
Welcome to the MS Office MCQ online test quiz with answers! Some knowledge of Microsoft Office packages is required for those who wish to work in an organization. The quiz below is designed for those needing a refresher on all things related to MS Office. Is that you? Give it a try and see what you need to practice more before applying for the job you have been eyeing.
This quiz covers a wide range of topics, including Microsoft Word, Excel, PowerPoint, and Outlook. Each question is carefully crafted to test your understanding of essential functions and features within Read morethese applications. By taking this quiz, you'll identify your strengths and areas for improvement, ensuring you're well-prepared for any office-related tasks in a professional environment. Challenge yourself and enhance your skills.
MS Office Questions and Answers
- 1.
Which of the following is not part of a standard office suite?
- A.
Word Processor
- B.
Access
- C.
Photo Editor
- D.
File Manager
Correct Answer
D. File ManagerExplanation
A standard office suite typically includes applications such as a word processor, spreadsheet program, presentation software, and sometimes a database management system. These applications are commonly used in office settings for various tasks such as creating documents, managing data, and making presentations. A file manager, on the other hand, is not typically considered part of a standard office suite. A file manager is a software tool used to manage files and folders on a computer system, allowing users to organize, rename, copy, and move files. While file management is an essential function, it is not directly related to the core tasks performed in an office suite.Rate this question:
-
- 2.
Outlook Express is a:
- A.
E-Mail Client
- B.
Scheduler
- C.
Address Book
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
Outlook Express is a software program that serves as an email client, scheduler, and address book. As an email client, it allows users to send, receive, and manage their emails. It also includes a scheduler feature that enables users to set up appointments, reminders, and tasks. Additionally, Outlook Express has an address book function that allows users to store and manage their contacts. Therefore, the correct answer is "All of the above" as Outlook Express encompasses all these functionalities.Rate this question:
-
- 3.
MS Office provides help in many ways. Which of these is closer to the answer?
- A.
What’s This
- B.
Office Assistant
- C.
Help Menu
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
MS Office provides help in multiple ways. The "What's This" feature allows users to get information about specific elements or functions within the software. The "Office Assistant" is a virtual assistant that provides interactive help and guidance. The "Help Menu" provides access to a wide range of support resources, including tutorials, articles, and troubleshooting guides. Therefore, all of these options are valid ways in which MS Office provides help to users.Rate this question:
-
- 4.
Which menu in MS Word can be used to change page size & typeface?
- A.
View
- B.
Tools
- C.
Format
- D.
Data
Correct Answer
C. FormatExplanation
The Format menu in MS Word can be used to change the page size and typeface. This menu provides options for formatting the document, including changing the page layout and adjusting the font settings. By selecting the Format menu, users can easily modify the page size and typeface to suit their preferences or specific requirements for the document.Rate this question:
-
- 5.
Which key should be pressed to start a new paragraph in MS Word?
- A.
Down Cursor Key
- B.
Enter Key
- C.
Shift + Enter
- D.
Control + Enter
Correct Answer
B. Enter KeyExplanation
The Enter key should be pressed to start a new paragraph in MS Word. Pressing the Enter key creates a new line and moves the cursor to the beginning of the next line, indicating the start of a new paragraph.Rate this question:
-
- 6.
Which toolbar allows changing of Fonts and their sizes?
- A.
Standard
- B.
Formatting
- C.
Print Preview
- D.
None of these
Correct Answer
B. FormattingExplanation
The Formatting toolbar allows changing of fonts and their sizes. This toolbar typically includes options for selecting a font, changing the font size, and applying bold, italic, or underlined formatting to text. It is commonly used in word processing software to customize the appearance of text.Rate this question:
-
- 7.
Which bar is usually located below the Title Bar that provides categorized options?
- A.
Menu Bar
- B.
Status Bar
- C.
Tool Bar
- D.
Scroll Bar
Correct Answer
A. Menu BarExplanation
The menu bar is usually located below the title bar and provides categorized options for the user. It contains a series of menus that allow the user to access various functions and commands within the software or application. The menu bar is an essential component of the user interface as it helps the user navigate and interact with the software easily.Rate this question:
-
- 8.
Which of the following are the valid Min. & Max. zoom sizes in MS Office?
- A.
10, 100
- B.
20, 250
- C.
10, 500
- D.
10, 1000
Correct Answer
C. 10, 500Explanation
In Microsoft Office applications, the zoom feature allows you to adjust the magnification or size of the document on the screen. The values provided in the options represent the minimum and maximum zoom sizes: Minimum Zoom: 10% Maximum Zoom: 400% This means you can zoom out to see the document at 10% of its normal size or zoom in to a maximum of 400% for a closer view. These are standard zoom range limits in MS Office applications, providing flexibility for users to customize their view according to their preferences or needs.Rate this question:
-
- 9.
Which type of files cannot be navigated using the Clip Art browser?
- A.
AVI
- B.
BMP
- C.
WAV
- D.
MP3
Correct Answer
D. MP3Explanation
The Clip Art browser is used to navigate and search for clip art images. MP3 files are audio files and cannot be viewed or navigated using the Clip Art browser, as it is designed specifically for images. AVI, BMP, and WAV files can be navigated using the Clip Art browser as they are image or video file formats.Rate this question:
-
- 10.
Which option in the File pull-down menu is used to close a file in MS Word?
- A.
New
- B.
Quit
- C.
Close
- D.
Exit
Correct Answer
C. CloseExplanation
The option "Close" in the File pull-down menu is used to close a file in MS Word. This option allows the user to close the currently open file without exiting the entire application. It is a common and straightforward way to close a file in MS Word.Rate this question:
-
- 11.
Which of the following is a popular DOS-based spreadsheet package?
- A.
Word
- B.
Smart Cell
- C.
Excel
- D.
Lotus 1-2-3
Correct Answer
D. Lotus 1-2-3Explanation
Lotus 1-2-3 was a popular DOS-based spreadsheet package. It was one of the earliest and most influential spreadsheet applications in the early days of personal computing. However, it has been largely replaced by modern spreadsheet applications like Microsoft Excel which is not a DOS-based spreadsheet package; it is a modern spreadsheet application developed by Microsoft.Rate this question:
-
- 12.
How many characters can be typed in a single cell in Excel?
- A.
256
- B.
1024
- C.
32000
- D.
32767
Correct Answer
D. 32767Explanation
In Microsoft Excel, a single cell can contain up to 32,767 characters. This limit includes both numbers and text. The cell limit is designed to accommodate a wide range of data types and ensure that users can input a significant amount of information within a single cell. While Excel is primarily a spreadsheet application and is often used for numerical data, it also allows users to include text, formulas, and other types of information in cells. The generous character limit provides flexibility for users who may need to input lengthy descriptions, notes, or other textual information into a cell.Rate this question:
-
- 13.
What is the maximum number of rows a worksheet can have?
- A.
256
- B.
1024
- C.
32000
- D.
1,048,576
Correct Answer
D. 1,048,576Explanation
A Worksheet can have a maximum number of 1,048,576 rows. This means that a worksheet in a spreadsheet program, such as Microsoft Excel, can contain up to 1,048,576 rows of data. This allows for a large amount of data to be organized and analyzed within a single worksheet.Rate this question:
-
- 14.
How many columns does a typical worksheet have?
- A.
128
- B.
16384
- C.
512
- D.
1024
Correct Answer
B. 16384Explanation
A typical worksheet has 16384 number of columns. This means that there are 16384 vertical divisions or sections in the worksheet where data can be entered or displayed. This large number of columns allows for a wide range of data to be organized and analyzed in the worksheet, making it suitable for complex calculations and data manipulation.Rate this question:
-
- 15.
What are comments put in cells called?
- A.
Smart Tip
- B.
Cell Tip
- C.
Web Tip
- D.
Soft Tip
Correct Answer
B. Cell TipExplanation
The correct answer is "Cell Tip" because comments put in cells are commonly referred to as cell tips. This term is used in various software applications, such as spreadsheets, where users can insert comments or notes in specific cells to provide additional information or explanations. These cell tips can be helpful for collaboration and documentation purposes, allowing users to communicate and share insights about the data in the spreadsheet.Rate this question:
-
- 16.
Which menu option can be used to split windows into two?
- A.
Format -> Window
- B.
View -> Window -> Split
- C.
Window -> Split
- D.
View -> Split
Correct Answer
B. View -> Window -> SplitExplanation
To split windows into two in Microsoft Excel, you can use the "View" menu, then navigate to "Window," and select "Split." This option allows you to split the active window into two separate panes, which is particularly useful for working with large worksheets and comparing different parts of the same sheet..Rate this question:
-
- 17.
What is the process of getting data from a cell located in a different sheet called?
- A.
Accessing
- B.
Referencing
- C.
Updating
- D.
Functioning
Correct Answer
B. ReferencingExplanation
Referencing is the correct answer because when you access data from a cell located in a different sheet, you are referring to that specific cell in order to retrieve its value or use it in calculations. Referencing allows you to connect and retrieve data from different sheets within a workbook, making it a useful feature for organizing and analyzing data.Rate this question:
-
- 18.
Which of the following is not a valid data type in Excel?
- A.
Number
- B.
Character
- C.
Label
- D.
Date/Time
Correct Answer
B. CharacterExplanation
In Microsoft Excel, the term "Character" is not specifically used as a data type. Instead, text data is commonly referred to as the "Text" data type. Excel recognizes several data types, and some of the common ones include:
Number: This data type is used for numerical values, including integers and decimals.
Text: Text data type is used for alphanumeric characters, such as words, sentences, or any combination of letters and numbers.
Label: In Excel, labels are essentially treated as text. They are typically used for headings or any descriptive text.
Date/Time: This data type is used for representing dates and times.
So, while "Character" is not a distinct data type, you can work with text using the "Text" data type in Excel. The terminology may vary, but it's important to understand how to work with and format different types of data in Excel.Rate this question:
-
- 19.
Which elements of a worksheet can be protected from accidental modification?
- A.
Contents
- B.
Objects
- C.
Scenarios
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
All of the elements mentioned in the options can be protected from accidental modification in a worksheet. Contents refer to the data and information entered into the cells of the worksheet. Objects refer to any inserted shapes, images, or charts in the worksheet. Scenarios refer to the different sets of input values that can be used for calculations in the worksheet. Protecting all of these elements ensures that they cannot be accidentally changed, helping to maintain the integrity and accuracy of the worksheet.Rate this question:
-
- 20.
Concatenation of text can be done using which function?
- A.
Apostrophe (‘)
- B.
Exclamation (!)
- C.
Hash (#)
- D.
Ampersand (&)
Correct Answer
D. Ampersand (&)Explanation
The ampersand (&) is used for concatenation of text in many programming languages and software applications. It is commonly used to combine two or more strings or text values into a single string. The apostrophe ('), exclamation (!), and hash (#) symbols are not typically used for concatenation purposes.Rate this question:
-
- 21.
Which area in an Excel window allows entering values and formulas?
- A.
Title Bar
- B.
Menu Bar
- C.
Formula Bar
- D.
Standard Tool Bar
Correct Answer
C. Formula BarExplanation
The Formula Bar in an Excel window allows users to enter values and formulas. It is located below the Menu Bar and displays the contents of the selected cell. Users can directly enter data or formulas into the Formula Bar and it also provides a convenient way to edit the contents of a cell. The other options listed, such as the Title Bar, Menu Bar, and Standard Tool Bar, do not provide the functionality to enter values and formulas.Rate this question:
-
- 22.
Multiple calculations can be made in a single formula using which feature?
- A.
Standard Formulas
- B.
Array Formula
- C.
Complex Formulas
- D.
Smart Formula
Correct Answer
B. Array FormulaExplanation
Array formulas allow multiple calculations to be made in a single formula by performing operations on arrays of data rather than individual cells. This allows for more complex calculations and can save time by avoiding the need for multiple separate formulas.Rate this question:
-
- 23.
An Excel Workbook is a collection of what?
- A.
Workbooks
- B.
Worksheets
- C.
Charts
- D.
Worksheets and Charts
Correct Answer
D. Worksheets and ChartsExplanation
An Excel Workbook is a collection of worksheets and charts. A worksheet is a single spreadsheet that contains cells organized in rows and columns, where data can be entered and manipulated. Charts, on the other hand, are visual representations of data that can be created based on the data in the worksheets. Therefore, an Excel Workbook includes both worksheets for data entry and manipulation, as well as charts for data visualization.Rate this question:
-
- 24.
What is the term for graphics used in a word processor?
- A.
Peripheral
- B.
Clipart
- C.
Highlight
- D.
Execute
Correct Answer
B. ClipartExplanation
Clipart refers to pre-made images or graphics that can be inserted into documents, presentations, or other digital media. In the context of a word processor, graphics are often used to enhance the visual appeal of documents or to illustrate concepts. Therefore, clipart is a suitable answer as it specifically relates to the use of graphics in a word processor. Peripheral, highlight, and execute do not directly relate to graphics for a word processor.Rate this question:
-
- 25.
What does the Ctrl + I shortcut key accomplish in Ms-Word?
- A.
It converts selected text into the next larger size of the same font.
- B.
It adds a line break to the document.
- C.
It makes the selected text bold.
- D.
It applies Italic formatting to the selected text.
Correct Answer
D. It applies Italic formatting to the selected text.Explanation
In Microsoft Word, the Ctrl + I keyboard shortcut is a common formatting command that applies italic formatting to the selected text. When you have a portion of text highlighted or the cursor is placed within a word or a section of text, pressing Ctrl + I will toggle the text between italic and regular (non-italic) formatting. This is a quick and convenient way to apply or remove italic styling from text without using the formatting options in the toolbar. It's part of the suite of keyboard shortcuts in Microsoft Word that allows users to efficiently format text without relying on the mouse or the ribbon interface.Rate this question:
-
- 26.
Why are headers and footers used in documents?
- A.
To enhance the overall appearance of the document
- B.
To mark the starting and ending of a page
- C.
To make large documents more readable
- D.
To allow page headers and footers to appear on a document when it is printed.
Correct Answer
D. To allow page headers and footers to appear on a document when it is printed.Explanation
Headers and footers are used in documents to allow important information, such as page numbers, document titles, and author names, to appear consistently on each page. This helps to organize and structure the document, making it easier for readers to navigate and understand. Additionally, headers and footers can also be used to add branding elements or design elements that enhance the overall appearance of the document. However, the main purpose of headers and footers is to ensure that important information remains visible even when the document is printed.Rate this question:
-
- 27.
Which of the following shortcut key is used to check to spell?
- A.
F1
- B.
F2
- C.
F7
- D.
F9
Correct Answer
C. F7Explanation
The shortcut key F7 is used to check the spelling in various software applications, including word processors and text editors. When pressed, it typically opens the spell check feature, which scans the document for any spelling errors and suggests corrections. This shortcut key is commonly used to ensure the accuracy and correctness of written content by quickly identifying and fixing any spelling mistakes.Rate this question:
-
- 28.
What does the Ctrl + B shortcut accomplish in MS Word?
- A.
It converts selected text into the next larger size of the same font.
- B.
It adds a line break to the document.
- C.
It makes the selected text bold.
- D.
It applies Italic formatting to the selected text.
Correct Answer
C. It makes the selected text bold.Explanation
The Ctrl + B shortcut in MS Word is used to make the selected text bold. This means that when you have text highlighted in your document and you press Ctrl + B, the text will be displayed in a bold font.Rate this question:
-
- 29.
What is the minimum number of rows and columns that a word table can have?
- A.
Zero
- B.
2 rows and 1 column
- C.
2 rows and 2 column
- D.
1 row and 1 column
Correct Answer
D. 1 row and 1 columnExplanation
A word table can have a minimum of 1 row and 1 column because a table requires at least one row and one column to exist. Having zero rows or columns would mean that there is no table present. Having 2 rows and 1 column, 2 rows and 2 columns, or any other combination would still be a valid table, but the minimum requirement is 1 row and 1 column.Rate this question:
-
- 30.
When a formatted number does not fit within a cell, it displays
- A.
#####
- B.
#DIV/0
- C.
#DIV@
- D.
None of these
Correct Answer
A. #####Explanation
When a formatted number does not fit within a cell in Microsoft Excel, it displays a series of pound signs (#####). This is Excel's way of indicating that the cell is not wide enough to display the entire number, and you should adjust the column width to make the content visible.Rate this question:
-
- 31.
What symbol is used to enter number as text?
- A.
‘
- B.
"
- C.
=
- D.
+
Correct Answer
A. ‘Explanation
The symbol used to enter a number as text is the apostrophe ('), also known as a single quotation mark. This symbol is commonly used in computer applications, such as spreadsheets, to indicate that a value should be treated as text rather than as a numerical value. By placing an apostrophe before a number, it prevents the application from automatically interpreting it as a mathematical calculation and instead treats it as plain text.Rate this question:
-
- 32.
Data can be arranged in ascendÂing or descendÂing order by using.
- A.
Sort commands from the Table menu
- B.
Sort command from the Data menu
- C.
Sort command from the Tools menu
- D.
None of these
Correct Answer
B. Sort command from the Data menuExplanation
The correct answer is the "Sort command from the Data menu." This option is the most logical choice as the Data menu typically contains options and commands related to manipulating and organizing data. The Sort command specifically allows the user to arrange data in ascending or descending order, making it the appropriate choice for arranging data in the desired order. The other options mentioned, such as the Sort commands from the Table menu or Tools menu, are not commonly associated with data manipulation and organization.Rate this question:
-
- 33.
Red triangle at the top right corner of a cell indicates
- A.
There is an error in the cell.
- B.
There is a comment associated with the cell.
- C.
The font color of the text in cell is red.
- D.
The cell can’t accept formula.
Correct Answer
A. There is an error in the cell.Explanation
A red triangle at the top right corner of a cell in Microsoft Excel indicates that there is an error in the cell. This error triangle is often accompanied by an error message or a comment that provides information about the nature of the error and how to resolve it. It's a visual indicator that something is incorrect in the cell's content.Rate this question:
-
- 34.
To select mulÂtiÂple non-adjacent cells in a workÂsheet, you will click them holding
- A.
CTRL key
- B.
ALT key
- C.
Shift Key
- D.
Ctrl+Shift key
Correct Answer
A. CTRL keyExplanation
To select multiple non-adjacent cells in a worksheet, you will click them while holding the CTRL key. This is because the CTRL key allows you to select multiple cells or ranges that are not adjacent to each other. By holding down the CTRL key and clicking on different cells, you can add them to your selection. This is a common feature in spreadsheet programs and allows you to perform actions on multiple cells simultaneously.Rate this question:
-
- 35.
How many sheets are there in the Excel Workbook by default?
- A.
2
- B.
3
- C.
4
- D.
5
Correct Answer
B. 3Explanation
By default, there are three sheets in an Excel workbook. These sheets are labeled as Sheet1, Sheet2, and Sheet3. These sheets provide the user with separate spaces to work on different sets of data or calculations within the same workbook. The user can rename these sheets according to their preference and can also add or delete sheets as needed.Rate this question:
-
- 36.
Which of the folÂlowÂing comÂpoÂnent disÂplays the conÂtents of active cells?
- A.
Name box
- B.
Formula bar
- C.
Menu bar
- D.
Status bar
Correct Answer
B. Formula barExplanation
The formula bar displays the contents of active cells in a spreadsheet. It is located above the worksheet and shows the formula or value of the selected cell. Users can edit the contents of a cell directly in the formula bar by typing in new data or modifying existing data. This component is essential for viewing and manipulating the data in a spreadsheet.Rate this question:
-
- 37.
To move to the previous worksheet press:
- A.
Ctrl+PgUp
- B.
Ctrl+PgDn
- C.
Shift+Tab
- D.
Ctrl+Tab
Correct Answer
A. Ctrl+PgUpExplanation
The correct answer is Ctrl+PgUp. This keyboard shortcut allows you to move to the previous worksheet in a spreadsheet application. By pressing Ctrl and PgUp simultaneously, you can navigate through multiple worksheets within a workbook quickly and efficiently.Rate this question:
-
- 38.
Which of the following Microsoft Office applications is primarily designed for creating presentations?
- A.
Microsoft Word
- B.
Microsoft Excel
- C.
Microsoft PowerPoint
- D.
Microsoft Access
Correct Answer
C. Microsoft PowerPointExplanation
Microsoft PowerPoint is the presentation software within the Microsoft Office suite. It provides tools for creating dynamic slideshows with text, images, graphics, and multimedia elements. PowerPoint presentations are widely used in business, education, and other settings to convey information, ideas, and data in a visually engaging format.Rate this question:
-
- 39.
Two common wildcard characters that Excel recognizes are
- A.
* and ?
- B.
< and >
- C.
^ and /
- D.
+ and -
Correct Answer
A. * and ?Explanation
The correct answer is * and ?. In Excel, the asterisk (*) is used as a wildcard character to represent any number of characters, while the question mark (?) is used to represent a single character. These wildcard characters are commonly used in functions like COUNTIF and SUMIF to search for specific patterns or values within a range of cells. For example, using the asterisk wildcard with the COUNTIF function like "=COUNTIF(A1:A10, "*apple*")" will count the number of cells that contain the word "apple" anywhere in the cell. Similarly, using the question mark wildcard like "=COUNTIF(A1:A10, "??")" will count the number of cells that have exactly two characters.Rate this question:
-
- 40.
How to align the center using a shortcut?
- A.
CTRL+j
- B.
CTRL+e
- C.
CTRL+r
- D.
CTRL+l
Correct Answer
B. CTRL+eExplanation
To align the center using a shortcut, you can use the CTRL+e combination. This shortcut is commonly used in various text editing software and word processors to quickly align text or objects to the center of the page or document. By pressing CTRL+e, you can easily center-align the selected text or object without having to go through the menu options or using the mouse.Rate this question:
-
- 41.
Shortcut to insert the current date in a word:
- A.
Shift+d
- B.
Ctrl+shift+d
- C.
Alt+shift+d
- D.
Ctrl+d
Correct Answer
C. Alt+shift+dExplanation
To insert the current date in Microsoft Word, you can use the shortcut Alt+Shift+D. This keyboard shortcut inserts the current date into the document. To insert the current date in Microsoft Word, you can use the shortcut Alt+Shift+D. This keyboard shortcut inserts the current date into the document.Rate this question:
-
- 42.
Maximum font size of MS Word is:
- A.
1638
- B.
72
- C.
512
- D.
1024
Correct Answer
A. 1638Explanation
The accurate response includes 8 and 72. Access the Fonts dialog box or utilize the tools in the Home tab within MS Word. The available font sizes range from 8 to 72 points. Microsoft Word supports font sizes within the range of 1 to 1638 points.Rate this question:
-
- 43.
How to set a bulleted list for the ordinary list?
- A.
Select the list and press the bullets icon in the toolbar
- B.
Press the bullets icon in the toolbar
- C.
Select list and select format --> bullets and numbering
- D.
Both A and C
Correct Answer
D. Both A and CExplanation
To set a bulleted list for the ordinary list, you can either select the list and press the bullets icon in the toolbar or select the list and go to the format option, then choose bullets and numbering. Both options A and C are correct ways to achieve a bulleted list.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Oct 15, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Aug 31, 2010Quiz Created by
Abi333
Back to top