Explanation

Delete a record

• Open the table in Datasheet View or form in Form View.
• Select the record or records that you want to delete. To select a record, click the record selector next to the record, if the record selector is available. 
• Press DELETE, select Home > Records > Delete, or press Ctrl+Minus Sign (-).

Explanation

The "Edit, Clear" command in spreadsheet software (like Microsoft Excel) allows you to remove different elements from selected cells, such as:

• Contents (values/data)

• Formats (cell formatting)

• Comments/Notes

However, it does not delete the cells themselves—it only clears their contents or attributes.

Explanation

The function key to quickly navigate to a specific cell in MS Excel is F5 or Ctrl+G.

These keys open the "Go To" dialog box, where you can enter the cell reference (e.g., B3) and press Enter to jump to that cell

Explanation

Filtering in Excel enables you to display rows that meet certain criteria, hiding the others.

This Excel feature allows you to display only the rows that meet specific conditions while hiding the others.

Explanation

COUNT function counts only numerical values in a selected range.

It ignores text, blank cells, and logical values (TRUE/FALSE).