Enter a formula in cell b10 to return a value of 35000 if the net profit after tax (cell b() is greater than or equal to 350000 or 1000 if it is not.

Step by step explanation:

Statement to be written in cell B10 :

IF ( B9 >= 350000 , 35000, 1000)

Formula:

IF ( logical_test ,  [value_if_true] ,  [value_if_false] )

logical_test = Net Profit After Tax (cell B9)

value_if_true = 35000

(if the Net Profit After Tax (cell B9) is greater than or equal to 350000)

    value_if_false = 1000

(if the Net Profit After Tax (cell B9) is lesser than 350000)

yes we can change both the color of the value of a cell as well as background color of a cell at the same time .

as we know that excel sheet consists of columns and rows.

and intersection of column and row is called cell.

we can change color of the cell and background of the cell at the same time.

hence the statement that

can a person change color of the cell and background of the cell at the same time is true.