Business Computer Applications II Final & (EDGE Credit)

52 Questions | Total Attempts: 63

SettingsSettingsSettings
Please wait...
Computer Application Quizzes & Trivia

Mrs. Vance's Business Computer Applications II class will take this exam (50% of grade) along with a hands-on performance test (50% of grade) for EDGE credit and a final exam grade. GOOD LUCK!


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

  • 26. 
    _____ is NOT a method for copying data to another part of the worksheet.
    • A. 

      Drag-and-Drop

    • B. 

      Fill Down

    • C. 

      Inserting

    • D. 

      Copy and Paste

  • 27. 
    In the Excel Page Setup dialog box, which tab would you choose to specify the amount of space on the edges of the page?
    • A. 

      Sheet

    • B. 

      Header/Footer

    • C. 

      Page

    • D. 

      Margins

  • 28. 
    The transposition feature in Excel allows you to switch data from rows to columns or columns to rows.
    • A. 

      True

    • B. 

      False

  • 29. 
    _____ may be placed in a worksheet to show other files or Web pages on the screen.
    • A. 

      Objects

    • B. 

      Hyperlinks

    • C. 

      Charts or graphs

    • D. 

      External files

  • 30. 
    The _____ option is a choice when creating a presentation.
    • A. 

      AutoContent Wizard

    • B. 

      Design Template

    • C. 

      Blank Presentation

    • D. 

      All of the above

  • 31. 
    The _____ controls the formatting for all of the slides in a presentation.
    • A. 

      Template slide

    • B. 

      Slide template

    • C. 

      Slide master

    • D. 

      Template master

  • 32. 
    You can embed information as an object by accessing the _____ dialog box.
    • A. 

      Embed Object

    • B. 

      Insert Information

    • C. 

      Insert Object

    • D. 

      None of the above

  • 33. 
    To convert an existing presentation to a Web page, choose _____ on the File menu.
    • A. 

      Save as Web Page

    • B. 

      Publish

    • C. 

      Publish as a Web Page

    • D. 

      Save As

  • 34. 
    To tell PowerPoint that you want to create a new macro, open the _____ menu and click the Macro command.
    • A. 

      Insert

    • B. 

      Tools

    • C. 

      Edit

    • D. 

      Format

  • 35. 
    Persons on the same level of an organization chart are called _____.
    • A. 

      Managers

    • B. 

      Subordinates

    • C. 

      Coworkers

    • D. 

      Assistants

  • 36. 
    PowerPoint can accept pictures saved in _____ file format.
    • A. 

      JPEG

    • B. 

      TIFF

    • C. 

      GIF

    • D. 

      All of the above

  • 37. 
    To import an outline into PowerPoint, click Open and then change files of type to _____ to see available outline documents.
    • A. 

      All Outlines

    • B. 

      All Files

    • C. 

      Outlines

    • D. 

      Either A or B

  • 38. 
    The original application in which an embedded or linked object is created is called the _____ application.
    • A. 

      Destination

    • B. 

      Source

    • C. 

      Default

    • D. 

      Main

  • 39. 
    A _____ is a software program used to view Web pages.
    • A. 

      Site

    • B. 

      Host

    • C. 

      Link

    • D. 

      Browser

  • 40. 
    The act of conducting business transactions over the Internet is called _____.
    • A. 

      Search

    • B. 

      E-commerce

    • C. 

      E-mail

    • D. 

      Chat

  • 41. 
    A network that connects computers within an office or single building is a(n) _____ area network.
    • A. 

      Local (LAN)

    • B. 

      Office (OAN)

    • C. 

      Building (BAN)

    • D. 

      Wide (WAN)

  • 42. 
    _____ is an important consideration when choosing an ISP.
    • A. 

      Nation-wide phone numbers for dial-up access

    • B. 

      Ease of installation and setup

    • C. 

      Customer support and technical support

    • D. 

      All of the above

  • 43. 
    If you want your work to have a consistent appearance, but don't want the hassle of applying the formats over and over, you can use _____.
    • A. 

      Formatting

    • B. 

      Styles

    • C. 

      Transposing

    • D. 

      Customizing

  • 44. 
    To move a picture, you must _____.
    • A. 

      Drag it to the desired position

    • B. 

      Click the Restore button on the Picture toolbar

    • C. 

      Click the Increase Contrast or Decrease Contrast button on the Picture toolbar

    • D. 

      Drag the sizing handles on the sides of the picture

  • 45. 
    The term used for bibliographical references when typing a report in MLA is _____.
    • A. 

      Bibliography

    • B. 

      Parenthetical References

    • C. 

      Citations

    • D. 

      Works Cited

  • 46. 
    A Webmaster is a person who _____.
    • A. 

      Maintains and operates Web servers

    • B. 

      Designs and creates Web pages

    • C. 

      Maintains and audits business accounts

    • D. 

      Both A and B

  • 47. 
    Ethical computer practices include _____.
    • A. 

      Making backup copies

    • B. 

      Reading coworkers E-mail

    • C. 

      Making copies of copyrighted software

    • D. 

      None of the above

  • 48. 
    Good keyboarding techniques include all of the following EXCEPT _____.
    • A. 

      Curving fingers

    • B. 

      Wrists flat on desk or keyboard

    • C. 

      Sitting up straight in chair

    • D. 

      Keeping eyes on copy to be typed

  • 49. 
    A mail merge operation is used to _____.
    • A. 

      Create personalized letters, envelopes, labels, and directories

    • B. 

      Integrate OLE objects

    • C. 

      Create a new address database

    • D. 

      Print records as charts

  • 50. 
    Which sentence contains correct spelling accuracy?
    • A. 

      The Declaration of Independance was written in 1776.

    • B. 

      Do you beleive the stories about ghosts?

    • C. 

      You might like to join us tomorow at the Mall.

    • D. 

      It's going to be a dinner that will not be forgotten.

  • 51. 
    What is a resume?
    • A. 

      A document which all lines start flush with the left margin, without a first-line indent.

    • B. 

      A document listing information about a person's education, work experience, and interests.

    • C. 

      A document used to provide information about a company, organization, or event to the media.

    • D. 

      A document used to communicate information within a company, or between one company and another.

  • 52. 
    The line at the start of a letter including the greeting and the recipient's name, such as Dear Mr. Doe, is called what?
    • A. 

      Subject Line

    • B. 

      Complimentary Closing

    • C. 

      Salutation

    • D. 

      Copy Notation