Return to IFS 105 Notes! Show Excel
Creating a Worksheet and Embedded Chart What Is Excel ? 4 Major Parts The Workbook
The Worksheet
The Worksheet
Worksheet Window Note: worksheet is 256 columnsand 65,536 rows(16,777,216 cells)
Menu Bar
Standard and Formatting Toolbar
Status Bar
Speech Recognition and Speech Playback
2 ways to display Language bar
3 Kinds of Cell Entries
Data and Functions
Using the Fill Handle to Copy a Cell to Adjacent Cells
Table Formats and Charts
Saving Options
AutoCalculate Statistics
2 Ways to Correct Errors
4 Ways to Clear a Range of Cells
Computer Assignment 4 Return to IFS 105 Notes! What displays the cell reference of the active cell in Excel?The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells. To name a cell or range, highlight the cell or range you would like to name, type the name in the Name box, and press ENTER.
What part of the Excel screen displays the contents of the active cell?Name Box: The name box appears to the left of the formula bar and displays the name of the current cell. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.
What is the data that is shown in the formula bar?The formula bar shows the content of the cell that is active or selected in Excel. If the active cell has text or a number in it, then this is shown in the formula bar. You can use the formula bar to edit the content of the cell instead of editing the content directly in the cell.
Where in Excel address of an active cell is displayed?Detailed Solution
The address of the Current Active Cell is displayed in the Cell Name box. Data or Formula of Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar.
|