Quiz 3 - Advanced spreadsheets

A macro is a small ... . It records the mouse ... and ... strokes as you complete a task.

• key / clicks / programme

• clicks / programme / key

• programme / clicks / key

The actions are saved as ... code. Macros can be edited to correct ... code or add extra ... to cells

• errors / javascript / formatting

• javascript / formatting / errors

• java script / errors / formatting

Look at the macro code and answer the questions that follow.

Which cell is having the colour of the text changed?

• A12

• A14

• A16

• A18

• A20

Look at the macro code and answer the questions that follow.

Will the text in cell A20 be set to bold?

• Yes

• No

Look at the macro code and answer the questions that follow.

What will the code for cell A14 change?

• The colour of the text

• The background fill colour of the cell

• The colour of the border around the cell

Look at the macro code and answer the questions that follow.

Which cell will use a different style of font to the rest of the cells?

• A12

• A14

• A16

• A18

• A20