2. In selected cases, why should you use absolute addressing ($) in a column, row, or both? A So that when I copy the formula or use an auto-fill handle, the column and row reference would change B. So that when I copy the formula or use an auto-fill handle, the column and row reference will remain accordingly the same ction B a formula and reference that identify the location of the data to be processed, Ca ready-made function that performs a series of operations on a specified range of cells. Da ready-made formula that performs an operation on a specified range of cells. C. For me to calculate monetary values in the range of cells that are expressed in dollars D. Because absolute addressing is a standard way in referencing rows and columns 3.Susan wants to put a formula and functions to her workbook to make some calculations. She uses an equal sign (-) before each function and formula. What do you think is the function of the equal sign? The equal sign: A shows equality between numbers, text, dates, and other values 8. initializes the values assigned to the cell references in the worksheet Calerts MSExcel to perform a execution of the inserted function or formula. D. shows equality of the values between the cell reference and the formula bar. 4. In the expression (1+1)*1/1^1, which arithmetic operation will be executed last? A (multiplication) B.+ (addition) C/(division) D. (exponentiation) S.If you are to override the order of operations, what would you use? A brackets B. parentheses C. quotes D. Asterisks 6. If you are to use multiplication operator, you will be typing 299 multiplication sign (*) to get the product of the set of numbers that are found in cell range A1 to A300. To do the task in a fast and efficient way that yields the same result, what will you use? B. Function A Data Range C Relative Reference D. AutoSum A a ready-made range of data that performs a series of operations on a specified range of cells. 7. In relation to number 6 answer, why did you choose it? Because number 6 answer is: 8.To indicate the cell addresses of the values that the function will act on, what element will you specify? A parenthesis 8. argument C. comma D. equal sign 9. In building a function, why do you specify the Function's name? To indicate: A the range of cells to be calculated 8. the exact argument to be used. C what operation that will be performed. D. the cell addresses of the values to be processed. 10. Assume that these values 1,2,3,4 and 5 are in the cell range A4 to AB. To obtain the value found in A5, what function will you use? A AVE B. MEAN CMIDDLE D. MEDIAN 11. Given this set of numbers in cell range A1 to A10: 1,2,1,2,1,2,1,2,1,2 what function 157 will you use to obtain A. SUM 8. PRODUCT C. RANK D. TOTAL 12. Why should you use cell references (column and row headers) when calculating values instead actual figures? A. So that the calculated values will not change when the data in the cells change of typing its 8. Because values in the cells will be identified through cell references. C. For the user to know easily whether the formula is complex or not D. So that calculated values will change accordingly when the data in the cells change 13. Given this formula: A1+A2+A3+A4+A5+A7+A8. How will you simplify it using a function? in the cell I will type: A SUM(A1,AB) B. SUM(A1:AB) C=SUM(A1+A8) D. SUM(A18) 14. Auto fill is an Excel function that allows you to quickly fill cells with repetitive or sequential data. Which of the following actions initiate an auto fill so that when you copy the formula or use an auto-fill handle, the column and row reference will A change accordingly B. will remain the same. C. expressed in dollars. D.referencing rows and columns 24
PLS HELP​