Correct Answer: =SUMIF(A1:A100,">"&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
Which is the proper vba naming convention for a macro?
When I have selected a column, what is the shortcut I can use to completely delete it?
Imagine a leaderboard of 1000 players. Column A shows player rankings, B their names and C their points. You want to sum the points of the top X players, where X is defined in D1. What is the correct formula?
If A1 is '=4*2' and B1 is '=6/2', what result would appear if C1 was '=A1(#)B1
You've selected a range of sales data that has categories across the top row of the columns. How can you get filter buttons on this row, and alternate-row striping for the data?
To convert fluid ounces to milliliters you can use the following function:
Which formula returns the sum of the three smallest values in a range named Data?
To prevent yourself or others from accidentally deleting formulas or other critical data you can use:
Information Rights Management (IRM) allows individuals and administrators to specify access permissions to documents, workbooks, and presentations. This helps prevent sensitive information from being printed, forwarded, or copied by unauthorized people. IRM cannot help with the following though:
Which of the the following formulas will get the Last Name from name?