please answer all questions correctly

Question 13: Which statement is correct regarding the FIFO method? Answer: A. B. C. D. It uses an average of costs to determine the cost of goods sold. O It assumes ending inventory is made up of the latest goods to arrive in the warehouse. It assumes ending inventory is made up of the earliest goods to arrive in the warehouse. It assumes cost of goods sold is made up of the latest goods to arrive in the warehouse. Question 10: Why does the MID function require an argument for the number of characters? Answer: A. B. C. D. O So Excel knows how long the current string of characters is O To calculate the highest value in the cells It's necessary when finding the average O To indicate how many characters should be displayed Question 7: Why include "" in a formula that includes the CONCAT function? Answer: A. B. C. D. To insert an additional row O To add a blank space between combined entries O To put quotation marks around all text O To capitalize all text Question 4: What is the result when the formula =LEFT(A1, 5) is entered in cell A3? Answer: A 1 123456789 2 3