Excel Intermediate 1

If we do not select the entire table before sorting, will the row sorting be appropriate for the following table?

• Yes, Excel considers the table as a 16-row table.

• No, due to the empty row, Excel considers the data as two separate tables.

When deleting sorting levels, do we get back to the original table state - what we had before the sorting?

• No, but Excel saves the before sorting state in an additional table.

• No, the table remains in the sorted state after deleting a level.

• Yes, the table automatically reverts back to the original unsorted state.

• Yes, we can manually restore the table to its original state using the Sort Wizard.

Which sorting levels should we set for the table to achieve the following appearance?

• 1. level: Seller A-Z order

  2. level: Green fill color on top

• 1. level: City A-z order

  2. level: Red font color on bottom

• 1. level: Income largest-to-smallest order

  2. level: Seller A-Z order

• 1. level: Green fill color on top

  2. level: Red font color on bottom

We would like to set up a simple sort (A to Z) for the table based on column A. How can we do that?

• Click to the Column A and click to A-Z sorting button.

• Select the sortable range first (A4:F17), then open the sorting window and create the sort level.

• Select the entire table then open the sorting window and set the sort level.

• Turn on the Filter and from the drop-down list at Column A select the A-Z button.

When filtering a table by multiple columns, can we set up an OR logical connection between the columns (between the criterias)?

• Yes, we can set OR connection between separate column conditions.

• Yes, we can create a logical OR by negating the AND connection.

• No, with the simple filtering just the AND connection is possible between the different columns.

Based on which column(s) is the table filtered?

• Column A

• Column E

• Column A and Column E

• All of the columns

What is the keyboard shortcut for Filtering?

• Ctrl + L

• Shift + L

• Ctrl + Shift + L

• Alt + L

What formula should we write in cell E2 to get the total?

• C2*D2

• =D2*C2

• =C2*D3

• =C2xD2

A formula contains a reference to B4, how does it change when copied down?

• B4

• B5

• C4

• $B$4

What is the keyboard shortcut for Locking cells (insert $)?

• F2

• F4

• F8

• F12