Question

09) which of the formulas below are valid? Select all that apply.
=F2 F3-F4-53
A3+*100
=R2D2
=SB+6B​

Answer 1

Answer:

right answer is second

Explanation:

but I am not shore

Answer 2

Answer:

The given questions has some errors in the options, the corrected options are:

1. =F2+F3+F4-53
2. A3+100
3. =R2*D2
4. =5B+6B

The correct option for the given question is option 1 and 3.

Explanation:

The explanation for the valid formula for the respective given options are as follows:

1. Option 1 is a valid formula as it starts with a symbol of 'equal to' sign which is essential for a valid formula input in the spreadsheet. Further it addresses the correct form of cell address as F2, F3, F4 with correct position of addition and subtraction symbol.
2. Option 2 is not a valid formula because it does not starts with 'equal to' sign, which is essential in the formula input for spreadsheet.
3. Option 3 is a valid formula as it starts with a symbol of 'equal to' sign which is essential for a valid formula input in the spreadsheet. Further it addresses the correct form of cell address as R2 and D2 with correct position of multiplication symbol.
4. Option 4 is not a valid formula because it does not addresses the correct form of cell address as B5 and B6, rather does it 5B and 6B.