Computer Literacy Final Exam Part III
-
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)
-
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.
IT IS NOT POSSIBLE TO INSERT AN IMAGE FROM A FILE INTO EXCEL
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 3.
WHICH KEY WOULD YOU PRESS TO CONNECT NON CONNECTED WORKSHEETS IN EXCEL
-
F7
-
ALT
-
ENTER
-
CTRL
Correct Answer
A. CTRLExplanation
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:
-
- 4.
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 DELETEExplanation
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:
-
- 5.
EXCEL DATA CANNOT BE USED AS A DATA SOURCE FOR MAIL MERGE IN EXCEL
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 6.
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 ENGINEExplanation
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:
-
- 7.
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 DRAGExplanation
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:
-
- 8.
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:
-
- 9.
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:
-
- 10.
WHICH TAB ALLOWS YOU TO RUN SPELLCHECK
-
OPTIONS TAB
-
MAILINGS TAB
-
SPELLCHECK TAB
-
REVIEW TAB
Correct Answer
A. REVIEW TABExplanation
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:
-
- 11.
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 -
- 12.
YOU CAN ONLY HAVE ONE ORIENTATION SETTING FOR YOUR DOCUMENTS IN MICROSOFT OFFICE SOFTWARES
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 13.
WHERE DO YOU CHANGE THE PAGE ORIENTATION?
-
OFFICE BUTTON
-
PAGE LAYOUT TAB
-
VIEW TAB
-
NONE OF THE ABOVE
Correct Answer
A. PAGE LAYOUT TABExplanation
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:
-
- 14.
ONLY MSWORD GIVES YOU THE OPTION TO PREVIEW YOUR DOCUMENT BEFORE PRINTING
-
True
-
False
Correct Answer
A. FalseExplanation
This statement is false because other word processing software, such as Google Docs or Apple Pages, also provide the option to preview a document before printing. Therefore, it is not only Microsoft Word that offers this feature.Rate this question:
-
- 15.
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 APPEARExplanation
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:
-
- 16.
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 ABOVEExplanation
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:
-
- 17.
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 EXPERTISEExplanation
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:
-
- 18.
YOU SHOULD NEVER HAVE REFERENCES AVAILABLE UPON REQUEST ON YOUR RESUME
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 19.
WHEN EMAILING YOUR RESUME YOU SHOULD BEGIN WITH A __________ ____________ IN THE MESSAGE BODY OF YOUR EMAIL
Correct Answer
COVER LETTER
Cover Letter
cover letterExplanation
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:
- 20.
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. HOOVERSExplanation
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:
-
- 21.
HOW MANY CHILDREN YOU HAVE AN WHAT ARE THEIR AGES IS A COMMON INTERVIEW QUESTION
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 22.
WHAT TAB ALLOWS YOU TO ACCESS THE BULLET LIBRARY
-
ZOOM
-
REVIEW
-
EDIT
-
HOME
Correct Answer
A. HOMEExplanation
The Home tab allows you to access the bullet library.Rate this question:
-
- 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
-
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 BUTTONExplanation
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:
-
- 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)
Correct Answer
HOME PARAGRAPH SPECIAL
Home Paragraph Special
home paragraph specialExplanation
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:
- 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)
Correct Answer
PRINT WHAT HANDOUT PRINT
Print What Handout Print
print what handout printExplanation
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:
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, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 20, 2011Quiz Created by
PCDAC
Back to top