Chapter Exam

Chapter 6: Editing and Formatting a Worksheet — Online MCQ Test

Q: Which of the following is NOT a cell formatting option?

Answer: C. Data sorting — Data sorting is a separate operation used to arrange data in ascending or descending order, not a cell formatting option. Font color, background color, and border styles are all formatting properties.

Q: You want to highlight all cells in a column where values are greater than 100. Which feature would you use?

Answer: A. Conditional formatting — Conditional formatting automatically highlights cells based on conditions like 'greater than 100', making it the appropriate tool for this task.

Q: If you have a list of student names and marks, and you want to see only students with marks above 75, what would you use?

Answer: A. Filtering — Filtering allows you to hide rows that don't meet your criteria (marks < 75), showing only the relevant data without permanently deleting it.

Q: A spreadsheet contains student data with names, ages, and grades. If you sort by age in ascending order and then by grade in descending order, what determines the final arrangement?

Answer: A. Students are first grouped by age (youngest to oldest), then within each age group, sorted by grade (highest to lowest) — Multi-level sorting applies the first sort criterion, then within each group of the first criterion, applies the second criterion for detailed organization.

Q: You apply conditional formatting to highlight cells with values above the average with green color. However, you notice the formatting is not appearing. What could be the reason?

Answer: A. The condition formula might be incorrect or the range selected doesn't contain the data to be formatted — Conditional formatting failures often result from incorrect formulas, wrong cell ranges, or the data not matching the specified condition.

Q: You are designing a data entry sheet for a company. The phone number column should accept only 10-digit numbers. Additionally, you want invalid entries to display a specific error message. Which feature combination would you use?

Answer: A. Data validation with a constraint rule and custom error message — Data validation can restrict input to 10-digit numbers and display custom error messages when invalid data is entered, making it ideal for controlled data entry.

Q: A spreadsheet contains monthly sales data for 12 months and 8 product lines. You want to create a visualization showing which products perform best in which months. You've narrowed it down to either a stacked column chart or a heat map. Which choice and why?

Answer: A. A heat map is better because it shows intensity patterns across both dimensions (months and products) more clearly than a stacked chart — Heat maps use color intensity to show patterns across two dimensions, making it easier to identify which product-month combinations have the highest/lowest performance compared to stacked charts.

INFORMATION TECHNOLOGY · Grade 6 · CBSE(NCERT)

Practice Chapter 6: Editing and Formatting a Worksheet with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 6 INFORMATION TECHNOLOGY. This chapter covers: Cell formatting Conditional formatting Sorting Filtering Charts Data validation Alignment Borders Worksheet management. AI-generated questions from basic to board-exam level, with instant results and explanations.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter 6: Editing and Formatting a Worksheet — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 6 INFORMATION TECHNOLOGY — Chapter 6: Editing and Formatting a Worksheet, with answers and explanations. These are sample questions; the exam has its own separate question set.

What is cell formatting in a worksheet?

A. The process of changing the appearance and structure of cells without altering data ✓
B. Creating new cells in a worksheet
C. Deleting unwanted data from cells
D. Moving cells from one location to another

Answer: A. The process of changing the appearance and structure of cells without altering data
Cell formatting refers to modifying the visual properties of cells like font, color, borders, and alignment while keeping the actual data unchanged.

Which of the following is NOT a cell formatting option?

A. Font color
B. Cell background color
C. Data sorting ✓
D. Border style

Answer: C. Data sorting
Data sorting is a separate operation used to arrange data in ascending or descending order, not a cell formatting option. Font color, background color, and border styles are all formatting properties.

What is conditional formatting used for?

A. To automatically apply formatting based on cell values or conditions ✓
B. To delete cells that don't meet conditions
C. To merge multiple cells together
D. To copy formatting from one cell to another

Answer: A. To automatically apply formatting based on cell values or conditions
Conditional formatting automatically applies formatting rules (like colors or highlighting) to cells that meet specified criteria or conditions.

What does the Sort function do in a worksheet?

A. Arranges data in a specified order (ascending or descending) ✓
B. Combines multiple cells into one
C. Changes the font style of data
D. Removes duplicate values from cells

Answer: A. Arranges data in a specified order (ascending or descending)
Sorting organizes data in a specific order, either alphabetically, numerically, or chronologically in ascending or descending sequence.

You want to highlight all cells in a column where values are greater than 100. Which feature would you use?

A. Conditional formatting ✓
B. Sorting
C. Filtering
D. Cell alignment

Answer: A. Conditional formatting
Conditional formatting automatically highlights cells based on conditions like 'greater than 100', making it the appropriate tool for this task.

If you have a list of student names and marks, and you want to see only students with marks above 75, what would you use?

A. Filtering ✓
B. Sorting
C. Conditional formatting
D. Data validation

Answer: A. Filtering
Filtering allows you to hide rows that don't meet your criteria (marks < 75), showing only the relevant data without permanently deleting it.

A spreadsheet contains student data with names, ages, and grades. If you sort by age in ascending order and then by grade in descending order, what determines the final arrangement?

A. Students are first grouped by age (youngest to oldest), then within each age group, sorted by grade (highest to lowest) ✓
B. Only the grade sorting applies; age sorting is ignored
C. Data is randomly arranged
D. Only the age sorting applies; grade sorting is ignored

Answer: A. Students are first grouped by age (youngest to oldest), then within each age group, sorted by grade (highest to lowest)
Multi-level sorting applies the first sort criterion, then within each group of the first criterion, applies the second criterion for detailed organization.

You apply conditional formatting to highlight cells with values above the average with green color. However, you notice the formatting is not appearing. What could be the reason?

A. The condition formula might be incorrect or the range selected doesn't contain the data to be formatted ✓
B. Conditional formatting doesn't work with above-average conditions
C. Green color is not available in conditional formatting
D. The worksheet is protected and doesn't allow formatting

Answer: A. The condition formula might be incorrect or the range selected doesn't contain the data to be formatted
Conditional formatting failures often result from incorrect formulas, wrong cell ranges, or the data not matching the specified condition.

You are designing a data entry sheet for a company. The phone number column should accept only 10-digit numbers. Additionally, you want invalid entries to display a specific error message. Which feature combination would you use?

A. Data validation with a constraint rule and custom error message ✓
B. Conditional formatting with color highlighting
C. Sorting by phone number length
D. Filtering to hide invalid entries

Answer: A. Data validation with a constraint rule and custom error message
Data validation can restrict input to 10-digit numbers and display custom error messages when invalid data is entered, making it ideal for controlled data entry.

A spreadsheet contains monthly sales data for 12 months and 8 product lines. You want to create a visualization showing which products perform best in which months. You've narrowed it down to either a stacked column chart or a heat map. Which choice and why?

A. A heat map is better because it shows intensity patterns across both dimensions (months and products) more clearly than a stacked chart ✓
B. A stacked column chart is better because it always shows more detail
C. Both are equally good with no difference
D. Neither can display this data type

Answer: A. A heat map is better because it shows intensity patterns across both dimensions (months and products) more clearly than a stacked chart
Heat maps use color intensity to show patterns across two dimensions, making it easier to identify which product-month combinations have the highest/lowest performance compared to stacked charts.

← Previous Chapter

Chapter 5: Introduction to MS Excel

Next Chapter →

Chapter 7: Introduction to Adobe Flash Scratch