class 8 chapter 2


Test Yourself – Answers

  1. A formula may need which of the following to perform calculations?
    d. All of these

  2. To select adjacent cells, which of the following keys is used?
    d. Shift

  3. Absolute referencing is applied using which of the following letter?
    b. $

  4. Here are all the answers from the worksheet.

    A. Choose the correct answer

    1. The values passed to a function are called Arguments.
      Answer: b. Arguments

    2. The second argument in the IF( ) is applicable when the given expression evaluates to True.
      Answer: a. True

    3. The error code #### indicates Column width too small to display result.
      Answer: a. Column width too small to display result

    B. Fill in the blanks

    ( Mixed, Highest, Join, Condition to check, F4 )

    1. The Max function returns the Highest value in a given cell range.

    2. The & operator is used to Join two or more text strings.

    3. The cell address B$5 is an example of Mixed cell reference.

    4. The IF() takes arguments: Condition to check, value if true, value if false.

    5. The key to cycle through relative, absolute, and mixed referencing is F4.

    C. State whether the statements are True or False

    1. The Concatenate function is another name for the & operator when joining the text.
      True

    2. The result of formula will update if the data in the referenced cells changes.
      True

    3. The Count() function counts all cells in a range, including empty ones.
      False

    4. The AutoSum option can only perform the Sum function.
      False

    5. The syntax for referencing a cell from another worksheet is SheetName:Cell Address.
      False

    D. Mention the function for the given situation

    1. Check if attendance percentage (B5) is below 75% → IF()

    2. Find the average temperature of a month → AVERAGE()

    3. Keep 8% reference constant while dragging formula → Absolute Reference ($)

    4. Determine the lowest price from sellers → MIN()

    5. Combine contents of F2 and G2 with a space using a function → CONCATENATE()

a) Check B5 cell mark; if below 75, show “Denied”
Use the IF function
=IF(B5<75,"Denied","Allowed")

b) You have daily temperature readings for a month and want the average
Use the AVERAGE function
=AVERAGE(A1:A30)

c) Sales tax is always 8% of the price and must remain constant when dragging the formula
Use Absolute Cell Reference with $
If 8% is in cell C1:
=A1*$C$1

d) Determine the lowest price offer for a particular item from various sellers
Use the MIN function
=MIN(B1:B10)

e) Need to combine F2 cell “Anima” and G2 cell “Report” in one cell
Use the CONCATENATE function (or &)
=F2&" "&G2

1) Rules of using Functions in MS Excel

  • Every function starts with = (equal sign).

  • The function name is written after = (e.g., SUM, AVERAGE).

  • Arguments are written inside brackets ( ).

  • Cell ranges are written with a colon ( : ) (e.g., A1:A10).

  • Multiple arguments are separated by a comma ( , ).

  • Example: =SUM(A1:A10)

2) Difference between Formula and Function

FormulaFunction
A formula is a calculation written by the user.A function is a built-in formula in Excel.
Can use numbers, cell references, and operators.Uses a predefined name like SUM, MIN, MAX.
Example: =A1+A2Example: =SUM(A1:A2)

3) What is Cell Referencing? Why is it important in a spreadsheet?

  • Cell referencing means using the address of a cell (like A1, B2) in a formula.

  • It is important because:

    • It saves time when copying formulas.

    • It updates results automatically when values change.

    • It helps in accurate calculations across the sheet.

4) Difference between COUNT and MIN Function

COUNTMIN
Counts the number of cells that contain numbers.Finds the smallest number in a range.
Example: =COUNT(A1:A10)Example: =MIN(A1:A10)

5) List of Common Errors in Excel

  • #DIV/0! – Dividing by zero

  • #NAME? – Wrong function name

  • #VALUE! – Wrong type of value used

  • #REF! – Invalid cell reference

  • #NUM! – Invalid number

  • #N/A – Value not available

Comments

Post a Comment

Popular posts from this blog

class 7 last chapter

  A. Tick ( ✔ ) the correct option What is the main goal of intelligent security in smart cities? ✔ b. To improve surveillance and threat detection What technology is used to monitor and enhance traffic conditions on smart highways? ✔ b. Roadway Sensors Which AI technology is used for enhancing surveillance through facial identification and analysis? ✔ a. Facial Recognition B. Fill in the blanks (Words given: Security, Autonomous vehicles, Smart home, Traffic) The development of autonomous vehicles has led to the creation of vehicles that can improve traffic flow and safety. In smart cities, security technology enables real-time monitoring of surveillance cameras and can detect unusual activities or potential threats. AI in traffic management systems can analyse data from sensors and cameras to optimise traffic signals and reduce congestion. The integrati...
Read more

class 8 computer chapter 5

1. Java Keyword 👉 Definition: Keywords are reserved words in Java that have special meaning to the compiler. They cannot be used as identifiers (like variable names). 👉 Example: class , public , static , void , int , if , else public class Example { public static void main(String[] args) { int number = 10; // 'int' is a keyword if(number > 5) { // 'if' is a keyword System.out.println("Number is greater than 5"); } } } 2. Java Token 👉 Definition: A token is the smallest unit in a Java program. 👉 Types of Tokens: Keywords Identifiers Literals (numbers, characters, strings) Operators ( + , - , * , / ) Separators ( ; , {} , () ) 👉 Example: int a = 10; // Tokens: int, a, =, 10, ; 3. Java Data Types 👉 Definition: Data types define the type of data a variable can store. Two categories: Primitive Data Types (8 types) byte → 1 byte (e.g. byte b = 100; ) short → 2 bytes (e.g...
Read more