VU Final Term Past Papers
CS001 — Computer Proficiency License — Final Term Past Papers & Solved MCQs
50 solved final term past paper MCQs for CS001 (Computer Proficiency License) at Virtual University, each with the correct answer marked. Use them to learn the VU question style and test your recall. An independent study tool — not affiliated with VU.
Prefer a summary first? Read the CS001 final term handout.
Q1. In excel the intersection of a row and a column is called:
- A.data
- B.a field.
- C.a cell.✓ Correct
- D.an equation.
Q2. The cell labeled F5 refers to
- A.row F column 5
- B.column F row 5✓ Correct
- C.functions available in cells
- D.Function key F4
Q3. Which of the following describes how to select all the cells in a single column ?
- A.Right click on column and select Pick From List
- B.Use the Data - Text to Columns menu item
- C.Left click on the gray column title button✓ Correct
- D.Pressing CTRL + A on the keyboard
Q4. What is the format of a spreadsheet?
- A.Round
- B.Rows and Columns✓ Correct
- C.Square
- D.Wide
Q5. Which one is a relative address?
- A.$C$4
- B.256
- C.C4✓ Correct
- D.None of these
Q6. What do you use to create a chart?
- A.Chart Wizard✓ Correct
- B.Pie Wizard
- C.Excel Wizard
- D.Data Wizard
Q7. On an Excel sheet the active cell is indicated by ____.
- A.a dark wide border✓ Correct
- B.a dotted border
- C.a blinking border
- D.All of these
Q8. News Groups are...
- A.provided only by large international news services
- B.are online discussions about various topics✓ Correct
- C.are only available from 9am to 5pm EST
- D.All of these
Q9. A(n) ____ line has transfer rates of 128 Kbps to 8.45 Mbps.
- A.DSL✓ Correct
- B.ISDN
- C.ATM
- D.Fractional T1
Q10. ____ refers to the amount of data, instructions, and information that can travel over a communications channel.
- A.Latency
- B.Transfer rate
- C.Bandwidth✓ Correct
- D.Broadband
Q11. The process of converting readable data into unreadable characters to prevent unauthorized use is called ____
- A.normalization
- B.decryption
- C.validation
- D.encryption✓ Correct
Q12. To safeguard personal information, ____
- A.write your telephone number on credit receipts
- B.use shopping club and buyer cards
- C.do not reply to spam for any reason✓ Correct
- D.complete all requested information on registration forms
Q13. Storage is also referred as
- A.Data
- B.Instructions
- C.Files
- D.Memory✓ Correct
Q14. To enter capital characters use
- A.Num lock
- B.Pause lock
- C.Caps lock✓ Correct
- D.Scroll lock
Q15. Windows is software developed by
- A.Sun
- B.Java
- C.Html
- D.Microsoft✓ Correct
Q16. Desktop Icon is a link to
- A.Hardware
- B.Software✓ Correct
- C.Storage
- D.None of these
Q17. In Word which of the following shortcut key combination, changes the font.
- A.Ctrl + Shift + F✓ Correct
- B.Ctrl + Shift + I
- C.Ctrl + F
- D.Ctrl + I
Q18. In Word which of the following shortcut key combination, Save.
- A.Shift + F12✓ Correct
- B.Ctrl + Shift + F12
- C.Alt + Shift + T
- D.Alt + Shift + S
Q19. Which will select all the cells in a document ?
- A.Clicking three times with the right mouse button in the spreadsheet
- B.Using the Edit - Select All menu item
- C.Pressing CTRL + A on the keyboard✓ Correct
- D.None of these
Q20. ___________ will insert a new worksheet.
- A.ALT+SHIFT+F1✓ Correct
- B.ALT+SHIFT+F2
- C.ALT+SHIFT+F3
- D.None of these.
Q21. Which will not select all the cells in a document ?
- A.Clicking three times with the right mouse button in the spreadsheet✓ Correct
- B.Using the Edit - Select All menu item
- C.Pressing CTRL + A on the keyboard
- D.None of these
Q22. Spreadsheet can be used as :
- A.Accounting
- B.Data base
- C.Ledger
- D.All of above✓ Correct
Q23. A ____ is a device that converts analog signals to digital signals, and vice versa.
- A.Tablet PC
- B.modem✓ Correct
- C.microwave station
- D.notebook computer
Q24. _______Displays the Help task pane.
- A.F2
- B.F3
- C.F1✓ Correct
- D.None of these
Q25. The act of defecting or destroying computer equipment is known as ____
- A.hardware vandalism✓ Correct
- B.software piracy
- C.hardware theft
- D.information theft
Q26. Which is an absolute address?
- A.$C$4✓ Correct
- B.10700 - 105 Ave.
- C.C4
- D.None of these
Q27. The private combination of characters associated with a user name that allows access to certain computer resources is called a(n) ____
- A.audit trail
- B.password✓ Correct
- C.possessed object
- D.biometric device
Q28. Pressing the key once and releasing it is called a
- A.Key stroke✓ Correct
- B.Key strike
- C.Key action
- D.None of these
Q29. An unsolicited e-mail message sent to many recipients at once is known as ____.
- A.Email-spyware
- B.E-mail spam✓ Correct
- C.Junk mail
- D.a Web bug
Q30. The problem face by software companies is ____
- A.vandalism
- B.piracy✓ Correct
- C.theft
- D.hacking
Q31. Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric and place the result in a different cell ?
- A.Count
- B.Average
- C.Sum✓ Correct
- D.None of these
Q32. Which format is used to insert the picture in power point
- A..jpg✓ Correct
- B..wav
- C..grv
- D..jpg .wmv .grv
Q33. There are three types of data found in a spreadsheet.
- A.data, words, numbers
- B.equations, data, numbers
- C.words, numbers, labels
- D.numbers, formulas, labels✓ Correct
Q34. A constant is another name for this type of data:
- A.number✓ Correct
- B.equation
- C.formula
- D.description
Q35. What program do you use to create a spreadsheet?
- A.Word
- B.Excel✓ Correct
- C.Access
- D.PowerPoint
Q36. Which button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions?
- A.AutoSum✓ Correct
- B.Insert Function
- C.AutoFill
- D.Paste
Q37. Which type of chart shows the pattern or relationships between sets of data points?
- A.Line
- B.Pie
- C.Area
- D.XY (Scatter)✓ Correct
Q38. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
- A.Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.Right click on the spreadsheet tab and select DELETE✓ Correct
- C.Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
- D.None of these
Q39. The World Wide Web (WWW) is...
- A.a part of the Internet✓ Correct
- B.the Internet
- C.not a part of the Internet
- D.All of these
Q40. Uniform Resource Locator (URL) are...
- A.the same as Search Engines
- B.the addresses of specific documents and resources on the WWW✓ Correct
- C.never more than 11 characters long
- D.All of these.
Q41. The standard defines how data transmits across telephone lines or other means.
- A.TCP/IP✓ Correct
- B.EDI (Electronic Data Interchange)
- C.Electronic funds transfer (EFT)
- D.Ethernet
Q42. A(n) line typically costs $1,000 or more per month.
- A.ISDN
- B.T3
- C.ATM
- D.T1✓ Correct
Q43. A is a Web site that uses encryption techniques to secure its data.
- A.digital certificate
- B.secure (S-
- C.wallet program
- D.secure site✓ Correct
Q44. Repeats the last command or action, if possible in excel.
- A.F1
- B.F2
- C.F3
- D.F4✓ Correct
Q45. Which of the following is primary storage?
- A.Hard disk
- B.Floppy disk
- C.RAM✓ Correct
- D.Optical disk
Q46. The device used to store data is called
- A.Input device
- B.Out put device
- C.None of these
- D.Storage device✓ Correct
Q47. Which of the following is intangible?
- A.Software✓ Correct
- B.Hard disk
- C.Optical disk
- D.Computer Mouse
Q48. In Word which of the following shortcut key combination, Inserts link
- A.Ctrl + P
- B.Ctrl + F
- C.Ctrl + I
- D.Ctrl + K✓ Correct
Q49. In Word which of the following shortcut key combination, decreases selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
- A.Ctrl + Shift + <✓ Correct
- B.Ctrl + Shift + >
- C.Ctrl + ]
- D.Ctrl + [
Q50. E-mail stands for
- A.electronic mail✓ Correct
- B.the print out from a fax machine
- C.a letter printed from a computer
- D.All of these