Quiz for Lesson 12

Excel Worksheets – Checking the Integrity of your Worksheets

1. What feature in Excel shows quick calculations like Total, Average, and Count when a cell range is selected?

A) Formula Bar

B) Name Box

C) Status Bar

2. Which Excel tool can help you trace which cells are used in a formula?

A) Data Validation

B) Trace Precedents

C) Format Painter

3. What is a quick way to identify duplicate rows in Excel?

A) Using AutoSum

B) Applying Conditional Formatting

C) Merging Cells

Your score is