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

oleh
Cetak
Menyematkan

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

Pulihkan simpan otomatis: ?