NEW
Font size
WorksheetsExcel - Games R Us Lesoon
Total questions: 10
Worksheet time: 8mins
Why is FORMATTING important in Spreadsheets?
Formatting is only necessary for aesthetic purposes.
Formatting is important in spreadsheets for improving readability and data organization.
Formatting has no impact on data analysis.
Formatting is irrelevant in collaborative spreadsheets.
What is the purpose of inserting a new ROW in a Spreadsheet?
To change the format of the spreadsheet.
To add additional data or information to the spreadsheet.
To delete existing data from the spreadsheet.
To create a new spreadsheet entirely.
Which of the following best describes the use of cell references in formulas?
Cell references are static and do not change with data updates.
Cell references can only link to text data.
Cell references enable dynamic linking of data in formulas.
Cell references are only used for absolute values.
How does the SUM function improve efficiency in Spreadsheets?
The SUM function only works with whole numbers.
The SUM function requires manual entry of each number.
The SUM function is used to format cells in a spreadsheet.
The SUM function improves efficiency by automating calculations and reducing manual errors.
Which formula would you use when multiplying values?
*
+
/
-
What is the role of an IF statement?
To define a variable in a program.
The role of an IF statement is to execute code conditionally based on whether a specified condition is true.
To store data in an array.
To create loops in a program.
How can you calculate the cash raised?
Total cash raised = Total assets - Liabilities
Total cash raised = Sum of funds received - Fundraising costs
Total cash raised = Total expenses - Revenue
Total cash raised = Average donation per donor x Number of donors
what is the outcome of IF statements?
IF statements are used to declare variables.
IF statements can only execute one line of code.
IF statements always return a boolean value.
The outcome of IF statements is the execution of code based on the truth value of a condition.
What task would you use the SUM function for?
To count the number of entries in a list.
To add up a series of numbers.
To find the average of a set of numbers.
To determine the maximum value in a range of cells.
What is the advantage of naming a cell in Spreadsheets?
It increases the file size significantly.
It simplifies formula creation and improves spreadsheet navigation.
It automatically generates charts based on the cell's value.
It prevents any changes to the cell's content.
