5) Highlight the mixed reference cell where the row is locked A. B1 B. \$BSI C. BS1 D. \$B1 6) The main difference between CONCAT( ) and TEXTJOIN( ) is that A. CONCAT accepts a delimiter to use when joining values together. B. TEXTJOIN accepts a delimiter to use when joining values together. C. TEXTJOIN does not accept a delimiter to use when joining values together. 7) The main difference between FIND( ) and SEARCH( ) is that A. FIND function is not case-sensitive i.e. it does not check uppercase and lowercase letters B. FIND function allows the wildcard characters such as "?", "" etc. C. SEARCH function is not case-sensitive i.e. it does not check uppercase and lowercase letters 8) What is the output for formula > =LEN("apple pie") A. 8 B. 9 C. 10