End Of Year revision

An example of an absolute cell reference is: = B3

• True

• False

What is the name of the electronic component, invented in 1947, that was used to process data in the second generation of computers? Its invention led to the first big reduction in size the size of electronic computers.

• Valves

• Microchips

• Transistors

• Integrated circuits

A law that predicted that the number of transistors that could be etched on a single microchip would continue to double every two years was named after the person who stated it. Who was the law named after?

• Bill Gates

• Steve Jobs

• Tim Berners-Lee

• Gordon Moore

Which function is used to find the lowest of the values in a range of cells?

• =MIN

• =AVERAGE

• =MAX

• =SUM

Which function is used to find the highest of the values in a range of cells?

• =MIN

• =AVERAGE

• =MAX

• =SUM

In which decade was the law that predicted that the number of transistors that could be etched on a single microchip would continue to double every two years first stated?

• 1950s

• 1960s

• 1970s

• 1980s

From 1959, the invention of silicon-based circuits made it possible to build much smaller computers with faster processing speeds. What were these silicon-based circuits called?

• Valves

• Microchips

• Transistors

• Integrated circuits

The formula in C1 is replicated to cells C2 - C7. What value will be shown in cell C4?

• 425

• 386

• 850

• 489

Why do you need to use the 'erase all' block when drawing shapes?

• Without it, the stage will not be cleared of drawings

• Without it, a line will not be drawn

• Without it, the width of the pen won't be set

• Without it, the colour of the pen won't be set

This photograph shows a mechanical computer called the Analytical Engine. Who invented it?

• Bill Gates

• Claude Shannon

• Charles Babbage

• Augustus De Morgan