When creating a dual-substitution data table, where must you put the formula that the table is based on?

What will be the result of this formula =MOD (40, 0) ?

Which function lets you reference a cell or range (that hasn't been named) using text values?

One of the major differences between the inStr function in VBA and the Excel Search function is that...

Which is false regarding Conditional Formatting?

Cell A1 has text in the format YYYYMMDD. How do you convert this to a valid Excel date?

When does the triangle appear in the top-left corner of the cell, as shown in the picture?

Which line style should be used to specify the style used for the end of the line?

Which of the following charts have no axes?

Which method would you follow to add an alternative text to a picture?

A Macro project can be digitally signed.