Computer Science MCQS

Computer Science MCQ with detailed explanations for students & freshers preparing for entrance exams, various tests, interviews, competitive exams like GATE exam, interview, competitive examination and entrance exam.

📚 Table of Content

Excel function for loan payment calculation:

A. PMT

B. FV

C. PV

D. RATE

Correct answer is: A. PMT

Feature that creates presentation by answering questions:

A. Template

B. Design Ideas

C. AutoContent Wizard

D. SmartArt

Correct answer is: C. AutoContent Wizard

Mail Merge in Word allows you to:

A. Send email

B. Combine document with data source

C. Merge two documents

D. Attach file to email

Correct answer is: B. Combine document with data source

Which function finds current date?

A. TIME

B. DATE

C. TODAY()

D. NOW()

Correct answer is: C. TODAY()

GIGO stands for:

A. Great Input Great Output

B. Garbage In Garbage Out

C. Gigabyte Input Gigabyte Output

D. General Input Output

Correct answer is: B. Garbage In Garbage Out

Function to look up value in first column of a table:

A. HLOOKUP

B. LOOKUP

C. VLOOKUP

D. FIND

Correct answer is: C. VLOOKUP

Which is NOT a printer type?

A. Laser Printer

B. Inkjet Printer

C. Plotter

D. Scanner

Correct answer is: D. Scanner

Number of columns in Excel 2007+:

A. 256

B. 65,536

C. 16,384

D. 1,048,576

Correct answer is: C. 16,384

Shortcut to select entire document or worksheet:

A. Ctrl + A

B. Ctrl + S

C. Ctrl + E

D. Ctrl + W

Correct answer is: A. Ctrl + A

A computer architect is designing a new processor and wants to minimize the time taken to access frequently used instructions and data. Which memory hierarchy component should she focus on optimizing for the greatest impact on CPU performance?

A. Hard Disk Drive capacity

B. RAM clock speed

C. Cache memory hit rate

D. Virtual memory page file size

Correct answer is: C. Cache memory hit rate