To sort data alphabetically from A to Z, we use the (a)   sort option.

To select an entire worksheet, you can press the keyboard shortcut (a)   or click the Select All button.

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

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

Cell content can be modified by either replacing the content directly or by using the (a)   mode.

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

Moved or copied data is temporarily stored in a memory location called the (a)   .

When you insert a blank cell using the 'Shift cells down' option, the existing cells are (a)   .

You can change the date format in excel from the (a)   dialog box.

The row height option can be selected from the drop-down menu of the (a)   button in the cells group.

(a)   is the easiest method to fill the consecutive data items automatically in the cells.

What is the difference between autofill and flash fill feature in excel?

How can you select non-adjacent rows/columns in excel?

Suppose you have entered the months Jan, Feb, Mar in three cells. How can you extend the list till Dec without typing each one manually?

You accidentally deleted a row of data. Which option will help you restore it? What shortcut key will you use?

A worksheet has a column with dates written as 12/05/2025. Your teacher wants them displayed as May 12, 2025. What steps will you take to change the format?

You have entered roll numbers in a column, but Excel is treating them as numbers (removing leading zeros). How will you ensure they are stored as text?

Identify the Excel tab and group for the below features.