Excel Functions - VIII
Excel
True or False
1. The SUM function adds all the numbers in a range of cells.
Answer:-True
2. The AVERAGE function finds the highest value in a range.
Answer:-False
3. You can use the MAX function to find the smallest number in a range.
Answer:- False
4. MIN is used to find the lowest number in a range of cells.
Answer:-True
5. Left-aligned text is the default alignment for text in Excel.
Answer:-True
6. Right-aligned text is the default alignment for numbers in Excel.
Answer:-True
7. The SORT feature organizes data alphabetically, numerically, or by a custom order.
Answer:-True
8. The FILTER feature hides rows based on specific criteria.
Answer:-True
9. The term "column" refers to a vertical arrangement of cells.
Answer:-True
10. The autofill feature is used to copy formulas or values automatically.
Answer:-True
11. You cannot insert a new row between two existing rows.
Answer:-False
12. The Insert Column feature allows you to add new columns to your spreadsheet.
Answer:-True
13. Filtering data deletes the rows that don’t meet the criteria.
Answer:-False
14. Sorting and Filtering are the same processes in Excel.
Answer:-False
15. The SUM function can work with multiple ranges at once.
Answer:-True
16. The AVERAGE function ignores empty cells in the range.
Answer:-True
17. Autofill can only be used for numeric data.
Answer:-False
18. Excel has built-in options to sort data by color.
Answer:-True
19. Rows are horizontal in Excel, while columns are vertical.
Answer:-True
20. The MIN and MAX functions can only be used with numeric data.
Answer:-False
Match the Following
| Column A | Column B | Answer |
|---|---|---|
| 1. SUM | a. Finds the largest number in a range | d. Adds up all the numbers in a range |
| 2. AVERAGE | b. Arranges data alphabetically | e. Finds the mean of a range |
| 3. MAX | c. Adds a new column to the sheet | a. Finds the largest number in a range |
| 4. MIN | d. Adds up all the numbers in a range | f. Finds the smallest number in a range |
| 5. Right alignment | e. Finds the mean of a range | h. Default number alignment in Excel |
| 6. Left alignment | f. Finds the smallest number in a range | g. Default text alignment in Excel |
| 7. SORT | g. Default text alignment in Excel | b. Arranges data alphabetically |
| 8. FILTER | h. Default number alignment in Excel | i. Hides rows based on criteria |
| 9. Column | i. Hides rows based on criteria | j. Vertical arrangement of cells |
| 10. Autofill | j. Vertical arrangement of cells | k. Copies formulas and values quickly |
| 11. Insert Column | k. Copies formulas and values quickly | c. Adds a new column to the sheet |
| 12. Insert Row | l. Adds a new row to the spreadsheet | l. Adds a new row to the spreadsheet |
| 13. MIN function | m. Retrieves the smallest value | m. Retrieves the smallest value |
| 14. MAX function | n. Retrieves the largest value | n. Retrieves the largest value |
| 15. SUM function | q. Handles multiple ranges at once | q. Handles multiple ranges at once |
One-line Question and Answer
1. What does the SUM function do in Excel?
Answer:-Adds all the numbers in a selected range of cells.
2. Can you sum non-numeric values?
Answer:-No, SUM only works with numbers and ignores text.
3. What function is used to find the average of numbers?
Answer:-The AVERAGE function.
4. What does the MAX function do?
Answer:-It returns the largest value from a given range of numbers.
5. How do you sort data in Excel?
Answer:-Use the Sort option in the Data tab to arrange your data.
6. What is the default alignment for numbers in Excel?
Answer:-Right alignment.
7. How do you filter data in Excel?
Answer:-You use the Filter feature to hide rows based on specific criteria.
8. How do you add a new row in Excel?
Answer:-Right-click a row number and select Insert.
9. How do you insert a column in Excel?
Answer:-Right-click a column letter and select Insert.
10. How does Autofill work?
Answer:-It automatically fills in a series or pattern in cells based on the data you enter.
Detailed Answers
1. How do you sum values from A1 to A10?
Answer:-By typing =SUM(A1:A10) in a cell, Excel will add all the numbers from cell A1 to A10. It’s useful when you need to total a column or row.
2. Can you sum non-numeric values?
Answer:-No, the SUM function only works with numeric values. Text or empty cells are ignored in the calculation.
3. How do you calculate the average of numbers from A1 to A10?
Answer:-To find the average of numbers in cells A1 to A10, use =AVERAGE(A1:A10). Excel adds the numbers and divides by the total count of numbers.
4. How do you find the highest number between A1 and A10?
Answer:-To find the maximum number, use the formula =MAX(A1:A10). This will return the highest number in the range A1 to A10.
5. What does the MIN function do?
Answer:-The MIN function finds the smallest number in a range of cells. It’s useful when you want to identify the lowest value in a list.
6. How do you get the last 3 characters from "Apple"?
Answer:-Use =RIGHT("Apple", 3) to extract the last 3 letters of the word "Apple", resulting in "ple".
7. How do you get the first 3 characters from "Apple"?
Answer:-The formula =LEFT("Apple", 3) returns "App", which are the first 3 letters of the word "Apple".
8. What does the SORT function do?
Answer:-The SORT function arranges data in either ascending (A-Z) or descending (Z-A) order. It’s useful for organizing data in a logical sequence.
9. How do you sort a list from A to Z?
Answer:-You can sort data from A to Z by selecting the range of cells and clicking the "Sort A to Z" button on the Data tab. This arranges the data in alphabetical order.
Comments
Post a Comment