class 8 imp

 

I. Choose the correct answer

1. Which chart is best suited to show a trend over time?

a. Pie Chart
b. Line Chart
c. Bar Chart
d. Scatter Chart

Answer: b. Line Chart

2. The error code #### in Excel usually indicates:

a. Column width is too small to display the result
b. Invalid value in a formula
c. Data is not available
d. Division by zero

Answer: a. Column width is too small to display the result

3. Which of the following keywords are used for decision-making in a program?

a. If
b. Else
c. Both a) and b)
d. Go to

Answer: c. Both a) and b)

4. In Excel, which function key creates a default chart instantly?

a. F4
b. F12
c. F11
d. Ctrl + C

Answer: c. F11

5. Which type of chart is suitable for comparing multiple skills or characteristics?

a. Bar
b. Column
c. Area
d. Radar

Answer: d. Radar

6. The second argument of the IF() function is applicable when the given expression evaluates to:

a. True
b. False
c. 0
d. Greater than the given value

Answer: a. True

7. In a flowchart, the implementation of a loop is generally shown using a:

a. Backward arrow
b. Downward arrow
c. Rounded arrow
d. Circle

Answer: a. Backward arrow

8. Which of the following situations can benefit from the use of flowcharts?

a. Complex algorithms
b. Longer programs
c. Short, simple algorithms
d. All of these

Answer: d. All of these

II. Fill in the blanks

1. A __________ shape is used to show decision-making in a flowchart.

Answer: Diamond

2. The __________ symbol is used to indicate the beginning or end of a program.

Answer: Terminator (Oval)

3. A __________ joins a flowchart from one page to another.

Answer: Connector

4. The __________ is a key that identifies the colours or symbols used in a chart.

Answer: Legend

5. In a pie chart, all the slices together add up to __________ percent.

Answer: 100

6. A __________ chart is suitable for showing the relationship between two numerical values.

Answer: Scatter

III. State whether the following statements are True or False

1. An algorithm must always terminate after a finite number of steps.

Answer: True

2. Area charts are useful for showing cumulative data.

Answer: True

3. Column and Bar charts have exactly the same orientation.

Answer: False

4. Radar charts are suitable for comparing multiple characteristics or skills.

Answer: True

5. All flowcharts begin with the START symbol.

Answer: True

6. Algorithms and flowcharts are useful tools for problem-solving in computer science.

Answer: True

IV. Mention the function or feature used

1. You need to check whether a student's attendance percentage in cell B5 is below 75% and display “Detained” if it is. Which Excel function would you use?

Answer: IF() function

Example: =IF(B5<75%,"Detained","")

2. You have daily temperature readings for a month and want to calculate the average temperature. Which Excel function would you use?

Answer: AVERAGE() function

Example: =AVERAGE(B2:B31)

3. You want to determine the lowest price offered for an item from a list of prices. Which Excel function would you use?

Answer: MIN() function

Example: =MIN(B2:B10)

4. You need to combine the contents of cell F2 (“Annual”) and cell G2 (“Report”) into one cell with a space between them. Which Excel function would you use?

Answer: CONCAT() function

Example: =CONCAT(F2," ",G2)

5. You are calculating sales tax, which is always 8% of the price. You want the reference to the tax rate to remain constant when the formula is copied down. Which type of cell reference would you use?

Answer: Absolute Cell Reference

Example: $B$2

V. Answer the following questions

1. Write an algorithm to find the circumference of a circle when its radius is given.

Answer:

  1. Start.
  2. Input the radius R.
  3. Calculate circumference using:
    C = 2 × π × R
  4. Display the circumference C.
  5. Stop.

2. Draw a flowchart to calculate the product of two even numbers.

Answer:

START
↓
Input A and B
↓
P = A × B
↓
Display P
↓
STOP

3. Write any three advantages of using a flowchart.

Answer:

  1. It makes the logic of a program easy to understand.
  2. It helps identify errors in the logic of a program.
  3. It helps in planning and designing a program before coding.

4. Write the rules for writing functions in Excel.

Answer:

  1. A function must begin with an equal sign =.
  2. The function name is written after the equal sign.
  3. Arguments are placed inside parentheses ( ).
  4. Multiple arguments are separated by commas.
  5. Cell references or ranges can be used as arguments.
  6. The correct function name and arguments should be used.

Example: =SUM(A1:A5)

5. List the common errors that are encountered while working in Excel and explain any three.

Answer:

Common Excel errors are:

  • ####
  • #DIV/0!
  • #VALUE!
  • #NAME?
  • #REF!
  • #N/A

Explanation:

1. ####: The column is too narrow to display the result.

2. #DIV/0!: It occurs when a number is divided by zero or an empty cell.

3. #VALUE!: It occurs when an inappropriate type of value is used in a formula.

VI. Write the differences

1. COUNT() Function and MIN() Function

COUNT() Function

MIN() Function

It counts the number of cells containing numbers.

It finds the smallest number in a range.

It returns the number of numeric values.

It returns the lowest numerical value.

Example: =COUNT(A1:A5)

Example: =MIN(A1:A5)

2. Area Chart and Line Chart

Area Chart

Line Chart

It displays data using lines with the area below them filled.

It displays data using points connected by lines.

It is useful for showing cumulative quantities or magnitude.

It is mainly useful for showing trends over time.

It emphasizes the volume or magnitude of data.

It emphasizes changes and trends.

VII. Write the steps

1. Write the steps to move a chart to another sheet in Excel.

Answer:

  1. Select the chart.
  2. Click the Chart Design tab.
  3. Click Move Chart.
  4. Select New Sheet or Object in.
  5. Select the required sheet if using Object in.
  6. Click OK.
  7. The chart will be moved to the selected sheet.

2. Write the steps to apply simple formatting to a chart.

Answer:

  1. Select the chart.
  2. Click the Chart Design or Format tab.
  3. Select a suitable Chart Style.
  4. Add or edit the Chart Title.
  5. Add Axis Titles if required.
  6. Modify the Legend and other formatting options.
  7. Click outside the chart to finish formatting.

 

Comments

Post a Comment

Popular posts from this blog

CLASS 3 REVISION

I. Choose the Correct Answer Which of the following is an output device? a) Keyboard b) Mouse c) Monitor d) Scanner Answer: c) Monitor Which device is used to type letters and numbers? a) Mouse b) Keyboard c) Printer d) Speaker Answer: b) Keyboard Which of the following is a storage device? a) Hard Disk b) Monitor c) Mouse d) Speaker Answer: a) Hard Disk Which key is used to move to a new line while typing? a) Shift Key b) Enter Key c) Spacebar d) Caps Lock Answer: b) Enter Key Which device is used to print documents on paper? a) Scanner b) Printer c) Monitor d) Keyboard Answer: b) Printer II. Fill in the Blanks (Keyboard, Mouse, Output, Monitor, Hardware) The physical parts of a computer are called __________. Answer: Hardware A __________ is used to point and click on items on the screen. Answer: Mouse A __________ is used to type text into the computer. Answer: Keyboard The result given by a computer is called __________. Answer: Output A __________ displays information on the scree...
Read more

CLASS V

  Extra 3 Questions for Each Section I. Choose the Correct Answer Which software acts as an interface between the user and the computer hardware? a) Application Software b) System Software c) Utility Software d) Presentation Software Answer: b) System Software Which generation of computers used microprocessors? a) First b) Second c) Third d) Fourth Answer: d) Fourth Which of the following is an example of utility software? a) MS Word b) Photoshop c) Antivirus Software d) PowerPoint Answer: c) Antivirus Software II. Fill in the Blanks The __________ is the physical part of a computer system. Answer: Hardware __________ software helps protect a computer from viruses. Answer: Antivirus The Analytical Engine was designed by __________. Answer: Charles Babbage III. State Whether the Following Statements are True or False Hardware can function effectively without software. Answer: False MS Excel is an example of application software. Answer: True The first generation computers us...
Read more