Computer Literacy Final Exam Part III

25 Questions | By PCDAC | Last updated: Mar 18, 2022 | Total Attempts: 174

Questions

Settings

Create your own Quiz

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)