Computer — All MCQs
4795 questions available
Q3001.We can add charts in an Excel worksheet by using _____?
Correct Answer: C
Excel allows users to insert data visualization charts directly through the Insert Tab on the Ribbon.
Q3002.Which of the following functions of Excel would you use to extract the substring 'Pak' from the word 'Pakistan'?
Correct Answer: A
The LEFT function extracts a specified number of characters starting from the left of a string (e.g., =LEFT("Pakistan",3) returns 'Pak').
Q3003.The correct syntax of using the COUNTIF() function in MS Excel 2016 is ______?
Correct Answer: B
The correct Excel COUNTIF syntax is =COUNTIF(range, criteria), counting cells that meet the specified conditional test.
Q3004.The two kinds of main memory are _____?
Correct Answer: A
The two main components of primary memory (main memory) are volatile RAM (Random Access Memory) and non-volatile ROM (Read-Only Memory).
Q3005.Which of the following is a billionth of a second?
Correct Answer: C
A nanosecond represents one-billionth of a second (10^-9 seconds).
Q3006.Which of the following is the decimal equivalent (?)₁₀ of the binary number (11111)₂?
Correct Answer: B
Binary 11111 translates in decimal to 2^4 + 2^3 + 2^2 + 2^1 + 2^0 = 16 + 8 + 4 + 2 + 1 = 31.
Q3007.Which of the following is the binary equivalent (?)₂ of the decimal number (20)₁₀?
Correct Answer: A
Decimal 20 is equal to binary 10100 (which is 16 + 4, or 2^4 + 2^2).
Q3008.Which one of the following is the smallest unit of memory?
Correct Answer: A
Among the given options, KB (Kilobyte) is the smallest unit of digital storage, followed sequentially by MB, GB, and TB.
Q3009.Which of the following is the largest/highest unit of storage?
Correct Answer: C
Among the given options, TB (Terabyte, or 1024 GB) represents the largest capacity storage unit.
Q3010.Which of the following is a result of poor design that could cause an accident in the workplace?
Correct Answer: D
An unplanned or congested workspace layout represents a fundamental system/design failure that directly creates structural workplace hazards.
Q3011.In Microsoft Excel, the file you create and edit is called?
Correct Answer: C
In Microsoft Excel, the files created are called workbooks, which can contain multiple individual worksheets.
Q3012.The F7 key is commonly used for?
Correct Answer: B
F7 does a spelling and grammar check in Microsoft Word.
Q3013.JPEG stands for______.
Correct Answer: A
The JPEG is a digital image file extension given its acronym from Joint Photographic Experts Group.
Q3014.CD-ROM stands for ______?
Correct Answer: A
CD-ROM stands for Compact Disc Read-Only Memory.
Q3015.MAC stands for_______.
Correct Answer: A
MAC Address means Media Access Control Address, which is a unique identifier assigned to a Network Interface Card (NIC).
Q3016.C.L.I stands for _____?
Correct Answer: A
CLI stands for Caller’s Line Identification, a feature that displays the phone number of the incoming caller.
Q3017.Wi-Fi stands for ______?
Correct Answer: A
Wi-Fi stands for Wireless fidelity.
Q3018.DSL stands for in computer term?
Correct Answer: A
DSL stands for Digital Subscriber Line, which uses existing telephone lines to transport high-bandwidth data.
Q3019.In computer GB stands for _______?
Correct Answer: A
GB stands for Gigabyte, which is a unit of digital information equal to 1 billion bytes.
Q3020.IC stands for _____?
Correct Answer: A
An Integrated Circuit (IC) is a tiny electronic device containing transistors, diodes, and resistors on a single piece of semiconductor silicon.