DL DL Productivity Software 2 — Questions and Answers
Question 1: In Microsoft Excel, a cell reference like '$A$1' is called what type of reference?
- Relative reference
- Mixed reference
- Absolute reference (Correct answer)
- Dynamic reference
Correct answer: Absolute reference
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?
- Track Changes
- Show/Hide ¶ (Correct answer)
- Find & Replace
- Page Layout
Correct answer: Show/Hide ¶
The Show/Hide ¶ toggle reveals non-printing characters like spaces, tabs, and paragraph marks.
Question 3: What is a 'template' in productivity software?
- A backup copy of a file
- A pre-designed document layout used as a starting point (Correct answer)
- A type of chart
- A file compression tool
Correct answer: A pre-designed document layout used as a starting point
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?
- Slide Show view
- Normal view (Correct answer)
- Outline view
- Reading view
Correct answer: Normal view
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?
- Combine multiple Word files into one PDF
- Send emails directly from Word
- Create personalized letters using a data source (Correct answer)
- Merge two formatting styles
Correct answer: Create personalized letters using a data source
Mail merge pulls data (like names and addresses) from a spreadsheet or database to automatically personalize multiple copies of a document.
Question 6: Which Excel feature allows you to quickly summarize and analyze large datasets by dragging fields into rows, columns, and values?
- VLOOKUP
- Conditional Formatting
- PivotTable (Correct answer)
- Data Validation
Correct answer: PivotTable
A PivotTable lets you dynamically reorganize and summarize large sets of data without writing formulas.
DL DL Productivity Software 2
In Microsoft Excel, a cell reference like '$A$1' is called what type of reference?