1.
What are spreadsheets used to do?
Correct Answer
D. To help us calculate rapidly, explore different options and represent data in charts.
Explanation
Spreadsheets are used to help us calculate rapidly by performing various mathematical operations on the data. They also allow us to explore different options by easily changing values and formulas. Additionally, spreadsheets enable us to represent data in charts, making it easier to visualize and analyze the information.
2.
Tick the spreadsheet programs.
Correct Answer(s)
C. Numbers
D. LibreOffice Calc
F. Excel
Explanation
The correct answer is Numbers, LibreOffice Calc, and Excel. These three options are spreadsheet programs commonly used for organizing and analyzing data. Keynote, Pages, Word, and PowerPoint are not spreadsheet programs, but rather presentation and word processing software.
3.
Spreadsheets are arranged in...
Correct Answer
A. Columns and rows
Explanation
Spreadsheets are arranged in columns and rows to create a grid-like structure. Columns are vertical sections that are labeled with letters, while rows are horizontal sections labeled with numbers. This arrangement allows data to be organized and displayed in a tabular format, with each cell representing a unique intersection of a column and row. Cells can contain various types of data, such as numbers, text, or formulas, while references enable linking and accessing data from other cells within the spreadsheet.
4.
All formulae begin with...
Correct Answer
E. =
Explanation
The correct answer is "=" because in mathematics, the symbol "=" is used to indicate equality or equivalence between two expressions or values. It is used to show that the value on the left side of the equation is equal to the value on the right side. Therefore, all formulae begin with the "=" sign to establish this equality.
5.
I want to multiply the number in cell E2 by that in cell B5. What is the formula?
Correct Answer(s)
A. =E2*B5
C. =B5*E2
Explanation
The correct answer is =E2*B5 or =B5*E2. Both formulas will multiply the number in cell E2 by the number in cell B5. The order of the cells being multiplied does not matter in multiplication, so both formulas are correct.
6.
=F7/G3 This formula divides the number in cell F7 by the number in cell G3.
Correct Answer
A. True
Explanation
The given formula "=F7/G3" is a division formula that divides the number in cell F7 by the number in cell G3. Therefore, the correct answer is true.
7.
Spreadsheets are useful for ...
Correct Answer(s)
A. Creating charts and graphs
B. Exploring alternatives
Explanation
Spreadsheets are useful for creating charts and graphs because they allow users to organize and present data in a visual format. This feature is particularly helpful when analyzing numerical information and identifying patterns or trends. Additionally, spreadsheets enable users to explore alternatives by manipulating the data and conducting "what-if" scenarios. This allows for easy comparison and decision-making.
8.
Example/s of a cell reference.
Correct Answer(s)
B. C1
C. L99
D. I8
Explanation
The given examples represent cell references in a spreadsheet. In a spreadsheet, cells are identified by their column and row labels. The first example "C1" refers to the cell in column C and row 1. Similarly, "L99" refers to the cell in column L and row 99, and "I8" refers to the cell in column I and row 8. Cell references are used to refer to specific cells in formulas or to retrieve data from those cells.
9.
What does the function SUM do?
Correct Answer
C. It quickly adds up values in a range of cells.
Explanation
The function SUM is used to quickly add up values in a range of cells. This means that if you have a series of numbers in different cells, you can use the SUM function to calculate their total sum. It is a useful tool for performing calculations and obtaining the sum of multiple values without having to manually add them together.
10.
Which of these could you use a spreadsheet for?
Correct Answer(s)
A. Presenting data in charts and graphs
C. Calculating pocket money in order to find out how long you need to wait to buy a new 'toy'.
D. Budgeting for a party.
Explanation
You could use a spreadsheet for presenting data in charts and graphs, calculating pocket money to determine how long you need to wait to buy a new 'toy', and budgeting for a party. Spreadsheets are versatile tools that allow you to organize and analyze data, perform calculations, and create visual representations of data through charts and graphs. They can be used for various tasks, including financial planning, data analysis, and project management.