Edited, memorised or added to reading list

on 02-Jan-2023 (Mon)

Do you want BuboFlash to help you learning these things? Click here to log in or create user.

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.

statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




Formulas are mathematical expressions that calculate the value of cell contents.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




Firstly, a function is a pre-defined formula and a quick way to enter certain calculations.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




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.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




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.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




cell references are included in formulas using the column first and row number format.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




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.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




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
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

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




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.
statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

Unknown title
ure 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 <span>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. Edit Delete <span>