The Ultimate Business Computer Applications MCQ Quiz Part- II

52 Questions | Total Attempts: 69

SettingsSettingsSettings
Please wait...
Computer Application Quizzes & Trivia

Questions and Answers
  • 1. 
    A file is often referred to as a(n) _____.
    • A. 

      Wizard

    • B. 

      Document

    • C. 

      Pane

    • D. 

      Device

  • 2. 
    You organize files by storing them in _____.
    • A. 

      Archives

    • B. 

      Folders

    • C. 

      Indexes

    • D. 

      Lists

  • 3. 
    _____ is formalized education that typically takes place using a computer and the Internet.
    • A. 

      Distance learning

    • B. 

      Telecommuting

    • C. 

      Multitasking

    • D. 

      Network education

  • 4. 
    A(n) _____ identifies a file's type and the program that created the file.
    • A. 

      File path

    • B. 

      Subfolder

    • C. 

      Extension

    • D. 

      Folder

  • 5. 
    Which of the following is NOT a removable medium?
    • A. 

      CD

    • B. 

      Zip disk

    • C. 

      Floppy disk

    • D. 

      Hard disk

  • 6. 
    Which of the following is NOT application software?
    • A. 

      Drivers

    • B. 

      E-mail

    • C. 

      MS Excel

    • D. 

      Browsers

  • 7. 
    Which of the following would NOT be considered an operating system?
    • A. 

      Microsoft Office Suite

    • B. 

      MAC OS

    • C. 

      Vista and Windows XP

    • D. 

      Linux's Unix

  • 8. 
    A computer distinguishes one drive from another by assigning each a drive _____.
    • A. 

      Score

    • B. 

      Number

    • C. 

      Rank

    • D. 

      Letter

  • 9. 
    To select files that are not listed together, click one file, hold down the _____ key, and then click the other files.
    • A. 

      Ctrl

    • B. 

      Shift

    • C. 

      Exc

    • D. 

      Alt

  • 10. 
    _____ a file places it in two locations.
    • A. 

      Moving

    • B. 

      Cutting

    • C. 

      Pasting

    • D. 

      Copying

  • 11. 
    DBMS stands for _____.
    • A. 

      Database monitoring system

    • B. 

      Database management system

    • C. 

      Database maintenance system

    • D. 

      Data management and storage

  • 12. 
    In Access, which database object stores data in a format similar to that of a worksheet?
    • A. 

      Page

    • B. 

      Report

    • C. 

      Table

    • D. 

      Form

  • 13. 
    In Access, clicking the _____ option in the New Table dialog box will guide you step-by-step through the process of creating a table.
    • A. 

      Design View

    • B. 

      Table Wizard

    • C. 

      Datasheet View

    • D. 

      Import Table

  • 14. 
    The Criteria row, located at the bottom of the query window, allows you to _____.
    • A. 

      Sort the results of the query

    • B. 

      Select the fields to be part of the query

    • C. 

      Enter search conditions for the fields you want to search

    • D. 

      All of the above

  • 15. 
    In Access, the _____ option is the most common type of relationship.
    • A. 

      One-to-many

    • B. 

      Many-to-many

    • C. 

      One-to-one

    • D. 

      None of the above

  • 16. 
    The _____ section has contents that appear at the end of a report in Access.
    • A. 

      Detail

    • B. 

      Report Footer

    • C. 

      Category Footer

    • D. 

      Page Footer

  • 17. 
    Which of the following form attributes can you change in Design view in Access?
    • A. 

      Font

    • B. 

      Size

    • C. 

      Style

    • D. 

      All of the above

  • 18. 
    This uniquely identifies a field for each record in Access.
    • A. 

      Sort Key

    • B. 

      Criteria Key

    • C. 

      Primary Key

    • D. 

      Data Key

  • 19. 
    To use the Import Spreadsheet Wizard for inserting Excel data into an Access table, open the database file and select the _____ command on the File menu.
    • A. 

      Convert Database

    • B. 

      Get External Data

    • C. 

      Export

    • D. 

      Office Links

  • 20. 
    When using AutoFormat in Excel, you can format _____.
    • A. 

      The entire worksheet

    • B. 

      Charts and graphs only

    • C. 

      Text only

    • D. 

      None of the above

  • 21. 
    In Excel, assume that C3 contains the value of 5, C4 the value of 7, and C5 the value of 9. Which of the following functions would display 7?
    • A. 

      =MAX(C3:C5)

    • B. 

      =SUM(C3:C5)

    • C. 

      =COUNT(C3:C5)

    • D. 

      =AVERAGE(C3:C5)

  • 22. 
    The function =COUNT(E5:E7) would  _____.
    • A. 

      Display the number of cells with numerical values in the range E5:E7

    • B. 

      Display the value in E5 to the closest hundreds place

    • C. 

      Display the standard deviation of the values in the range E5:E7

    • D. 

      Display the variance of the values in the range E5:E7

  • 23. 
    A(n) _____ cell reference does not change when it is moved or copied to a new cell.
    • A. 

      Absolute

    • B. 

      Mixed

    • C. 

      Relative

    • D. 

      Stable

  • 24. 
    Press _____ to switch between displaying formulas and displaying values.
    • A. 

      Ctrl+>

    • B. 

      Shift+#

    • C. 

      Ctrl+`

    • D. 

      Shift+*

  • 25. 
    You would like to view the top row on an Excel worksheet even when scrolling down several screens. What feature would you use?
    • A. 

      Split Panes

    • B. 

      Freeze Panes

    • C. 

      Drag-and-Drop

    • D. 

      Copy and Paste

Back to Top Back to top