Excel Basics for Grade 5

What does the SUM function do in Excel?

• Subtracts the numbers in a range of cells.

• Adds up all the numbers in a range of cells.

• Multiplies all the numbers in a range of cells.

• Divides the numbers in a range of cells.

How is the AVERAGE function used in Excel?

• Select the cell, type =AVERAGE(range of cells), press Enter

• Click on the cell, type =AVERAGE(range of cells), press Enter

• Use the AVERAGE button in the toolbar

• Type =SUM(range of cells) instead of =AVERAGE(range of cells)

Explain the purpose of the MAX function in Excel.

• The MAX function calculates the average of a set of values.

• The MAX function finds the smallest value in a set of values.

• The MAX function is used to count the number of cells in a range.

• The MAX function in Excel is used to find the largest value in a set of values.

When would you use the MIN function in Excel?

• When you want to calculate the average of a range of cells.

• When you want to find the largest value in a range of cells.

• When you want to count the number of cells in a range.

• When you want to find the smallest value in a range of cells.

What does the COUNT function count in Excel?

• colors in a range

• formulas in a range

• numbers in a range

• text in cells

How is the IF function structured in Excel?

• =IF(logical_test, value_if_false, value_if_true)

• =IF(logical_test, value_if_true, value_if_false)

• =IF(value_if_true, logical_test, value_if_false)

• =IF(value_if_false, logical_test, value_if_true)

What is the purpose of the VLOOKUP function in Excel?

• To insert a new row in a worksheet

• To change the font style of a cell

• To search for a value in a table and return a corresponding value from another column.

• To calculate the sum of a range of cells

How can you work with Date & Time functions in Excel?

• Use functions like TODAY(), NOW(), DATE(), TIME(), YEAR(), MONTH(), DAY(), HOUR(), MINUTE(), SECOND(), etc. in Excel.

• Use functions like YESTERDAY(), LATER(), EARLIER(), etc. in Excel.

• Manually input the date and time values in each cell in Excel.

• Ignore Date & Time functions and use only basic arithmetic operations in Excel.

How do you join text and numbers in Excel?

• Combine text and numbers manually without any specific function in Excel.

• Utilize the SUM function or '/' operator in Excel.

• Use the AVERAGE function or '-' operator in Excel.

• Use the CONCATENATE function or '&' operator in Excel.

Give an example of a formula in Excel.

• =MAX(A1:A10)

• =IF(A1>10, B1, C1)

• =AVERAGE(A1:A10)

• =SUM(A1:A10)