IC3 GS6 Digital Literacy Level 2 Certification Exam
Actual 2024/2025 with Detailed Rationales | 100%
Verified | Pass Guaranteed – A+ Graded
SECTION 1: KEY APPLICATIONS (Word Processing, Spreadsheets,
Presentations) (15 Questions)
Q1: In Microsoft Word, which feature allows a user to create a personalized letter
that is automatically merged with a list of recipient names and addresses from an
Excel spreadsheet?
A. Track Changes
B. Mail Merge
C. Find and Replace
D. Styles
Correct Answer: B
Rationale: Mail Merge combines a main document with a data source to generate
personalized letters, labels, or envelopes for multiple recipients automatically.
Q2: A user needs to calculate the average of values in cells A1 through A10 in
Microsoft Excel. Which formula is correct?
A. =SUM(A1:A10)
B. =AVERAGE(A1:A10)
,C. =MEAN(A1:A10)
D. =TOTAL(A1:A10)
Correct Answer: B
Rationale: The AVERAGE function calculates the arithmetic mean of a range of cells,
returning the sum of values divided by the count of values.
Q3: In Microsoft PowerPoint, which feature controls the visual movement between
slides during a slideshow?
A. Animation
B. Transition
C. Slide Sorter
D. Master Slide
Correct Answer: B
Rationale: Transitions control the visual effects applied when moving from one slide
to the next, while animations control movement of individual objects within a slide.
Q4: A user wants to apply consistent formatting—font, color, and paragraph
spacing—to all headings in a Word document. Which feature is most efficient?
A. Manually formatting each heading individually
B. Using a Heading style and modifying the style definition
C. Using Find and Replace to change fonts
D. Copying and pasting formatting with Format Painter for each heading
Correct Answer: B
, Rationale: Modifying a Heading style definition applies consistent formatting to all
headings using that style throughout the document, ensuring uniformity and
enabling automatic table of contents generation.
Q5: In Excel, which function counts the number of cells in a range that contain
numeric values?
A. COUNTA
B. COUNT
C. COUNTIF
D. COUNTBLANK
Correct Answer: B
Rationale: The COUNT function counts only cells containing numeric values in a
range; COUNTA counts all non-empty cells, COUNTIF counts based on criteria, and
COUNTBLANK counts empty cells.
Q6: A user needs to create a chart in Excel that compares sales figures across four
quarters for three product lines. Which chart type is most appropriate?
A. Pie chart
B. Line chart
C. Clustered column chart
D. Scatter plot
Correct Answer: C
Actual 2024/2025 with Detailed Rationales | 100%
Verified | Pass Guaranteed – A+ Graded
SECTION 1: KEY APPLICATIONS (Word Processing, Spreadsheets,
Presentations) (15 Questions)
Q1: In Microsoft Word, which feature allows a user to create a personalized letter
that is automatically merged with a list of recipient names and addresses from an
Excel spreadsheet?
A. Track Changes
B. Mail Merge
C. Find and Replace
D. Styles
Correct Answer: B
Rationale: Mail Merge combines a main document with a data source to generate
personalized letters, labels, or envelopes for multiple recipients automatically.
Q2: A user needs to calculate the average of values in cells A1 through A10 in
Microsoft Excel. Which formula is correct?
A. =SUM(A1:A10)
B. =AVERAGE(A1:A10)
,C. =MEAN(A1:A10)
D. =TOTAL(A1:A10)
Correct Answer: B
Rationale: The AVERAGE function calculates the arithmetic mean of a range of cells,
returning the sum of values divided by the count of values.
Q3: In Microsoft PowerPoint, which feature controls the visual movement between
slides during a slideshow?
A. Animation
B. Transition
C. Slide Sorter
D. Master Slide
Correct Answer: B
Rationale: Transitions control the visual effects applied when moving from one slide
to the next, while animations control movement of individual objects within a slide.
Q4: A user wants to apply consistent formatting—font, color, and paragraph
spacing—to all headings in a Word document. Which feature is most efficient?
A. Manually formatting each heading individually
B. Using a Heading style and modifying the style definition
C. Using Find and Replace to change fonts
D. Copying and pasting formatting with Format Painter for each heading
Correct Answer: B
, Rationale: Modifying a Heading style definition applies consistent formatting to all
headings using that style throughout the document, ensuring uniformity and
enabling automatic table of contents generation.
Q5: In Excel, which function counts the number of cells in a range that contain
numeric values?
A. COUNTA
B. COUNT
C. COUNTIF
D. COUNTBLANK
Correct Answer: B
Rationale: The COUNT function counts only cells containing numeric values in a
range; COUNTA counts all non-empty cells, COUNTIF counts based on criteria, and
COUNTBLANK counts empty cells.
Q6: A user needs to create a chart in Excel that compares sales figures across four
quarters for three product lines. Which chart type is most appropriate?
A. Pie chart
B. Line chart
C. Clustered column chart
D. Scatter plot
Correct Answer: C
