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 View as JSON

• 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