Year 12 Spreadsheets

A ____ is a single unit on a spreadsheet formed due to an intersection of a column and a row.

=Sum(A1:A5) is a good example of a/an _________

• function

• formula

• operator

• expression

The _______ function gives the current date and time.

• =TIME()

• =WEEKDAY()

• =NOW()

• =DATE()

Left, Right, Mid & Concatenate are examples of ____ functions.

The following formula extracts the ___________ of an email address in A1.

=RIGHT(A1,LEN(A1)-FIND("@",A1))

• the @ symbol

• domain name

• username before the @ symbol

• None of the above

Macros in Excel are created in the ______ menu.

• View

• Developer

• Formulas

• Review

The ISTEXT function returns a _______ if the value is a number.

The ______ function finds a value based on its position within a table.

• =MATCH

• =VLOOKUP

• =INDEX

• =XLOOKUP

An IF functions contains _________ elements.

• one

• two

• three

• not known

Write a formula in B1 to retrieve data from A1 as shown.