ICT Grade 6 - Theme 4 - Lesson 5

........ store a large amount of information in a computer system.

• Databases
• Search engines
• Social media
• Stock exchange

In Excel, go to the toolbar, Data, then click on ............ to arrange information alphabetically.

• Layout
• Sort
• Format
• Design

You can use ........ to create databases.

• MS PowerPoint
• MS Teams
• MS Excel
• MS Word

To add additional columns to a database, right--click the top of the column and then select .......... column.

• move
• delete
• edit
• insert

Excel lets you manipulate numbers in your database by adding .........

• filters
• formulas
• pictures
• text

To create a simple formula in Excel, first type .......... in the cell

• -
• +
• =
• x

You can also add text, such as names to cells, ......... using a formula.

• with
• without
• a and b
• none of the previous

To add additional information columns to a database, ........... click the top of the column.

• left
• right
• double
• a and b

In Excel, when you write numbers, such as a data, Excel will .............

• automatically format them
• delete them
• change them to text
• none of the previous

Sorting data in Excel involves going to the toolbar and choosing the Format option.

• True
• False