2 Minute Excel Quiz

The best way to make this chart from this data is by using:
(a) the chart wizard.
(b) one single keystroke on your keyboard.
(c) the Chart AutoFormat wizard.

After you have created the first formula for a column of 5,000 rows of calculations, the best way to get the remaining 4,999 calculations is:
(a) to copy and paste the first formula into the remaining cells.
(b) to drag the AutoFill handle down for 4,999 rows.
(c) to use another method.  Neither of the above methods is the best way.

When you have a worksheet that has 20 columns and 200 rows of numbers and you need to sum them all both vertically in each column and horizontally on each row, you need to:
(a) type in a =Sum() function for each column and row.
(b) click into each cell that needs a formula and use the AutoSum function.
(c) make Excel fill in all of the formulas (4,000 of them) with only 3 clicks.

The worksheet on the left is not formatted.  The same worksheet shown on the right has been formatted.  Estimate the number of keystrokes/mouse moves you would make to perform the same activity.
(a) fewer than 5 keystrokes/mouse moves.
(b) between 5 and 10 keystrokes/mouse moves.
(c) more than 10 keystrokes/mouse moves.