ICT 4TH TERM CONCEPTUAL ASSESSMENT 8th

In a Pivot Table image, the green colour bolong to the field of:

• ROWS

• FILTER

• COLUMNS

• VALUES

These are the elements or fields that are used to set up the pivot table, _________, ROWS, COLUMNS and __________.

(a)  

When creating a pivot table, what does the data source refer to?

• The values of the pivot table

• The analysis that results from doing the dynamic table

• This is the data that forms the columns of the pivot table.

• It is a table or database that contains the information to make the pivot table.

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

• implementing

• Sorting

• Organizing

• Filtering

The menu used to use the Pivot Table icon is ....

• HOME

• INSERT

• PAGE LAYOUT

• FILE

Select the icons that are not used to insert a Pivot Table.

• 
• 
• 
• 

Digital images in GIMP are made up of tiny, solid colour squares called___________

• CANVAS

• PIXELS

• DOTS

• BYTES

_______tool can be used to cut only the desired part of an image.

• CROP

• SELECTION

• MOVE

• SCALE

If i have to edit a picture named Dibujo with GIMP software, the file must end whit a aprticular format extension. Write the filename with the correct format extension.

(a)  

With the source data from the image create a pivot table with the sum of the salary for each delegation in the following order: SOUTH $_______, TOWN $________ AND NORTH $______:

(a)