First term assessment ICT- 7TH GRADE

1.      What option do we use to insert charts (graphics)

• Home

• Formulas

• Insert

• Data

2. What sign or symbol do the formulas begin in Excel?

• *

• =

• :

• ;

3.  What mathematical operation is not considered basic?

• Sum

• Subtraction

• Average

• Division

4. Excel rows are identified by : 

• Letters

• Numbers

• Symbols

• Nicknames

The following formula:

=AVERAGE (A1/A3) contains an error; indicate which it is:

• It does not indicate the range to count

• shows the criterion between quotes

• the symbol is  not using just a “coma or semicolon”

• missing parenthesis grouping the function and the range

The correct form to divide using Excel program is:

a. =division(A3:A5)

b. =(A3/A5)

c. (A3*A5)

d. Other

• =div(A3:A5)

• =(A3/A5)

• (A3*A5)

• None

 the picture shows 4 types of charts:

Select the best option

• Bars, Area, lines, and pie

• Bars, Area, dots, columns

• Columns, Area, lines, pie

• Bars, Area, dots, pie

Each chart element can be individually customized: legend, chart area, grid lines

• Using the predefined chart layouts (quick styles).

• Using the Layout and Format tabs: by selecting the element and clicking the Format Selection tool.

• The last two option are right

what do we use a chart for?

 

• Charts are used to display series of columns data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.

• Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.

• Charts are used to display series of rowsground data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.

Once the graph is made, it can be modified.

• Once the graph is made, nothing can be modified in it.

• Its format, through quick formats or with the different tools available.

• The data it includes.

• You can modify your data and its format