MCQ Collection
Ict MCQs
Practice Ict questions with answers and explanations.
Choose an option to check your answer.
A.
$A$1
B.
A1
C.
A$1:B2
D.
A:A without a row
Show Answer
Correct Answer: A. $A$1
Explanation:
Dollar signs before both the column and row create an absolute reference.
Choose an option to check your answer.
A.
It fixes both column and row
B.
It fixes column B but allows the row number to change
C.
It allows both column and row to change
D.
It refers to an entire workbook
Show Answer
Correct Answer: B. It fixes column B but allows the row number to change
Explanation:
A dollar sign before B locks the column, while the row has no dollar sign.
Choose an option to check your answer.
A.
To send an email attachment
B.
To begin a video conference
C.
To copy formulas or extend a recognized series into adjacent cells
D.
To create a hardware backup
Show Answer
Correct Answer: C. To copy formulas or extend a recognized series into adjacent cells
Explanation:
Dragging the fill handle can repeat formulas and continue patterns such as dates or numbers.
Choose an option to check your answer.
A.
Freeze Panes
B.
Spell Check
C.
Slide Master
D.
Sort descending
Show Answer
Correct Answer: D. Sort descending
Explanation:
Descending sorting arranges numeric values from largest to smallest.
Choose an option to check your answer.
A.
Filter
B.
Merge Cells
C.
Page Break
D.
Mail Merge
Show Answer
Correct Answer: A. Filter
Explanation:
Filtering temporarily hides rows that do not meet selected criteria.
Choose an option to check your answer.
A.
Scatter plot with no paired numeric variables
B.
Column chart
C.
Stock chart for text labels only
D.
Radar chart for one isolated value
Show Answer
Correct Answer: B. Column chart
Explanation:
A column chart clearly compares the magnitude of values across discrete categories.
Choose an option to check your answer.
A.
WordArt
B.
Header and Footer
C.
PivotTable
D.
Format Painter only
Show Answer
Correct Answer: C. PivotTable
Explanation:
A PivotTable summarizes large tabular data by selected categories and measures.
Choose an option to check your answer.
A.
Page Orientation
B.
Track Changes in Word
C.
Presenter View
D.
Conditional Formatting
Show Answer
Correct Answer: D. Conditional Formatting
Explanation:
Conditional Formatting applies visual styles when cell values meet defined rules.
Choose an option to check your answer.
A.
It always becomes $A$1
B.
It changes to B1
C.
It becomes plain text
D.
It normally changes to A2
Show Answer
Correct Answer: D. It normally changes to A2
Explanation:
A1 is a relative reference, so it adjusts according to the formula’s new position.
Choose an option to check your answer.
A.
With a question mark (?)
B.
With a postal address
C.
With a slide number
D.
With an equals sign (=)
Show Answer
Correct Answer: D. With an equals sign (=)
Explanation:
The equals sign tells Excel to evaluate the entry as a formula.
Choose an option to check your answer.
A.
=SUM(A1:A10)
B.
=AVERAGE(A1:A10)
C.
=COUNT(A1:A10)
D.
=MAX(A1:A10)
Show Answer
Correct Answer: A. =SUM(A1:A10)
Explanation:
SUM returns the total of the numeric values in the specified range.
Choose an option to check your answer.
A.
=SUM(B2:B8)
B.
=AVERAGE(B2:B8)
C.
=MIN(B2:B8)
D.
=COUNTIF(B2:B8)
Show Answer
Correct Answer: B. =AVERAGE(B2:B8)
Explanation:
AVERAGE adds the numeric values and divides by the number of included values.
