Which of these is the correct formula for an addition?
0%
=SUMB6+B7
0%
B6+B7
0%
=SUM(B6+B7)
0%
=B6-B7
Q.2.
Which symbol would you use in a formula for multiplication (to multiply two or more numbers)?
0%
x
0%
/
0%
÷
0%
*
Q.3.
Which of these could be used in a spreadsheet to display your data?
0%
A bar chart
0%
A line graph
0%
A pie chart
0%
All of the above
Q.4.
Which of these could a spreadsheet NOT be used for?
0%
Creating a graph from your science investigation results
0%
Calculating the cheapest mobile phone package from a range of choices
0%
Finishing your English writing homework
0%
Storing the test results for a class of year six pupils
Q.5.
On a spreadsheet, all cells are named. In the cell named B10, the 'B' refers to which of these?
0%
The row where that cell is located
0%
The type of information which can be entered into that cell
0%
The column where that cell is located
0%
The type of calculation which has been entered into that cell
Q.6.
What does it mean to 'format' a cell?
0%
To make a cell bigger
0%
To make a cell smaller
0%
To insert a picture into a cell
0%
To choose what type of information can be entered into a cell and how it is displayed
Q.7.
A spreadsheet is divided into what?
0%
Columns, rows and cells
0%
Lines and squares
0%
Parallel and diagonal lines
0%
Helixes
Q.8.
Which symbol would you use in a formula for division (dividing a number)?
0%
x
0%
/
0%
÷
0%
*
Q.9.
What is an electronic spreadsheet?
0%
A large piece of cloth spread over a flat surface
0%
A software package used to organise information
0%
A piece of A3 paper spread out so that you can see it clearly
0%
A word processing file
Q.10.
You are creating a spreadsheet to calculate the cost of a party. You want to know how much you will spend on pizzas. Why is it better to use a formula rather than working out the calculations yourself?
0%
It will make it easier if you want to rearrange your spreadsheet
0%
A formula will instantly calculate the change in cost if you need to change the price of the pizzas
0%
The spreadsheet will be tidier if you use a formula
0%
It is always faster to calculate in your head rather than to use a formula
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.