Answer to Question #259834 in Software Engineering for claire

Question

TRUE OR FALSE? 1.MICROSOFT EXCEL CAN PERFORM MATHEMATICAL EQUATIONS. 2.RANGE,CRITERIA,AND LOGICAL TEST ARE PART OF THE AVERAGEIF SYNTAX. 3.EXCEL FORMULAS ALWAYS BEGIN WITH A SIGN. 4.EXCEL CAN BE USED TO CREATE A DATABASE. 5.COLUMN J AND ROW 9 IS ALSO REFERRED TO AS CELL 9J. 6.AVERAGE FUNCTION USED TO GET THE AVERAGE OF A CERTAIN RANGE OF CELLS IF A CONDITION IS MET. 7.SUMIF FUNCTION ADDS ALL THE NUMERIC VALUES IN A RANGE OF CELLS IF A CONDITION IS MET. 8.BOTH "IF" AND AVERAGEIF CAN PERFORM A LOGICAL TEST. 9.ASTERISK(*) SYMBOL IS USED TO MULTIPLY ITEMS IN EXCEL. 10.SUMIF FUNCTION ADDS VALUES THAT MEET A GIVEN CRITERIA. 11.IF FUNCTION CAN HAVE TWO RESULTS. 12.FUNCTIONS ARE MATHEMATHECAL EQUATIONS THAT CALCULATES THE VALUE OF A CELL. 13.THE INTERSECTION OF ROWS AND COLUMNS IS CALLED CELL REFERENCE. 14.AVERAGEIF FUNCTION RETURNS THE ARITHMETIC MEAN OF ALL THE CELLS IN A RANGE THAT MEET A GIVEN CRITERIA. 15.IN EXCEL,THE ACTIVE CELL IS INDICATED BY AN UNDERLINE.

Answer 1

1 True

2 True

3 True

4 True

5 Wrong

6 True

7 True

8 True

9 True

10 True

11 True

12 True

13 True

14 True

15 Wrong