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

さんの投稿です
印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?