600 computer mcq pdf

Which of the following functions in MS Excel counts the number of cells within a range that meet the given condition?

A. COUNTIFB

B. COUNTA

C. COUNT

D. COUNTIF

Correct answer is: D. COUNTIF

COUNTIF counts cells in a range that meet a specified condition.

The intersection of a row and a column in a spreadsheet (e.g., MS Excel) is called a:

A. Box

B. Field

C. Cell

D. Sheet

Correct answer is: C. Cell

The intersection of a row and column in a spreadsheet is referred to as a cell.

Which keyboard shortcut is used to create a formula that sums all the cells above the active cell in Excel?

A. Alt + S

B. Ctrl + =

C. Alt + =

D. Shift + =

Correct answer is: C. Alt + =

Alt + = inserts a SUM formula for the cells above the active cell in Excel.

Gmail, Hotmail, and Yahoo are examples of:

A. Search engines

B. Web browsers

C. Email servers

D. None of these

Correct answer is: C. Email servers

Gmail, Hotmail, and Yahoo provide email services, functioning as email servers.

The Protect Document option can be found in the ____ tab of the Ribbon.

A. Review

B. Home

C. References

D. Edit

Correct answer is: A. Review

The Protect Document option is located in the Review tab in MS Word.

Shimmer, Sparkle text, Blinking Background etc. are known as:

A. WordArt

B. Font styles

C. Text effects

D. Badge

Correct answer is: C. Text effects

These are visual enhancements applied to text, known as text effects in software like PowerPoint.

The functions of Copy and Paste reside in which group on the Home tab in MS Word?

A. Home

B. Paragraph

C. Style

D. Clipboard

Correct answer is: D. Clipboard

Copy and Paste are located in the Clipboard group on the Home tab in MS Word.

What are cookies in a web browser used for?

A. Cleaning the browser cache

B. Displaying advertisements

C. Storing user data and preferences

D. Blocking pop-ups

Correct answer is: C. Storing user data and preferences

Cookies store user data like login details and preferences to enhance browsing.

If you want to apply the formatting of one page to another without copying the text, which tool should you use?

A. Copy-Paste

B. Format Painter

C. Format Text Box

D. Page Setup

Correct answer is: B. Format Painter

Format Painter copies formatting from one section to another without copying content.

The World Wide Web (WWW) is used for:

A. Sending e-mails

B. File printing

C. Accessing and sharing information over the internet

D. Operating system functions

Correct answer is: C. Accessing and sharing information over the internet

The WWW enables access and sharing of information via websites on the internet.

Computer MCQS