Menu
Qualifications KS3 Computing Spreadsheets

Key Terms

Card 1 of 21 0 got it 0 still learning
Question
TapClick or press space to see the answer
Answer
All 21 cards in this set
What does the cell reference C6 identify?
Column C, row 6
Ravi wants to refer to all the cells from D2 down to D8 together. Which of these writes this range correctly?
D2:D8
Priya clicks the letter C at the top of her spreadsheet. What does she select?
The whole of column C
Why would you double click a cell that already contains data?
To edit the data already in the cell
A student selects a cell and presses Backspace. What happens?
The data in the cell is deleted
Which action selects several cells that are next to each other?
Click and drag across the cells
What do people mainly use spreadsheets for?
To organise, process and analyse data
What is a cell in a spreadsheet?
The box where a column and a row meet
Which statement about spreadsheets and jobs is correct?
They are used in many different jobs
Jay wants to type the number 25 into cell B3. What should he do?
Click cell B3 and type 25
Why are the columns of a sheet labelled with letters and the rows with numbers?
So every cell has its own reference
A football coach records each player's goals and fitness in a spreadsheet. How does this help him?
He can analyse the data to pick a team
A spreadsheet file has three tabs at the bottom of the screen. What does this mean?
The file contains three sheets
Which term describes a group of cells that are next to each other?
Range
What is meant by 'sheet'?
A page within a spreadsheet, shown as a tab at the bottom of the screen
Which term describes the parts of a sheet that run up and down and are labelled with letters?
Column
What is meant by 'cell reference'?
The column letter followed by the row number, which identifies one cell
What is meant by 'row'?
A part of a sheet that runs across and is labelled with a number
Which of these is another name for a cell reference?
Cell address
Dev clicks the number 4 on the left of a spreadsheet. What does he select?
The whole of row 4
A pupil is working on a sheet called Sales and wants to switch to the sheet called Costs. What should she do?
Click the Costs tab at the bottom