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:

To add a comment, select the:

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

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

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

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

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?

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?

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

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.

In Microsoft Excel 2016, the =TODAY()command returns: