Google Sheets: what is an array?
Self-tutoring about spreadsheet terms: the tutor mentions the idea of an array in the context of Google Sheets.
The following is by my understanding.
In Google Sheets, b12:b21 is a range. However, for the purpose of constructing a function, it could also be thought of as an array.
For instance, in my post from yesterday I mention the Google Sheets function sumproduct. Sumproduct can accept two ranges as arguments, such as =sumproduct(a1:a3,b1:b3). Yet, a1:a3 and b1:b3 can be thought of as arrays in this context. An array is a list of values.
Source:
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.