Excel

Question 1

absolute value

Answer 1

formula doesn’t change when dragged

Question 2

spreadsheet software

Answer 2

allows user to organize data in columns and rows and perform calculations

Question 3

why use spreadsheet

Answer 3

-speed
-accuracy
-automatic calculations
-easy to change data
-do “what if”
produce charts, graphs, tables
-communication
-dif perspective on data

Question 4

arithmetic operators

Answer 4

\+ ; addition
- ; subtraction
* ; multiplication
/ ; division
^ ; exponent

Question 5

space

Answer 5

intersection operator, produces on reference to cells common to the two references

ie, where the two ranges intersect