In Microsoft Excel 2016, which of the following arguments of the YEARFRAC function is/are optional?

i) Start date.

ii) End date.

iii) The type of day count basis to use.

What does the blue triangle and border color imply in cell B4?

The IT security department of Mark's organization has decided that only digitally signed macros will be allowed in Microsoft Excel 2016. Which of the following is the correct way to restrict the unsigned macros?

Peter was working in a Microsoft Excel 2016 workbook. His workbook closed due to a system error and he couldn't save it. Which of the following is the correct way to recover an unsaved workbook?

How can we publish a Workbook to Power BI?

The 'brush' symbol indicates which of the following options?

Cell A1 contains the text string 'BA1740'. The formula to extract the last four characters as a value in A1 is:

The formula =REPLACE('the cat in the hat',12,3,'red') returns:

To add a comment, select the:

June 6th, 2011 was a Monday. Based on the normally set week, date value 6/6/2011 is in cell A1. The formula in B1 =Weekday(A1) returns:

The formula =IFISERROR(A2) returns: