DL DL Productivity Software 2

Question 1

In Microsoft Excel, a cell reference like '$A$1' is called what type of reference?

Accepted Answer

Absolute reference

Answer

An absolute reference uses dollar signs to lock both the column and row, so it does not change when a formula is copied.

Question 2

Which feature in Word allows you to see all formatting marks, such as spaces and paragraph breaks?

Accepted Answer

Show/Hide ¶

Answer

The Show/Hide ¶ toggle reveals non-printing characters like spaces, tabs, and paragraph marks.

Question 3

What is a 'template' in productivity software?

Accepted Answer

A pre-designed document layout used as a starting point

Answer

A template is a pre-formatted document structure that can be reused to create new documents with consistent styling.

Question 4

In PowerPoint, which view shows thumbnail images of all slides in a panel on the left?

Accepted Answer

Normal view

Answer

Normal view displays a slide thumbnail panel on the left alongside the main editing area and notes pane.

Question 5

What does 'mail merge' allow you to do in word processing software?

Accepted Answer

Create personalized letters using a data source

Answer

Mail merge pulls data (like names and addresses) from a spreadsheet or database to automatically personalize multiple copies of a document.

(DL) Digital Literacy Certification Practice Test