Formula

What do you call the intersection of a row and a column?

• Cell

• Column

• Row

• Box

Every formula in MS Excel or Google Sheets must begin with what?

• Plus Sign

• Equal Sign

• Function Sign

• Square Bracket

In Excel/Google Sheets, ROWS are identified by ______________.

• Numbers

• Letters

• Characters

• None of the choices

What is the very first cell in a worksheet?

• 1A

• Cell

• A1

• FX

In Excel/Google Sheets, COLUMNS are identified by ______________.

• Numbers

• Letters

• Characters

• None of the choices

In Excel, the name of the bar where information appears as you input data is called?

• Help Bar

• Window Bar

• Menu Bar

• Formula Bar

What function adds all of the numbers in a range of cells?

• Add

• Calculate

• Sum

• Compute

What is the correct formula if I want to know the total amount of Ice Cream Sold in the month of February?

• =SUM(D5:D10)

• =D5+D10

• =ADD(D5:D10)

• SUM(D5:D10)=

What is the correct formula if I want to know the total number of Rocky Road Ice Cream?

• =SUM(C10:E10)

• =C10:E10

• =ADD(C10:E10)

• SUM(C10:E10)=

Analyze the receipt properly.

What is the correct formula to get the total amount of $570.00?

• =E6-E8

• =E6+E7

• =SUM(E6+E7)-E8

• =E7-E8