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

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม