![]() Sum – It does what the word suggests, sums up all the numeric values.Average – It averages all the non-empty cells from columns/rows.(irrespective of data type Numeric/Character). Count – It counts the number of non-empty cells from columns/rows.Some statistical/mathematical options exist for a quick calculative view of the numeric data in the Excel status bar. Once you click on zoom percentage, the zoom dialog box opens, from where you can select the magnification percentage for a current worksheet.It is situated next to the zoom slider on the left-hand side of the status bar.Zoom percentage can also magnify the worksheet and be considered to function the same as that of the Zoom slider.See the below sample image for your reference. Zoom Out helps you reduce the worksheet’s magnification, and you can see more data in a single shot. Using Zoom In, you can magnify the current worksheet and look closely at the data. Moreover, it has (+) (-) keys that can be used for “ Zoom In ” and “ Zoom Out “, respectively.The zoom slider lets you quickly zoom in or out of the Excel worksheet you are working on.If you are working on Excel frequently, you might be well know to this option which is provided at the rightmost corner of the status bar.Please see the attached sample image for your reference. ![]() Point – It gets activated when the user enters a formula in a cell while providing other cells (which have data in them) as input to the formula. It is displayed when the user double-clicks the cell or presses F2 once. It means the cell is being edited (new data replace old data). ![]() Word entered itself suggests that input entering has been started.Įdit – It is quite like Enter. It can also consider as in the general state, where the cell has no input data.Įnter – It means that the user has either started typing the data in the cell or pressed F2 twice to edit the cell. Ready –It means the cell on which you have your cursor is ready to take user input from you. The “Cell Mode” option is enabled by default in excel and can be seen at the extreme left side of the status bar. This tutorial will cover default options enabled in the Excel status bar and additional options that can add and prove useful. Note : If you want to come out of the Customized status bar, simply click anywhere in the sheet outside the popped-up menu.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |