Smart Learning

Tuesday, June 16, 2026

MS Excel-2021 Advance Featurers-Class-7-Ch-3(2026-27):

Educator CBSE SOLUTIONS-2026-27 ,

CBSE SOLUTIONS-2026-27

CLASS-7

CHAPTER-3 MS Excel 2021: Advance Features

A. Use your pencil and fill the correct circles:

1. Categories are organized along the horizontal axis and values along the vertical axis in a:

(A) Column chart (B) Pie chart (C) Line chart (D) Doughnut chart

Answer: (A) Column chart

2. Each section on a ring displays the contribution of an individual item to the total of all items in a particular series in:

(A) Bar charts (B) Pie charts (C) Doughnut charts (D) Scatter charts

Answer: (C) Doughnut charts

3. The bars, slices or other elements that represent the data:

(A) Data series (B) Plot area (C) Gridlines (D) Data tables

Answer: (A) Data series

4. You use it to restrict cell entries within a specified range:

(A) Filter feature (B) Values option (C) Sorting data option (D) Data validation

Answer: (D) Data validation

B. Write TRUE or FALSE:

1. Data validation is used to restrict the cell entries within a specified range.

Answer: TRUE

2. In doughnut chart, data series is represented by individual rings.

Answer: TRUE

3. Data can be sorted in rows on the basis of text and numbers or dates.

Answer: TRUE

4. A hierarchy chart plots data in concentric circles with each axis representing a different variable extending outward from a central point.

Answer: FALSE

5. Conditional Formatting is a feature in MS Excel that lets you apply formatting.

Answer: TRUE

ICT SKILLS-II-CLASS-10-U-3(2026-27):

Educator CBSE SOLUTIONS-2026-27 ,

CBSE-SOLUTIONS

CLASS-10

PART-A

UNIT-III ICT SKILLS-II

A. Multiple Choice Questions

1. A ________ operating system is a computing environment that reacts to input within a specific period of time.

(a) Single User (b) Multi-User (c) Real Time (d) Distribute

Answer: (c) Real Time

2. Identify the measure to protect computer from threats and viruses.

(a) Sharing password with friends (b) Allow anyone to use your device

Answer: (c) Use Antivirus

3. The cleaning of software installed in the computer cannot be achieved by ________.

(a) Disk cleanup (b) Backup (c) Cleaning CPU cabinet (d) Installing antivirus software

Answer: (a) Disk cleanup

4. Which one of the following shortcut keys is used to paste a file?

(a) Ctrl + C (b) Ctrl + P (c) Ctrl + V (d) Ctrl + X

Answer: (c) Ctrl + V

5. How can an antivirus protect your device?

(a) It can protect it from over-heating. (b) It can increase its performance.

Answer: (c) It can prevent data from getting corrupt.

6. Which option is not required to keep a device cool?

(a) Keep the device unplugged when in use. (b) Do not cover the laptop with a blanket.

Answer: (a) Keep the device unplugged when in use.

7. Which of the following is essential for maintaining keyboard?

(a) Turn the keyboard upside down and shake it to remove.

(b) Blow dust and other particles with the help of a blower.

(c) Use a very diluted combination of soap and water applied with a non-abrasive cloth to remove stains from the keycaps.

(d) All of the above

Answer: (d) All of the above

What is MS Excel-Formula and Functions?-Class-7-Ch-2(2026-27):

Educator CBSE SOLUTIONS-2026-27 ,

CBSE SOLUTIONS-2026-27

CLASS-7

CHAPTER-2 MS Excel-Formula and Functions

A. Use your pencil and fill the correct circles:

1. When you copy or move the formula to other cells, the reference cell automatically gets changed known as:

(A) Absolute reference

(B) Relative reference

(D) None of these

Answer: (B) Relative reference

2. In order to work correctly, a function must be written in a specific way, called the:

(A) Arguments

(B) Equal to

(D) Syntax

Answer: (D) Syntax

3. The AutoSum option is present in the ________ group on the Home tab.

(A) Insert

(B) Editing

(D) None of these

Answer: (B) Editing

4. An error that occurs when the number is divided by 0 is:

(A) #VALUE

(B) #NAME?

(D) #DIV/0!

Answer: (D) #DIV/0!

5. This function finds the largest number in a range:

(A) Average

(B) Count

(D) Min

Answer: (C) Max

B. Write TRUE or FALSE:

1. An Excel formula always begins with an equal to (=) sign.

Answer: TRUE

2. The #VALUE! Error occurs if the formula is used incorrectly.

Answer: TRUE

3. The commonly used functions in MS Excel include Sum, Product, Average, Max, Min and Count.

Answer: TRUE

4. There are six types of cell references in MS Excel 2021.

Answer: FALSE

5. The Paste option is found in the Clipboard group on the Home tab.

Answer: TRUE

C. Fill in the blanks with the words given below:

1. While filling cells, sometimes it is not necessary to ________ a cell reference.

Answer: change

2. Absolute references use a dollar sign ($) to look a specific ________ or part of a cell reference.

Answer: cell

3. In the ________, the first cell address does not include a dollar sign.

Answer: formula

4. In ________ reference, either the row or column remains fixed.

Answer: mixed

5. Most ________ programs allow you to reference cells from different worksheets.

Answer: spreadsheet

WHAT IS NETWORKING?-CLASS-8-CH-2(2026-27):

Educator CBSE SOLUTIONS-2026-27 ,

CBSE SOLUTIONS-2026-27

CLASS-8

CHAPTER-2 NETWORKING: DIGITAL BRIDGES

A. Multiple Choice Questions

1. This device helps your computer to connect to the internet:

(A) Wi-Fi (B) LAN (C) MAN (D) Modem

Answer: (D) Modem

2. This device connects computers in a network:

(A) Modem (B) Switch (C) Both A & B (D) None of these

Answer: (B) Switch

3. It carries pieces of the message, like a puzzle:

(A) Switch (B) Hub (C) Packet (D) Modem

Answer: (C) Packet

4. This uses a wireless antenna that increases the communication range of the radio signal:

(A) Router (B) Switch (C) Both A & B (D) None of these

Answer: (A) Router

5. An overall design of a computer network is called:

(A) WAN (B) LAN (C) MAN (D) Network architecture

Answer: (D) Network architecture

B. Write TRUE or FALSE

1. A MAN is a network that covers larger area than a LAN.

Answer: TRUE

2. A PAN is a global computer network that spreads across cities, countries or continents.

Answer: FALSE

3. A WAN typically connects devices such as printers, phones, PDAs and laptops.

Answer: FALSE

4. The architecture of a network can be defined as the structure and organization of the company’s hardware and software.

Answer: TRUE

5. Twisted pair cables were invented by Alexander Graham Bell in 1881.

Answer: TRUE

WHAT IS SELF MANAGEMENT SKILL?-CLASS-9-U-II-CH-1(2026-27):

Educator CBSE SOLUTIONS-2026-27 ,

CBSE-SOLUTIONS

CLASS-9

PART-A

UNIT-II SELF MANAGEMENT SKILL-I

A. Multiple Choice Questions

1. Which of the following is not a self-management skill?

(a) Problem solving

(b) Bargaining

(d) Confidence building

Answer: (b) Bargaining

2. Grooming refers to:

(a) time management

(b) problem solving

(d) self-management

Answer: (c) neat and clean appearance

3. Building self-confidence includes:

(a) Set goals in life.

(b) Always think positively.

(d) All of the above.

Answer: (d) All of the above.

4. Which of the following is a positive attitude?

(a) Ignoring the feedback

(b) Accepting the feedback but not using it

(d) Learning from feedback and improving it

Answer: (d) Learning from feedback and improving it

5. Dressing and grooming are important because they help us to look ______

(a) smart

(b) untidy

(d) all of the above

Answer: (a) smart

Smart Learning

Tuesday, June 16, 2026

MS Excel-2021 Advance Featurers-Class-7-Ch-3(2026-27):

Sunday, May 17, 2026

ICT SKILLS-II-CLASS-10-U-3(2026-27):

Thursday, April 30, 2026

What is MS Excel-Formula and Functions?-Class-7-Ch-2(2026-27):

Wednesday, April 29, 2026

WHAT IS NETWORKING?-CLASS-8-CH-2(2026-27):

WHAT IS SELF MANAGEMENT SKILL?-CLASS-9-U-II-CH-1(2026-27):

Followers

Search blog

Categories

Blog Archive

Recent Post

Tags

Popular Posts