Word 2007, Power-point, Excel, Access

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Sherleyann11
S
Sherleyann11
Community Contributor
Quizzes Created: 3 | Total Attempts: 962
| Attempts: 181
SettingsSettings
Please wait...
  • 1/16 Questions

    View the presentation as a show

    • Slide sorter
    • Slide show
    • Normal
Please wait...
About This Quiz

This quiz covers functionalities in Microsoft Office applications such as Word, Excel, PowerPoint, and Access, focusing on specific features like text alignment, formatting, and document structuring.

Microsoft Office Quizzes & Trivia

Quiz Preview

  • 2. 

    A cell reference that change relative to the direction in which the formula is being copied.

    • Relative reference

    • Absolute reference

    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 the formula is copied to a different cell, the reference will adjust accordingly. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically adjust to B2. This allows for easier and more efficient copying of formulas across multiple cells.

    Rate this question:

  • 3. 

    A cell reference that stays the same no matter where you copy a formula

    • Absolute reference

    • Relative reference

    Correct Answer
    A. Absolute reference
    Explanation
    An absolute reference is a cell reference that remains constant or fixed, regardless of where the formula is copied or moved within a spreadsheet. This means that if you copy a formula containing an absolute reference to another cell, the reference will not change. It is denoted by using a dollar sign ($) before the column letter and/or row number in the reference. This is useful when you want to refer to a specific cell or range of cells consistently in a formula, regardless of its position in the spreadsheet.

    Rate this question:

  • 4. 

    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 manage large amounts of data in a structured and organized manner.

    Rate this question:

  • 5. 

    A database object that enables you 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 you to ask questions about the data stored in a database. It enables you to specify certain criteria or conditions and returns the answers in the order from the records that match your instructions. By using a query, you can retrieve specific information from a database, filter data based on certain conditions, and sort the results according to your requirements.

    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 be seen as a single entry or row in a database table that holds all the attributes and characteristics of the subject being represented. A record is used to store and organize data in a structured manner, allowing for efficient retrieval and manipulation of information.

    Rate this question:

  • 7. 

    The intersection of a column and row designed by a column letter and a row number

    • Cell reference

    • Relative reference

    • Absolute reference

    Correct Answer
    A. Cell reference
    Explanation
    A cell reference is a combination of a column letter and a row number that identifies a specific cell in a spreadsheet. It is used to refer to a particular cell or range of cells in formulas, functions, or formatting. By using a cell reference, you can easily update the data in a cell and have it automatically reflected in any formulas or calculations that reference that cell.

    Rate this question:

  • 8. 

    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 collection of structured data that is organized and accessible in various ways. It allows for efficient storage, retrieval, and manipulation of large amounts of data. Databases are commonly used in various applications and systems to manage and store data securely.

    Rate this question:

  • 9. 

    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 tool is used to copy the formatting of a specific phrase or paragraph and apply it to another section of text. It helps to maintain consistency in the formatting of a document by quickly transferring the desired formatting style. This tool eliminates the need to manually adjust font size, color, spacing, etc., saving time and effort.

    Rate this question:

  • 10. 

    View the presentation in origingal form

    • Normal

    • Slide sorter

    • Slide show

    Correct Answer
    A. Normal
    Explanation
    The term "Normal" refers to the default view of a presentation, where all the slides are displayed in a single window. It allows the user to edit and modify individual slides easily. The other options, "slide sorter" and "slide show," are different views that provide alternative ways to navigate and present the slides.

    Rate this question:

  • 11. 

    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 the correct answer because it is used to end one section of a document and start the next on a new page. It forces the content following the break to begin on a new page, ensuring a clear separation between sections. Soft break, enter, and tab are not suitable options for this purpose as they do not guarantee a new page.

    Rate this question:

  • 12. 

    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 that represents a specific attribute or piece of information, such as a book title or telephone number. It is a fundamental component of a database or spreadsheet, used to store and organize data in a structured manner. Fields are typically organized within tables or records, and can be used for various purposes, such as sorting, filtering, or performing calculations on the data.

    Rate this question:

  • 13. 

    Which term is decribed in this phrase "selecting 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 term described in the given phrase is "comment". The phrase explains how to select the option to print the document showing markup or the reviewing pane without the document text. This indicates that comments, which are a form of markup or annotations in a document, can be printed using the mentioned options. Therefore, the correct answer is "comment".

    Rate this question:

  • 14. 

    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,  stop aligns 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

    • Decimal

    • Bar

    Correct Answer(s)
    A. Center
    A. Left
    A. Right
    A. Decimal
    A. Bar
    Explanation
    The answer choices provided are all different options for the "stop" command. The explanation states that "stop" can be used to set the start position of text, the middle position of text, the right end of text, or to align numbers around a decimal point. It also mentions that "stop" does not position text, but instead inserts a vertical bar at the tab position. Therefore, the correct answer choices are center, left, right, decimal, and bar.

    Rate this question:

  • 15. 

    Used as a format for numbering or bullets with the 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 is "hanging, first line" because when using a hanging indent format, all lines except the first are indented. This format is commonly used for numbering or bullet points to visually separate each item or paragraph. In this case, the "hanging" refers to the indentation of all lines except the first, and "first line" indicates that the first line remains at the left margin without any indentation.

    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
    This option "Show all Revisions Inline" is related to reviewing and filtering comments. By selecting this option, the user can see all the revisions made in the rough draft, including comments. Therefore, the correct answer is "comment, filter" as it refers to displaying and managing comments in the document.

    Rate this question:

Quiz Review Timeline (Updated): Mar 16, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 16, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 10, 2008
    Quiz Created by
    Sherleyann11
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.