Q#1: 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
Answer: (D) Numbers, formulas, labels
Q#2: A constant is another name for this type of data:
(A) Number
(B) Equation
(C) Formula
(D) Description
Answer: (A) Number
Q#3: Which is an absolute address?
(A) $C$4
(B) 10700 – 105 Ave.
(C) C4
(D) None of these
Answer: (A) $C$4
Q#4: What program do you use to create a spreadsheet?
(A) Word
(B) Excel
(C) Access
(D) PowerPoint
Answer: (B) Excel
Q#5: Which button on the standard toolbar gives quick access to Sum, Average, Count, Min and Max functions?
(A) AutoSum
(B) Insert Function
(C) AutoFill
(D) Paste
Answer: (A) AutoSum
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: Which type of chart shows the pattern or relationships between sets of data points?
(A) Line
(B) Pie
(C) Area
(D) XY (Scatter)
Answer: (D) XY (Scatter)
Q#8: 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#9: A user wishes to remove a spreadsheet from a workbook. Which is correct?
(A) File → Save As
(B) Right click on spreadsheet tab → Delete
(C) Right click → Insert Column
(D) None of these
Answer: (B) Right click on spreadsheet tab → Delete
Q#10: The World Wide Web (WWW) is
(A) A part of the Internet
(B) Not part of Internet
(C) All of these
(D) None of these
Answer: (A) A part of the Internet
Q#11: URL stands for
(A) Search engine
(B) Address of resources on WWW
(C) Only 11 characters long
(D) All of these
Answer: (B) Address of resources on WWW
Q#12: The standard defines how data transmits across telephone lines.
(A) TCP/IP
(B) EDI
(C) EFT
(D) Ethernet
Answer: (D) Ethernet
Q#13: A ____ line typically costs $1000 or more per month.
(A) ISDN
(B) T3
(C) ATM
(D) T1
Answer: (D) T1
Q#14: A website that uses encryption to secure data is called
(A) Digital certificate
(B) Secure HTTP
(C) Wallet program
(D) Secure site
Answer: (D) Secure site
Q#15: Converting readable data into unreadable characters is called
(A) Normalization
(B) Decryption
(C) Validation
(D) Encryption
Answer: (D) Encryption
Q#16: Repeats the last command in Excel
(A) F1
(B) F2
(C) F3
(D) F4
Answer: (D) F4
Q#17: Which is primary storage?
(A) Hard Disk
(B) Floppy Disk
(C) RAM
(D) Optical Disk
Answer: (C) RAM
Q#18: The device used to store data is called
(A) Input device
(B) Output device
(C) None of these
(D) Storage device
Answer: (D) Storage device
Q#19: Which of the following is intangible?
(A) Software
(B) Hard Disk
(C) Optical Disk
(D) Mouse
Answer: (A) Software
Q#20: Tab key is a
(A) Non-typing key
(B) Typing key
(C) Toggle key
(D) Application key
Answer: (A) Non-typing key
Q#21: Shortcut key to create chart from selected cells
(A) F3
(B) F4
(C) F5
(D) F6
Answer: (C) F5
Q#22: In Word shortcut key to insert hyperlink
(A) Ctrl + P
(B) Ctrl + F
(C) Ctrl + I
(D) Ctrl + K
Answer: (D) Ctrl + K
Q#23: Decrease selected font size
(A) Ctrl + Shift + <
(B) Ctrl + Shift + >
(C) Ctrl + ]
(D) Ctrl + [
Answer: (A) Ctrl + Shift + <
Q#24: Select all cells in document
(A) Right click three times
(B) Edit → Select All
(C) Ctrl + A
(D) None
Answer: (C) Ctrl + A
Q#25: Insert a new worksheet
(A) Alt + Shift + F1
(B) Alt + Shift + F2
(C) Alt + Shift + F3
(D) None
Answer: (A) Alt + Shift + F1
Q#26: E-mail stands for
(A) Electronic mail
(B) Fax printout
(C) Computer letter
(D) All of these
Answer: (A) Electronic mail
Short Questions (Solved)
Q: Difference between Closing and Exiting
- Closing: Closes the current document only.
- Exiting: Closes the entire program.
Q: What is an Icon?
An icon is a small graphical image that represents a program, file, or folder on the desktop.
Q: Shortcut to switch between documents
Alt + Tab
Q: What does Undo do?
Undo reverses the last action performed. Shortcut key is Ctrl + Z.
Q: Steps to open Notepad
- Click Start Menu
- Select All Programs
- Open Accessories
- Click Notepad