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?

If you enter 'August 1, 2012' (without quotes) in cell A1 in a new worksheet, which data type would it be?

In Excel, you can choose a picture as the background of a:

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: