Hello . i need help to answer 8 multiple choices questions about( Accounting computerized system -chapter 7&8)

1) Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester? Which function should you used? a) =YEARFRAC(B1,B2) B)=DAYS(B2,B1) C)=DAY(B1) D)=DAYS(B1,B2) 2) The date 5/12/2018 is stored in cell C1 what function should you use to extract just 12? a)=MONTH(C1) B)=YEAR(C1) C)=DAY(C1) D)=DAYS(B1,C1) 3) A workbook contains a list of members in the computer club .you want to identify the number of students who are freshmen who are information system majors. Without filtering the dataset what function should you use? A) COUNT B) COUNTA C) DSUM D) DCOUNT 4) Your workbook contains a list of artwork .column B lists sold out if the piece is sold out, available if it is still readily available, or limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out .what function would produce the same results as =OR(B1=\"Availble\1) Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester? Which function should you used? a) =YEARFRAC(B1,B2) B)=DAYS(B2,B1) C)=DAY(B1) D)=DAYS(B1,B2) 2) The date 5/12/2018 is stored in cell C1 what function should you use to extract just 12? a)=MONTH(C1) B)=YEAR(C1) C)=DAY(C1) D)=DAYS(B1,C1) 3) A workbook contains a list of members in the computer club .you want to identify the number of students who are freshmen who are information system majors. Without filtering the dataset what function should you use? A) COUNT B) COUNTA C) DSUM D) DCOUNT 4) Your workbook contains a list of artwork .column B lists sold out if the piece is sold out, available if it is still readily available, or limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out .what function would produce the same results as =OR(B1=\"Availble\1) Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester? Which function should you used? a) =YEARFRAC(B1,B2) B)=DAYS(B2,B1) C)=DAY(B1) D)=DAYS(B1,B2) 2) The date 5/12/2018 is stored in cell C1 what function should you use to extract just 12? a)=MONTH(C1) B)=YEAR(C1) C)=DAY(C1) D)=DAYS(B1,C1) 3) A workbook contains a list of members in the computer club .you want to identify the number of students who are freshmen who are information system majors. Without filtering the dataset what function should you use? A) COUNT B) COUNTA C) DSUM D) DCOUNT 4) Your workbook contains a list of artwork .column B lists sold out if the piece is sold out, available if it is still readily available, or limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out .what function would produce the same results as =OR(B1=\"Availble\