Displaying 5 out
of 13
questions & answers.
Q1.
Fill in the blanks.
- A cell address is also called _____________ in Excel.
- Ampersand operator is also called ___________________ operator. It helps to _________________ the texts.
- A _________________ is a set of adjacent cells in a row or column.
- The ______________ function returns the number of cells in a range.
- A reference can be made an absolute reference by suffixing ___________ symbol on the cell address.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
- reference
- concatenation, concatenate
- range
- COUNT
- $
Q2.
State whether the following statements are True (T) or False (F).
- A sheet name can be 65536 characters long.
- Arithmetic operators in Excel follows the BODMAS rule.
- The chart's horizontal axis presents the categories, and the vertical axis shows the values.
- Bar charts are the vertical column charts.
- Doughnut charts are similar to Pie charts and used to represent more than one data series in "layers", forming a multicoloured "doughnut".
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
- False
- True
- True
- True
- True
Q3.
Define Functions.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
Functions are built-in routines that perform some calculations and give results. For eg. SUM, COUNT, MIN, MAX etc.
Q4.
Write one use of having a chart for representing data.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
answer not shownQ5.
Write one use of having data labels in the chart.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
answer not shown





























































































