CHAPTER 3 ANALYSE DATA IN EXCEL 2016

-

Q1. Fill in the blanks with the help of the given words.

1.............. is the rearragement of data in either ascending or descending order.

ans- SORTING

2. .......................in Microsoft Excel helps to retrieve data to edit, analyse, format or print it.

ans- FILTER

3. Auto Filter is used to filter a column or row to view the data based on a ...........condition.

ANS SPECIFIED

4. To apply conditional formatting, i will click on.................group under Home tab.

ANS Style

5. Sort A to Z option will sort data in......................order

ANS Asceding 


B. Tick the correct answer.

1. Which option will you choose to sort data in descending order?

ANS-  Sort Z to A

2. Which of these is not a type of filter in Microsoft Excel?

Ans- Conditional

3. Which of the following key combinations will you press to filter the data?

ANS  Ctrl+Shift +L

4. Which button will you click to remove all the conditional formatting from a cell?

ANS- Clear rules 

5. On the Home tab, in the editing group, click sort & filter drop-down menu to quickly sort a list based on 

ANS- One Column


ANSWER THE FOLLOWING QUESTIONS

1. What do you understand by sorting a range of cells?

ANS-  Sorting a range of cells means rearranging the data within that selected group of cells in a specific order, such as ascending or descending, based on the values in one or more columns or rows

2. Name the two types of sorting. Explain with an example.

ANS2  In Microsoft Excel, sorting is the process of arranging data in a specific order to make it easier to analyze or present. There are several types of sorting available in Excel:

The SORT function is a search and reference function in MS Excel that enables sorting the contents of a range of matrices based on four arguments: Alphabetical: Sort your texts alphabetically, from A to Z or Z to A. Numeric: Sorts data in ascending order (smallest to largest) or descending order (largest to smallest)

example-  amit sanjay rohit mohit govind

A to Z- amit govind mohit rohit sanjay 

Z to A- amit govind mohit rohit sanjay 

salary- 25000 20000 18000 15000 12000 16000

increasing order- 12000 15000 16000 18000  20000 25000   

Decreasing order-  25000 20000 18000 16000 15000 12000    

Excel's custom sorting feature allows users to sort data based on predefined lists or specific criteria. 

Q3. What is filtering of data?

Ans3. In Microsoft Excel, filtering data is the process of displaying only the rows that meet specific criteria, while hiding the rest. This allows users to focus on a subset of data without deleting or rearranging it. Filter helps to retrieve data to edit, analyse, format or print. Filter enable to compare data in many ways. 

Q4. What is the difference between sorting and filtering?

ANS4. Sorting and filtering are both data manipulation techniques, but they serve different purposes. Sorting arranges data in a specific order (ascending or descending) based on one or more criteria. Filtering, on the other hand, displays only the data that meets certain criteria, hiding the rest

Q5. Explain the concept of formatting cells based on a condition with the help of an example.

Answer- Conditional formatting is a feature in spreadsheets, that automatically applies formatting (like colors, fonts, border) to cells or text based on predefined rules or conditions

For example - Highlight the marks of the students who got marks greater than 80 with green colored text.





Comments

Post a Comment

Popular posts from this blog

CLASS 8 DATA TYPES IN PYTHON

-
  DATA TYPES IN PYTHON A. Tick the correct option 1.   Which of the following is not a valid variable name? ANS1. a. Print 2.   Which of the following is not a string?   ANS2. a. 89 3.   How many types of number data type are there in Python? ANS C. 4 4.   Which of the following is a data type? ANS A. TUPLE 5.   Which of the following will you use to access a value stored in a dictionary? ANS C. [ ] B. Fill in the blanks 1.   A multiline string spreads across multiple lines. 2.   Data type is used to represent data in the memory of the computer. 3.   A tuple can consist of different types of values. 4.     A conditional statement can also be called a decision making statement. 5.     The IF conditional statement has code for the condition being true only. C  Write the output of the following code snippets. 1. >>> number_of_pages=200 >>>print( number_of_pag...
Read more

CHAPTER 4 RAISING QUERIES CLASS 8 COMPUTER

-
CLASS 8 CHAPTER 4 RAISING QUERIES A. Fill in the blanks with the help of the given words. 1. Connecting tables in a database is the concept of relational database. 2. A foreign key is the primary key of another table which creates a link between two tables based on a common column. 3. If you modify the primary key value, Cascade update related fields  allows you to update all the related foreign key values. 4. A query   allows you to pull information from one or more tables based on a set of defined search conditions. 5. The query design view allows you to customise the query.     B. Tick the correct answer. 1. Which of the following options allows you to delete the related records from the foreign key table, if you delete records from the primary key table? ANS B. Cascade delete related records 2. Which option in Edit Relationships dialog box prevents you from entering a value in the foreign key field? ANS B. Enforce referential integrity 3. Press.......... to...
Read more

HTML 1 TEST ONLINE 20 MAY 2025

-
Image
                   QUESTION 3. Which HTML Tag is used to underline the text?                                 a. <U>   b. <I>    c. <TT>   d. <B>                               QUESTION 4. HTML Tags are written in                                 a. Capital letters                                b. Small letters                                c. Both Capital and Small letters                                d. No...
Read more