G5 final third term

    In MS Excel, what is the basic calculation for this symbol (/)?

• Addition

• division

• subtraction

    In MS Excel, the function that join cell contents.

 

• COUNT

• TODAY

• CONCATENATE

  In MS Excel, if the cell shows the Value TRUE or False what should be the function?

 

• AND

• OR

• IF and AND together

• all of the above

  If you have a table and you want to find out how many cells have a value of greater than or equal to 60, then you can use what function?

 

• TODAY

• COUNT

• COUNTIF

To make your data presentations more lively and interesting, you can use

• Chart

• numbers

• tables

  What is this type of chart that is used to display only one series of data?

•   Scatter Chart

• pie chart

• Bar chart

    What is this type of chart that is used to display the value of two series and to compare them over time?

• pie chart

• Scatter Chart

• a.       Area Chart

   Sometimes you just want a graphical representation of your data inside a table, to do this you can use:

 

• Big chart

• Mini chart

• Pie chart

.  If you want to replace part of a text in a cell, you will use the

 

• SUBSTITUTE

• TODAY

• COUNT

In MS Excel, after you create a chart, you can -----------it

 

• Delete it

• Modify it

• copy it