Excel Essentials: Navigating the Basics

How do you enter data into a cell in Excel?

• Double-click the cell and type the data

• Click the cell and type the data

• Right-click the cell and select 'Enter Data'

• Press the 'Enter Data' button on the toolbar

Which of the following is a correct formula to add cells A1 and B1?

• A1 + B1

• =ADD(A1, B1)

• =A1 + B1

• =SUM(A1, B1)

How can you apply bold formatting to cell contents?

• Press Ctrl + B with the cell selected

• Right-click the cell and choose 'Bold'

• Both A and B

• Select the cell and click 'Bold' in the Home tab

What function would you use to calculate the average of the numbers in cells A1 through A10?

• =AVERAGE(A1:A10)

• =AVG(A1:A10)

• =SUM(A1:A10)/10

• =MEAN(A1:A10)

How do you change the number format of a cell to currency?

• Right-click the cell, select 'Format Cells', and choose 'Currency'

• Go to the Home tab, click on the 'Number Format' dropdown, and select 'Currency'

• Both A and B

• Click on the 'Currency' button on the toolbar

What is the shortcut key to copy the contents of a cell?

• Ctrl + C

• Ctrl + X

• Ctrl + V

• Ctrl + P

Which of the following is not a chart type in Excel?

• Pie Chart

• Bar Chart

• Spider Chart

• Line Chart

How do you insert a new column to the left of column C?

• Right-click on column C and select 'Insert Column'

• Go to the Home tab, click 'Insert', and select 'Insert Sheet Columns'

• Both A and B

• Click on column C and press Ctrl + Shift + "+"

What formula would you use to find the lowest number in a range of cells from B1 to B10?

• =MIN(B1:B10)

• =LOWEST(B1:B10)

• =SMALLEST(B1:B10)

• =BOTTOM(B1:B10)

How can you quickly resize a column to fit the contents?

• Double-click the right border of the column header

• Drag the right border of the column header

• Right-click the column header and select 'AutoFit Column Width'

• Both A and C