Module 1.2 - Mastering Range Names
Автор: Data Won't Save You
Загружено: 2021-10-23
Просмотров: 88
Описание:
Defined name - a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it's called a named range, or defined range. These names are subject of today's tutorial.
For instance, to find the total of sales (B2:B13) for a specific item (E1), you can use the following formula:
=SUM($B$2:$B$13)
Or, you can give meaningful names to the ranges and individual cells and supply those names to the formula:
=SUM(Sales)
Download Class Notes here: https://www.opencastlabs.co.ke/module...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: