wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Data Science-Spreadsheet Functions

Total questions: 50

Worksheet time: 29mins

Name
Class
Date
1.

Which formula is used to find the average of a set of numbers in Excel?

a)

=SUM(A1:A10)

b)

=MIN(A1:A10)

c)

AVERAGE(A1:A10)

d)

=AVERAGE(A1:A10)

2.

The formula =IF(A1>50, "Pass", "Fail") will return "Pass" if:

a)
A1 contains the text 'Pass'.
b)
A1 contains a number greater than 50.
c)
A1 is empty or contains no value.
d)
A1 contains a number less than 50.
3.

Which function is used to round a number to two decimal places?

a)

=TRUNC(A1,2)

b)

=ROUND(A1,2)

c)

ROUND(A1,2)

d)

=RND(A1,2)

4.

What does the $ symbol do in a cell reference, such as $A$1?

a)
The $ symbol makes the cell reference relative, allowing it to change when copied.
b)
The $ symbol is used to format the cell as currency.
c)
The $ symbol indicates a formula error in the cell reference.
d)
The $ symbol makes the cell reference absolute, preventing it from changing when copied.
5.

What formula is used to calculate the sum of a range of cells in Excel?

a)

=SUMIF(A1:A10)

b)

=TOTAL(A1:A10)

c)

=SUM(A1:A10)

d)

=ADD(A1:A10)

6.

In Excel, which formula returns the highest value in a range?

a)

=MIN(A1:A10)

b)

MAX(A1:A10)

c)

=MAX(A1:A10)

d)

=SUM(A1:A10)

7.

Which function can be used to find the rank of a number in a list?

a)

=RANK(A1,A1:A10)

b)

RANK(A1,A1:A10)

c)

=MATCH(A1,A1:A10,0)

d)

=INDEX(A1:A10,3)

8.

How can you use conditional formatting to highlight cells that contain values greater than 90?

a)
Use conditional formatting to highlight cells greater than 90 by creating a new rule with the condition 'greater than 90'.
b)
Create a rule to highlight cells with values between 80 and 90.
c)
Use conditional formatting to highlight cells equal to 90.
d)
Highlight cells that contain values less than 90.
9.

Which formula would count the number of cells in a range that contain numbers?

a)

=SUM(A1:A10)

b)

COUNT=(A1:A10)

c)

=COUNT(A1:A10)

d)

=AVERAGE(A1:A10)

10.

In a pivot table, which area is used to add the values you want to summarize?

a)
Rows area
b)
Columns area
c)
Values area
d)
Filters area
11.

The formula =VLOOKUP(A1, B1:C10, 2, FALSE) does what?

a)
It looks up a value in A1 and returns the corresponding value from column B.
b)
It calculates the sum of values in column C based on A1.
c)
It checks if the value in A1 exists in column C and returns TRUE or FALSE.
d)

It looks up a value in A1 in column B and returns the value from column C.

12.

What does the standard deviation formula =STDEV(A1:A10) measure?

a)

How much the values vary from the mean

b)
It measures the range of a dataset.
c)
It measures the total number of data points.
d)
It measures the average of a dataset.
13.

Which formula will return the smallest value in a range?

a)

MIN(A1:A10)

b)

=AVERAGE(A1:A10)

c)

=MIN(A1:A10)

d)

=SUM(A1:A10)

14.

How can you link data from Sheet2 cell A1 into Sheet1?

a)
Link data by copying and pasting from Sheet2 to Sheet1.
b)

=A1' in Sheet1.

c)

=Sheet2!A1'

d)
Reference Sheet2 cell A1 by typing 'Sheet2.A1' in Sheet1.
15.

The formula =IF(A1>=50, "Pass", "Fail") will:

a)

Return 'Pass' if A1 is >= 50, otherwise return 'Fail'.

b)

Return "Pass" if A1 is less than 50

c)
Return 'Fail' if A1 is >= 50, otherwise return 'Pass'.
d)
Return 'Pass' if A1 is < 50, otherwise return 'Fail'.
16.

Which formula can restrict entries in a cell to a whole number between 1 and 100?

a)

Use Conditional Formatting > Whole number between 1 and 100

b)

Use SUMIF formula

c)

Use IF formula

d)

Use Data Validation > Allow > Whole number between 1 and 100

17.

The ​ (a)   function checks ​ (b)   is true ​ (c)   , and then shows one result for ​ (d)   for false.

Choose from the below words
IF-THEN
if a condition
or false
true and another
18.

The ​ (a)   function ​ (b)   in one ​ (c)   and ​ (d)   from ​ (e)   in the same row.

Choose from the below words
VLOOKUP
looks for a value
column
returns a value
another column
19.

The ​ (a)   reference feature ​ (b)   when you ​ (c)   . The ​ (d)   locks the row or column.

Choose from the below words
absolute
keeps a cell reference fixed
copy a formula
$ symbol
20.

The ​ (a)   is a tool that helps you ​ (b)   amounts of data by ​ (c)   , averages, or ​ (d)  

Choose from the below words
Pivot Table
summarize large
grouping and calculating totals
other summaries.
21.

Which Excel function is used to concatenate text from multiple cells?

a)

=CONCATENATE(A1, B1)

b)

=JOIN(A1, B1)

c)

=MERGE(A1, B1)

d)

=TEXTJOIN(A1, B1)

22.

What does the Excel function =LEN(A1) return?

a)

The length of the text in cell A1.

b)

The number of words in cell A1.

c)

The number of cells in range A1.

d)

The sum of numbers in cell A1.

23.

Which Excel function can be used to find the current date?

a)

=DATE()

b)

=NOW()

c)

=TODAY()

d)

=CURRENTDATE()

24.

What is the purpose of the Excel function =CONCATENATE(A1, B1)?

a)

To add the values in cells A1 and B1.

b)

To merge the text from cells A1 and B1 into one cell.

c)

To find the average of the values in cells A1 and B1.

d)

To compare the values in cells A1 and B1.

25.

Which Excel function is used to calculate the median of a set of numbers?

a)

=MEDIAN(A1:A10)

b)

=AVERAGE(A1:A10)

c)

=MODE(A1:A10)

d)

=SUM(A1:A10)

26.

How can you freeze the top row in an Excel worksheet?

a)

Go to View > Freeze Panes > Freeze Top Row.

b)

Go to Home > Format > Freeze Top Row.

c)

Go to Insert > Freeze Panes > Freeze Top Row.

d)

Go to Data > Freeze Panes > Freeze Top Row.

27.

Which function is used to add numbers in a range of cells?

a)

=SUM

b)

=CALCULATE

c)

=ADD

d)

=TOTAL

28.

What does the AVERAGE function do?

a)
The AVERAGE function calculates the total of a range of values.
b)
The AVERAGE function computes the mean of a range of values.
c)
The AVERAGE function finds the maximum value in a set of numbers.
d)
The AVERAGE function counts the number of entries in a dataset.
29.

Which function returns the largest value in a range?

a)

=MAX

b)

=SUM

c)

=AVERAGE

d)

=MIN

30.

What does the MIN function return?

a)
The median value from a set of values.
b)
The average value from a set of values.
c)
The smallest value from a set of values.
d)
The largest value from a set of values.
31.

What is the purpose of the IF function?

a)
The purpose of the IF function is to evaluate a condition and return different values based on whether the condition is true or false.
b)
The IF function is designed to create charts and graphs.
c)
The IF function calculates the sum of a range of numbers.
d)
The IF function is used to format text in a cell.
32.

Which function counts the number of numeric entries in a range?

a)

=COUNT

b)

=MAXIMUM

c)

=AVERAGE

d)

=SUM

33.

What does the COUNTA function count?

a)
Only numeric cells in a range.
b)
Non-empty cells in a range.
c)
Empty cells in a range.
d)
Cells with text only in a range.
34.

Which function is used to combine the contents of multiple cells?

a)

=CONCATENATE or & operator

b)

=IF function

c)

=AVERAGE function

d)

=SUM function

35.

Which function is used to combine the contents of multiple cells?

a)

=IF function

b)

=AVERAGE function

c)

=CONCATENATE function or & operator

d)

=SUM function

36.

What does the NOW or TODAY function display?

a)
NOW displays the current date and time; TODAY displays the current date.
b)
NOW and TODAY both display the current time only.
c)
NOW shows the last modified date; TODAY shows the last modified time.
d)
NOW displays the current time only; TODAY displays the current month.
37.

Which function searches for a value in the first column of a range?

a)

=HLOOKUP

b)

=MATCH

c)

=INDEX

d)

=VLOOKUP

38.

What is the output of =SUM(10, 20, 30)?

a)
50
b)
70
c)
60
d)
90
39.

If cell A1 contains "12345", what is the result of =LEFT(A1, 3)?

a)
12
b)
345
c)
1234
d)
123
40.

What is the result of =RIGHT("Hello", 2)?

a)
lo!
b)
Hello
c)
lo
d)
He
41.

Which function removes all extra spaces from the text?

a)

=strip

b)

=clear

c)

=sanitize

d)

=trim

42.

If =IF(A1>10, "Yes", "No") is used and A1 contains 5, what is the result?

a)
Maybe
b)
No
c)
Yes
d)
Definitely not
43.

What will be the output of =SUM(5, 15, 25)?

a)
45
b)
30
c)
50
d)
20
44.

If today’s date is November 28, 2024, what will =NOW() return?

a)
November 28, 2025, current time
b)
December 1, 2024, current time
c)
November 28, 2024, current time
d)
November 28, 2023, current time
45.

If cell A1 contains the value "123.456", what will the result of =ROUND(A1, 2) be?

a)
123.45
b)
123.456
c)
123.46
d)
124.00
46.

If =RIGHT("Microsoft", 5) is used, what will the output be?

a)
softw
b)

osoft

c)
Micro
d)
Micosoft
47.

What will =LEFT("Microsoft", 4) return?

a)
Micro
b)
Micosoft
c)
Microsoft
d)
Micr
48.

If cell A1 contains "Excel" and A2 contains "Fun", what will =CONCAT(A1, " is ", A2) return?

a)
Fun is Excel
b)
Excel is Fun
c)
Excel and Fun
d)
Excel is Boring
49.

What is the output of =MAX(10, 20, 30, 40, 50)?

a)
10
b)
20
c)
50
d)
30
50.

If cell A1 contains 100 and cell A2 contains 50, what is the result of =AVERAGE(A1, A2)?

a)
75
b)
150
c)
50
d)
100

Similar Resources on Wayground

Web Design 1: Final Review

48 questions

Web Design 1: Final Review

quiz

Worksheet

•

10th Grade - University

MedLit Copyryt

45 questions

MedLit Copyryt

quiz

Worksheet

•

12th Grade - University

MEDIA AND INFORMATION LITERACY 2nd Sem 1st Quarter Examination

50 questions

MEDIA AND INFORMATION LITERACY 2nd Sem 1st Quarter Examination

quiz

Worksheet

•

12th Grade

UJI KOMPETENSI PRAKERIN

50 questions

UJI KOMPETENSI PRAKERIN

quiz

Worksheet

•

12th Grade

Ag Power- Alternative Energy

50 questions

Ag Power- Alternative Energy

quiz

Worksheet

•

9th Grade - University

DDPK Networking Service

50 questions

DDPK Networking Service

quiz

Worksheet

•

10th Grade - University

1ST TERM CBT EXAMINATION FOR YEAR 12 2025/2026

50 questions

1ST TERM CBT EXAMINATION FOR YEAR 12 2025/2026

quiz

Worksheet

•

12th Grade

SOAL - 6 INFORMATIKA KELAS X

48 questions

SOAL - 6 INFORMATIKA KELAS X

quiz

Worksheet

•

2nd Grade - University