MS Office MCQ Online Trivia With Answers

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS, Computer Science |
Computer Expert
Review Board Member
Godwin is a proficient Database Administrator currently employed at MTN Nigeria. He holds as MS in Computer Science from the University of Bedfordshire, where he specialized in Agile Methodologies and Database Administration. He also earned a Bachelor's degree in Computer Science from the University of Port Harcourt. With expertise in SQL Server Integration Services (SSIS) and SQL Server Management Studio, Godwin's knowledge and experience enhance the authority of our quizzes, ensuring accuracy and relevance in the realm of computer science.
, MS, Computer Science
Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Abi333
A
Abi333
Community Contributor
Quizzes Created: 3 | Total Attempts: 154,910
Questions: 20 | Viewed: 104,237

1.

Which menu in MS Word can be used to change  page size & typeface?

Answer: Format
Explanation:
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.
2.

Which key should be pressed to start a new paragraph in MS Word?

Answer: Enter Key
Explanation:
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.
3.

Which of these toolbars allows changing of Fonts and their sizes?

Answer: Formatting
Explanation:
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.
4.

Which bar is usually located below the Title Bar that provides categorized options?

Answer: Menu Bar
Explanation:
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.
5.

Which type of files cannot be navigated using the Clip Art browser?

Answer: MP3
Explanation:
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.
6.

Which option in the File pull-down menu is used to close a file in MS Word?

Answer: Close
Explanation:
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.
7.

How many characters can be typed in a single cell in Excel?

Answer: 32767
Explanation:
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.
8.

A Worksheet can have a maximum number of ______ rows.

Answer: 1,048,576
Explanation:
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.
9.

A typical worksheet has______ number of columns

Answer: 16384 
Explanation:
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.
10.

Comments put in cells are called

Answer: Cell Tip
Explanation:
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.
11.

Which menu option can be used to split windows into two?

Answer: View -> Window -> Split
Explanation:
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..
12.

Getting data from a cell located in a different sheet is called

Answer: Referencing
Explanation:
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.
13.

Concatenation of text can be done using.

Answer: 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.
14.

Which area in an Excel window allows entering values and formulas?

Answer: Formula Bar
Explanation:
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.
15.

Multiple calculations can be made in a single formula using.

Answer: Array Formula
Explanation:
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.
16.

An Excel Workbook is a collection of

Answer: Worksheets and Charts
Explanation:
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.
17.

Graphics for a word processor

Answer: Clipart
Explanation:
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.
18.

What does the Ctrl + I shortcut key accomplish in Ms-Word?

Answer: 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.
19.

Why are headers and footers used in documents?

Answer: 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.
20.

What does the Ctrl + B shortcut accomplish in MS Word?

Answer: 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.
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.