Excel (midterm rivision)

Chose the correct answer: 

The name for facts and figures.

• Data

• Programe

True or false:

Each field in the data table stores one fact

• True

• False

Choose the correct answer:

Which cell is selected in this picture?

• B2

• M3

• C3

Fill in the blank:

In spreadsheet

 a column goes  

​ ​ (a)  

a row goes

​ ​ (b)  

(c)  

True or fales:

There are two main types of sorting: alphabetical and numerical order.

• True

• false

​

 means selecting records you want to see from a data table.

​

(a)  

True or False :

Data validation can help you spot mistakes

• True

• False

True or fales: 

validation means that you decide on rules called validation criteria .

• True

• False

The second step  to add a Data Validation to a data table is ?

• Click to select 

  the 'Data' tab.

• Click on 

  'Data Validation' .

The third step to add a Data Validation to a data table ?​ ​ ​

​

• Click on 'Data Validation'

• Click on 

  'Data Validation'