In Google Sheets, you want to add up all the numbers found in Column A, rows 1-7. Which is the correct formula to use in the cell where you want to see the total?Group of answer choices=tot(A,1:7)=total(columnA,rows:1-7)=sum(A1:A7)=sum(column:A,row:1-7)

In Google Sheets, you want to add up all the numbers found in Column A, rows 1-7. Which is the correct formula to use in the cell where you want to see the total?

Your manager, Angelique Kidjo, has a Google Sheet where she keeps track of her weekly expenses. She has listed the expenses in Column A, rows 1-7. Angelique wants to know the total amount spent for the week. What formula would you put in the cell where you want to see the total?=SUM(A1:A7)=TOTAL(A1:A7)=AVERAGE(A1:A7)=ADD(A1:A7)I don't know

The first step when using the Subtotal command is to_____________.Group of answer choicesSort the list.Open the Subtotal dialog box.Insert blank rows between each data group.Select the function used to calculate the subtotals.

You have a Sheet that contains list of 100 people, each listed in a row (rows 1-100). In column B, it indicates whether the person in that row is a "VIP" or "Non-VIP". You want to know how many total "VIP"s are on your sheet. What formula would you put in the cell where you want this information? Group of answer choices=COUNTB(B1:B100,"VIP")=COUNT(B1:B100,"VIP")=COUNTA(B1:B100,"VIP")=COUNTIF(B1:B100,"VIP")

What Excel spreadsheet command multiplies all the values in a column (or row) by the values in another column (or row) and then sums the result?Group of answer choicesGIVEITTOMEADDANSWERSThere is not such a wonderful command.SUMPRODUCT