Latest:
LinkedIn Microsoft Excel Certification 

What is the difference between pressing the delete key and using the clear command in the Home tab’s Editing group?

Editorial Staff
  • deletes removes the entire column or row. Clear removes the content from the column or row
  • deletes removes formulas, values and hyperlinks. clear removes formulas, values, hyperlinks, formats, comments and notes
  • Delete removes the cell itself, shifting cells either up or to the left. Clear removes content and properties but does not muves cells
  • Delete removes formulas and values. clear removes formulas, values, hyperlinks, formats, comments and notes

The correct answer is:

  • deletes removes formulas, values and hyperlinks. clear removes formulas, values, hyperlinks, formats, comments and notes

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

How can you drill down into a PivotTable to show details?

Editorial Staff 0

You want to add a column to the PivotTable below that shows a 5% bonus for each sales rep. That data does not exists in the original data table. How can you do this without adding more data to the table?

Editorial Staff 0

How would you search an entire workbook with Find & Select?

Editorial Staff 0