Excel Features and Functions Quiz

In Excel, the sort feature allows you to arrange data in ascending or descending order.

• ascending

• descending

To sort data alphabetically from A to Z, we use the Ascending sort option.

• Ascending

• Descending

To select an entire worksheet, you can press the keyboard shortcut Ctrl+A or click the Select All button.

To select non-adjacent rows or columns, you should hold down the Ctrl key while making your selections.

To enter a number like '01481' and prevent Excel from dropping the leading zero, you must type an apostrophe before the number, which treats it as text.

Cell content can be modified by either replacing the content directly or by using the edit mode.

The undo command is used to cancel your last action. Its keyboard shortcut is Ctrl+Z.

To insert new cells, you must first click the Insert option, which is located in the cells group on the home tab.

A range is defined as a group of contiguous cells forming the shape of a rectangle.

To change the row height or column width, you click on the format option from the cells group on the Home tab.