Hello please help me to answer this thank you!

I need this asap.

Please provide correct answer thank you!

When you copy and paste a cell that contains a formula with absolute cell references, the reference/s in the formula will update automatically based on a relative position of row/s and column/s True False When inserting a cell, the content in a row or column will be moved down or to the right True False This function automatically adds up the numbers in a column or row you specify SUM AutoSum SUMIF AVERAGE "BB" is an example of a in Excel. column heading row heading active cell cell reference This function adds up the numbers in the selected cells you specify SUM Au toSum SUMIF AVERAGEThe best formula to calculate the Average for Sales is: A B C D E F G Quarter1 Quarter2 Quarter3 Quarter4 Total Average Sales 150,122 163,859 209,783 189,374 713,138 178,284.50 3 Profits 45,908 52,456 78,376 635,490 812,230 203,057.50 =MEAN(B2:E2) =AVERAGE(B2:E2) =SUM(B2:E2)/COUNT() =SUM(B2+C2+D3+E2)/4 What is the intersection of a row and a column? Cell Worksheet Chart Cell range None of the above By default, Excel will align the numbers to the right left center top bottomThe formula =B2+83 is in cell E5. If you paste it into F7, what formula will you see? =C4+C5 =SB2+$83 =C2+C3 =B4+B5 To determine the number of businessmen aged 35 years and below from a given dataset, we use the function. COUNT COUNTA COUNTIF COUNTIFS The mode can be used for qualitative data True False If the raw data have 2 and 3 decimal places in creating a histogram. What will be the class size if the value of c is 2.4467? 2 2.4 2.44 2.446 None of the above