Unit notes and practice questions
Everything here is for unit 3 of the Grade 9 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 9 Information Technology page. Open one at a time.
| Operator | Operation | Example Formula | Result |
|---|---|---|---|
| + | Addition | = | |
| - | Subtraction | = | |
| * | Multiplication | = | |
| / | Division | = | |
| ^ | Exponentiation | = | |
| % | Percent |
When you use it
Use these operators to construct mathematical calculation formulas in Excel worksheets.
Watch out
All formulas must start with an equal sign (=), otherwise Excel treats the input as plain text.
Drafted from Grade 9 Information Technology, pages 72-144, then checked twice before it went up
| Indent Marker or Method | Action |
|---|---|
| First-line indent marker | Adjusts the first line indent of a paragraph |
| Hanging indent marker | Adjusts all lines in a paragraph except the first line |
| Left indent marker | Moves first-line and hanging indent markers together |
| Tab key | Quickest method to indent a single existing paragraph |
When you use it
Use when adjusting the distance of paragraph text away from the left or right margin.
Watch out
Dragging the Left indent marker moves both the first-line and hanging indent markers at the same time.
Drafted from Grade 9 Information Technology, pages 72-144, then checked twice before it went up
| View Name | Main Function |
|---|---|
| Normal View | Create and edit slides, thumbnails, and speaker notes |
| Slide Sorter View | Reorder, hide, and set timing using slide thumbnails |
| Notes Page View | Create and print full-page notes for each slide |
| Reading / Slide Show View | Display the presentation full-screen to the audience |
When you use it
Use to switch between different working environments while designing, organizing, or presenting slides.
Watch out
Hiding a slide in Slide Sorter View keeps it in the file, but it will not appear during the presentation.
Drafted from Grade 9 Information Technology, pages 72-144, then checked twice before it went up
When you use it
Use relative references (like A1) when formulas should shift across rows or columns, and absolute references (like 1) when a referenced cell must stay constant.
Watch out
Forgetting the dollar sign ($) or pressing F4 causes the referenced cell to shift incorrectly when dragging the fill handle.
Drafted from Grade 9 Information Technology, pages 72-144, then checked twice before it went up
| Alignment | Shortcut | Function |
|---|---|---|
| Left Alignment | Ctrl + L | Aligns text evenly along the left margin |
| Center Alignment | Ctrl + E | Centers text between margins for titles |
| Right Alignment | Ctrl + R | Aligns text evenly along the right margin |
| Justification | Ctrl + J | Aligns text evenly to both left and right margins |
When you use it
Use to format the horizontal orientation and edges of paragraphs or headings in Microsoft Word.
Watch out
Center alignment is meant for titles and headings, not for long paragraphs.
Drafted from Grade 9 Information Technology, pages 72-144, 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, which symbol must be typed at the beginning of every formula?
Answer: A = (equal sign)
Why
To allow Excel to distinguish formulas from data, all formulas must start with an equal sign (=).
Question 2
Which keyboard shortcut is used to insert a manual page break in Microsoft Word?
Answer: A Ctrl + Enter
Why
You can insert a manual page break in Microsoft Word by pressing Ctrl + Enter on your keyboard.
Question 3
In Microsoft PowerPoint, which shortcut key combination is used to insert a new slide?
Answer: A Ctrl + M
Why
In PowerPoint, you can insert a new slide page using the shortcut keys Ctrl + M.
Question 4
Which keyboard shortcut is used to center align selected text in Microsoft Word?
Answer: A Ctrl + E
Why
Ctrl + E aligns text to the center of the page. Ctrl + L is for left alignment, Ctrl + R for right, and Ctrl + J for justification.
Question 5
When you use the Indent commands on the Home tab in Microsoft Word, by how much is the indent adjusted per click?
Answer: A 1/2 inch increment
Why
The Indent commands (Increase Indent and Decrease Indent) adjust the indent by a 1/2 inch increment.
Question 6
While typing a multilevel list in Microsoft Word, how can a student decrease the indentation level of a line?
Answer: A Hold the Shift key and press the Tab key
Why
To increase the indent level, you press Tab. To decrease the indentation level, you hold the Shift key and press the Tab key.
Question 7
Almaz is calculating the price of teff sacks in Excel. She needs to multiply each sack's price by a fixed sales tax rate in cell G1. How should cell G1 be written so it does not change when copied to other rows?
Answer: A 1
Why
An absolute cell reference uses the dollar sign ($) before the column letter and row number (such as 1) to keep the reference constant when copied.
Question 8
According to the textbook, what are the default line spacing and paragraph spacing values in Microsoft Word?
Answer: A 1.15 inches line spacing and 8 points paragraph spacing
Why
In a Microsoft Word document, the default line spacing is 1.15 inches and the default spacing between paragraphs is 8 points.
Question 9
According to the presentation design guidelines in the textbook, what font sizes should be used for slide titles, sub-headings, and body text in PowerPoint?
Answer: A 44 to 60 points for titles, 32 to 40 points for sub-headings, and 18 to 32 points for body text
Why
The textbook specifies that titles should be between 44 and 60 points, sub-headings between 32 and 40 points, and body text between 18 and 32 points.
Question 10
Which PowerPoint view displays thumbnail images of all slides so you can easily reorder them by dragging and dropping or set slide show timing?
Answer: A Slide Sorter View
Why
Slide Sorter View shows thumbnails of your slides, letting you reorder them by dragging and dropping, set timings, or hide slides.
The app holds 12 questions on this unit, marked as you go. These are the first 10.
Unit 3 runs from page 72 to page 144 of the Ministry of Education edition.
Ministry of Education edition, English, 251 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.
