Computer Literacy Final Exam Part III

25 Questions | Total Attempts: 174

SettingsSettingsSettings
Computer Literacy Final Exam Part III - Quiz

Questions and Answers
  • 1. 
    OPEN MS EXCEL AND ENTER THE DATA EXACTLY AS IT IS FOUND IN THE IMAGE BELOW - BE SURE TO USE WRAP TEXT AND ROW BACKGROUD COLOR SHADING AS SHOWN IN THE IMAGE. AFTER YOU ENTER THE DATA CREATE A 3D EXPLODED PIE CHART ON THE SAME PAGE AS THE DATA  CHANGE THE CHART LAYOUT TO LAYOUT 3 CHANGE THE CHART STYLE TO STYLE 42 ADD A HEADER TO THE CHART WITH THE TEXT 'COMPUTER LITERACY EXCEL CHART FOR FINAL EXAM' ADD A FOOTER WITH YOUR NAME IN THE LEFT TEXT BOX, THE CURRENT DATE IN THE CENTER AND 'PHILEMON RESTORATION' IN THE RIGHT TEXT BOX. PRINT THE SHEET WITH THE CHART AND TABLE ON ONE PAGE (ADJUST ORIENTATION OF PAGE TO LANDSCAPE) SAVE THE WORKSHEET EMAIL IT TO [email protected] AS AN ATTACHEMENT WITH THE PROPER EMAIL ETIQUETTE (SUBJECT, GREETING, STATEMENT OF MATERIAL ENCLOSED AND SALUTATION IN THE BODY OF THE TEXT)
  • 2. 
    IT IS NOT POSSIBLE TO INSERT AN IMAGE FROM A FILE INTO EXCEL
    • A. 

      True

    • B. 

      False

  • 3. 
    WHICH KEY WOULD YOU PRESS TO CONNECT NON CONNECTED WORKSHEETS IN EXCEL
    • A. 

      F7

    • B. 

      ALT

    • C. 

      ENTER

    • D. 

      CTRL

  • 4. 
    WHAT IS THE CORRECT SEQUENCE (STEPS) TO REMOVE A SPREADSHEET FROM A WORKBOOK
    • A. 

      LEFT CLICK ON THE SPREADSHEET AND SELECT DELETE

    • B. 

      ASK KATRENA TO CHECK HER CELL PHONE FOR THE ANSWER

    • C. 

      RIGHT CLICK ON THE SPREADSHEET TAB AT THE BOTTOM THAT YOU WANT TO DELETE AND SELECT DELETE

    • D. 

      NONE OF THE ABOVE

  • 5. 
    EXCEL DATA CANNOT BE USED AS A DATA SOURCE FOR MAIL MERGE IN EXCEL
    • A. 

      True

    • B. 

      False

  • 6. 
    WHAT IS USED TO LOCATE OR SEARCH FOR DATA ON THE WEB? (think carefully)
    • A. 

      A SPIDER

    • B. 

      A BROWSER

    • C. 

      A SEARCH ENGINE

    • D. 

      THE INTERNET

  • 7. 
    Q.3)  In the image below, how would you move the open window to another part of the screen?
    • A. 

      PLACE YOUR CURSOR IN THE AREA INDICATED BY #8, HOLD DOWN THE LEFT MOUSE BUTTON AND DRAG.

    • B. 

      DOUBLE CLICK ANYWHERE ON THE WINDOW, A MENU WILL APPEAR WITH AN OPTION TO MOVE THE WINDOW

    • C. 

      PUT THE CURSOR ON THE BAR INDICATED BY #2, HOLD DOWN THE LEFT MOUSE BUTTON AND DRAG

    • D. 

      ALL OF THE ABOVE

  • 8. 
    WHICH OF THE STEPS BELOW IS THE PROPER WAY TO SHUT DOWN AND RESTART A COMPUTER?
    • A. 

      USE THE KEYBOARD KEYS 'CTRL', 'ALT', 'DELETE' AT THE SAME TIME TO GET THE TASK MANAGER AND THEN SELECT SHUT DOWN

    • B. 

      PRESS THE ON / OFF POWER BUTTON ON THE COMPUTER

    • C. 

      CLICK 'START' BUTTON, CLICK 'TURN OFF COMPUTER', THEN CLICK 'RESTART'

    • D. 

      ALL OF THE ABOVE

  • 9. 
    WHAT OPTIONS CAN MAKE A POWERPOINT PRESENTATION TOO DISTRACTING
    • A. 

      TOO MANY FONTS (TEXT)

    • B. 

      LOTS OF ANIMATIONS

    • C. 

      MR. TRAYLOR'S LOCS

    • D. 

      MANY DIFFERENT BACKGROUNDS AND THEMES

  • 10. 
    WHICH TAB ALLOWS YOU TO RUN SPELLCHECK
    • A. 

      OPTIONS TAB

    • B. 

      MAILINGS TAB

    • C. 

      SPELLCHECK TAB

    • D. 

      REVIEW TAB

  • 11. 
    HOW DO YOU SET THE ENTER KEY DIRECTION IN EXCEL
    • A. 

      USE YOUR CURSOR

    • B. 

      HIT THE ENTER KEY ON THE KEYBOARD AND IT WILL GO WHERE YOU WANT

    • C. 

      ASK BRIAN TO SWITCH COMPUTERS WITH YOU BECAUSE YOURS WON'T MOVE TO THE RIGHT

    • D. 

      CLICK THE OFFICE BUTTON AND SELECT EXCEL OPTIONS

  • 12. 
    YOU CAN ONLY HAVE ONE ORIENTATION SETTING FOR YOUR DOCUMENTS IN MICROSOFT OFFICE SOFTWARES
    • A. 

      True

    • B. 

      False

  • 13. 
    WHERE DO YOU CHANGE THE PAGE ORIENTATION?
    • A. 

      OFFICE BUTTON

    • B. 

      PAGE LAYOUT TAB

    • C. 

      VIEW TAB

    • D. 

      NONE OF THE ABOVE

  • 14. 
    ONLY MSWORD GIVES YOU THE OPTION TO PREVIEW YOUR DOCUMENT BEFORE PRINTING
    • A. 

      True

    • B. 

      False

  • 15. 
    HOW DO YOU ACCESS THE DESIGN TAB IN EXCEL
    • A. 

      CLICK ON THE TAB ON THE RIBBON BAR

    • B. 

      CREATE A PRIMARY SHEET SEPARATE FROM THE WORKSHEET FOR THE DESIGN ENTRY

    • C. 

      CLICK 'INSERT', THEN 'CHARTS' AND THE DESIGN TAB WILL APPEAR

    • D. 

      ALL OF THE ABOVE

  • 16. 
    WHICH TAB ALLOWS YOU TO CHANGE THE LINE SPACING IN A DOCUMENT
    • A. 

      DATA TAB

    • B. 

      INSERT TAB

    • C. 

      VIEW TAB

    • D. 

      NONE OF THE ABOVE

  • 17. 
    WHAT IS THE PURPOSE OF A RESUME
    • A. 

      TO GET A JOB

    • B. 

      TO LIST YOUR WORK HISTORY

    • C. 

      TO 'SELL' YOUR PROFESSIONAL EXPERTISE

    • D. 

      NONE OF THE ABOVE

  • 18. 
    YOU SHOULD NEVER HAVE REFERENCES AVAILABLE UPON REQUEST ON YOUR RESUME
    • A. 

      True

    • B. 

      False

  • 19. 
    WHEN EMAILING YOUR RESUME YOU SHOULD BEGIN WITH A __________  ____________ IN THE MESSAGE BODY OF YOUR EMAIL
  • 20. 
    WHICH OF THE OPTIONS BELOW CAN I USE FOR A FEE TO HELP ME FIND OUT INFORMATION ABOUT A COMPANY
    • A. 

      HOOVERS

    • B. 

      THE INTERNET

    • C. 

      DAMIEN BEAMON DETECTIVE AGENCY

    • D. 

      LINKEDIN

  • 21. 
    HOW MANY CHILDREN YOU HAVE AN WHAT ARE THEIR AGES IS A COMMON INTERVIEW QUESTION
    • A. 

      True

    • B. 

      False

  • 22. 
    WHAT TAB ALLOWS YOU TO ACCESS THE BULLET LIBRARY
    • A. 

      ZOOM

    • B. 

      REVIEW

    • C. 

      EDIT

    • D. 

      HOME

  • 23. 
    YOU JUST TYPED A 500 PAGE LETTER AND CHANGED THE FONT TYPE TO ARIEL BOLD.  JUST AS YOU WERE ABOUT TO PRINT THE LETTER YOU WERE TOLD TO CHANGE THE FONT BACK TO THE ORIGINAL FONT YOU HAD.   WHAT IS THE BEST AND QUICKEST WAY TO MAKE THE CORRECTION
    • A. 

      RE-TYPE THE LETTER IN THE RIGHT FONT

    • B. 

      HIGHLIGHT THE ENTIRE LETTER AND THEN CHANGE THE FONT

    • C. 

      USE THE UNDO BUTTON

    • D. 

      NONE OF THE ABOVE

  • 24. 
    TO CREATE A HANGING INDENT YOU MUST SELECT THE TEXT YOU WANT TO INDENT THEN CLICK ON THE _________ TAB AND THEN CLICK DROP DOWN IN THE _____________ AREA OF THE TAB TO GET THE DIALOG BOX.  ONCE IT APPEARS YOU WILL CHANGE THE _____________ DROP DOWN OPTION IN THE INDENTATION AREA TO HANGING. (DO NOT USE COMMAS IN YOU ANSWER - TOTAL OF THREE WORDS)
  • 25. 
    YOU HAVE TO CHANGE THE ________ __________ OPTION ON THE __________ DIALOGUE BOX TO __________ INDICATE THE NUMBER OF SLIDE PER PAGE WHEN PRINTING HANDOUTS. (FOUR WORDS, NO COMMAS NECESSARY)
Back to Top Back to top