Unit 2 Presentations and Quizzes

Question 1

how do you determine cell addresses?

Answer 1

column then row

Question 2

what are the types of data?

Answer 2

text
numeric
formulas

Question 3

what are formulas?

Answer 3

perform calculations or other actions on data in worksheet
-always starts with an equal sign
-uses cell address instead of numbers
-can use standar math operators to calculate value or you can integrate functions

Question 4

what is a function?

Answer 4

a preset formula that performs calculations using specific values called arguments

Question 5

what is a input?

Answer 5

basic information needed to do calculations

Question 6

what is a intermediate?

Answer 6

calculation necessary to change input data into a form required for final output

Question 7

what is an output?

Answer 7

specific pieces of information someone would need to know and is a calculation that uses intermediate calculations to determine the final product