Available Answers

1. 1.

   Fill in the blanks.

   1. A cell address is also called _____________ in Excel.
   2. Ampersand operator is also called ___________________ operator. It helps to _________________ the texts.
   3. A _________________ is a set of adjacent cells in a row or column.
   4. The ______________ function returns the number of cells in a range.
   5. A reference can be made an absolute reference by suffixing ___________ symbol on the cell address.
2. 2.

   State whether the following statements are True (T) or False (F).

   1. A sheet name can be 65536 characters long.
   2. Arithmetic operators in Excel follows the BODMAS rule.
   3. The chart's horizontal axis presents the categories, and the vertical axis shows the values.
   4. Bar charts are the vertical column charts.
   5. Doughnut charts are similar to Pie charts and used to represent more than one data series in "layers", forming a multicoloured "doughnut".
3. 3.

   Define Functions.

4. 4.

   Write one use of having a chart for representing data.

5. 5.

   Write one use of having data labels in the chart.

6. 6.

   Write the result of evaluating the following expressions in Excel.

   1. =5*6/2-23+3
   2. =89+23*2/3-1