Used in place of absolute cell reference, IFS, SUMIF, Named Cells, Conditional Formatting, Data can be filtered for specific criteria eg, sales in a particular region (drop-down), Named Cells, Pivot Table, Conditional Formatting, Filter, Asks questions, one by one, and gives instructions of what the software must do if the answer to the question is true, IFS, CountIF, CountBlank, Pivot Table, Counts how many cells meet a certain rule, CountIF, Filter, Named Cells, SUMIF, Counts how many cells are empty, SUMIF, Conditional Formatting, Filter, CountBlank, Adds together all the numbers relating to a value looked for, Named Cells, IFS, SUMIF, CountBlank, Automatically applies formats to cells that meet a certain rule eg bold all cells over £2,000, Conditional Formatting, Filter, SUMIF, CountIF, A tool that shows only the data that meets a criteria and hides the rest, CountIF, Named Cells, Filter, IFS

Spreadsheet Features 2

tarafından
Yazdır
Yerleştir

Skor Tablosu

Görsel stil

Seçenekler

Şablonu değiştir

Otomatik olarak kaydedilen geri yüklensin mi: ?