Excel - lesson and knowledge check.

Excel is a ...

• Spreadsheet software program

• Spreadsheet to work with data, and charts.

• Analysis tool

• Powerful data visualization

• 1,3,4 are correct.

Answer explanation

Correct

Excel is a spreadsheet software program, analysis tool and powerful data visualization.

​ (a)   ​ is an action that CANNOT be reversed using the Undo command​.

• Deleting a tab in the workbook
• Typing over the contents of a cell in a workbook
• Deleting 20 rows of data in the workbook.
• Deleting a column in the workbook

Answer explanation

Correct

The Undo feature does not apply to modifying tabs in the workbook, which includes deleting and renaming the tab.

Which action will edit locked cells in a protected worksheet?

• Highlight the data, right-click, and then select Unlock.

• Use Save As to create a new worksheet, and then make your edits.

• Unlock the cells in which you are interested.

• Enter the password to turn off the protection.

Answer explanation

Correct

Before you can edit, you must enter the password to unlock the protected sheet.

What is the difference between a workbook and worksheet?

• Workbook and worksheet are terms that can be used interchangeably and are Excel files.

• A workbook is a collection of Excel files and a worksheet is an individual file.

• A worksheet is the file and a workbook is the individual tab within the worksheet.

• A workbook is the file and a worksheet is the individual tab within the workbook

You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products? ​ ​ (a)  

• by typing =d5-d6
• By typing d5-d6
• by typing 400-250
• By typing 400-250
• By typing =400-250

Answer explanation

Correct

This creates a formula you can drag across other products using the fill handle.

One of the number cells in your worksheet shows as ###. What does this mean?

• The cell is empty in a row of cells filled with content.

• There is a division-by-zero error in the cell contents calculation.

• The content in the cell is wider than the cell width.

• The number you entered in the cell is larger than 1,000.

Answer explanation

Correct

The correct display will reappear if the cell is made larger to accommodate the display.

What is the first step in creating a chart with Excel Office 365? ​ ​ (a)  

• Highlight the data you want to show in the chart.
• Insert a row of empty cells beneath the title.
• Create totals for each row and each column.
• Select the chart type you are interested.

Answer explanation

Correct

The first step in creating a chart is telling Excel the data from which you want the chart to be created.