# on 02-Jan-2023 (Mon)

#### Annotation 7558584470796

 Important notes for names Use valid characters — Always begin a name with a letter, an underscore character (_), or a backslash (\). Use letters, numbers, periods, and underscore characters for the rest of the name. Exceptions: You can’t use "C", "c", "R", or "r" for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box. Don’t use cell references — Names can’t be the same as a cell reference, such as Z$100 or R1C1. Don’t use a space to separate words — Spaces cannot be used in the name. Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Examples: DeptSales, Sales_Tax or First.Quarter. Maximum 255 characters — A table name can have up to 255 characters. Use unique table names — Duplicate names aren’t allowed. Excel doesn’t distinguish between upper and lowercase characters in names, so if you enter “Sales” but already have another name called “SALES" in the same workbook, you’ll be prompted to choose a unique name. status not read Rename an Excel table - Microsoft Support e shown in the Address bar, which appears to the left of the Formula bar. When you select any table from the list, Excel will automatically jump to that table—even if it's on another worksheet. <span>Important notes for names Use valid characters — Always begin a name with a letter, an underscore character (_), or a backslash (\). Use letters, numbers, periods, and underscore characters for the rest of the name. Exceptions: You can’t use "C", "c", "R", or "r" for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box. Don’t use cell references — Names can’t be the same as a cell reference, such as Z$100 or R1C1. Don’t use a space to separate words — Spaces cannot be used in the name. Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Examples: DeptSales, Sales_Tax or First.Quarter. Maximum 255 characters — A table name can have up to 255 characters. Use unique table names — Duplicate names aren’t allowed. Excel doesn’t distinguish between upper and lowercase characters in names, so if you enter “Sales” but already have another name called “SALES" in the same workbook, you’ll be prompted to choose a unique name. Rename a table in Excel for the web Note: This is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize the

#### Annotation 7558588927244

 Formulas are mathematical expressions that calculate the value of cell contents.

Unknown title
terial Week 1 Week 2 Week 3 Week 4 Week 5 Grades Notes Discussion Forums Messages Resources Course Info Notes Filter (Required) * All notes ​ A closer look at formulas and functions 0:34 - 0:39 <span>Formulas are mathematical expressions that calculate the value of cell contents. Edit Delete A closer look at formulas and functions 1:00 - 1:08 Firstly, a function is a pre-defined formula and a quick way to enter certain calculations. Edit Delete A closer look at

#### Annotation 7558591810828

 Firstly, a function is a pre-defined formula and a quick way to enter certain calculations.

Unknown title
loser look at formulas and functions 0:34 - 0:39 Formulas are mathematical expressions that calculate the value of cell contents. Edit Delete A closer look at formulas and functions 1:00 - 1:08 <span>Firstly, a function is a pre-defined formula and a quick way to enter certain calculations. Edit Delete A closer look at formulas and functions 3:16 - 3:30 When you create a formula with several operators, Excel evaluates and performs the calculations in a specific order. For

#### Annotation 7558593383692

 When you create a formula with several operators, Excel evaluates and performs the calculations in a specific order. For instance, Excel always performs multiplication before addition. This order is called the order of operator precedence.

Unknown title
at formulas and functions 1:00 - 1:08 Firstly, a function is a pre-defined formula and a quick way to enter certain calculations. Edit Delete A closer look at formulas and functions 3:16 - 3:30 <span>When you create a formula with several operators, Excel evaluates and performs the calculations in a specific order. For instance, Excel always performs multiplication before addition. This order is called the order of operator precedence. Edit Delete A closer look at formulas and functions 5:12 - 5:24 One easy way to remember precedence order is to remember the word BEDMAS, which stands for brackets or parenthesis, expon

#### Annotation 7558594956556

 One easy way to remember precedence order is to remember the word BEDMAS, which stands for brackets or parenthesis, exponents, division, multiplication, addition, and subtraction.

Unknown title
order. For instance, Excel always performs multiplication before addition. This order is called the order of operator precedence. Edit Delete A closer look at formulas and functions 5:12 - 5:24 <span>One easy way to remember precedence order is to remember the word BEDMAS, which stands for brackets or parenthesis, exponents, division, multiplication, addition, and subtraction. Edit Delete A closer look at formulas and functions 5:24 - 5:31 cell references are included in formulas using the column first and row number format. Edit Delete A closer look at formu

#### Annotation 7558596529420

 cell references are included in formulas using the column first and row number format.

Unknown title
member the word BEDMAS, which stands for brackets or parenthesis, exponents, division, multiplication, addition, and subtraction. Edit Delete A closer look at formulas and functions 5:24 - 5:31 <span>cell references are included in formulas using the column first and row number format. Edit Delete A closer look at formulas and functions 5:48 - 5:59 Cell references are naturally relative references which simply means that if a formula is moved or copied to another loca

#### Annotation 7558598102284

 Cell references are naturally relative references which simply means that if a formula is moved or copied to another location, Excel will change the references relative to its new location.

Unknown title
look at formulas and functions 5:24 - 5:31 cell references are included in formulas using the column first and row number format. Edit Delete A closer look at formulas and functions 5:48 - 5:59 <span>Cell references are naturally relative references which simply means that if a formula is moved or copied to another location, Excel will change the references relative to its new location. Edit Delete A closer look at formulas and functions 6:28 - 6:41 Absolute references use dollar signs before the cell or row to make sure a formula always references the same location, n

#### Annotation 7558599675148

 Absolute references use dollar signs before the cell or row to make sure a formula always references the same location, no matter where the formula is copied or moved to. You can assign absolute cell references in three ways

Unknown title
ly means that if a formula is moved or copied to another location, Excel will change the references relative to its new location. Edit Delete A closer look at formulas and functions 6:28 - 6:41 <span>Absolute references use dollar signs before the cell or row to make sure a formula always references the same location, no matter where the formula is copied or moved to. You can assign absolute cell references in three ways Edit Delete Create tables 1:07 - 1:23 A table is a specially designated range of information that has added functionality. If you need to analyze smaller sets of data within a large wor

#### Annotation 7558601248012

 A table is a specially designated range of information that has added functionality. If you need to analyze smaller sets of data within a large workbook or break down large sets of data into smaller parts, then converting your data into tables is often the best solution.