4.Question 4A junior data analyst encounters a spreadsheet error. They realize that their formula is referencing a row that has been deleted, so they correct the formula. What type of error did they resolve?1 pointREFNUMVALUEERROR or parsing error5.Question 5In this spreadsheet, which SUM function will add all of the values between cells B1 and D6?(n/a)ABCDEF1543585682352596792534174521234542134526589456785635679678922147887234089042231434531237523129789069430546342869675679652136673585663523547408325464457943521 point=SUM(B1,D6)=SUM(B1:D6)=SUM,B1+D6=SUM(B1-D6)

At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is*3 pointsTo tell the person viewing that this is a function and it should be added together.To inform the computer that an arithmetic function will occur.To add all the data together using addition only.To calculate all the data correctly without any mistakes.

Which of the following is an invalid Excel formula?*1 point=7+8=K9=A5*C2None of the above

When you wrote incorrect functions, what did you learn about spreadsheet data?How do you think this knowledge of the SUM spreadsheet function will help you write other kinds of functions?

Question 5A data professional in the trucking industry calculates the number of spreadsheet rows that contain the SKU value BK09876. Which function do they use?1 point=COUNTIF(BK09876=G2:G30)=COUNTIF(G2:G30,“BK09876”)=COUNTIF(G2:G30,BK09876)=COUNTIF(G2:G30,“=BK09876”)

iferror satisfy the need of the data analyst to correct --------errors? Options : Not Available error Mathematical error Both 1 and 2 None of the above