Which area in an excel window allows entering values and formulas?

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

Which of the the following formulas will get the Last Name from name?

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:

To prevent yourself or others from accidentally deleting formulas or other critical data you can use:

Which formula returns the sum of the three smallest values in a range named Data?

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

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 is '=4*2' and B1 is '=6/2', what result would appear if C1 was '=A1(#)B1

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?

When I have selected a column, what is the shortcut I can use to completely delete it?