SORT - Arranges data in a specific order, either ascending or descending., FILTER - Displays only the rows that meet certain criteria, hiding the others., VLOOKUP - Searches for a value in the first column of a table and returns a value in the same row from a specified column., sum - Adds all the numbers in a range of cells., AVERAGE - Calculates the mean value of a group of numbers., IF - Performs a logical test and returns one value if the condition is true and another value if it is false., CONDITIONAL FORMATTING - Changes the appearance of cells based on specific conditions or criteria., DATA VALIDATION - Restricts the type of data or the values that users can enter into a cell., CHARTS - Graphical representations of data that make it easier to visualize and understand trends and patterns., AND - Returns TRUE if all the arguments evaluate to TRUE, and FALSE otherwise.,

Microsoft Excel- Activity 2

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?