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

Format Painter

Answer

Cell Styles

Answer

Data Validation

Question 2

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

Accepted Answer

1,048,576

Answer

65,536

Answer

16,384

Answer

256

Question 3

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

Accepted Answer

Ctrl+H

Answer

Ctrl+F

Answer

Ctrl+G

Answer

Ctrl+R

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

Converts the value to currency format

Answer

Locks the cell from editing

Answer

References a cell on another sheet

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

Solver

Answer

Formula Auditing

Answer

Scenario Manager

Question 6

What happens when you press Ctrl+Shift+L in Excel?

Accepted Answer

Toggles AutoFilter on the selected data range

Answer

Applies a hyperlink to the cell

Answer

Locks the selected cells

Answer

Opens the Format Cells dialog