MS Excel — Set 6

Correct Answer: B. Both absolute and relative parts

In Excel, a Mixed Reference contains Both absolute and relative parts within a single cell reference. For example, $A1 locks the column (absolute) while letting the row change (relative), and A$1 locks the row while letting the column change. Mixed references are very useful when creating tables where either rows or columns need to remain fixed while copying formulas.

Correct Answer: C. AVERAGE

The AVERAGE function adds all the numbers in a range and divides by the count of those numbers. It automatically ignores blank cells but can be affected by cells containing zero. It is one of the most frequently used statistical functions.

Correct Answer: C. Left

By default, text labels align to the left side of the cell. Numbers, on the other hand, are automatically aligned to the right. This visual distinction helps users identify data types at a glance.

Correct Answer: B. Wrap Text

Wrap Text increases the row height to fit long text strings into the cell's current width. This prevents text from overflowing into empty adjacent cells. It is essential for managing descriptive columns in a report.

Correct Answer: B. 16,384

Excel sheets contain 16,384 columns, ending with the label XFD. This large capacity allows for storing extensive horizontal data. Row counts are much higher, at over one million per sheet.

Correct Answer: A. DAYS

The DAYS function takes an end date and a start date to return the numeric difference in days. Alternatively, simply subtracting one cell from another (Date2 - Date1) gives the same result. This is useful for tracking project timelines.

Correct Answer: B. Miniature charts within a single cell

Sparklines provide a visual representation of data trends right next to the data itself. They take up only one cell and don't have axes or labels. They are effective for showing historical performance at a glance.

Correct Answer: B. UPPER

The UPPER function converts all letters in a text string to capital letters. PROPER function converts only the first letter of each word to uppercase. LOWER function does the opposite by making all letters small.

Correct Answer: B. ^

The caret symbol (^) is used for powers, such as 2^3 which equals 8. Excel also has a built-in POWER function that performs the same calculation. This is commonly used in financial and scientific formulas.

Correct Answer: A. Page Layout View

Page Layout View allows you to see rulers and adjust headers/footers directly on the sheet. It gives a realistic preview of the final document. Normal View is standard for data entry and editing.