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 used to calculate the average is ____.
Answer (1)
The values which are directly entered in the cells are called constants . In spreadsheet software like Microsoft Excel or Google Sheets, constants refer to the explicit values you type into a cell without using a formula or reference to another cell.
The range reference includes both anchor points separated by a colon (:) . In spreadsheets, a range reference is used to denote a group of cells. For example, A1:A10 refers to all the cells from A1 to A10.
Every cell in a worksheet has a unique address called a cell reference . This address is typically composed of a column letter followed by a row number, such as B3 or D5.
The function used to calculate the average is AVERAGE . This function is used in spreadsheet applications to find the mean or average value of a set of numbers. For example, =AVERAGE(B1:B10) would calculate the average of the numbers in cells B1 through B10.
These concepts are fundamental for understanding how to manage and analyze data effectively in spreadsheet applications.
