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

Spreadsheet Features 1

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

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

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

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