The Conditional Formatting task pane provides everything you need for creating, editing, and deleting rules. Use to open the task pane and work with all the Conditional Formatting rules in a selection or a sheet. task pane opens and displays the rules, scoped to your current selection.

AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) The AVERAGEIFS function syntax has the following arguments: Average_range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers. Criteria_range1, criteria_range2, ….

Locate hidden cells on a worksheet. When you want to reveal cells that may reside in hidden rows or columns, it can be difficult to locate them. The approach is to first select all visible cells in the worksheet, which also will reveal hidden rows and columns.

本文將說明公式語法及MOD函數的使用方式，此函數會傳回數位除以除數后的餘數。. 結果的符號與除數相同.

需要在表格或区域中按行查找内容时，请使用 VLOOKUP。. 例如，按部件号查找汽车部件的价格，或根据员工 ID 查找员工姓名。. 在这一最简单的形式中，VLOOKUP 函数表示：. =VLOOKUP (要查找的内容、要查找的位置、包含要返回的值的范围内的列号、返回表示为 1/TRUE ...