Computer Applications Quiz: Excel Unit A

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 Mr.rumsey
M
Mr.rumsey
Community Contributor
Quizzes Created: 1 | Total Attempts: 450
Questions: 16 | Attempts: 450

SettingsSettingsSettings
Computer Applications Quiz: Excel Unit A - Quiz

It covers information covered in Excel unit a, as well as some Questions from MS Word and Computer Concepts


Questions and Answers
  • 1. 

    What is the difference between a Work Book and a Work Sheet

    • A.

      Work Book is Excell, and Work Sheet is MicroSoft Word

    • B.

      Work book 255 different books within one Worksheet

    • C.

      There is no difference

    • D.

      A work book is a file that holds up to 255 worksheets, a work sheet is a data sheet that allows the organize and manipulate data

    • E.

      What is a Work book for 200?, Alex

    Correct Answer
    D. A work book is a file that holds up to 255 worksheets, a work sheet is a data sheet that allows the organize and manipulate data
    Explanation
    A work book is a file that holds up to 255 worksheets, while a work sheet is a data sheet that allows the organization and manipulation of data.

    Rate this question:

  • 2. 

    In Excel, order of precedence determines:

    • A.

      The order in which worksheets are printed.

    • B.

      The colors used to distinguish cell references.

    • C.

      The order in which calculations are performed.

    • D.

      How values are multiplied.

    Correct Answer
    C. The order in which calculations are performed.
    Explanation
    The order of precedence in Excel refers to the hierarchy in which mathematical operations are performed in a formula. It determines the sequence in which calculations are executed, ensuring that the correct result is obtained. This is important because different operations have different priorities, and Excel follows a specific set of rules to determine the order in which calculations should be carried out. By understanding the order of precedence, users can accurately perform complex calculations and obtain the desired outcome.

    Rate this question:

  • 3. 

    The maximum number of worksheets you can include in a workbook is:

    • A.

      3

    • B.

      250

    • C.

      255

    • D.

      Unlimited

    Correct Answer
    C. 255
    Explanation
    The maximum number of worksheets you can include in a workbook is 255. This means that you can have up to 255 separate sheets within a single workbook file. This allows for a large amount of organization and data storage within a single file, making it easier to manage and navigate through multiple sets of data.

    Rate this question:

  • 4. 

    A selction of multiple cells is called a:

    • A.

      Group

    • B.

      Range

    • C.

      Reference

    • D.

      Package

    Correct Answer
    B. Range
    Explanation
    A selection of multiple cells in a spreadsheet is called a range. A range refers to a group of adjacent cells that are selected together for performing operations or applying formatting. It allows for efficient manipulation of data and performing calculations across multiple cells simultaneously.

    Rate this question:

  • 5. 

    Using a cell address in a formula is known as:

    • A.

      Formularizing

    • B.

      Prefixing

    • C.

      Cell referencing

    • D.

      Cell mathematics

    Correct Answer
    D. Cell mathematics
  • 6. 

    Which worksheet view shows how your worksheet will look when printed?

    • A.

      Page layout

    • B.

      Data

    • C.

      Review

    • D.

      View

    Correct Answer
    A. Page layout
    Explanation
    The Page Layout view in a worksheet shows how the worksheet will appear when printed. It allows users to see the exact placement of data, headers, footers, and other elements on the printed page. This view is useful for adjusting the layout and formatting of the worksheet to ensure it fits properly on the printed page and looks as intended.

    Rate this question:

  • 7. 

    Which button should you click if you want to print formulas in a worksheet?

    • A.

      Save button

    • B.

      Fill button

    • C.

      Any button on the Quick Access Toolbar

    • D.

      Office button

    Correct Answer
    D. Office button
    Explanation
    The Office button is the correct answer because it is the button that provides access to various commands and options in Microsoft Office applications, including the option to print formulas in a worksheet. By clicking on the Office button, users can access the Print menu and choose to print the formulas along with the rest of the worksheet content.

    Rate this question:

  • 8. 

    Clicking the Scale arrow in the Scale to Fit group on the Page Layout tab opens which dialog box

    • A.

      Print

    • B.

      Scale to fit

    • C.

      Width/Height

    • D.

      Page setup

    Correct Answer
    D. Page setup
    Explanation
    Clicking the Scale arrow in the Scale to Fit group on the Page Layout tab opens the Page Setup dialog box. This dialog box allows the user to customize various settings related to the page layout, such as paper size, orientation, margins, and scaling options. By clicking the Scale arrow, the user can access the scaling options within the Page Setup dialog box, which allows them to adjust the size of the content to fit within the specified page dimensions.

    Rate this question:

  • 9. 

    In which view can you see the header and footer areas of a worksheet?

    • A.

      Normal view

    • B.

      Page layout view

    • C.

      Page break preview

    • D.

      Header/Footer

    Correct Answer
    B. Page layout view
    Explanation
    In Page layout view, you can see the header and footer areas of a worksheet. This view displays the worksheet as it would appear when printed, including the header and footer sections. It allows you to easily customize and edit the header and footer content, such as adding page numbers, dates, or titles. This view is helpful for previewing and adjusting the layout of the worksheet before printing.

    Rate this question:

  • 10. 

    Which key can you press to switch to edit mode?

    • A.

      [F1]

    • B.

      [F2]

    • C.

      [F4]

    • D.

      [F6]

    Correct Answer
    B. [F2]
    Explanation
    Pressing the [F2] key allows you to switch to edit mode.

    Rate this question:

  • 11. 

    Which type of break can you insert if you want to force text to begin on the next page?

    • A.

      Automatic page break

    • B.

      Continuous section break

    • C.

      Text wrapping break

    • D.

      Next page section break

    Correct Answer
    D. Next page section break
    Explanation
    A "Next page section break" can be inserted to force text to begin on the next page. This type of break creates a new section and starts the content on a new page, ensuring that the text following the break will always begin on a fresh page.

    Rate this question:

  • 12. 

    Which type of break do you insert if you want to balance the columns in a section?

    • A.

      Column break

    • B.

      Continuous section break

    • C.

      Manual page break

    • D.

      Text wrapping break

    Correct Answer
    B. Continuous section break
    Explanation
    A continuous section break is used to balance the columns in a section. This type of break allows for the content to flow smoothly from one column to another, ensuring that the columns are evenly distributed. It is commonly used in documents with multiple columns, such as newsletters or magazines, to create a visually appealing layout.

    Rate this question:

  • 13. 

    Which of the following cannot be inserted using the Quick Parts command?

    • A.

      AutoText building block

    • B.

      Document property

    • C.

      Page number field

    • D.

      Page break

    Correct Answer
    D. Page break
    Explanation
    The Quick Parts command in Microsoft Word allows users to insert pre-defined content into their documents. AutoText building blocks, document properties, and page number fields are all examples of content that can be inserted using the Quick Parts command. However, a page break is not a type of content that can be inserted using this command. Instead, page breaks are inserted using the Page Layout tab or by pressing Ctrl+Enter on the keyboard.

    Rate this question:

  • 14. 

    Which of the following do documents with mirror margins always have?

    • A.

      Gutters

    • B.

      Landscape orientation

    • C.

      Inside and outside margins

    • D.

      Different first page headers and footers

    Correct Answer
    C. Inside and outside margins
    Explanation
    Documents with mirror margins always have inside and outside margins. Mirror margins are a type of layout where the inside and outside margins of a document are different. The inside margin is wider than the outside margin, allowing for binding or folding of the document. This layout is commonly used for documents that will be printed and bound, such as books or brochures, to ensure that the text is evenly distributed on each page and does not get cut off during the binding process.

    Rate this question:

  • 15. 

    What name describes formatted pieces of content that are stored in galleries?

    • A.

      Header

    • B.

      Field

    • C.

      Building block

    • D.

      Property

    Correct Answer
    C. Building block
    Explanation
    Building block is the correct answer because it accurately describes formatted pieces of content that are stored in galleries. Building blocks are pre-designed content elements that can be easily inserted into documents or templates. They can include text, images, tables, or other types of content, and they provide a convenient way to reuse and manage content in a structured manner. By organizing content into building blocks, users can quickly access and insert commonly used elements, saving time and ensuring consistency in their documents.

    Rate this question:

  • 16. 

    What must you do to change an inline graphic to a floating graphic?

    • A.

      Apply text wrapping to the graphic

    • B.

      Resize the graphic

    • C.

      Anchor the graphic

    • D.

      Move the graphic

    Correct Answer
    A. Apply text wrapping to the graphic
    Explanation
    To change an inline graphic to a floating graphic, you need to apply text wrapping to the graphic. This allows the graphic to be moved independently from the surrounding text, giving it a floating effect. By applying text wrapping, you can position the graphic anywhere on the page and have the text flow around it. This is useful when you want to have more control over the placement of the graphic in your document.

    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
  • Mar 28, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 20, 2009
    Quiz Created by
    Mr.rumsey
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.