Unit notes and practice questions
Everything here is for unit 3 of the Grade 10 Information Technology textbook: what the chapter covers, the short notes, practice questions with their answers, and the lesson video where one exists.
The cards filed under this chapter on the Grade 10 Information Technology page. Open one at a time.
When you use it
Use this rule to determine the default positioning of text versus numeric entries in spreadsheet cells.
Watch out
Text automatically aligns to the bottom-left of a cell, whereas numbers align to the bottom-right.
Drafted from Grade 10 Information Communication Technology, pages 81-138, then checked twice before it went up
When you use it
Use this to fix or prevent formula errors in spreadsheet calculations.
Watch out
Every formula in Excel must begin with an equal sign (=). Without it, Excel treats the formula as simple text and does not calculate.
Drafted from Grade 10 Information Communication Technology, pages 81-138, then checked twice before it went up
When you use it
Use this sequence to evaluate which calculation Excel performs first in a complex formula.
Watch out
Multiplication and division are always performed before addition and subtraction unless parentheses are used.
Drafted from Grade 10 Information Communication Technology, pages 81-138, then checked twice before it went up
| Function | Syntax | Purpose |
|---|---|---|
| SUM | =SUM(range) | Calculates total sum of numbers |
| AVERAGE | =AVERAGE(range) | Calculates arithmetic mean |
| COUNT | =COUNT(range) | Counts cells containing numbers |
| MAX | =MAX(range) | Returns the largest value |
| MIN | =MIN(range) | Returns the smallest value |
When you use it
Use this table as a reference for the most common predefined calculation functions in Excel.
Watch out
COUNT only counts cells containing numerical data, ignoring blank or pure text cells in the range.
Drafted from Grade 10 Information Communication Technology, pages 81-138, then checked twice before it went up
| Feature | Slide Transition | Animation |
|---|---|---|
| Scope | Entire slide | Individual elements |
| Trigger | Moving between slides | Within a single slide |
| Application | Slide movement effect | Text, shape, or picture effect |
When you use it
Use this table to distinguish between whole-slide movements and element-level effects.
Watch out
Transitions apply only to entire slides, while animations apply to individual objects like text and pictures.
Drafted from Grade 10 Information Communication Technology, pages 81-138, then checked twice before it went up
10 multiple-choice questions written against this chapter, each with its answer and the reason. Try one before you open the answer.
Question 1
In Microsoft Excel, all formulas must start with which character?
Answer: A An equal sign (=)
Why
All formulas in Excel must begin with an equal sign (=) because the cell contains or is equal to the formula and the value it calculates.
Question 2
In a Microsoft Word table, what is the rectangle formed where a row and a column meet called?
Answer: A A cell
Why
A cell is the rectangular box formed by the intersection of a horizontal row and a vertical column in a table.
Question 3
What is the name of the special animated effect used when moving from one slide to the next in PowerPoint?
Answer: A Slide transition
Why
Transitions are animated effects that occur when you move from one slide to another during a slide show.
Question 4
According to Excel's order of operations, which part of a complex formula is calculated first?
Answer: A Operations enclosed in parentheses
Why
Excel calculates operations enclosed in parentheses first, followed by exponents, then multiplication and division, and finally addition and subtraction.
Question 5
When drawing a shape in Microsoft Word, which keyboard key can you hold down to create a perfect version of the shape?
Answer: A Shift key
Why
Holding down the Shift key while clicking and dragging allows you to create a perfect shape, such as a perfect circle or square.
Question 6
When you click the plus sign (+) on the blue insert control tool at the top border of a Word table, where is the new column inserted?
Answer: A To the right of the tool
Why
The insert control tool inserts a row below the tool or a column to the right of the tool.
Question 7
A school in Hawassa needs to count the number of cells that contain numerical test scores in a range. Which Excel function should they use?
Answer: A COUNT
Why
The COUNT function counts the number of cells that contain numerical data within the specified argument range.
Question 8
In Microsoft Excel, what punctuation mark must be used to separate multiple arguments in a function like =SUM(A1:A3, C1:C2, E2)?
Answer: A A comma
Why
When a function contains multiple arguments, they must be separated by a comma inside the parentheses.
Question 9
A shopkeeper in Bahir Dar wants to freeze row 1 and row 2 so they stay visible at the top while scrolling down. Which row must they select before clicking Freeze Panes?
Answer: A Row 3
Why
To freeze rows in Excel, you must select the row directly below the rows you wish to freeze. Selecting row 3 freezes rows 1 and 2.
Question 10
What is the difference between Sort sheet and Sort range in Microsoft Excel?
Answer: A Sort sheet organizes all data in the worksheet by one column, while Sort range sorts only the data in selected cells without affecting the rest.
Why
Sort sheet organizes all the data in your worksheet by one column, whereas Sort range sorts only the data in a selected range of cells without affecting other content on the sheet.
The app holds 12 questions on this unit, marked as you go. These are the first 10.
Unit 3 runs from page 81 to page 138 of the Ministry of Education edition.
Ministry of Education edition, English, 234 pages
Temari turns this chapter into timed practice and marks it as you go, with an AI tutor to explain anything that did not land.
Start free
Temari.et is also an Android app, free on Google Play.
