CS001 Computer Proficiency – Solved MCQs
Q#1: In Excel the intersection of a row and a column is called:
(A) Data
(B) A field
(C) A cell
(D) An equation
Answer: (C) A cell
Q#2: The cell labeled F5 refers to:
(A) Row F column 5
(B) Column F row 5
(C) Functions available in cells
(D) Function key F4
Answer: (B) Column F row 5
Q#3: 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
(D) Pressing CTRL + A on the keyboard
Answer: (C) Left click on the gray column title button
Q#4: What is the format of a spreadsheet?
(A) Round
(B) Rows and Columns
(C) Square
(D) Wide
Answer: (B) Rows and Columns
Q#5: Which one is a relative address?
(A) $C$4
(B) 256
(C) C4
(D) None of these
Answer: (C) C4
Q#6: What do you use to create a chart?
(A) Chart Wizard
(B) Pie Wizard
(C) Excel Wizard
(D) Data Wizard
Answer: (A) Chart Wizard
Q#7: On an Excel sheet the active cell is indicated by:
(A) A dark wide border
(B) A dotted border
(C) A blinking border
(D) All of these
Answer: (A) A dark wide border
Q#8: News Groups are:
(A) Provided only by large international news services
(B) Online discussions about various topics
(C) Available only from 9am to 5pm EST
(D) All of these
Answer: (B) Online discussions about various topics
Q#9: A ______ line has transfer rates of 128 Kbps to 8.45 Mbps.
(A) DSL
(B) ISDN
(C) ATM
(D) Fractional T1
Answer: (D) Fractional T1
Q#10: ______ refers to the amount of data, instructions, and information that can travel over a communications channel.
(A) Latency
(B) Transfer rate
(C) Bandwidth
(D) Broadband
Answer: (C) Bandwidth
Q#11: The process of converting readable data into unreadable characters to prevent unauthorized use is called:
(A) Normalization
(B) Decryption
(C) Validation
(D) Encryption
Answer: (D) Encryption
Q#12: 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
(D) Complete all requested information on registration forms
Answer: (C) Do not reply to spam for any reason
Q#13: Storage is also referred as:
(A) Data
(B) Instructions
(C) Files
(D) Memory
Answer: (D) Memory
Q#14: To enter capital characters use:
(A) Num Lock
(B) Pause Lock
(C) Caps Lock
(D) Scroll Lock
Answer: (C) Caps Lock
Q#15: Windows is software developed by:
(A) Sun
(B) Java
(C) HTML
(D) Microsoft
Answer: (D) Microsoft
Q#16: Desktop Icon is a link to:
(A) Hardware
(B) Software
(C) Storage
(D) None of these
Answer: (B) Software
Q#17: What is the keyboard shortcut for creating a chart from the selected cells?
(A) F3
(B) F4
(C) F5
(D) F6
Answer: (C) F5
Q#18: In Word, which shortcut key combination changes the font?
(A) Ctrl + Shift + F
(B) Ctrl + Shift + I
(C) Ctrl + F
(D) Ctrl + I
Answer: (A) Ctrl + Shift + F
Q#19: In Word, which shortcut key combination saves the document?
(A) Shift + F12
(B) Ctrl + Shift + F12
(C) Alt + Shift + T
(D) Alt + Shift + S
Answer: (A) Shift + F12
Q#20: Which will select all the cells in a document?
(A) Clicking three times with the right mouse button
(B) Using Edit → Select All menu item
(C) Pressing CTRL + A on the keyboard
(D) None of these
Answer: (C) Pressing CTRL + A
Q#21: ______ will insert a new worksheet.
(A) ALT + SHIFT + F1
(B) ALT + SHIFT + F2
(C) ALT + SHIFT + F3
(D) None of these
Answer: (A) ALT + SHIFT + F1
Q#22: Which will not select all the cells in a document?
(A) Clicking three times with the right mouse button
(B) Using Edit → Select All menu item
(C) Pressing CTRL + A on the keyboard
(D) None of these
Answer: (A) Clicking three times with the right mouse button
Q#23: Spreadsheet can be used as:
(A) Accounting
(B) Database
(C) Ledger
(D) All of above
Answer: (D) All of above
Q#24: A ______ is a device that converts analog signals to digital signals and vice versa.
(A) Tablet PC
(B) Modem
(C) Microwave station
(D) Notebook computer
Answer: (B) Modem
Q#25: Displays the Help task pane:
(A) F2
(B) F3
(C) F1
(D) None of these
Answer: (C) F1
Q#26: The act of damaging or destroying computer equipment is known as:
(A) Hardware vandalism
(B) Software piracy
(C) Hardware theft
(D) Information theft
Answer: (A) Hardware vandalism