Excel Basics Skills Quiz

Which function in Excel is used to calculate the average of a range of cells?

• SUM

• AVERAGE

• MEDIAN

• MODE

Answer explanation

The correct function in Excel to calculate the average of a range of cells is AVERAGE.

Tags

DOK Level 1: Recall

How do you start a formula in Excel?

• By typing the cell address

• By typing an equal sign (=)

• By typing a plus sign (+)

• By typing a minus sign (-)

Answer explanation

By typing an equal sign (=)

Tags

DOK Level 1: Recall

Which of the following is the correct way to reference cell A1 in a formula?

• @A1

• #A1

• $A1

• A1

Answer explanation

The correct way to reference cell A1 in a formula is simply by using 'A1'. This is the standard notation for referencing cells in Excel formulas.

Tags

DOK Level 1: Recall

What is the shortcut key to save a workbook in Excel?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + P

Answer explanation

The shortcut key to save a workbook in Excel is Ctrl + S.

Tags

DOK Level 1: Recall

Which of the following is NOT a type of chart available in Excel?

• Line Chart

• Bar Chart

• Pie Chart

• Flow Chart

Answer explanation

The correct choice is 'Flow Chart' as it is NOT a type of chart available in Excel.

Tags

DOK Level 1: Recall

How can you quickly adjust the width of a column to fit its content?

• Double-click the right border of the column header

• Right-click the column header and select "Fit to Content"

• Use the "AutoFit" button in the toolbar

• Manually drag the column border

Answer explanation

To quickly adjust the width of a column to fit its content, you should double-click the right border of the column header.

Tags

DOK Level 2: Skill/Concept

Which function would you use to find the highest value in a range of cells?

• MIN

• MAX

• LARGE

• HIGH

Answer explanation

To find the highest value in a range of cells, you would use the MAX function. MAX returns the largest value in a set of values, making it the correct choice in this scenario.

Tags

DOK Level 1: Recall

What is the purpose of the VLOOKUP function in Excel?

• To look up a value in a vertical table

• To look up a value in a horizontal table

• To validate data in a cell

• To visualize data in a chart

Answer explanation

The purpose of the VLOOKUP function in Excel is to look up a value in a vertical table, making it the correct choice among the options provided.

Tags

DOK Level 2: Skill/Concept

How do you create a new worksheet in an Excel workbook?

• Click on the "File" menu and select "New Worksheet"

• Right-click on an existing worksheet tab and select "Insert"

• Click the "+" icon next to the existing worksheet tabs

• Use the shortcut Ctrl + N

Answer explanation

To create a new worksheet in an Excel workbook, click the '+' icon next to the existing worksheet tabs.

Tags

DOK Level 1: Recall

Which of the following is an example of a relative cell reference?

• A$1

• $A1

• A1

Answer explanation

The correct choice for a relative cell reference is A1, where the column and row are not fixed with dollar signs. This allows the reference to adjust when copied to other cells.

Tags

DOK Level 1: Recall