Excel Basics Quiz

Questions and Answers

Match the Excel action with the correct mouse action:

Select one cell = click once in the cell Select entire row = click the column label Select entire column = click the row label Select entire worksheet = click the whole sheet button

Match the Excel action with the correct method:

Select a cluster of cells = drag mouse over the cells or hold down the SHIFT key while using the arrow keys Select entire row = click the row label Select entire column = click the column label Select entire worksheet = click the whole sheet button

Match the Excel feature with its purpose:

Cut, Copy, and Paste commands = move or copy entire cells or their contents Cell range = formatting cells Moving border = displaying errors Worksheet = organizing data

Match the Excel action with the correct result:

Press ESC = cancel a moving border Click the whole sheet button = select entire worksheet Click the row label = select entire column Click the column label = select entire row Signup and view all the answers

Match the Excel concept with its description:

Cell range = a group of adjacent cells Cluster of cells = selecting multiple columns or rows Worksheet = a collection of cells Entire worksheet = selecting all cells Signup and view all the answers

Match the Excel task with the correct procedure:

Select a range of cells = move to the first cell, click-and-hold the left mouse button, and drag to the last cell Modify a spreadsheet = use the Cut, Copy, and Paste commands Create a spreadsheet = use the following processes to assist when creating a spreadsheet Format cells = select the cells, then use the formatting options Signup and view all the answers

Match the Excel shortcut with its purpose:

SHIFT key = selecting a cluster of cells Arrow keys = moving the cursor ESC key = canceling a moving border Left mouse button = selecting a range of cells Signup and view all the answers

Match the Excel action with the correct result:

Click the row label = select entire row Click the column label = select entire column Click the whole sheet button = select entire worksheet Drag mouse over the cells = select a cluster of cells Signup and view all the answers

Match the Excel concept with its purpose:

Cell management = organizing and modifying cells Worksheet organization = arranging data in a spreadsheet Formula editing = creating and modifying formulas Basic shortcuts = using shortcuts to perform tasks efficiently Signup and view all the answers

Match the Excel feature with its purpose:

Animated moving border = displaying cells that have been cut or copied Cell range = performing operations on multiple cells Worksheet = organizing data into rows and columns Excel navigation = moving around the spreadsheet quickly Signup and view all the answers

Study Notes

Excel Basics

The Name Box shows the address of the current selection or active cell.
The Formula Bar displays information entered or being entered as you type in the current or active cell, and allows editing of cell contents.

Cells

A cell is the most basic part of an Excel document, holding a piece of data at the intersection of a column and row.

Navigation buttons allow movement to another worksheet in an Excel workbook.
Sheet tabs separate a workbook into specific worksheets, with a default of three worksheets.
A Workbook must contain at least one worksheet.

Moving around the worksheet

To activate a cell, point to it with the mouse and click.
To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys.
To move to another worksheet, click on the sheet tab (Sheet1, Sheet2 or Sheet3) that you want to display.

Renaming a worksheet

To rename a worksheet, use one of the following methods:
- In the CELLS group of the Home tab, choose FORMAT, and select RENAME SHEET.
- Double-click the Sheet Tab.
- Right-click the tab for the worksheet you want to rename and choose Rename from the shortcut menu.

Create, Open and Save Workbooks

To create a new blank workbook:
- Click the File tab.
- Select New.
- Select Blank workbook under Available Templates.
- Click Create.
To open an existing workbook:
- Click the File tab.
- Select Open.
- Select your desired workbook, then click Open.
To save a worksheet, use one of the following methods:
- Click the SAVE button in the Quick Access toolbar.
- Press F12 to open the Save As dialog box.
- Click FILE tab and from the menu, select SAVE or SAVE AS command.

Enter, Edit and Delete Data

Entering Text in a Cell:
- Enter various kinds of data in a cell, including numbers, text, and scientific notation.
- Excel displays scientific notation automatically if a number is too long to be viewed in its entirety in a cell.
Selecting a Range of Cells:
- Move to the first cell in the range.
- Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.
- Release the mouse button.

Modifying Spreadsheets

To create an understandable and professional document, make adjustments to cells, rows, columns, and text using processes such as Cut, Copy, and Paste Data.
Use the Cut, Copy, and Paste commands to move or copy entire cells or their contents.