Ribbon tab - the top tool-bar of the Excel Sheets Formula bar - the bar below the Ribbon Tab of the excel sheet Status bar - the bottom most tool bar where you can zoom in and zoom out of an excel sheet Excel workbook - A sheet of an excel, where it is made up of Rows and columns - it has about some 1,048,576 ROWS and 16,384 COLUMNS Upto 256 Sheets can be added for Excel to optimally work, but then the limit on the number of sheets that can be added totally depends on the Processing power of the CPU To change the number type format · Home -> number format -> change the type of number format Relative reference It refers to the way by which Cells across another locations can be referenced and used from some other cell position - Example as given below, Values from B4 to B8 can be referenced and added in another totally different position ABSOLUTE REFERENCE - When some cells are referenced by absolu...
A Data Science Blog