[go: up one dir, main page]
Scribd
Upload
30 views2 pages

Computer Chapter 2

Chapter 2 covers various Excel functions and commands, including the If() function for condition checking, sorting, and filtering data. It provides multiple-choice questions, fill-in-the-blank statements, and practical applications of these functions. Key features such as conditional formatting and data filtering are also explained with examples.

Uploaded by

arindambera2003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
30 views2 pages

Computer Chapter 2

Chapter 2 covers various Excel functions and commands, including the If() function for condition checking, sorting, and filtering data. It provides multiple-choice questions, fill-in-the-blank statements, and practical applications of these functions. Key features such as conditional formatting and data filtering are also explained with examples.

Uploaded by

arindambera2003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Chapter 2

Tick the correct option

1. Which function checks whether a condition is true or fals


 Power ()
 If()
 Else
 None of these

2. The sort and filter command is present under task group


 Editing
 Sales
 Number
 Both 1 and 2

3. Which key combination is used for filter the data?


 Ctrl+Shift+F
 Ctrl+Shift+L
 Ctrl+L
 Ctrl+F

4. Under which group the conditional formatting command is present


 Styles
 Editing
 Front
 Cells

5. Which function calculate the total of a given set of values


 Power()
 Sum()
 If()
 Average()

Fill in the blanks

1 The physical arrangement of data in ascending or descending order is called Sorting


2 Filter option shows the data you wish to see while hiding the rest temporarily
3 Sort and filter command present under the Home tab
4 The Sum() calculates the total of a given set of values
5 Add level button is used to add another column for sorting.
Chapter 2

Think and answer

1. Write the use of if function?


Ans: if() function is used to check a condition to be evaluated as True of False.

2. Write the steps to apply conditional formatting?


Ans: a) Select the data and click on the conditional formatting command
b) Select the desired option
c) Choose desired fill effects

3. How do you filter the data in excel?


Ans: To filter data in Excel, select the range of cells or table, then go to the "Data" tab
and click "Filter"

4. Divya was making a list of all the students of her class she wishing to sort them
alphabetically which type of sorting can see used for this?
Ans: To sort a list of students alphabetically, Divya can use alphabetical sorting.

5. Chirag wants to see the name of those people from the list who have the same age
as him which feature can he used for this?
Ans: Chirag can use the filter feature to see the names of people with the same age
as him. This feature allows him to display only the rows that meet a specific criterion
(in this case, matching age), hiding the rest of the data temporarily.

You might also like