NEW
Font size
WorksheetsPre-Test Spreadsheet 2
Total questions: 25
Worksheet time: 13mins
Which of the following is an example of alphanumeric (text) data?
12345
TRUE
Hello123
12/09/2025
Which data type is most suitable for storing a person's date of birth?
Number
Text
Date
Boolean
Which of these values would be stored as a number (numeric data type) in a spreadsheet?
3.14
"3 blind mice"
12 March 2025
ABC123
A telephone number (e.g. 0857921234) should be stored as which data type to preserve any leading zeros?
Number (Integer)
Date/Time
Text (Alphanumeric)
Currency
Which feature makes the text in a cell darker and thicker?
Bold
Italic
Underline
Highlight
If you want to change the background color of a cell, which tool should you use?
Fill Color (paint bucket icon)
Font Color (text color A icon)
Border style
Sort & Filter
⭐ True or False: In Excel, text is left-aligned in the cell by default, and numbers are right-aligned by default.
True
False
Which of the following is a horizontal alignment option for cell content?
Align Left
Rotate Text Up
Merge Cells
Wrap Text
If you apply the Percentage format to the number 0.5, how will it be displayed in the cell?
50%
5%
0.5%
0.5
True or False: Changing a cell’s format (e.g. making text bold or applying a number format) does not change the underlying value in the cell.
True
False
Which function would you use to add up a series of numbers in Excel?
SUM
MAX
MIN
AVERAGE
Which Excel function returns the largest value from a set of numbers?
MIN
MAX
AVERAGE
SUM
What will the formula =MIN(8, 6, 4, 10) return?
4
10
8
6
If cells A1, A2, A3 contain 5, 10, 15 respectively, what will =AVERAGE(A1:A3) display?
5
10
15
30
Which of these is NOT a valid function name in Excel?
SUM
AVERAGE
MAX
ADD
In Excel, formulas and functions must always start with which symbol?
= (equal sign)
+ (plus sign)
@ (at symbol)
# (hash)
What does the IF function do in a spreadsheet?
Adds together values in a range.
Checks a condition and returns one value if it’s true and another if it’s false.
Repeats a set of steps a specified number of times.
Finds the largest value in a range.
If cell A1 contains 30, what will the formula =IF(A1>=50, "Pass", "Fail") display?
Pass
Fail
30
"A1>=50"
What is a "nested IF" formula?
An IF function placed inside another IF function.
An IF function using multiple AND/OR conditions.
An IF statement repeated on multiple lines.
An error in an IF formula.
How many possible results can a single IF function return?
1
2
3
Unlimited
Which formula correctly assigns a performance category based on a score in B2 (>=80 = "Excellent"; 50–79 = "Good"; below 50 = "Needs Improvement")?
=IF(B2>=80, "Excellent", IF(B2>=50, "Good", "Needs Improvement"))
=IF(B2>=80, "Excellent", "Good", "Needs Improvement")
=IF(B2=50, "Good", "Excellent")
What does the LEFT function do?
Extracts a given number of characters from the left side of a text string.
Extracts characters from the right end of a text string.
Returns the leftmost non-empty cell in a row.
Aligns text to the left within a cell.
What does the RIGHT function do?
Returns a given number of characters from the end (right side) of a text string.
Finds the rightmost numeric value in a range.
Extracts the first character of a text string.
Aligns text to the right within a cell.
If cell A1 contains the text "BANANA", what will =LEFT(A1, 3) return?
BAN
ANA
NAN
BANANA
If cell A1 contains "BANANA", what will =RIGHT(A1, 2) return?
BA
NA
ANA
2
