Spreadsheet Functions

What is the correct syntax for the SUM Function?

• =SUM(value1,value2...)

• SUM(value1+value2

• =value1+value2

• SUM=(value1:value2)

Which function can be used to find the highest grade in a grades list?

• AVERAGE

• MIN

• MAX

• COUNTA

The VLOOKUP Functions helps us find a value in table and return a corresponding value.

• True

• False

Which function counts textual values in a spreadsheet?

• COUNT

• COUNTA

• SUM

• AVERAGE

Which function finds the lowest value in a table?

• MAX

• IF

• COUNT

• MIN

Which function finds the mean within a list of numbers?

• SUM

• COUNT

• AVERAGE

• COUNTA

Which function counts only numeric values?

• COUNTA

• MAX

• SUM

• COUNT

Which symbol is used to join two text strings?

• #

• &

• +

• =

What symbol is used to lock on cell references?

• $

• @

• #

• &

What symbol is the union operator, which combines multiple references into one reference?

• .

• *

• &

• ,