When does the #NAME? error occur?

The formula =IFISERROR(A2) returns:

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:

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

How can we publish a Workbook to Power BI?

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?