Excel Coding Basics

To fix a typo in a cell, should you click once or double click to edit it?

• Once

• Double Click

If you want to join multiple cells together for a heading, what might you do?

• Bold them

• Merge and centre

• Italics

• Centre

How can you quickly perfectly size column A to fit in text?

• Double click between Column A and B

• Click once on Column A

• Double click between Column B and C

• Click one between Column A and B

What does A2:A5 represent?

• Cells A2 and A5

• Adding up Cells A2 and A5

• All cells between A2 and A5

• Multiplying A2 and A5

Do rows go horizontally or vertically?

• Horizontally

• Vertically

Which cell is selected?

• 3

• B

• A1

• B3

What represented the highlighted cells?

• B1 to B5

• B1:B5

• A1:B5

• 1B:5B

When making a table of information, what should you aim to do?

• Headings

• Do whatever

• Just enter the data in

• Make it clear and neat using headings and borders

What can Excel be used for?

• Storing and organizing data

• Calculations

• Financial data

What does this button do?

• You can sort data alphabetically

• You can sort numbers from large to small

• You can either sort alphabetically, or from large to small