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?

If A1=4.33, B1=6.111, and C1=26.5, then entering =A1:C1, when will return the answer ____ .

A Shared Workbook will allow users to do all of the following except:

Suppose you wanted A1, a non-whole number, to round up to the nearest whole number. What function(s) would NOT work?

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?

If the Formula cannot return a legitimate result or an inappropriate argument in a function, you will get the following error?

If the Formula cannot return a legitimate result or an inappropriate argument in a function, you will get the following error?

Address of last cell in range as following formula?