Font size
WorksheetsRQ1Exl
Total questions: 75
Worksheet time: 38mins
Which Excel function is commonly used to retrieve a value from a table based on a lookup value?
INDEX
MATCH
VLOOKUP
SUM
What does the formula =IF(A1="", "Missing", A1) do?
Returns A1 if it is empty
Returns 'Missing' if A1 is empty
Returns TRUE if A1 is not empty
Returns FALSE if A1 is empty
Which feature allows you to change the cell color based on its value?
Data Validation
Conditional Formatting
Cell Linking
Pivot Table
What is the purpose of Data Validation in Excel?
To format cells
To restrict data entry
To calculate values
To link cells
Which function calculates the average of a range of numbers?
SUM
COUNT
AVERAGE
MAX
What does the formula =VLOOKUP(85, TransmuteTable, 2, TRUE) return?
The exact match for 85
The closest match for 85
The second column value for 85
An error if 85 is not found
Which Excel feature allows you to link data from one sheet to another?
Cell Linking
Conditional Formatting
Data Validation
Sorting
What does the formula =IF(B2>75, "Pass", "Fail") do?
Returns Pass if B2 is less than 75
Returns Fail if B2 is greater than 75
Returns Pass if B2 is greater than 75
Returns Fail if B2 is empty
Which function returns the number of cells that contain numbers?
COUNT
COUNTA
COUNTIF
SUM
What is the result of =ROUND(89.456, 1)?
89.4
89.5
89.45
90
What does the formula =IF(C10>60, "Pass", "Fail") do?
Returns Pass if C cell is less than 60
Returns Fail if C cell is greater than 60
Returns Pass if C cell is greater than 60
Returns Fail if C cell is empty
Which Excel function retrieves a value from a table based on a lookup value?
INDEX
MATCH
VLOOKUP
SUM
What does the formula =IF(A1="", "Missing", A1) do?
Returns A1 if it is empty
Returns "Missing" if A1 is empty
Returns TRUE if A1 is not empty
Returns FALSE if A1 is empty
Which feature allows you to change cell color based on its value?
Data Validation
Conditional Formatting
Cell Linking
Pivot Table
What is the purpose of Data Validation in Excel?
To format cells
To restrict data entry
To calculate values
To link cells
Which function calculates the average of a range of numbers?
SUM
COUNT
AVERAGE
MAX
What does =VLOOKUP(85, TransmuteTable, 2, TRUE) return?
The exact match for 85
The closest match for 85
The second column value for 85
An error if 85 is not found
Which Excel feature allows linking data from one sheet to another?
Cell Linking
Conditional Formatting
Data Validation
Sorting
What does =IF(B2>75, "Pass", "Fail") do?
Returns Pass if B2 is less than 75
Returns Fail if B2 is greater than 75
Returns Pass if B2 is greater than 75
Returns Fail if B2 is empty
Which function counts cells containing numbers?
COUNT
COUNTA
COUNTIF
SUM
What is the result of =ROUND(89.456, 1)?
89.4
89.5
89.45
90
What does =IFERROR(A1/B1, "Error") do?
Returns A1/B1 or "Error" if division fails
Returns TRUE if A1 is not zero
Returns A1 if B1 is zero
Returns "Error" if A1 is blank
Which function joins text from multiple cells?
CONCATENATE
JOIN
TEXTJOIN
MERGE
What does =LEN("Excel") return?
4
5
6
0
Which function extracts the first character from a cell?
RIGHT
MID
LEFT
LEN
What does =ISNUMBER(A1) return if A1 contains 123?
TRUE
FALSE
123
Error
What does =ISBLANK(A1) return if A1 is empty?
TRUE
FALSE
""
Error
Which function counts non-empty cells?
COUNT
COUNTA
COUNTIF
COUNTBLANK
What does =TEXT(TODAY(), "mm/dd/yyyy") return?
A number
A date in text format
An error
The current time
What is the purpose of the MATCH function?
To find the position of a value in a range
To return a value from a table
To count matching values
To compare two cells
What does =INDEX(A1:A5, 3) return?
A3
3
A1
A5
What does =AND(A1>0, B1<10) return if A1=5 and B1=8?
TRUE
FALSE
13
Error
What does =OR(A1>10, B1<5) return if A1=8 and B1=3?
TRUE
FALSE
11
Error
What does =NOT(TRUE) return?
TRUE
FALSE
1
0
Which function returns the current date?
NOW
TODAY
DATE
TIME
What does =NOW() return?
Current date
Current time
Current date and time
Today's weekday
What does =IF(A1=60, "Base", "Not Base") return if A1=60?
Base
Not Base
TRUE
60
What is the default alignment for numbers in Excel?
Left
Right
Center
Justify
What is the default alignment for text in Excel?
Left
Right
Center
Justify
What does the Fill Handle do?
Copies formatting
Copies formulas or values
Deletes content
Adds borders
What does Freeze Panes do?
Locks the entire sheet
Prevents editing
Keeps rows/columns visible while scrolling
Hides rows
What does =IF(A1=60, "Base", "Not Base") return if A1=60?
Base
Not Base
TRUE
60
What is the default alignment for numbers in Excel?
Left
Right
Center
Justify
What is the default alignment for text in Excel?
Left
Right
Center
Justify
What does the Fill Handle do?
Copies formatting
Copies formulas or values
Deletes content
Adds borders
What does Freeze Panes do?
Locks the entire sheet
Prevents editing
Keeps rows/columns visible while scrolling
Hides rows
What does the TRANSPOSE function do?
Converts text to uppercase
Reverses cell values
Switches rows to columns and vice versa
Sorts data alphabetically
What does =INDIRECT("A1") return?
The value in cell A1
The address of cell A1
A formula
An error
What does =OFFSET(A1, 2, 1) return?
Value two rows down and one column to the right of A1
A1
A range
An error
What is the use of Named Ranges in Excel?
To create charts
To simplify formulas
To validate data
To protect cells
What does =COUNTIF(A1:A10, ">60") do?
Counts cells equal to 60
Counts cells greater than 60
Counts all cells
Returns 60
What does =IF(A1>60, "High", "Low") return if A1 is 75?
High
Low
TRUE
75
What is the purpose of the Transmutation Table in grading?
To convert raw scores to final grades
To calculate averages
To validate entries
To sort learners
What does =MAX(A1:A10) return?
The smallest value
The largest value
The average
The count
What does =MIN(A1:A10) return?
The smallest value
The largest value
The average
The count
What does =IFERROR(VLOOKUP(A1, Table, 2, FALSE), "Not Found") do?
Returns error
Returns "Not Found" if lookup fails
Returns A1
Returns TRUE
What does =CONCAT(A1, B1) do?
Adds numbers
Joins text from A1 and B1
Multiplies values
Returns a formula
What does =TEXT(A1, "0.00") do?
Converts A1 to text with two decimals
Rounds A1
Returns A1
Converts A1 to a date
What does =RANK(A1, A1:A10) do?
Returns the position of A1 in the range
Returns the value of A1
Returns the average
Returns the count
What does =IF(A1>=90, "A", IF(A1>=80, "B", "C")) return if A1=85?
A
B
C
Error
What does =IF(A1="", "Empty", "Filled") return if A1 is blank?
Empty
Filled
TRUE
Error
What does =IF(A1>100, "Exceeded", "OK") return if A1=101?
OK
Exceeded
TRUE
Error
What does =IF(A1<0, "Negative", "Positive") return if A1=-5?
Negative
Positive
TRUE
Error
What does =IF(A1=0, "Zero", "Non-zero") return if A1=0?
Zero
Non-zero
TRUE
Error
What does =IF(A1>=50, "Pass", "Fail") return if A1=49?
Pass
Fail
TRUE
Error
What does =IF(A1<=100, "Valid", "Invalid") return if A1=101?
Valid
Invalid
TRUE
Error
What does =IF(A1<>B1, "Different", "Same") return if A1=5 and B1=5?
Different
Same
TRUE
Error
What does =IF(A1=B1, "Match", "No Match") return if A1=5 and B1=6?
Match
No Match
TRUE
Error
What does =IF(A1>=60, "Passed", "Failed") return if A1=60?
Passed
Failed
TRUE
Error
What does =IF(A1<60, "Failed", "Passed") return if A1=59?
Passed
Failed
TRUE
Error
The formula =IF(AL7="", "", VLOOKUP(AL7, TRANSMUTE, 4, TRUE)) uses the (a) function to retrieve a value from a table.
The weight of the Performance Task in Quarter 2 is (a) .
The transmutation table converts raw scores into (a) grades.
The total weight of all grading components in a quarter is (a) .
The base score used for computing grades in Quarter 3 is (a) .
