Central Administration Page Science Education Resource Center | Carleton College

## SERC Vocabularies

These controlled vocabularies are under development at SERC. They vary widely in terms of refinement and the degree to which they have been tested with users. None represents a finished product. Caveat emptor.

## SSAC Excel Skills

• Basic Arithmetic
65:1 end
• Simple Formulas
65:1 65:8 end
• Nested Formulas
65:1 65:9 end
• Arithmetic Functions
65:1 65:10 end
• SUM
65:1 65:10 65:48 end
• PRODUCT
65:1 65:10 65:49 end
• SUMPRODUCT
65:1 65:10 65:50 end
• QUOTIENT
65:1 65:10 65:51 end
• Percent (format)
65:1 65:11 end
• Angles and Trig Functions
65:2 end
• PI
65:2 65:12 end
65:2 65:13 end
• SIN, ASIN
65:2 65:14 end
• COS, ACOS
65:2 65:15 end
• TAN, ATAN, ATAN2
65:2 65:16 end
• Other Elementary Math Functions
65:3 end
• ABS
65:3 65:17 end
• SIGN
65:3 65:18 end
• SQRT
65:3 65:19 end
• EXP
65:3 65:20 end
• LOG, LOG10
65:3 65:21 end
• LN
65:3 65:22 end
• POWER
65:3 65:23 end
• Statistical Functions
65:4 end
• One array
65:4 65:24 end
• COUNT, COUNTA
65:4 65:24 65:52 end
• AVERAGE
65:4 65:24 65:53 end
• GEOMEAN, HARMEAN
65:4 65:24 65:54 end
• MEDIAN
65:4 65:24 65:55 end
• STDEV, STDEVP, etc
65:4 65:24 65:56 end
• VAR, VARP, etc
65:4 65:24 65:57 end
• MAX, MIN, etc
65:4 65:24 65:58 end
• LARGE, SMALL, etc
65:4 65:24 65:59 end
• MODE
65:4 65:24 65:60 end
• QUARTILE
65:4 65:24 65:61 end
• PERCENTILE
65:4 65:24 65:62 end
• Two arrays
65:4 65:25 end
• CORREL
65:4 65:25 65:63 end
• COVAR
65:4 65:25 65:64 end
• INTERCEPT
65:4 65:25 65:65 end
• TREND
65:4 65:25 65:66 end
• SLOPE
65:4 65:25 65:67 end
• LINEST
65:4 65:25 65:68 end
• GROWTH
65:4 65:25 65:69 end
• Logic Functions
65:5 end
• IF
65:5 65:26 end
• AND
65:5 65:27 end
• OR
65:5 65:28 end
• NOT
65:5 65:29 end
• TRUE
65:5 65:30 end
• FALSE
65:5 65:31 end
• COUNTIF
65:5 65:32 end
• SUMIF
65:5 65:33 end
• Graphs and Charts
65:6 end
• XY Scatterplot
65:6 65:34 end
• One Plot
65:6 65:34 65:70 end
• Multiple Plots
65:6 65:34 65:71 end
• Trendlines
65:6 65:34 65:72 end
• Error Bars
65:6 65:34 65:73 end
• Log Scale
65:6 65:34 65:74 end
• Pie Chart
65:6 65:35 end
• Bar Graph
65:6 65:36 end
• Clustered
65:6 65:36 65:75 end
• Stacked
65:6 65:36 65:76 end
• Line Graph
65:6 65:37 end
• Other Manipulations and Functions
65:7 end
• ROUND, ROUNDUP, ROUNDOWN
65:7 65:38 end
• Data/Sort
65:7 65:39 end
• Pivot Table, Pivot Chart
65:7 65:40 end
• Conditional Formatting
65:7 65:41 end
• Lookup Functions
65:7 65:42 end
• Financial Functions
65:7 65:43 end
• Day/Time Functions
65:7 65:44 end
• MDETERM
65:7 65:45 end
• Other Matrix Functions
65:7 65:46 end
• RAND, RANDBETWEEN
65:7 65:47 end

Problems? Questions? Contact sfox@carleton.edu