Write 'T' for True and 'F' for False statements.
1. Constants and Formulas are two ways of entering data in Excel.
2. Cell range references must start with a letter.
3. The MAX function in Excel returns the lowest value in a range.
4. Relative references in Excel adjust automatically while copying formulas.
Fill in the blanks.
1. The values which are directly entered in the cells are called ________.
2. The range reference includes both anchor points separated by ________.
3. Every cell in a worksheet has a unique address called ________.
4. The ________ function is used to calculate the average.
Answer (2)
In Excel, you can enter data as constants (fixed values) or as formulas (calculations based on other cells).
Cell range references must start with a letter.
Answer: T (True)
The true and false statements assess basic Excel knowledge including data entry and formula functionality. Constants are fixed values, while ranges are identified with a colon. The AVERAGE function is specifically designed to calculate the mean.
;
