- Study guides, Class notes & Summaries

C268 Spreadsheet Quizzes Correctly Solved 100% Adds the individual numbers or the numbers included in the range(s). *** SUM() Counts the number of cells in a range of cells that contain numbers. *** COUNT() Counts the number of cells in a range of cells that are not blank *** COUNTA() Calculates the simple average of a set of numbers *** AVERAGE() Returns the largest value in a set of numbers *** MAX() Returns the smallest value in a set of numbers *** MIN() Calculates the int...

-

9 pages

Written in 2023/2024

Grade A+

AceTests

Spreadsheet Model - -Represents the logic of a more complicated logical process through functions Absolute Cell Reference - -A cell reference that remains constant when a formula is pasted into a new cell, containing a $. Whenever possible, it is often best to use an absolute cell reference Algorithm - -The level of confidence that we want to have with our estimate. Calculated as 1, so 95% confidence is noted as .05(or 1-95%). Arguments - -The inputs of a function Arr...

-

4 pages

Written in 2024/2025

Grade A+

AlexScorer