Question 2Which spreadsheet feature uses a set of instructions to perform calculations, such as addition or subtraction?1 pointFormatFilterFunctionFormula

Question 4Which of the following are examples of spreadsheet functions? Select all that apply.1 pointSave=A1+A2+A3Cut=2*B2

At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is*3 pointsTo tell the person viewing that this is a function and it should be added together.To inform the computer that an arithmetic function will occur.To add all the data together using addition only.To calculate all the data correctly without any mistakes.

In Excel, what does the function "=A1*B1" do?a) It multiplies the values in cells A1 and B1.b) It adds the values in cells A1 and B1.c) It calculates the average of cells A1 and B1.d) It subtracts B1 from A1.

Question 12True or False: When using the math operations feature, the steps will remain the same regardless of which calculation option you select. 1 pointTrue False

When you wrote incorrect functions, what did you learn about spreadsheet data?How do you think this knowledge of the SUM spreadsheet function will help you write other kinds of functions?