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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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

status | not read | reprioritisations | ||
---|---|---|---|---|

last reprioritisation on | suggested re-reading day | |||

started reading on | finished reading on |

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>