Mastering Microsoft Excel

What is the shortcut key for entering data in a cell?

• Ctrl

• Tab

• Enter

• Shift

How can you quickly fill a series of numbers in Excel?

• Use the fill handle to drag and fill a series of numbers.

• Select the entire column and press delete.

• Copy and paste the numbers from another document.

• Use the formula bar to enter numbers manually.

What does the VLOOKUP function do in Excel?

• The VLOOKUP function searches for a value and returns a value in the same row from a specified column.

• The VLOOKUP function sorts data in ascending order.

• The VLOOKUP function creates a pivot table from selected data.

• The VLOOKUP function formats cells based on their values.

Which formula would you use to calculate the average of a range of cells?

• MAX(range)

• AVERAGE(range)

• COUNT(range)

• SUM(range)

How can you enter the same data in multiple cells at once?

• Select a single cell, type the data, and press Enter.

• Highlight the entire column, type the data, and press Shift + Enter.

• Right-click on the cells, choose 'Paste', and enter the data.

• Select multiple cells, type the data, and press Ctrl + Enter.

How do you create a formula that adds values from different cells?

• =ADD(A1, B1, C1)

• =TOTAL(A1, B1, C1)

• =SUM(A1, B1, C1)

• =SUM(A1 + B1 + C1)

What function would you use to count the number of cells that contain numbers?

• AVERAGE

• SUM

• MAXIMUM

• COUNT

What function would you use to find the maximum value in a range of cells?

• MAXIMUM(range)

• HIGHEST(range)

• MAX(range)

• TOP(range)

What function would you use to find the average of a set of numbers in Excel?

• AVERAGE(range)

• MEAN(range)

• AVG(range)

• MEDIAN(range)

What function would you use to find the minimum value in a range of cells?

• MINIMUM(range)

• LOWEST(range)

• MIN(range)

• LEAST(range)