Score

The Ultimate Excel Quiz

Excel will multiply all cells from A2 to A5 with 10 and display the value in cells B2 to B5

Excel will correctly multiply cell A2 with 10 and will multiple A3 to A5 with blank values

It checks if the formula contains any errors

It steps into a formula and calculates it part by part for you to verify

Evaluate formula is not a feature in Excel

This cannot be done automatically, you have to select a new value

You can write VBA script to clear the displayed value of dependent list

You cannot create dependent lists in Excel

Yes, using format as table option and index, match formulas

Use the formulas like you would on any cell

This cannot be done; any formula will disappear with changes in pivot tables

Yes, you can apply conditional formatting using a formula

Yes, this can be achieved only through VB code

No, conditional formatting is only for the cell you apply it on