Which of the following is a Formula Auditing option? (9% of people got this correct)

Trace Precedents

Reconcile Totals

Conditional Formatting

What does the function =TRIM() do? (11% of people got this correct)

It rounds fractions to a specified number of decimal places

It strips out all spaces from text

It strips out extraneous spaces from before and after text

What is a Timeline? (12% of people got this correct)

A curve fitted to a set of data in an Excel chart

A log of Excel activity to allow actions to be undone or redone

A graphical way of filtering by date in a Pivot Table

What is the final argument 0 doing in this formula? =VLOOKUP(F7,B1:D5,3,0) (13% of people got this correct)

It’s an error, the formula will not work

It’s making sure the formula finds cells containing a 0 as well as a 3

It’s making sure only entries that EXACTLY match cell F7 are looked up

Why might grouping rows be preferable to hiding them? (13% of people got this correct)

Grouped rows have a symbol in the spreadsheet margin so it is clear when they are not displayed

Rows which are not adjacent can be grouped together

Grouped rows are automatically assigned a group ID, making reference to them easy

What is the syntax of the IF(A,B,C) function? (14% of people got this correct)

A and B are tested for equality, C is the result if they are equal

A is the condition, B is the result if the condition is not met, C is the result otherwise

A is the condition, B is the result if the condition is met, C is the flag for Boolean algebra

How could you ensure users entered only days of the week into a cell? (17% of people got this correct)

Use the function =WEEKDAY()

Format the cell as a custom date of syntax ddd

Define a Data Validation List consisting of weekdays

What would the formula =SUMIF(A1:A10,"Village",B1:B10) do? (22% of people got this correct)

It adds together the numbers in the ranges A1:A10, B1:B10 and the named range “Village”

For rows where column B cells contain the word Village, it adds up the numbers in column A

For rows where column A cells contain the word Village, it adds up the numbers in column B

What would have to have been set before the formula =SUM(Grid) would work? (22% of people got this correct)

A function called Grid, referring to some cells

An absolute reference called Grid, referring to some cells

A named range called Grid, referring to some cells

What does the character ^ do in an Excel formula? (23% of people got this correct)

Raises a quantity to a power (e.g. 3^2 is 3-squared)

Reformat the characters following it as superscript

Force characters following it to be interpreted as text rather than a number

Unlock and Upgrade