1.
Please explain in 10 words why you should receive an A in ICT?
2.
A tool used to organize and analyze information
Correct Answer
B. Spreadsheet
Explanation
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.
3.
An
instruction to carry out operations
on the numerical data
Correct Answer
D. Formula
Explanation
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.
4.
The intersection (meeting point) of a row and a column
Correct Answer
D. Cell
Explanation
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.
5.
What is the correct way to start a formula?
Correct Answer
C. =
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.
6.
What is the correct formulae for adding 2 cells together?
Correct Answer
C. =A1+A2
Explanation
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.
7.
Put this formula in the correct order (sumA1:A5=)
Correct Answer
D. =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.
8.
What is the name of the cell in column G row 20?
Correct Answer
C. G20
Explanation
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.
9.
Spreadsheets can be used to see different scenarios to see what might happen. What is this called?
Correct Answer
E. Modelling
Explanation
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.
10.
Which symbol is used to divide to values?
Correct Answer
B. /
Explanation
The symbol "/" is used to divide two values.
11.
Which symbol is used to multiply two values?
Correct Answer
B. *
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 "*".
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.
Correct Answer
A. True
Explanation
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.
13.
What is added to the formula to create an absolute reference?
Correct Answer
C. $
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.
14.
An example of a formula that includes and absolute reference look like?
Correct Answer
C. =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.
15.
If you select a cell with a date in it and drag the fill handle down several cells, what happens is _____.
Correct Answer
B. The date is increased by one day into each cell
Explanation
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.
16.
The formula that will add the value of D4 to the value of C2 and then multiply by the value in B2 is _____.
Correct Answer
D. =(D4+C2)*B2
Explanation
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.
17.
The feature that allows you to arrange rows in alphabetical order is _____.
Correct Answer
A. Sorting
Explanation
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.
18.
If a cell displays #######, it means that _____.
Correct Answer
B. The column is too narrow to display all the digits of the number
Explanation
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.
19.
All charts use an X-axis and a Y-axis EXCEPT a _____ chart.
Correct Answer
D. Pie
Explanation
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.
20.
A block of cells in an Excel worksheet is called the _____.
Correct Answer
B. Range
Explanation
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.
21.
To select Cells A3-A9 and Cells D3-D9 simultaneously, you would _____.
Correct Answer
C. Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9
Explanation
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.
22.
In a large spreadsheet, while scrolling down, it is helpful to make column headings visible by applying the _____ feature to the spreadsheet.
Correct Answer
C. Freeze Panes
Explanation
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.
23.
A format such as cell shading or font color that Excel can apply automatically if certain things are true is called _____.
Correct Answer
B. Conditional formatting
Explanation
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.
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?
Correct Answer
B. =D5-E5
Explanation
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.
25.
To save an existing file using a different name, you would choose the _____ command.
Correct Answer
C. Save as
Explanation
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.
26.
A continuous group of selected cells.
Correct Answer
A. Cell Range
Explanation
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.
27.
In a spreadsheet, what runs up and down and are lettered?
Correct Answer
C. Column
Explanation
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.
28.
In a spreadsheet, what runs from left to right and are numbered?
Correct Answer
A. Row
Explanation
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.
29.
Who is your favourite teacher at St Thomas More Catholic School?
Correct Answer
C. Mr McStravick
30.
Mr McStravick should NOT give you Homework today - True or False?
Correct Answer
A. True
Explanation
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.