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

Number of rows in Excel 2007+:

A. 65,536

B. 1,048,576

C. 16,384

D. 99,999

Correct answer is: B. 1,048,576

Which of the following is a valid mixed cell reference?

A. $A$1

B. A1

C. $A1

D. All of the above

Correct answer is: D. All of the above

Feature that fills cells automatically based on pattern:

A. AutoComplete

B. AutoFill

C. AutoCorrect

D. Flash Fill

Correct answer is: B. AutoFill

Shortcut to apply/remove strikethrough:

A. Ctrl + 5

B. Ctrl + 4

C. Ctrl + 2

D. Ctrl + 1

Correct answer is: A. Ctrl + 5

A chart on a separate sheet is called:

A. Embedded Chart

B. Chart Sheet

C. Graph Sheet

D. Pivot Chart

Correct answer is: B. Chart Sheet

Function returning number of characters in text:

A. COUNT

B. LEN

C. MID

D. CHAR

Correct answer is: B. LEN

Which of the following is System Software?

A. MS Word

B. MS Excel

C. Windows 11

D. PowerPoint

Correct answer is: C. Windows 11

Purpose of BIOS stored in ROM:

A. Perform calculations

B. Manage internet connections

C. Run POST and boot computer

D. Store user files

Correct answer is: C. Run POST and boot computer

Ctrl + P is used to:

A. Open new file

B. Save file

C. Print file

D. Paste text

Correct answer is: C. Print file

Which memory is directly accessed by CPU?

A. Secondary Memory (HDD)

B. Primary Memory (RAM)

C. Cache Memory

D. Virtual Memory

Correct answer is: B. Primary Memory (RAM)