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 |