Excel Large Worksheets

What are assumptions in the context of spreadsheet modeling?

• Assumptions are the initial conditions set for a model.

• Assumptions are the final results of a model.

• Assumptions are irrelevant in spreadsheet modeling.

• Assumptions are only used in financial models.

The error #REF! in a spreadsheet indicates:

• A missing reference

• A division by zero

• An invalid name

• A circular reference

Explain the drag and drop feature in spreadsheet applications.

• A feature that allows users to move or copy data from one cell to another by clicking and dragging.

• A feature that automatically sorts data in a spreadsheet.

• A feature that creates a backup of the spreadsheet.

• A feature that formats cells based on their content.

Format symbols in spreadsheets are used for:

• Changing the font style

• Adjusting cell size

• Formatting numbers and dates

• Inserting images

The Office Clipboard is a feature in Microsoft Office applications. What is its primary function?

• To store multiple items that have been copied or cut

• To format text in documents

• To check spelling and grammar

• To create charts and graphs

Define relative cell reference in spreadsheets.

• A cell reference that changes when the formula is copied to another cell.

• A cell reference that remains constant, no matter where it is copied.

• A cell reference that refers to a specific range of cells.

• A cell reference that is used only in conditional formatting.

An absolute cell reference is a cell reference that remains constant even if the formula is copied or moved to another cell. How does it differ from a relative cell reference?

• An absolute cell reference changes when copied, while a relative cell reference remains constant.

• An absolute cell reference remains constant when copied, while a relative cell reference changes.

• Both absolute and relative cell references remain constant when copied.

• Both absolute and relative cell references change when copied.

The NOW function is used for what purpose in spreadsheets?

• To calculate the current date and time

• To sum a range of cells

• To find the maximum value in a range

• To sort data alphabetically

A volatile function in the context of spreadsheets is:

• A function that automatically recalculates every time a change is made in the spreadsheet.

• A function that remains constant regardless of changes in the spreadsheet.

• A function that only recalculates when manually triggered.

• A function that is used for data visualization.

A mixed cell reference in spreadsheets is:

• A reference that always refers to a specific cell, regardless of where it is moved or copied.

• A reference that changes when the formula is moved or copied to another cell.

• A reference that combines both absolute and relative references.

• A reference that only refers to cells in the same row.