PracticeExcelSign in
Google Sheets practice exercises

ARRAYFORMULA practice in Google Sheets

Run one formula over a whole column: multiply two columns, test every row with IF and join columns, with one formula in the top cell.

Start the first exercise
  1. 1One formula for a whole columnIn D2, use ARRAYFORMULA to multiply Units by Price for every row with one formula.
  2. 2IF for every rowPremiumIn C2, use ARRAYFORMULA with IF to write "Pass" for every score of 50 or more and "Fail" for the rest.
  3. 3Join two columns for every rowPremiumIn C2, use ARRAYFORMULA to join each first and last name with a space between them.

Functions in this topic