Check all that apply: $(2$ points$)$

$$

Check All That Apply

The CONCATENATE function in Excel can only combine text strings, not numerical values.The CONCATENATE function in Excel can only combine text strings, not numerical values.

"Data Validation" rules in Excel cannot be applied to cells containing formulas."Data Validation" rules in Excel cannot be applied to cells containing formulas.

When this formula is copied $\text{'}=$$D$$3+$$E$5\text{'},$ row $5$ will be updated.When this formula is copied $\text{'}=$$D$$3+$$E$5\text{'},$ row $5$ will be updated.

When using approximate match in VLOOKUP, the lookup range must be$$sorted in descending order.When using approximate match in VLOOKUP, the lookup range must be$$sorted in descending order.

$$The primary purpose of a named array is to create a range of cells with fixed references.The primary purpose of a named array is to create a range of cells with fixed references.