Computer Knowledge #2 MCQ

COMPUTER KNOWLEDGE #2 MCQ

1. Which of the following is not one of the syntax rules?

(a) Properly spelling the function’s name

(b) The precedence of the arguments

(c) The order in which you list the function’s arguments

(d) Whether or not the function has arguments

Answer: (b)

2. Which of the following is hardware not software?

(a) Printer driver

(b) Operating system

(c) Excel

(d) CPU

Answer: (d)

3. Which of the following is a prerecorded formula that provides a shortcut for complex calculations?

(a) Data Series

(b) Value

(c) Function

(d) None of the above

Answer: (c)

4. What is called when you create a chart on a separate sheet in the same workbook?

(a) Embedded chart

(b) View chart

(c) View sheet

(d) Chart sheet

Answer: (d)

5. The copy command saves to which of the following?

(a) Microsoft Word

(b) The clipboard

(c) The desktop

(d) None of the above

Answer: (b)

6. Which of the following displays programs that are currently running? A single click on one of the program icons will bring the window up?

(a) Task bar

(b) Title bar

(c) Menu bar

(d) Status bar

Answer: (d)

7. Which of the following signs is used to specify a cell range?

(a) : (colon)

(b) / (slash)

(c) - (hyphen)

(d) * (asterisk)

Answer: (a)

8. By using which of the following data can be arranged in a worksheet in an easy way to understand manner?

(a) Applying styles

(b) Changing fonts

(c) Auto formatting

(d) All of the above

Answer: (d)

9. Legends are used in which of the following?

(a) Validation

(b) Chart Wizard

(c) Auto Sum

(d) Function Wizard

Answer: (c)

10. Which of the following menu keeps the Goal seek command?

(a) Insert

(b) Tools

(c) Format

(d) Data

Answer: (b)

11. In which of the following table you can find the pivot table command?

(a) Insert

(b) Data

(c) Window

(d) Tools

Answer: (b)

12. Who developed the basic structure of computer?

(a) John Von Neumann

(b) Garden Moore

(c) Charles Babbage

(d) Blaise Pascal

Answer: (a)

13. Ethernet, LAN, Token ring and Token Bus are types of which of the following?

(a) LAN

(b) Communication channel

(c) Physical medium

(d) WAN

Answer: (b)

14. What does 192.9.200.153 represent?

(a) Ethernet Address

(b) Computer Address

(c) IP Address

(d) None of the above

Answer: (a)

15. A folder ________ .

A. is an organizational tool used to store files

B. is synonymous with directory, but folder is the newer preferred term

C. contains data

(a) Only A

(b) Only B

(c) Only C

(d) A and C

Answer: (d)

16. What is the storage called that supplements the primary internal storage of a computer?

(a) Primary storage

(b) Background storage

(c) Back-end storage

(d) Secondary storage

Answer: (c)

17. Which of the following number system does the computer use to store data and perform calculations?

(a) Binary

(b) Decimal

(c) Hexadecimal

(d) Octal

Answer: (a)

18. What are the units used to count the speed of a printer?

(a) DPI

(b) PPM

(c) CPM

(d) BIT

Answer: (d)

19. What is called the light-sensitive device that converts drawing, printed text or other images into digital form?

(a) Plotter

(b) OMR

(c) Scanner

(d) Keyboard

Answer: (c)

20. What is the storage device called that is used to compensate for the difference in rates of flow of data from one device to another?

(a) Channel

(b) Floppy

(c) Chip

(d) Buffer

Answer: (d)