Basic Excel

______ is a collection of cells in Excel.

• Cell

• Array

• Workbook

• Worksheet

In which tab in the Menu Bar can you find the Sort, Filter, and Remove Duplicates functions in Excel?

• Formula tab

• Insert tab

• Home tab

• Data tab

Cell A1 = Enhanced

Cell A2 = Community

Cell A3 = Quarantine

Cells A1 to A3 contain string values as stated above. Cell A4 should contain a combined string from these cells (i.e. Enhanced Community Quarantine).

Write the formula to type in cell A4 to get this output. Start with an equal sign.

What is one main difference between the syntax of SUMIF and SUMIFS?

• SUMIF does not need a range as an input

• SUMIF needs the sum_range as the first input;

  SUMIFS needs the sum_range as the last input

• SUMIF needs the sum_range as the last input;

  SUMIFS needs the sum_rang as the first input

Complete the steps when referring to a named array:

1. Select the same number of cells as the named array.

2. Type = followed by the defined name of the array.

3. Press ______________________.

• Enter

• Shift + Enter

• Ctrl + Shift + Enter

• Ctrl + Alt + Enter