Year 10 GCSE - Spreadsheet Modelling
-
Please explain in 10 words why you should receive an A in ICT?
-
Answer all 30 questions - You cannot submit your test until you have answered all questions.
All questions relate to what we covered on Wednesday and today.
Best of luck! :)
- 2.
A tool used to organize and analyze information
-
Row
-
Spreadsheet
-
Alignment
-
Value
Correct Answer
A. SpreadsheetExplanation
A spreadsheet is a tool used to organize and analyze information. It allows users to input data into rows and columns, making it easy to organize and manipulate data. Spreadsheets also have built-in functions and formulas that can be used to perform calculations and analyze data. With features like sorting, filtering, and charting, spreadsheets provide a convenient way to analyze and present data in a structured format.Rate this question:
-
- 3.
An instruction to carry out operations on the numerical data
-
Spreadsheet
-
Row
-
Column
-
Formula
-
Cell
Correct Answer
A. FormulaExplanation
A formula is an instruction used in a spreadsheet to carry out operations on numerical data. It allows users to perform calculations and manipulate data based on specific rules or equations. By entering a formula into a cell, the spreadsheet automatically calculates the result based on the values in other cells or specified criteria. Formulas are an essential feature in spreadsheets as they enable users to perform complex calculations and automate data analysis.Rate this question:
-
- 4.
The intersection (meeting point) of a row and a column
-
Row
-
Column
-
Label
-
Cell
Correct Answer
A. CellExplanation
A cell is the intersection or meeting point of a row and a column in a table or grid. It is the smallest unit within the table or grid and is identified by its unique row and column label.Rate this question:
-
- 5.
What is the correct way to start a formula?
-
+
-
-
-
=
-
/
-
(
Correct Answer
A. =Explanation
The correct way to start a formula is with the equals sign (=). This is because the equals sign is used in formulas to indicate that a calculation or function is going to be performed. By starting a formula with the equals sign, it signals to the software or program that it needs to interpret the following characters as a formula rather than a regular text entry.Rate this question:
-
- 6.
What is the correct formulae for adding 2 cells together?
-
A1+A2
-
+A1/A2
-
=A1+A2
-
(A1+A2)
-
A1-A2
Correct Answer
A. =A1+A2Explanation
The correct formula for adding 2 cells together is =A1+A2. This formula will add the values in cell A1 and A2 and provide the sum as the result.Rate this question:
-
- 7.
Put this formula in the correct order (sumA1:A5=)
-
(=sum)A1:A5
-
Sum=(A1:A5)
-
(A1:A5)sum=
-
=sum(A1:A5)
-
=(A1:A5)sum
Correct Answer
A. =sum(A1:A5)Explanation
The correct answer is =sum(A1:A5) because the formula is asking to calculate the sum of the values in cells A1 to A5. The correct syntax for the SUM function in Excel is =SUM(range), where "range" represents the range of cells to be summed. Therefore, =sum(A1:A5) is the correct order for the formula.Rate this question:
-
- 8.
What is the name of the cell in column G row 20?
-
02G0
-
20G
-
G20
-
0G2
-
CG20
Correct Answer
A. G20Explanation
The correct answer is G20 because it follows the standard convention of naming cells in a spreadsheet, where the column letter is followed by the row number. In this case, the cell is located in column G and row 20, so it is named G20.Rate this question:
-
- 9.
Spreadsheets can be used to see different scenarios to see what might happen. What is this called?
-
Testing
-
Working Out
-
Estimating
-
Planning
-
Modelling
Correct Answer
A. ModellingExplanation
The given correct answer for this question is "Modelling". Spreadsheets can be used to create models that simulate different scenarios and predict potential outcomes. By inputting different variables and formulas, users can manipulate the data to see how different changes could impact the results. This allows for a better understanding of the potential outcomes and helps in decision-making processes.Rate this question:
-
- 10.
Which symbol is used to divide to values?
-
-
-
/
-
=
Correct Answer
A. /Explanation
The symbol "/" is used to divide two values.Rate this question:
-
- 11.
Which symbol is used to multiply two values?
-
=
-
*
-
+
Correct Answer
A. *Explanation
The symbol "*" is used to multiply two values. This symbol is commonly known as the multiplication operator and is used in mathematical operations to indicate multiplication. For example, if we have two values, 3 and 4, the expression 3 * 4 would result in the product of these two values, which is 12. Therefore, the correct answer is "*".Rate this question:
-
- 12.
By using the cell name, such as C4, you do not have to go back into a formula and make changes when your information is changed or updated.
-
True
-
False
Correct Answer
A. TrueExplanation
By using cell names, like C4, instead of hardcoding specific values in a formula, you can easily update or change the information in the cell without having to modify the formula itself. This is because the formula references the cell by its name, rather than the specific value it contains. Therefore, if the information in the cell changes or is updated, the formula will automatically recalculate based on the new value, without requiring any manual changes to the formula. This saves time and reduces the chances of errors when updating or modifying data in a spreadsheet.Rate this question:
-
- 13.
What is added to the formula to create an absolute reference?
-
?
-
&
-
$
-
#
Correct Answer
A. $Explanation
To create an absolute reference in a formula, the dollar sign ($) is added. This is done by placing the dollar sign before the column letter and row number in the cell reference. By adding the dollar sign, the reference becomes fixed and does not change when the formula is copied or filled to other cells. This allows the formula to always refer to the same cell, providing a fixed point of reference in calculations.Rate this question:
-
- 14.
An example of a formula that includes and absolute reference look like?
-
=C12+D12+E12
-
=C12*D12*E12
-
=C12+$B12$
-
=C12= B12=D12
Correct Answer
A. =C12+$B12$Explanation
The correct answer is =C12+$B12$. This formula includes an absolute reference because the column reference ($B) and the row reference ($12) are both fixed with the use of the dollar sign. This means that when the formula is copied to other cells, the reference to column B and row 12 will not change. Only the reference to cell C12 will change based on the relative position of the copied formula.Rate this question:
-
- 15.
If you select a cell with a date in it and drag the fill handle down several cells, what happens is _____.
-
The date is copied to each cell
-
The date is increased by one day into each cell
-
The date is increased by one week into each cell
-
Nothing happens because the fill applies only to numbers
Correct Answer
A. The date is increased by one day into each cellExplanation
When you select a cell with a date in it and drag the fill handle down several cells, the date is increased by one day into each cell. This is because Excel recognizes the pattern of increasing dates and automatically increments the date by one day for each subsequent cell.Rate this question:
-
- 16.
The formula that will add the value of D4 to the value of C2 and then multiply by the value in B2 is _____.
-
(D4+C2)*B2
-
D4+C2*B2
-
=D4+C2*B2
-
=(D4+C2)*B2
Correct Answer
A. =(D4+C2)*B2Explanation
The correct answer is =(D4+C2)*B2. This formula correctly adds the value of D4 to the value of C2 and then multiplies it by the value in B2.Rate this question:
-
- 17.
The feature that allows you to arrange rows in alphabetical order is _____.
-
Sorting
-
Conditional formatting
-
Filtering
-
Autofill
Correct Answer
A. SortingExplanation
The feature that allows you to arrange rows in alphabetical order is sorting. Sorting is a process of arranging data in a specific order, such as alphabetical or numerical order. By using the sorting feature, you can easily organize rows in a spreadsheet or table based on the values in a specific column. This can be helpful when you want to quickly find and analyze data in a more structured and organized manner.Rate this question:
-
- 18.
If a cell displays #######, it means that _____.
-
There is a formatting error
-
The column is too narrow to display all the digits of the number
-
There is an error in your formula
-
You need to center the text within the cell
Correct Answer
A. The column is too narrow to display all the digits of the numberExplanation
If a cell displays #######, it means that the column is too narrow to display all the digits of the number. This is a common issue in spreadsheet programs where the column width is not wide enough to accommodate the entire number. To fix this, you can increase the column width or adjust the formatting to allow for the full display of the number.Rate this question:
-
- 19.
All charts use an X-axis and a Y-axis EXCEPT a _____ chart.
-
Bar
-
Line
-
Column
-
Pie
-
XY scatter plot
Correct Answer
A. PieExplanation
A pie chart does not use an X-axis and a Y-axis like other charts. Instead, it represents data using slices of a circle, where each slice represents a different category or value. The size of each slice corresponds to the proportion of the whole that each category or value represents. Therefore, a pie chart is the correct answer because it is the only chart that does not use an X-axis and a Y-axis.Rate this question:
-
- 20.
A block of cells in an Excel worksheet is called the _____.
-
Area
-
Range
-
Cell reference
-
Name box
-
All of the above
Correct Answer
A. RangeExplanation
A block of cells in an Excel worksheet is called a range. A range refers to a group or selection of cells that can be used together for various operations such as formatting, calculations, or data manipulation. It allows users to work with multiple cells simultaneously, making it a versatile and essential feature in Excel.Rate this question:
-
- 21.
To select Cells A3-A9 and Cells D3-D9 simultaneously, you would _____.
-
Hold down the CTRL key, select Cells A3-A9, select Cells D3-D9
-
Hold down the Shift key, select Cells A3-A9, select Cells D3-D9
-
Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9
-
Select Cells A3-A9, hold down the Shift key, select Cells D3-D9
-
Both A and B will make the selection simultaneously
Correct Answer
A. Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9Explanation
To select Cells A3-A9 and Cells D3-D9 simultaneously, you would select Cells A3-A9, hold down the CTRL key, and select Cells D3-D9. This combination of actions allows you to select both sets of cells at the same time.Rate this question:
-
- 22.
In a large spreadsheet, while scrolling down, it is helpful to make column headings visible by applying the _____ feature to the spreadsheet.
-
Arrange Panes
-
Split Panes
-
Freeze Panes
-
Conditional Formatting
Correct Answer
A. Freeze PanesExplanation
In a large spreadsheet, the Freeze Panes feature is helpful while scrolling down as it allows the column headings to remain visible. By freezing the panes, the user can keep the headings in place while navigating through the spreadsheet, making it easier to understand and interpret the data. This feature is particularly useful when working with extensive datasets where it is important to have a constant reference to the column headings.Rate this question:
-
- 23.
A format such as cell shading or font color that Excel can apply automatically if certain things are true is called _____.
-
Autoformatting
-
Conditional formatting
-
Patterns
-
Both a and b are correct
Correct Answer
A. Conditional formattingExplanation
Conditional formatting is the correct answer because it refers to a feature in Excel that allows users to apply formatting to cells based on certain conditions or criteria. This feature automatically applies formatting such as cell shading or font color to cells if specific conditions are met. Autoformatting, on the other hand, is a different feature in Excel that allows users to quickly apply pre-defined formatting styles to a range of cells. The term "patterns" is not directly related to this concept. Therefore, the correct answer is conditional formatting.Rate this question:
-
- 24.
A Sony digital camera price is listed as $300.00 in Cell D5. The digital camera discount price is listed in Cell E5 as $20.00. You are going to insert a formula in Cell F5 to list the final price. Which formula is correct?
-
=D5+E5
-
=D5-E5
-
=E5-D5
-
=PRICE(D5-E5)
Correct Answer
A. =D5-E5Explanation
The correct formula to calculate the final price is =D5-E5. This formula subtracts the discount price (E5) from the original price (D5) to give the final price.Rate this question:
-
- 25.
To save an existing file using a different name, you would choose the _____ command.
-
Save
-
Retrieve
-
Save as
-
Store file
Correct Answer
A. Save asExplanation
The correct answer is "save as". This command allows the user to save an existing file with a different name. By selecting this option, the user can specify a new name and location for the file, effectively creating a copy of the original file with a different name. This is useful when the user wants to keep the original file intact while also creating a modified version with a different name.Rate this question:
-
- 26.
A continuous group of selected cells.
-
Cell Range
-
Row
-
Colunm
-
Value
Correct Answer
A. Cell RangeExplanation
A cell range refers to a continuous group of selected cells. It allows you to perform operations or apply formatting to multiple cells at once. By selecting a range of cells, you can easily modify or analyze data in a spreadsheet. This can be particularly useful when working with large datasets or when you want to apply the same formatting or formula to multiple cells.Rate this question:
-
- 27.
In a spreadsheet, what runs up and down and are lettered?
-
Rows
-
Cells
-
Column
-
Formula
Correct Answer
A. ColumnExplanation
In a spreadsheet, columns run up and down and are lettered. Rows, on the other hand, run horizontally and are numbered. Cells refer to the individual boxes within the spreadsheet where data can be entered. Formulas are used to perform calculations within the spreadsheet. Therefore, the correct answer is column.Rate this question:
-
- 28.
In a spreadsheet, what runs from left to right and are numbered?
-
Row
-
Value
-
Column
-
Formula
Correct Answer
A. RowExplanation
In a spreadsheet, rows run from left to right and are numbered. Rows are horizontal lines that contain data in cells. Each row is identified by a number, starting from 1, which helps to locate and reference specific data within the spreadsheet.Rate this question:
-
- 29.
Who is your favourite teacher at St Thomas More Catholic School?
-
Mr Rowland
-
Mr Lusardi
-
Mr McStravick
-
Mr Saunders
Correct Answer
A. Mr McStravick -
- 30.
Mr McStravick should NOT give you Homework today - True or False?
-
True
-
False
Correct Answer
A. TrueExplanation
The statement "Mr McStravick should NOT give you Homework today" is true. This implies that Mr McStravick is not supposed to give homework on this particular day. Therefore, the correct answer is true.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 27, 2014Quiz Created by
MrMcStravick