Microsoft Excel Basics

What is the procedure to select a range of cells in a worksheet?

Click the first cell, hold down the Shift key, and then click the last cell

How do you deselect a range of cells?

Press any arrow key or click any cell in the worksheet

What is the shortcut to select nonadjacent cells or ranges?

Hold down the Ctrl key

How do you select a single row or column?

Click the header of the row or column Signup and view all the answers

What is the purpose of pressing the Esc key during editing?

To return the cell to its previous state Signup and view all the answers

What is the procedure to select multiple adjacent rows or columns?

Click the header of the first row or column, hold down the Shift key, and then click the header of the last row or column Signup and view all the answers

How can you undo an action in Excel?

By clicking the Undo button on the Quick Access toolbar or by pressing Ctrl + Z Signup and view all the answers

How do you select multiple nonadjacent rows or columns?

Hold down the Ctrl key and click the headers of the rows or columns Signup and view all the answers

What is the function of the Clipboard group on the Home tab?

To access temporary storage area Signup and view all the answers

How do you move a cell to a new location?

Select the cell, click the Cut button, and then click the Paste button Signup and view all the answers

What is the purpose of the Font group on the Home tab?

To contain the most commonly used formatting commands Signup and view all the answers

What is the result of pressing the Backspace key while editing?

Deletes the character to the left of the cursor Signup and view all the answers

How can you change the font size of a cell?

By clicking the Font button on the Home tab and selecting a font size Signup and view all the answers

What is the purpose of the Number group on the Home tab?

To contain the most commonly used commands for formatting numbers Signup and view all the answers

What is the purpose of pressing the Enter key after editing?

To save the changes made Signup and view all the answers

How do you copy a cell?

Select the cell, click the Copy button, and then click the Paste button Signup and view all the answers

How can you remove all borders from a selected cell?

By clicking the Borders arrow and selecting No Border on the menu Signup and view all the answers

What is the shortcut key to redo an action in Excel?

Ctrl + Y Signup and view all the answers

What is the primary function of the Alignment group in the Home tab of the Ribbon?

To change the horizontal and vertical alignment of cell contents Signup and view all the answers

What is the effect of clicking the Centre button in the Alignment group?

The cell contents are centred horizontally within the cell Signup and view all the answers

What is the purpose of indenting data in a cell?

To indicate a level of less importance Signup and view all the answers

How do you indent data in a cell?

By clicking the Increase Indent button Signup and view all the answers

What is the effect of clicking the Align Right button in the Alignment group?

The cell contents are aligned with the right edge of the cell Signup and view all the answers

What is the function of the Top Align button in the Alignment group?

To align the cell contents with the top edge of the cell Signup and view all the answers

What is the purpose of rotating data in a cell?

To label narrow columns or add visual impact Signup and view all the answers

How do you restore the data to its default orientation after rotating it?

By clicking the Orientation button and selecting the currently selected orientation Signup and view all the answers

What happens to the row height when you wrap data within a cell?

It increases Signup and view all the answers

What is the result of merging cells with data in more than one cell?

The data in the upper-left cell remains Signup and view all the answers

Where is the Orientation button located?

In the Alignment group on the Home tab Signup and view all the answers

What is the purpose of wrapping data within a cell?

To display data on multiple lines within a cell Signup and view all the answers