class 8 revision

 

1st Unit Exam – 2026

STD: VIII | Subject: Computer

I. Choose the Correct Answer

  1. The second argument in the IF() function is used when the expression evaluates to:
    a) True
    b) False
    c) 0
    d) Greater than given value
    Answer: a) True

  2. The error code ### indicates:
    a) Column width too small to display result
    b) Invalid value in formula
    c) Data not available
    d) Division by zero
    Answer: a) Column width too small to display result

  3. Which of the following is an example of System Software?
    a) MS Word
    b) Google Chrome
    c) Operating System
    d) VLC Media Player
    Answer: c) Operating System

  4. Which of these is a disadvantage of a Character User Interface (CUI)?
    a) Requires less memory
    b) Difficult for beginners to use
    c) Faster for experienced users
    d) Provides precise control
    Answer: b) Difficult for beginners to use

  5. What is the small program stored in ROM that controls the booting process?
    a) GUI
    b) CUI
    c) MS-DOS
    d) BIOS
    Answer: d) BIOS

  6. The values passed to a function are called:
    a) Range
    b) Arguments
    c) Data
    d) Expressions
    Answer: b) Arguments

  7. Which function is used to find the highest value in a range?
    a) MIN()
    b) MAX()
    c) COUNT()
    d) SUM()
    Answer: b) MAX()

  8. Which symbol is used to start a formula in Excel?
    a) @
    b) #
    c) =
    d) $
    Answer: c) =

  9. Which type of Operating System allows multiple users to work at the same time?
    a) Single-user OS
    b) Multi-user OS
    c) Real-time OS
    d) Batch OS
    Answer: b) Multi-user OS

  10. Which key is commonly used to access Help in many applications?
    a) F1
    b) F2
    c) F5
    d) Esc
    Answer: a) F1

  11. Which function counts only numeric values?
    a) COUNT()
    b) COUNTA()
    c) MIN()
    d) MAX()
    Answer: a) COUNT()

II. Fill in the Blanks

  1. The & operator is used to __________ two or more text strings.
    Answer: Concatenate / Join

  2. The key used to cycle through relative, absolute, and mixed references is __________.
    Answer: F4

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

  4. The Operating System acts as an __________ between the user and the computer hardware.
    Answer: Interface

  5. The first program loaded into the computer’s memory when it starts is the __________.
    Answer: Operating System

  6. The OS function that keeps track of where files are stored is called __________.
    Answer: File Management

  7. The __________ function is used to find the highest value in a range.
    Answer: MAX

  8. A spreadsheet is made up of rows and __________.
    Answer: Columns

  9. The __________ function is used to count numerical entries.
    Answer: COUNT

  10. GUI stands for __________ User Interface.
    Answer: Graphical

  11. The process of starting a computer is called __________.
    Answer: Booting

III. Mention the Function for the Given Situation

  1. Determine the lowest price for an item from a list of sellers.
    Answer: MIN()

  2. Calculate sales tax at a constant 8% while dragging the formula down.
    Answer: Absolute Cell Reference ($)

  3. Check if a student’s attendance (cell B5) is below 75% to mark “Detained”.
    Answer: IF()

  4. Find the average of daily temperature readings for a month.
    Answer: AVERAGE()

  5. Find the total marks obtained by a student.
    Answer: SUM()

  6. Count the number of students who have submitted assignments.
    Answer: COUNT()

  7. Display “Pass” if marks are 40 or above, otherwise “Fail”.
    Answer: IF()

  8. Find the highest score in a class.
    Answer: MAX()

  9. Join First Name and Last Name into a single cell.
    Answer: CONCATENATE() or & Operator

IV. Answer the Following Questions

  1. List the advantages of GUI.
    Answer:

    • Easy to use

    • User-friendly interface

    • No need to memorize commands

    • Supports icons, menus, and windows

  2. Give two examples where Real-Time Processing Operating Systems are used.
    Answer:

    • Air Traffic Control Systems

    • Medical Monitoring Systems

  3. What is the key difference between COUNT() and MIN() functions?
    Answer:

    • COUNT() counts numeric entries in a range.

    • MIN() returns the smallest value in a range.

  4. List common errors encountered while working in Excel.
    Answer:

    • #DIV/0!

    • #NAME?

    • #VALUE!

    • #REF!

  5. What is booting?
    Answer:
    Booting is the process of starting a computer and loading the operating system into memory.

  6. Differentiate between GUI and CUI.
    Answer:
    GUI uses icons and menus, whereas CUI uses text commands.

  7. What is an Operating System? Give two examples.
    Answer:
    An Operating System is system software that manages computer resources and acts as an interface between the user and hardware.
    Examples: Windows, Linux.

  8. Explain absolute and relative cell references with examples.
    Answer:

    • Relative Reference: A1 (changes when copied)

    • Absolute Reference: $A$1 (does not change when copied)

  9. What is BIOS? Mention its function.
    Answer:
    BIOS (Basic Input Output System) is a program stored in ROM that starts the computer and checks hardware during booting.

  10. What is the importance of system software?
    Answer:
    System software manages hardware resources, runs application software, and provides a platform for users to interact with the computer.

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