Computer Applications Quiz: Excel Unit A

16 Questions | Total Attempts: 396

SettingsSettingsSettings
Computer Application Quizzes & Trivia

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

  • 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.

  • 3. 
    The maximum number of worksheets you can include in a workbook is:
    • A. 

      3

    • B. 

      250

    • C. 

      255

    • D. 

      Unlimited

  • 4. 
    A selction of multiple cells is called a:
    • A. 

      Group

    • B. 

      Range

    • C. 

      Reference

    • D. 

      Package

  • 5. 
    Using a cell address in a formula is known as:
    • A. 

      Formularizing

    • B. 

      Prefixing

    • C. 

      Cell referencing

    • D. 

      Cell mathematics

  • 6. 
    Which worksheet view shows how your worksheet will look when printed?
    • A. 

      Page layout

    • B. 

      Data

    • C. 

      Review

    • D. 

      View

  • 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

  • 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

  • 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

  • 10. 
    Which key can you press to switch to edit mode?
    • A. 

      [F1]

    • B. 

      [F2]

    • C. 

      [F4]

    • D. 

      [F6]

  • 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

  • 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

  • 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

  • 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

  • 15. 
    What name describes formatted pieces of content that are stored in galleries?
    • A. 

      Header

    • B. 

      Field

    • C. 

      Building block

    • D. 

      Property

  • 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

Back to Top Back to top