Worksheet 2 (Chapters 4 and 5)
A. Fill in the blanks.
1. Concatenation
2. IFS ()
3. Column
4. Grouped
B. Select the correct option.
1. c. Colon
2. c. Mixed
3. a. Chart Tools
4. c. Data
C. Answer the following questions.
1. a. Legend: It depicts the colours, patterns, and symbols assigned to a data series. It helps in reading the chart accurately. By default, legends appear at the bottom of the chart.
b. Gridlines: Gridlines are horizontal and vertical lines that extend across the plot area. They make it easier to read and understand the values.
2. Mixed reference is a combination of relative and absolute reference. In this type of reference, either the row or column must remain fixed. $A1 + A$2 is an example of mixed reference.
No comments:
Post a Comment