The Ultimate Quiz On Word, Excel And Power Point

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS (Computer Science) |
Database Administrator
Review Board Member
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.
 , MS (Computer Science)
By Anilramesh
A
Anilramesh
Community Contributor
Quizzes Created: 1 | Total Attempts: 6,689
| Attempts: 6,781
SettingsSettings
Please wait...
  • 1/17 Questions

    View the presentation as a show

    • Slide sorter
    • Slide show
    • Normal
    • All of the above
Please wait...
About This Quiz

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.

The Ultimate Quiz On Word, Excel And Power Point - Quiz

Quiz Preview

  • 2. 

    A series of rows and columns that organize data effectively

    • Table

    • Query

    • Record

    • Field

    Correct Answer
    A. Table
    Explanation
    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 reference
    Explanation
    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 reference
    Explanation
    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 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. Database
    Explanation
    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:

  • 6. 

    A complete set of all of the data about one person, place, event, or idea

    • Record

    • Query

    • Table

    • Field

    Correct Answer
    A. Record
    Explanation
    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:

  • 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 reference
    Explanation
    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 painter
    Explanation
    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 sorter
    Explanation
    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. Normal
    Explanation
    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. Query
    Explanation
    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. Comment
    Explanation
    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 break
    Explanation
    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. Field
    Explanation
    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. Bar
    Explanation
    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. Filter
    Explanation
    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 line
    Explanation
    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:

Godwin Iheuwa |MS (Computer Science) |
Database Administrator
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.

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, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Godwin Iheuwa
  • Jan 15, 2012
    Quiz Created by
    Anilramesh
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.