Which of the following is/are correct about macro naming rules in Microsoft Excel 2016?

While editing a cell's content, if you change your mind about the changes you made before pressing the enter key, which of the following keys can be pressed to restore to the original text?

Which function can be performed on a protected worksheet if the password is not known?

Correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

For which of the following options, if included in a worksheet, we cannot use the Track Changes option?

When do we receive a '#Value!' error in the VLOOKUP function? i) When the 'lookup_value' argument is more than 255 characters. ii) When the 'col_index_num' argument contains text. iii) When the 'col_index_num' argument is equal to 0.

Cell A1 contains two blank spaces (eg press the space bar twice). The formula =ISBLANK(A1) returns:

You can automatically adjust the size of text in a cell if they do not fit in width by

You can set Page Border in Excel from...

Which of the following chart types is featured in Excel?

The formula SUMPRODUCT(a1:a4,b1:b4) is equivalent to: