Formulas

Card 1 of 20 0 got it 0 still learning

Question

TapClick or press space to see the answer

Answer

All 20 cards in this set

Which symbol must every spreadsheet formula start with?: An equals sign
Which symbol is used for multiplication in a spreadsheet formula?: The asterisk
A student types =83-3 into a cell and presses Enter. What is shown in the cell?: 80
What is the result of the formula =(10+5)*4?: 60
Cell A4 holds 97 and cell C2 holds 78. What does the formula =A4+C2 show?: 175
Which formula divides the number in B2 by the number in B4?: =B2/B4
A formula uses cell references instead of typed numbers. What is the main advantage?: The answer updates automatically when the data changes
In cell D2 the formula is =B2*C2. The formula is copied down to D3. What is the formula in D3?: =B3*C3
In a snack shop sheet, B2 holds the price per item and C2 holds the quantity sold. Which formula gives the total sales in D2?: =B2*C2
Which key do you press to finish entering a formula into a cell?: Enter
Why does every spreadsheet formula start with an equals sign?: So the entry is calculated instead of shown as text
What is the result of the formula =20+5*4?: 40
Which formula adds the value in B12 to the value in B7 and then divides the answer by the value in C9?: =(B12+B7)/C9
A sheet works out total sales for the first row in D2. The same total is needed for rows 3 to 13. What is the best way to work out the rest?: Copy the formula from D2 down to D13
Which term describes a calculation typed into a spreadsheet cell, such as =53+32?: Formula
What is meant by using brackets in a spreadsheet formula?: The part of the calculation inside the brackets is worked out first
What is the name for the maths symbols such as + and * that tell a spreadsheet which calculation to carry out?: Operators
A formula has been typed into a cell and Enter has been pressed. Where can the formula still be seen?: In the formula bar
Which symbol is used for division in a spreadsheet formula?: The forward slash
A student types the equals sign in a cell, then clicks on cell B2. What is added to the formula?: The cell reference B2

Formulas

Round complete