click below
click below
Normal Size Small Size show me how
Excel Unit 5
Excel unit 5 vocab
Question | Answer |
---|---|
What is the method of projecting what would happen in a spreadsheet called ? | what if analysis |
What is a nested function | a function within a function in a formula |
What is a shorthand way to write an equation that performs a calculation ? | function |
What function tells how many cells in a range contain a number ? | count |
What is the value the function uses to perform a calculation called ? | argument |
What function adds or totals a range of cells ? | sum |
What is the logical function that is used to display text or values if certain conditions exist ? | IF |
What function finds the highest number in a range of cells ? | MAX |
What function finds the smaller number in a range of cells ? | MIN |