Ict MCQs

MAX examines the supplied values and returns the greatest one.
MIN returns the smallest, while COUNT and CONCAT perform different operations.

MIN returns the smallest numeric value in the selected range.
It directly answers the need to identify the lowest score.

COUNT reports how many cells in a range contain numeric values.
It does not total the values or manipulate text and dates in the same way as the alternatives.

IF tests a condition and returns one result when true and another when false.
It is suited to two-outcome logical decisions such as pass or fail.

COUNTIF applies a criterion and counts matching cells.
It is more selective than COUNT, which counts numeric cells without the same condition logic.

Word Count measures words and often characters, paragraphs, or pages.
It is useful when an assignment or publication has a length requirement.

Alt text communicates the image’s meaning to screen-reader users.
It improves accessibility when visual information is necessary to understand the document.

PDF generally maintains page appearance independently of the viewer’s word-processing setup.
It is useful for distribution, although accessibility and final accuracy still require checking.

Document comparison identifies changes between versions of similar files.
It is more systematic than visually scanning two long documents line by line.

Print Preview shows how pages are expected to appear on paper.
It helps detect layout problems before ink, paper, and time are used.

Excel stores data in tabular form and provides formulas, analysis, and visualization tools.
It is designed for structured data work rather than only narrative writing.

Spreadsheet cell references normally combine the column letter with the row number.
Therefore column C and row 7 intersect at cell C7.