IBA sem 2
where can you enter data in a spreadsheet? - ANS-in a cell
you need to add cells C3 and C7, and multiply C3 by C6. based on the order of operations, what
would you do? - ANS-multiply first, and then add.
what formula would be used to add two cells together after equal sign? -
ANS-column#row#+column#row#
you are trying to determine how many 12 foot boards you need to make a new deck. you will
have to cut one board because you need an extra 8 feet. what function would help you
determine how many board to buy? - ANS-Roundup
the formula to calculate percentage is the same as which other function? - ANS-Division
what is the name of the formula to use when adding multiple cells together? - ANS-sum
of the following which calculation comes first in the order of operations? - ANS-parentheses
which function would you use to change the appearance of data in a cell from decimal to
percentage? - ANS-Format
To analyze data from a survey you use a spreadsheet to calculate the percent of students who
prefer corn over broccoli or carrots. However the results do not look like percentages. How can
spreadsheet? - ANS-by changing the decimal to a percentage
a contractor is putting together an estimate for a new customer who would like a built-in pool
installed. the contractor has a lot of different measurements that need to be calculated, and he
needs to keep track of them. what would you tell him to do keep track of the information and
calculate quickly and in an organized manner? - ANS-log the information into a spreadsheet and
calculate the measurements through the formulas in the spreadsheet program
a client server relationship is the basic form of a - ANS-computer network
what is a disadvantage of shopping online? - ANS-a higher risk of financial data theft
a service provided by egovernment that requires access to the internet is - ANS-E tax returns
which of the following is a disadvantage of egovernment? - ANS-it can be expensive to set up
and maintain the online systems
where can you enter data in a spreadsheet? - ANS-in a cell
you need to add cells C3 and C7, and multiply C3 by C6. based on the order of operations, what
would you do? - ANS-multiply first, and then add.
what formula would be used to add two cells together after equal sign? -
ANS-column#row#+column#row#
you are trying to determine how many 12 foot boards you need to make a new deck. you will
have to cut one board because you need an extra 8 feet. what function would help you
determine how many board to buy? - ANS-Roundup
the formula to calculate percentage is the same as which other function? - ANS-Division
what is the name of the formula to use when adding multiple cells together? - ANS-sum
of the following which calculation comes first in the order of operations? - ANS-parentheses
which function would you use to change the appearance of data in a cell from decimal to
percentage? - ANS-Format
To analyze data from a survey you use a spreadsheet to calculate the percent of students who
prefer corn over broccoli or carrots. However the results do not look like percentages. How can
spreadsheet? - ANS-by changing the decimal to a percentage
a contractor is putting together an estimate for a new customer who would like a built-in pool
installed. the contractor has a lot of different measurements that need to be calculated, and he
needs to keep track of them. what would you tell him to do keep track of the information and
calculate quickly and in an organized manner? - ANS-log the information into a spreadsheet and
calculate the measurements through the formulas in the spreadsheet program
a client server relationship is the basic form of a - ANS-computer network
what is a disadvantage of shopping online? - ANS-a higher risk of financial data theft
a service provided by egovernment that requires access to the internet is - ANS-E tax returns
which of the following is a disadvantage of egovernment? - ANS-it can be expensive to set up
and maintain the online systems
