Excel Icon Is A Squared Symbol How To Use It
Sheet2A1 Ctrl strange button (strange button is found just below Esc key with 3 symbols on it) This shows all formulas on a worksheet These are all used in calculations and formulas in Excel and they are covered in more detail on our Basic and Intermediate Excel 1 day courses. We hope you find this table useful Let us know what you think SymbolFeature Description This is an equals sign and is used at the beginning of a formula This is an addition sign and is used in sums and formulas - This is a subtraction sign and is used in sums and formulas This is a division sign and is used in sums and formulas This is a multiplication sign and is used in sums and formulas ( ) These are rounded brackets and are used to group together smaller sums in more complex formulas: This is a colon and is used in a formula to create a range of cells (e.g.Ī2:B4), This is a comma and is used for separating cell references in formulas (often for non-adjacent cells) This is a dollar sign and is used when creating absolute references This is a percentage sign and is used when dealing with figures in percentages These are square brackets and are used for identifying a workbook which is being linked in to a formula e.g.īook1Sheet1A1 This is an exclamation mark and is used for identifying a worksheet which is being linked in to a formula e.g. So we thought we would share this table with you all that we put together of some of the common used basic symbols in Excel.
Excel Icon Is A Squared Symbol How To Use Itīut have you ever been in a situation where you have clicked into a cell, exposed the formula and panicked at what you saw All those symbols jumbled together and not knowing what they mean Dont worry, it happens to us all So because of this, we decided to put a table into our Basic course as a bit of a Glossary to help when you start off learning about Excel Some of you would have been on our Basic Excel course and seen this table in your course notes you took away with you, however some of you wouldnt have seen it.