Computer Literacy Final Exam Part III

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By PCDAC
P
PCDAC
Community Contributor
Quizzes Created: 11 | Total Attempts: 7,496
| Attempts: 353
SettingsSettings
Please wait...
  • 1/25 Questions

    ONLY MSWORD GIVES YOU THE OPTION TO PREVIEW YOUR DOCUMENT BEFORE PRINTING

    • True
    • False
Please wait...
Computer Literacy Final Exam Part III - Quiz
About This Quiz

This final exam in COMPUTER LITERACY PART III assesses skills in Microsoft Excel, including data entry with specific formatting, creating and modifying a 3D exploded pie chart, and managing document properties. Students demonstrate their ability to integrate Excel with email communication, showcasing practical, real-world application of spreadsheet tools.

Quiz Preview

  • 2. 

    WHERE DO YOU CHANGE THE PAGE ORIENTATION?

    • OFFICE BUTTON

    • PAGE LAYOUT TAB

    • VIEW TAB

    • NONE OF THE ABOVE

    Correct Answer
    A. PAGE LAYOUT TAB
    Explanation
    The correct answer is "PAGE LAYOUT TAB" because the Page Layout tab in most software applications, such as Microsoft Word or Excel, contains various options and settings related to the layout and formatting of the document, including the page orientation. This tab allows users to change the page orientation from portrait to landscape or vice versa, depending on their needs. Therefore, if someone wants to change the page orientation, they would typically go to the Page Layout tab in the software they are using.

    Rate this question:

  • 3. 

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

    • LEFT CLICK ON THE SPREADSHEET AND SELECT DELETE

    • ASK KATRENA TO CHECK HER CELL PHONE FOR THE ANSWER

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

    • NONE OF THE ABOVE

    Correct Answer
    A. RIGHT CLICK ON THE SPREADSHEET TAB AT THE BOTTOM THAT YOU WANT TO DELETE AND SELECT DELETE
    Explanation
    To remove a spreadsheet from a workbook, the correct sequence of steps is to right-click on the spreadsheet tab at the bottom that you want to delete and select delete. This action will prompt the spreadsheet to be removed from the workbook. The other options mentioned, such as left-clicking on the spreadsheet and selecting delete or asking someone for the answer, are not the correct steps to remove a spreadsheet. Therefore, the correct answer is to right-click on the spreadsheet tab and select delete.

    Rate this question:

  • 4. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false because asking about someone's personal life, such as the number of children they have and their ages, is not a common interview question. Interview questions typically focus on a person's qualifications, skills, and experiences related to the job they are applying for. Personal questions like this are considered inappropriate and potentially discriminatory.

    Rate this question:

  • 5. 

    YOU CAN ONLY HAVE ONE ORIENTATION SETTING FOR YOUR DOCUMENTS IN MICROSOFT OFFICE SOFTWARES

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false because Microsoft Office software allows users to have multiple orientation settings for their documents. Users can choose between portrait and landscape orientations for their documents depending on their preferences or the type of content they are working with.

    Rate this question:

  • 6. 

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

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

    • PRESS THE ON / OFF POWER BUTTON ON THE COMPUTER

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

    • ALL OF THE ABOVE

    Correct Answer
    A. CLICK 'START' BUTTON, CLICK 'TURN OFF COMPUTER', THEN CLICK 'RESTART'
    Explanation
    The proper way to shut down and restart a computer is to click the 'Start' button, then click 'Turn off computer', and finally click 'Restart'. This method ensures that all running programs and processes are properly closed before the computer is shut down or restarted. Using the keyboard keys 'Ctrl', 'Alt', 'Delete' at the same time to get the task manager and then selecting shut down may not properly close all programs and processes, and pressing the on/off power button on the computer can result in data loss or damage to the system. Therefore, the correct answer is to click 'Start' button, click 'Turn off computer', then click 'Restart'.

    Rate this question:

  • 7. 

    IT IS NOT POSSIBLE TO INSERT AN IMAGE FROM A FILE INTO EXCEL

    • True

    • False

    Correct Answer
    A. False
    Explanation
    It is possible to insert an image from a file into Excel. Excel allows users to insert images into cells or as a floating object on the worksheet. This can be done by selecting the cell where the image is desired, going to the "Insert" tab, and selecting "Picture" or "Online Pictures" to insert an image from a file.

    Rate this question:

  • 8. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Excel data can be used as a data source for mail merge in Excel. Mail merge is a feature in Excel that allows users to create personalized letters, emails, or other documents by merging data from a data source, such as an Excel spreadsheet, with a template. Users can select the data source from Excel and then customize the document by inserting fields from the data source. Therefore, the given answer, "False," is correct.

    Rate this question:

  • 9. 

    WHAT TAB ALLOWS YOU TO ACCESS THE BULLET LIBRARY

    • ZOOM

    • REVIEW

    • EDIT

    • HOME

    Correct Answer
    A. HOME
    Explanation
    The Home tab allows you to access the bullet library.

    Rate this question:

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

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

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

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

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

    • ALL OF THE ABOVE

    Correct Answer
    A. PUT THE CURSOR ON THE BAR INDICATED BY #2, HOLD DOWN THE LEFT MOUSE BUTTON AND DRAG
    Explanation
    To move the open window to another part of the screen, you need to put the cursor on the bar indicated by #2, hold down the left mouse button, and drag. This action will allow you to move the window to a different position on the screen.

    Rate this question:

  • 11. 

    WHICH TAB ALLOWS YOU TO RUN SPELLCHECK

    • OPTIONS TAB

    • MAILINGS TAB

    • SPELLCHECK TAB

    • REVIEW TAB

    Correct Answer
    A. REVIEW TAB
    Explanation
    The Review tab allows you to run spellcheck. This tab contains various proofing tools, including the spellcheck feature, which allows you to check the spelling and grammar of your document.

    Rate this question:

  • 12. 

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

    • DATA TAB

    • INSERT TAB

    • VIEW TAB

    • NONE OF THE ABOVE

    Correct Answer
    A. NONE OF THE ABOVE
    Explanation
    The correct answer is NONE OF THE ABOVE because there is no specific tab in a document that allows you to change the line spacing. Line spacing is typically changed in the formatting options of a word processing software, such as Microsoft Word, which may be accessed through various tabs or menus depending on the specific software version.

    Rate this question:

  • 13. 

    HOW DO YOU ACCESS THE DESIGN TAB IN EXCEL

    • CLICK ON THE TAB ON THE RIBBON BAR

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

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

    • ALL OF THE ABOVE

    Correct Answer
    A. CLICK 'INSERT', THEN 'CHARTS' AND THE DESIGN TAB WILL APPEAR
    Explanation
    To access the Design tab in Excel, you need to click on the "Insert" tab on the ribbon bar, then select "Charts". Once you do this, the Design tab will appear, allowing you to customize and format your charts.

    Rate this question:

  • 14. 

    YOU SHOULD NEVER HAVE REFERENCES AVAILABLE UPON REQUEST ON YOUR RESUME

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Having references available upon request on your resume is not necessary because it is understood that you will provide references if requested. Including this statement on your resume takes up valuable space and can make it appear unprofessional or inexperienced. It is better to use that space to highlight your skills, qualifications, and achievements instead.

    Rate this question:

  • 15. 

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

    • A SPIDER

    • A BROWSER

    • A SEARCH ENGINE

    • THE INTERNET

    Correct Answer
    A. A SEARCH ENGINE
    Explanation
    A search engine is used to locate or search for data on the web. It is a software program that allows users to enter keywords or phrases and retrieves relevant information from the internet. Search engines use algorithms to analyze and index web pages, making it easier for users to find the information they are looking for. Examples of popular search engines include Google, Bing, and Yahoo.

    Rate this question:

  • 16. 

    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

    • RE-TYPE THE LETTER IN THE RIGHT FONT

    • HIGHLIGHT THE ENTIRE LETTER AND THEN CHANGE THE FONT

    • USE THE UNDO BUTTON

    • NONE OF THE ABOVE

    Correct Answer
    A. USE THE UNDO BUTTON
    Explanation
    The best and quickest way to make the correction is to use the undo button. This will revert the font change back to the original font without having to retype the entire letter or highlight and change the font for the entire letter.

    Rate this question:

  • 17. 

    HOW DO YOU SET THE ENTER KEY DIRECTION IN EXCEL

    • USE YOUR CURSOR

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

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

    • CLICK THE OFFICE BUTTON AND SELECT EXCEL OPTIONS

    Correct Answer
    A. CLICK THE OFFICE BUTTON AND SELECT EXCEL OPTIONS
  • 18. 

    WHEN EMAILING YOUR RESUME YOU SHOULD BEGIN WITH A __________  ____________ IN THE MESSAGE BODY OF YOUR EMAIL

    Correct Answer
    COVER LETTER
    Cover Letter
    cover letter
    Explanation
    When emailing your resume, it is important to begin with a cover letter in the message body of your email. A cover letter is a formal introduction that accompanies your resume and provides additional information about your qualifications and why you are interested in the position. Including a cover letter shows professionalism and highlights your attention to detail and interest in the job.

    Rate this question:

  • 19. 

    WHICH KEY WOULD YOU PRESS TO CONNECT NON CONNECTED WORKSHEETS IN EXCEL

    • F7

    • ALT

    • ENTER

    • CTRL

    Correct Answer
    A. CTRL
    Explanation
    Pressing the CTRL key allows you to select multiple non-contiguous worksheets in Excel and connect them. This feature is useful when you want to perform the same action, such as formatting or entering data, on multiple worksheets at once. By holding down the CTRL key and selecting the desired worksheets, you can easily connect them and make changes simultaneously.

    Rate this question:

  • 20. 

    WHAT IS THE PURPOSE OF A RESUME

    • TO GET A JOB

    • TO LIST YOUR WORK HISTORY

    • TO 'SELL' YOUR PROFESSIONAL EXPERTISE

    • NONE OF THE ABOVE

    Correct Answer
    A. TO 'SELL' YOUR PROFESSIONAL EXPERTISE
    Explanation
    The purpose of a resume is to 'sell' your professional expertise. A resume is a document that highlights your skills, qualifications, and experiences to potential employers. It serves as a marketing tool to showcase your abilities and convince employers that you are the right candidate for a job. By emphasizing your professional expertise, a resume aims to persuade employers to consider you for employment.

    Rate this question:

  • 21. 

    WHAT OPTIONS CAN MAKE A POWERPOINT PRESENTATION TOO DISTRACTING

    • TOO MANY FONTS (TEXT)

    • LOTS OF ANIMATIONS

    • MR. TRAYLOR'S LOCS

    • MANY DIFFERENT BACKGROUNDS AND THEMES

    Correct Answer
    A. TOO MANY FONTS (TEXT)
    Explanation
    Having too many fonts (text) in a PowerPoint presentation can make it too distracting. Using multiple fonts can create a cluttered and unprofessional look, making it difficult for the audience to focus on the content. It is recommended to stick to a maximum of two or three fonts throughout the presentation to maintain consistency and readability.

    Rate this question:

  • 22. 

    WHICH OF THE OPTIONS BELOW CAN I USE FOR A FEE TO HELP ME FIND OUT INFORMATION ABOUT A COMPANY

    • HOOVERS

    • THE INTERNET

    • DAMIEN BEAMON DETECTIVE AGENCY

    • LINKEDIN

    Correct Answer
    A. HOOVERS
    Explanation
    Hoovers is a viable option to use for a fee in order to gather information about a company. Hoovers is a well-known provider of business information and has a comprehensive database that includes company profiles, financial data, industry analysis, and more. By subscribing to Hoovers, individuals can access valuable information that can aid in making informed business decisions or conducting research on specific companies.

    Rate this question:

  • 23. 

    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)

    Correct Answer
    HOME PARAGRAPH SPECIAL
    Home Paragraph Special
    home paragraph special
    Explanation
    To create a hanging indent, you must select the text you want to indent, then click on the HOME tab and then click the drop-down in the PARAGRAPH area of the tab to get the dialog box. Once it appears, you will change the SPECIAL drop-down option in the indentation area to HANGING.

    Rate this question:

  • 24. 

    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)

    Correct Answer
    PRINT WHAT HANDOUT PRINT
    Print What Handout Print
    print what handout print
    Explanation
    To indicate the number of slides per page when printing handouts, you need to change the "Print What Handout Print" option on the dialogue box. The correct answer is "PRINT WHAT HANDOUT PRINT" (in all caps), as it matches the given answer format and accurately describes the action required.

    Rate this question:

  • 25. 
    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 ANUMINISTRIES@GMAIL.COM AS AN ATTACHEMENT WITH THE PROPER EMAIL ETIQUETTE (SUBJECT, GREETING, STATEMENT OF MATERIAL ENCLOSED AND SALUTATION IN THE BODY OF THE TEXT) - ProProfs

    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)

Quiz Review Timeline (Updated): Mar 18, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 18, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 20, 2011
    Quiz Created by
    PCDAC
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.