The Ultimate Quiz On Word, Excel And Power Point
-
View the presentation as a show
-
Slide sorter
-
Slide show
-
Normal
-
All of the above
-
Do you know how to use the tools in MS Word, Excel, and PowerPoint? You can test yourself with these Word, Excel, and PowerPoint questions and answers. We have curated the best practice questions here so that you can test yourself and learn more. Go for it and see how much you score on this quiz. All the best! Do not forget to share the quiz with others who are interested in enhancing their Microsoft skills. Questions Related To MS-Word, MS-Excel And MS-Power Point.
Quiz Preview
- 2.
A series of rows and columns that organize data effectively
-
Table
-
Query
-
Record
-
Field
Correct Answer
A. TableExplanation
A table is a series of rows and columns that organize data effectively. It is a structured way to store and display information, with each row representing a record and each column representing a field. Tables are commonly used in databases and spreadsheets to store and organize large amounts of data in a structured and easily accessible format.Rate this question:
-
- 3.
A cell reference that change relative to the direction in which the formula is being copied.
-
Relative reference
-
Absolute reference
-
Both a & b
-
None of the above
Correct Answer
A. Relative referenceExplanation
A relative reference is a cell reference that changes relative to the direction in which the formula is being copied. This means that if you copy a formula with a relative reference to another cell, the reference will adjust based on the relative position of the new cell compared to the original cell. This allows for easy replication of formulas across multiple cells without having to manually adjust the references.Rate this question:
-
- 4.
The intersection of a column and row designed by a column letter and a row number
-
Cell reference
-
Relative reference
-
Absolute reference
-
None of the above
Correct Answer
A. Cell referenceExplanation
A cell reference is used to identify and locate a specific cell in a spreadsheet. It is formed by combining the column letter and row number of the cell. This allows users to easily refer to and manipulate data in a particular cell within the spreadsheet. The given statement accurately describes a cell reference, making it the correct answer.Rate this question:
-
- 5.
A complete set of all of the data about one person, place, event, or idea
-
Record
-
Query
-
Table
-
Field
Correct Answer
A. RecordExplanation
A record is a complete set of all the data about one person, place, event, or idea. It contains all the relevant information and details related to a specific entity. It can include various fields such as name, address, date of birth, etc. A record is used to store and organize data in a structured manner, making it easier to retrieve and analyze information when needed.Rate this question:
-
- 6.
A file that consists of one or more tables and the supporting objects used to get data into and out of the tables
-
Database
-
Record
-
Field
-
Queries
Correct Answer
A. DatabaseExplanation
A database is a file that consists of one or more tables and the supporting objects used to get data into and out of the tables. It is a structured collection of data that is organized and managed in a way that allows for efficient storage, retrieval, and manipulation of data. Databases are commonly used in various applications and systems to store and manage large amounts of data in a structured manner.Rate this question:
-
- 7.
A cell reference that stays the same no matter where you copy a formula
-
Absolute reference
-
Relative reference
-
Both a & b
-
None of the above
Correct Answer
A. Absolute referenceExplanation
An absolute reference is a cell reference in a formula that remains fixed or constant, regardless of where the formula is copied or moved. This means that the referenced cell will always stay the same, allowing for consistent calculations and referencing of data. Unlike a relative reference, which adjusts based on the location of the formula, an absolute reference is useful when you want to refer to a specific cell or range of cells in a formula without it changing when copied to other cells.Rate this question:
-
- 8.
Helps copy a format by highlighting a specific phrase or paragraph
-
Copy
-
Format painter
-
Cut
-
Copy/ paste, then delete words
Correct Answer
A. Format painterExplanation
The format painter is a tool that allows you to copy the formatting of a specific phrase or paragraph and apply it to another section of your document. It saves time and effort by eliminating the need to manually format each section individually. By selecting the desired text and using the format painter, you can quickly and easily replicate the formatting throughout your document.Rate this question:
-
- 9.
View the presentation in an easily rearranged slides
-
Slide sorter
-
Slide show
-
Normal
-
None of the above
Correct Answer
A. Slide sorterExplanation
The correct answer is "slide sorter" because it is the view in a presentation software that allows users to easily rearrange the order of slides. This view provides a visual representation of all the slides in the presentation, making it convenient for users to organize and reorganize their content. The other options, such as slide show, normal, and none of the above, do not specifically offer the feature of rearranging slides.Rate this question:
-
- 10.
View the presentation in its original form
-
Normal
-
Slide sorter
-
Slide show
-
None of the above
Correct Answer
A. NormalExplanation
The correct answer is "Normal" because it refers to the default view mode in a presentation software where the slides are displayed one by one in a regular order. The other options, slide sorter and slide show, are different view modes that allow the user to manage or present the slides in a different way. "None of the above" is not the correct answer as it does not provide a specific view mode option.Rate this question:
-
- 11.
A database object that enables you to ask questions about the data stored in a database and returns the answers in the order from the records that match your instruction
-
Query
-
Field
-
Table
-
Record
Correct Answer
A. QueryExplanation
A query is a database object that allows users to ask questions about the data stored in a database and retrieve the answers in the order of the records that match the specified criteria. It is used to extract specific information from a database by specifying the desired fields, tables, and conditions. Queries enable users to retrieve, filter, and sort data based on their requirements, providing a way to interact with the database and obtain meaningful information.Rate this question:
-
- 12.
Which term is described in this phrase "Select the 'Document Showing Markup' option from the 'Print What' list via the Print dialog box? You can also print the Reviewing Pane without the document text by selecting the 'List Of Markup' option from the Print What list."
-
Comment
-
Article
-
Phrase
-
Pages
Correct Answer
A. CommentExplanation
The correct answer is "comment". In the given phrase, it mentions selecting the 'Document Showing Markup' option and the 'List Of Markup' option. These options are typically associated with comments in a document. Therefore, the term being described in the phrase is "comment".Rate this question:
-
- 13.
Ending one section of a document and need to start the next on a new page, use this will start your new document on a new page
-
Soft break
-
Hard break
-
Enter
-
Tab
Correct Answer
A. Hard breakExplanation
A hard break is used to end one section of a document and start the next section on a new page. It ensures that the new section begins on a fresh page, separating it from the previous content. This is particularly useful when creating documents with multiple sections or chapters, as it allows for better organization and readability. A hard break is a formatting tool that helps maintain the structure and flow of a document.Rate this question:
-
- 14.
A basic entity, data element, or category, such as a book title or telephone number
-
Field
-
Query
-
Table
-
Record
Correct Answer
A. FieldExplanation
A field is a basic entity, data element, or category, such as a book title or telephone number. It is used to store a specific piece of information within a database or spreadsheet. For example, in a database of books, the field "book title" would store the title of each book. Fields are used to organize and categorize data, making it easier to search, sort, and manipulate the information within a database or spreadsheet.Rate this question:
-
- 15.
Stop sets the start position of text that will then run to the right as you type. Stop sets the position of the middle of the text. The text centers on this position as you type. Stop sets the right end of the text. As you type, the text moves to the left and stops aligning numbers around a decimal point. Independent of the number of digits, the decimal point will be in the same position, and stop doesn't position text. It inserts a vertical bar at the tab position.
-
Center
-
Left
-
Right
-
Bar
Correct Answer(s)
A. Center
A. Left
A. Right
A. BarExplanation
The options provided are different ways to align text. "Center" aligns the text to the middle of the specified position, "left" aligns the text to the start of the specified position, "right" aligns the text to the end of the specified position, and "bar" inserts a vertical bar at the tab position.Rate this question:
-
- 16.
After organizing my thoughts on this rough draft, I choose the "Show all Revisions Inline" option. Which kind of _____ is this_____.
-
Comment
-
Filter
-
Review
-
Lookup
Correct Answer(s)
A. Comment
A. FilterExplanation
The correct answer is "filter". In this context, choosing the "Show all Revisions Inline" option allows the user to view and analyze the comments and feedback made on the rough draft. By selecting this option, the user can filter and display all the revisions inline, making it easier to review and make necessary changes to the draft.Rate this question:
-
- 17.
Used as a format for numbering or bullets with all the lines except the first indented. To help indent when writing a paragraph.
-
Hanging
-
First line
-
Center line
-
Right line
Correct Answer(s)
A. Hanging
A. First lineExplanation
The given answer correctly identifies the format used for numbering or bullets, where all the lines except the first are indented. This format is commonly known as "hanging" and is often used to visually distinguish the first line from the rest of the lines in a list or paragraph. It helps in organizing and structuring the content in a clear and concise manner.Rate this question:
-
Quiz Review Timeline (Updated): Jul 16, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jul 16, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Jan 15, 2012Quiz Created by
Anilramesh
Back to top