TERM 2 MS EXCEL QUIZ 1

Using Autosum in Excel, explain the steps to calculate the sum of a range of cells.

• Click on the cell where you want the sum to appear, then click on the 'AutoSum' button in the 'Editing' group on the 'Home' tab. Excel will automatically select what it thinks is the range of cells you want to sum. If it's correct, press Enter to accept the formula. If it's not correct, click and drag to select the correct range of cells, then press Enter.

• Click on the cell and press 'Delete' key

• Click on the 'AutoSum' button and then press 'Ctrl + A'

• Click on the cell and type 'SUM' manually

How do you calculate the total of a column in Excel using the SUM function?

• =SUM(range)

• =minus(range, range)

• =plus(range

• =keep adding(range)

In Excel, how do you find the minimum value in a range of cells?

• SUM(range)

• AVERAGE(range)

• MIN(range)

• MAX(range)

What is the significance of using the MIN function in Excel?

• It is used to find the smallest value in a range of cells.

• It is used to format the cells in a specific way.

• It is used to find the largest value in a range of cells.

• It is used to calculate the average of a range of cells.

How can you determine the maximum value in a range of cells using Excel?

• MAX function

• SUM function

• AVERAGE function

• MIN function

Explain the importance of the MAX function in Excel.

• It is used to calculate the average of a range of cells.

• It has no specific function in Excel.

• It helps to find the lowest value in a range of cells.

• It helps to find the highest value in a range of cells.

How do you use the TODAY function in Excel to display the current date?

• =CURRENT_DATE()

• =TODAY()

• =NOW()

• =DATE()

Explain the concept of autofill in MS Excel.

• Autofill is a feature that allows users to automatically fill cells

• Autofill is a feature that allows users to automatically format cells

• Autofill is a feature that allows users to automatically sort cells

• Autofill is a feature that allows users to automatically delete cells

How can you use autofill to fill a series of dates in MS Excel?

• Use the copy and paste function to fill the dates

• Select the cell with the first date, then drag the fill handle across the cells where you want to autofill the dates.

How to add borders to a range of cells in MS Excel?

• Right-click on the cells and select 'Add Borders'

• Select the range of cells, go to the 'Home' tab, click on the 'Borders' drop-down menu, and choose the desired border style.