wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

SF Exam - Comp1

Total questions: 50

Worksheet time: 33mins

Name
Class
Date
1.
Which of the following formulas correctly uses the SUM function to add the values in cells A1, B1, and C1?
a)
=ADD(A1:C1)
b)
=A1+B1+C1
c)
SUM(A1, C1)
d)
=SUM(A1:C1)
2.
In a range of cells (A1:A5) containing the values 10, 20, 30, 40, and a blank cell, what is the result of the formula =AVERAGE(A1:A5)?
a)
#DIV/0!
b)
50
c)
25
d)
20
3.
The range D1:D5 contains the values: 5, 8, 2, 12, 1. What value will the formula =MIN(D1:D5) return?
a)
5
b)
1
c)
28
d)
12
4.
A cell range F1:F5 contains the following values: -10, -5, 0, 5, 10. What is the result of the formula =MAX(F1:F5)?
a)
0
b)
5
c)
-10
d)
10
5.
What is the correct syntax structure for the IF function?
a)
=IF(condition, value_if_true)
b)
=IF(logical_test, value_if_true, value_if_false)
c)
=IF(value_if_true, logical_test, value_if_false)
d)
=IF(value_if_true, value_if_false)
6.
To sum the values in cells B2, C5, and the range D10 to D15, which formula uses the SUM function correctly?
a)
=SUM(B2 C5 D10:D15)
b)
=SUM(B2:C5:D10:D15)
c)
=SUM(B2+C5+D10:D15)
d)
=SUM(B2, C5, D10:D15)
7.
A cell range A1:A4 contains the values: 10, 20, 'Score', 40. What is the result of the formula =AVERAGE(A1:A4)?
a)
23.3333333333333
b)
17.5
c)
#VALUE!
d)
70
8.
The MIN function is most suitable for which of the following scenarios?
a)
Adding up all monthly expenses for the year.
b)
Identifying the top 5% of sales representatives.
c)
Determining the lowest recorded temperature in a dataset.
d)
Calculating the class average for a test.
9.
Which Excel function is specifically designed to find the highest numerical value in a range of cells?
a)
MAX
b)
TOP
c)
LARGE
d)
HIGH
10.
Cell A1 contains the value 75. What is the result of the formula =IF(A1>80, "Pass", "Fail")?
a)
Pass
b)
75
c)
80
d)
Fail
11.
Which of the following is an example of an incorrectly structured SUM function?
a)
=SUM(A1:A5)
b)
=SUM(A1; A5)
c)
=SUM(A1, B2, C3)
d)
=SUM(A:A)
12.
What happens when the AVERAGE function encounters a cell that contains the number $\$0$ (zero) in a range?
a)

The function returns a #DIV/0! error.

b)

The value 0 is included in the sum (numerator), but the cell is excluded from the count (denominator).

c)

The value 0 is included in the sum (numerator) and the cell is included in the count (denominator).

d)
The cell is ignored, and not included in the calculation.
13.
The column 'Sales' (C2:C100) contains sales figures. Which function would you use to find the smallest sale made during the period?
a)
AVERAGE(C2:C100)
b)
MAX(C2:C100)
c)
SMALL(C2:C100, 1)
d)
MIN(C2:C100)
14.
The column 'Height' (B2:B50) contains the height measurements of students. Which function is best for identifying the tallest student's height?
a)
LARGE
b)
MAX
c)
HEIGHT
d)
MIN
15.
In the formula =IF(A1="Complete", B1, 0), what is the value_if_false argument?
a)
A1="Complete"
b)
The entire formula
c)
B1
d)

0

16.
If a range contains both numbers and text, what does the SUM function do with the text values?
a)

It returns a #VALUE! error.

b)
It includes the text values as 1 in the calculation.
c)
It ignores the text values and only sums the numerical values.
d)

It includes the text values as $0 (zero) in the calculation.

17.
A student has scores of 85, 90, 75, and 100 in four exams (B1:B4). What is the result of =AVERAGE(B1:B4)?
a)
85
b)
87.5
c)
350
d)
90
18.
Given the range A1:A4 contains -10, 5, 15, -20. What are the results of =MIN(A1:A4) and =MAX(A1:A4) respectively?
a)
-20 and 15
b)
-20 and -10
c)
-10 and 15
d)
5 and 15
19.
In the formula =MAX(A1, B1, C1, D1), if all cells contain negative numbers (e.g., -5, -1, -10, -3), which cell's value will be returned?
a)
The number closest to zero (e.g., -1).
b)
An error, because the maximum must be a positive number.
c)
The most negative number (e.g., -10).
d)

0

20.
What is the primary purpose of nesting an IF function (i.e., using one IF function as the value_if_true or value_if_false of another IF function)?
a)
To sum the results of two different formulas.
b)
To check only one condition instead of multiple.
c)
To reduce the file size of the Excel workbook.
d)
To check and evaluate more than two possible outcomes or conditions.
21.
If cells A1, B1, and C1 contain the number 5, what is the result of =SUM(A1:C1)?
a)
12.5
b)
15
c)
5
d)
10
22.
What is the average of the following list of numbers: 10, 20, 30, and a blank cell?
a)
20
b)
15
c)
18.75
d)
30
23.
To find the lowest score achieved on a student exam across all 50 students listed in column G, which function is the most appropriate?
a)
LOW
b)
AVERAGE
c)
MIN
d)
SMALLEST
24.
A sales manager wants to identify the single largest transaction amount from a list of thousands of sales recorded in column J. Which function should be used?
a)
MAX
b)
LARGE
c)
SUM
d)
HIGH
25.
In the IF logical test, which operator means 'Greater than or equal to'?
a)
=<
b)
>
c)
>=
d)
<=
26.
Cell A1 is 10, A2 is 5, A3 is 'Apples'. What is the result of the formula =SUM(A1:A3, 10)?
a)
#VALUE!
b)
15
c)
35
d)
25
27.
A range of cells contains the numbers: 10, 20, 0. What is the average of these numbers?
a)
20
b)
15
c)
10
d)
30
28.
If you use the MIN function on a range of cells containing both positive numbers and dates, what value is likely to be returned?
a)
The latest date.
b)
The largest positive number.
c)
The earliest date.
d)
An error, as dates and numbers cannot be mixed.
29.
Cell A1 is -5, B1 is -2, C1 is -8. What is the result of the formula =MAX(A1:C1)?
a)
5
b)
-5
c)
-8
d)
-2
30.
What is the expected result of the IF statement: =IF(C1<=10, C1*2, C1/2) if cell C1 contains the value 4?
a)
4
b)
8
c)
10
d)
2
31.
True or False: The formula =SUM(A1+A2+A3) is the correct and preferred way to use the SUM function to add three cells.
a)
True
b)
False
32.
True or False: The AVERAGE function treats a cell containing text (e.g., 'Not Available') as $0 (zero) when calculating the average.
a)
True
b)
False
33.
True or False: The MIN function can be used to find the earliest date in a range of dates.
a)
True
b)
False
34.
True or False: If a range contains both positive and negative numbers, the MAX function will return the positive number closest to zero.
a)
True
b)
False
35.
True or False: The value_if_true and value_if_false arguments of an IF function must always be a text value enclosed in quotation marks.
a)
True
b)
False
36.
True or False: The SUM function can only be used on a single, contiguous range of cells (e.g., A1:A10).
a)
True
b)
False
37.
True or False: A cell with a blank value is treated the same as a cell with a value of $\$0$ (zero) by the AVERAGE function.
a)
True
b)
False
38.
True or False: The formula =MIN(A:C) is an efficient way to find the minimum value in only columns A and C.
a)
True
b)
False
39.
True or False: The MAX function returns the value in the first cell of the range if all cells in the range are the same value.
a)
True
b)
False
40.
True or False: The first argument of the IF function, the logical_test, must always evaluate to a boolean result (TRUE or FALSE).
a)
True
b)
False
41.

True or False: The VLOOKUP function requires the column containing the lookup value (the value you are searching for) to be the first column in the specified table array.

a)

True

b)

False

42.

True or False: In a VLOOKUP formula, the column index number specifies the column containing the data you want to retrieve, counting from the left side of the table array.

a)

True

b)

False

43.

True or False: If you set the range_lookup argument in VLOOKUP to FALSE, the function will accept the closest match instead of an exact match.

a)

True

b)

False

44.

True or False: The LOOKUP function, in its Vector form, can look up a value and return a corresponding value from a range that is not sorted.

a)

True

b)

False

45.

True or False: When VLOOKUP is set to look for an exact match, if it finds the lookup value more than once, it will return the corresponding value from the last matching entry.

a)

True

b)

False

46.

True or False: The LOOKUP function's "Array form" is generally considered the more flexible and common version compared to the "Vector form."

a)

True

b)

False

47.

True or False: If VLOOKUP cannot find an exact match (and is set to exact match), it returns the error value #N/A.

a)

True

b)

False

48.

True or False: When using an approximate match (TRUE or omitted) in VLOOKUP, the lookup column does not need to be sorted in ascending order.

a)

True

b)

False

49.

True or False: LOOKUP can perform a reverse lookup, meaning it can retrieve data to the left of the lookup column.

a)

True

b)

False

50.

True or False: VLOOKUP is designed to search data vertically (down the column) rather than horizontally across a row.

a)

True

b)

False

Similar Resources on Wayground

Final Exam - Introduction to Computing

52 questions

Final Exam - Introduction to Computing

quiz

Worksheet

•

University

CorelDRAW Application Quiz

51 questions

CorelDRAW Application Quiz

quiz

Worksheet

•

12th Grade - University

Excel - Hàm

50 questions

Excel - Hàm

quiz

Worksheet

•

9th Grade - University

Midterm Exam for AST 122

50 questions

Midterm Exam for AST 122

quiz

Worksheet

•

University

CCNA 2 Module 1-4

51 questions

CCNA 2 Module 1-4

quiz

Worksheet

•

University

Year 11 January Recap

50 questions

Year 11 January Recap

quiz

Worksheet

•

University

COMBINATIONAL DIGITAL CIRCUITS

55 questions

COMBINATIONAL DIGITAL CIRCUITS

quiz

Worksheet

•

University

LATIHAN SOAL

50 questions

LATIHAN SOAL

quiz

Worksheet

•

10th Grade - University