Microsoft Excel Basic and Advance Questions and Answers 2

Question 1

Which Excel feature allows you to apply consistent formatting across multiple cells based on their values?

Accepted Answer

Conditional Formatting

Answer

Conditional Formatting automatically applies formatting rules based on cell values, such as highlighting cells above a certain threshold.

Question 2

What is the maximum number of rows in an Excel worksheet (Excel 2007 and later)?

Accepted Answer

1,048,576

Answer

Starting with Excel 2007, worksheets support up to 1,048,576 rows (2^20), a significant increase from the 65,536 row limit in earlier versions.

Question 3

Which keyboard shortcut opens the Find and Replace dialog in Excel?

Accepted Answer

Ctrl+H

Answer

Ctrl+H opens the Find and Replace dialog directly on the Replace tab, while Ctrl+F opens it on the Find tab.

Question 4

What does the $ symbol do when used in a cell reference like $A$1?

Accepted Answer

Makes the reference absolute so it does not change when copied

Answer

The $ symbol creates an absolute reference, preventing the column and/or row from adjusting when the formula is copied to other cells.

Question 5

Which Excel tool allows you to see the impact of changing input values on formula results?

Accepted Answer

What-If Analysis (Data Tables)

Answer

What-If Analysis with Data Tables lets you substitute different input values into formulas to see how results change, making it ideal for sensitivity analysis.

Excel Practice Test

Excel Practice Test

Microsoft Excel Basic and Advance Questions and Answers 2