How is the information in spreadsheets laid out?
In a circle
In a spider diagram
In rows and columns
What is the main function of a spreadsheet?
To organise information and automatically make calculations from the data in the cells
To spread data over a large surface area
To make data transparent so that the user can see the binary code
What is the function of a formula?
To reshape data within one cell to match the shape of the other cell
To move and remove data within a cell
To add, subtract, multiply or divide information in one cell by the values in another cell
Which option is an example of a Boolean value?
31
Yes
Belfast
When an application can read and open a file created by another application, this is called:
Transforming
Importing
X-ray
Which type of statement can check if a statement is true or false?
WHEN statement
HOW statement
IF statement
A series of instructions and/or actions that can be recorded and then set to run whenever you need to perform the same task in future is called what?
A macro
A micro
A mini