Podcast
Questions and Answers
Match the Excel action with the correct mouse action:
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:
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:
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:
Match the Excel action with the correct result:
Signup and view all the answers
Match the Excel concept with its description:
Match the Excel concept with its description:
Signup and view all the answers
Match the Excel task with the correct procedure:
Match the Excel task with the correct procedure:
Signup and view all the answers
Match the Excel shortcut with its purpose:
Match the Excel shortcut with its purpose:
Signup and view all the answers
Match the Excel action with the correct result:
Match the Excel action with the correct result:
Signup and view all the answers
Match the Excel concept with its purpose:
Match the Excel concept with its purpose:
Signup and view all the answers
Match the Excel feature with its purpose:
Match the Excel feature with its purpose:
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 and Sheet Tabs
- 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.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz covers the basic elements of an Excel document, including the Name Box, Formula Bar, and cells. It also touches on navigation buttons and sheet tabs.