ICT P6 2nd Term Theme 4 Lesson5: Creating a Data base

symbol is used for dividing numbers in Excel formulas.

• -

• /

• *

• +

Databases store information about .

• people

• places

• things

• all of them

is a software that can be used to create databases.

• Microsoft Word

• Microsoft Excel

• Microsoft PowerPoint

• Microsoft Outlook

By adding formulas, Excel lets you manipulate numbers in your ………

• game

• home

• data

• database

A teacher can use a secure database to ..

• store employees' information

• store student information

• analyzing financial data

• none of them

Data in a database can be analyzed or changed ..

• manually

• manually and automatically

• automatically

• cannot be analyzed

You can add additional columns to a database by the top of the column and selecting Insert Column.

• right-click

• left-click

• double click

• none of them

…… are tools that can be used to manipulate data in Excel.

• Sorting

• Adding

• Subtracting

• All of them

Typing in column headings or field names is the ………….. step to creating a database.

• first

• second

• third

• fourth

Microsoft Excel can be considered as a database management system.

• True

• False