DIT Final Exam Review 1

Which function returns the highest number in a range?

• MAX
• COUNT
• AVERAGE
• MIN

Answer explanation

MAX finds the largest number in a selected range.

What does a pivot table do in Excel?

• Inserts images
• Adds animations
• Summarizes large data sets
• Sorts slides

Answer explanation

Pivot tables are used to quickly summarize data.

How can you quickly duplicate a worksheet?

• Formulas > Copy
• Insert > Table
• Right-click tab > Move or Copy
• File > Save As

Answer explanation

You can duplicate a worksheet by right-clicking the sheet tab.

What does the Merge & Center button do?

• Combines and centers selected cells
• Creates a chart
• Adds a border
• Sorts numbers

Answer explanation

Merge & Center is used to center titles over multiple cells.

Which symbol is used for multiplication in formulas?

• %
• x
• #
• *

Answer explanation

The asterisk (*) symbol represents multiplication.

What does a hanging indent do?

• Removes all spacing
• Indents all lines except the first
• Indents only the title
• Centers the paragraph

Answer explanation

Hanging indents are often used in bibliographies.

Which file format is used to save Word documents?

• .xlsx
• .pdf
• .pptx
• .docx

Answer explanation

.docx is the default Word file format.

How can you add a comment in Word?

• Layout tab > Breaks
• Home tab > Font
• Insert tab > Footer
• Review tab > New Comment

Answer explanation

You can insert comments from the Review tab.

What does the Thesaurus feature do?

• Counts words
• Adds images
• Inserts footnotes
• Suggests synonyms

Answer explanation

The Thesaurus helps improve vocabulary.

Which button removes formatting in Word?

• Header
• Undo
• Spell Check
• Clear All Formatting

Answer explanation

Clear All Formatting resets text appearance.