Correct Answer: =IF(A2>0,1,0)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
The Quick Access toolbar does which of the following?
In which tab is located the Proofing group?
When a cell containing a formula is copied and then pasted into a new cell, Excel:
Which command locates values in a worksheet?
At the bottom of column C, you have a simple total formula. You want to reuse it with the values in column D, so you copy and paste. What must you do with the formula after pasting?
By default, the pivottable report uses the ____ function for numbers in the values area.
All of the following are vertical alignment options except ____
A(n) ____________________ conveys a visual representation of data.
A(n) ____ is a group of cells in a rectangular block
A(n) ____ is a built-in formula that uses arguments to calculate information