Chapter 4 Quizz - Sec 3&4

Section I: Understanding Excel List Structure

1. 1 - Which of the following best describes a list in Excel?

• A) A series of charts

• B) A structured dataset with multiple records
  

• C) A formula collection
  

• C) A random group of numbers

2 - What are "labels" in an Excel list?

• A) Notes beside the chart

• B) Formula cells

• C) Column headers like “Name,” “Age”

• D) Font styles

3 - Which of the following is NOT a best practice when structuring an Excel list?

• A) Use consistent data formats

• B) Start with a clear header row

• C) Use merged cells for better layout

• D) Avoid blank rows

4 - Why is a good Excel list structure important?

• A) It helps with creating borders

• B) It improves font readability
  

• C) It ensures efficient sorting and filtering
  

• D) It changes the theme automatically

5 - Which of the following is an example of poor list structure?

• A) Column headers in the first row

• B) Each column representing a single data type

• 
  C) Merged cells in the dataset
  

• D) Numeric values stored as numbers

Section II: Sorting in Excel

6 - What does sorting in Excel allow you to do?

• A) Highlight duplicates

• B) Convert text to numbers

• C) Organize data alphabetically or numerically
  

• D) Merge cells

7 - Which option is used to sort text in ascending order?

• A) Sort Z to A

• B) Sort Smallest to Largest

• C) Sort A to Z

• D) Filter

8 - How can you sort multiple columns in Excel?

• A) Use AutoFilter

• B) Select Sort > Add Level

• C) Use Format Painter

• D) Hide rows

9 - What does the ‘Sort On’ option allow you to do?

• A) Rename cells

• B) Hide data

• C) Choose between sorting by values, color, or icon

• D) Add borders

10 - To sort dates from newest to oldest, which order should be selected?

• A) A to Z

• B) Oldest to Newest

• C) Z to A

• D) Newest to Oldest