Basic Excel Skills

What is the shortcut to enter the current date in a cell?

• Shift + ;

• Ctrl + D

• Alt + ;

• Ctrl + ;

How do you create a formula to add the values in cells A1 and A2?

• =A1+A2

• A1-A2

• =SUM(A1,A2)

• A1*A2

Explain the steps to change the font color of a cell to red.

• Right-click on the cell and select 'Red' from the context menu

• Open the 'File' tab, select 'Options', and then choose 'Red' from the 'Font Color' settings

• Select the cell or range of cells, go to the 'Home' tab, click on the 'Font Color' drop-down arrow in the 'Font' group, and choose the color red.

• Go to the 'Insert' tab and choose 'Red Font' from the drop-down menu

What is the function to find the average of a range of cells?

• MAX

• AVERAGE

• COUNT

• SUM

Describe the process of creating a bar chart in Excel.

• Delete data, go to Format tab, click on Scatter Chart

• Select data, go to Insert tab, click on Bar Chart

• Highlight data, go to Home tab, click on Line Chart

• Copy data, go to View tab, click on Pie Chart

How do you enter a new row in an Excel spreadsheet?

• Use the 'Format' menu to add a new row

• Press the 'Delete' key

• Right-click on the row number and select 'Insert'

• Double-click on the row number

What is the shortcut to copy a cell's contents?

• Alt + A

• Shift + S

• Ctrl + C

• Ctrl + X

Explain the steps to apply a border around a range of cells.

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

• Right-click on the range of cells, select 'Format Cells', go to the 'Border' tab, and choose the desired border style.

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

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

What is the purpose of using the SUM function in Excel?

• To sort the values in a range of cells.

• To multiply the values in a range of cells.

• To find the average of the values in a range of cells.

• To add up the values in a range of cells.

Describe the process of creating a line chart in Excel.

• Select data, go to Home tab, click on Line Chart

• Select data, go to Insert tab, click on Line Chart

• Go to File tab, click on Line Chart

• Click on Line Chart, then select data