ONE MUST BE TRUE, WHICH ONE? 1. or 3. or isn't it both?

1."Cells can be date, number or formula cells, amongst others "

2. A formulae in a spreadsheet always begins with a '+' sign

3. A spreadsheet is matrix of 'cells' determined by the intersection of 'columns' and 'rows'

4 A macro is used to sort and filter data

Sounds like homework, but I'll help out anyway. I'd say that if you can only choose one answer, choose # 3.

The reason I say that is because of the way # 1 is worded.

"Cells can be date, number or formula cells, amongst others "

Cells can be

formattedas dates, numbers, text, amongst others. In my mind, their the use of the word "or" makes the statement False.For example, a cell that

displays3/11/2012 could contain the actual Date 3/11/2012 or it could contain a formula that evaluates to 3/11/2012.So to say that a cell could be a date

ora formula cell would be False since it could be both.Note: I'm not saying that I'm correct since I didn't write the question, but if you're only allowed to choose 1 answer, and I feel that # 3 is True, I went looking for a way to make #1 False.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Homework for the lecturer!! Thank you - in a previous question paper, one of the multiple questions was as follows;

All of the following regarding spreadsheet applications is true except:

a) Cells can be date, number or formula cells, amongst others

b) a Formulae in a spreadsheet always begins with a '+' sign

c) A spreadsheet is matrix of 'cells' determined by the intersection of 'columns' and 'rows'

d) All of the aboveIn the previous question, they gave TWO of the statements that's true, what now? That is the reason why I thought that the answer for previous question can be 1 or 3? Do you agree? Thank you for your reply!!!

On Spreadsheet Applications False Except?

1."Cells can be date, number or formula cells, amongst others "

2. A formulae in a spreadsheet always begins with a '+' sign

3. A spreadsheet is matrix of 'cells' determined by the intersection of 'columns' and 'rows'

4 A macro is used to sort and filter data

I'm confused as to what you are asking about now. I answered your original question to the best of my ability and explained my reasoning.

Now you use the terms "previous question paper" and "previous question" and posted a different list of choices.

Frankly, I don't know what question you are referring to or what you want my help with at this point.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

The 2 questions come from 2 different question papers. Thank you for your help. I am satisfied with your first answer and I agree with you.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History