DIT Final Exam Review 1

Front

Which function returns the highest number in a range? Options: MAX, COUNT, AVERAGE, MIN

Back

MAX

Answer explanation

MAX finds the largest number in a selected range.

Front

What does a pivot table do in Excel?

Back

Summarizes large data sets

Answer explanation

Pivot tables are used to quickly summarize data.

Front

How can you quickly duplicate a worksheet? Options: Formulas > Copy, Insert > Table, Right-click tab > Move or Copy, File > Save As

Back

Right-click tab > Move or Copy

Answer explanation

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

Front

What does the Merge & Center button do?

Back

Combines and centers selected cells

Answer explanation

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

Front

Which symbol is used for multiplication in formulas?

Back

*

Answer explanation

The asterisk (*) symbol represents multiplication.

Front

What does a hanging indent do?

Back

Indents all lines except the first.

Answer explanation

Hanging indents are often used in bibliographies.

Front

Which file format is used to save Word documents? Options: .xlsx, .pdf, .pptx, .docx

Back

.docx

Answer explanation

.docx is the default Word file format.

Front

How can you add a comment in Word? Options: Layout tab > Breaks, Home tab > Font, Insert tab > Footer, Review tab > New Comment

Back

Review tab > New Comment

Answer explanation

You can insert comments from the Review tab.

Front

What does the Thesaurus feature do?

Back

Suggests synonyms

Answer explanation

The Thesaurus helps improve vocabulary.

Front

Which button removes recent formatting in Word? Options: Header, Undo, Spell Check, Clear All Formatting

Back

Clear All Formatting

Answer explanation

Clear All Formatting resets text appearance.