Data Science-Spreadsheet Functions

Quiz
•
Information Technology (IT)
•
12th Grade
•
Medium
Roger Thompson
Used 5+ times
FREE Resource
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is used to find the average of a set of numbers in Excel?
=SUM(A1:A10)
=MIN(A1:A10)
AVERAGE(A1:A10)
=AVERAGE(A1:A10)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The formula =IF(A1>50, "Pass", "Fail") will return "Pass" if:
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to round a number to two decimal places?
=TRUNC(A1,2)
=ROUND(A1,2)
ROUND(A1,2)
=RND(A1,2)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the $ symbol do in a cell reference, such as $A$1?
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula is used to calculate the sum of a range of cells in Excel?
=SUMIF(A1:A10)
=TOTAL(A1:A10)
=SUM(A1:A10)
=ADD(A1:A10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In Excel, which formula returns the highest value in a range?
=MIN(A1:A10)
MAX(A1:A10)
=MAX(A1:A10)
=SUM(A1:A10)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can be used to find the rank of a number in a list?
=RANK(A1,A1:A10)
RANK(A1,A1:A10)
=MATCH(A1,A1:A10,0)
=INDEX(A1:A10,3)
Create a free account and access millions of resources
Similar Resources on Wayground
50 questions
E.TECH. SPECIAL EXAMINATION

Quiz
•
12th Grade
45 questions
MS Word Kelas 5

Quiz
•
5th Grade - University
50 questions
Persiapan SAS - Artificial Intelligence

Quiz
•
9th - 12th Grade
49 questions
MCQs on Computer Applications

Quiz
•
12th Grade
50 questions
Soal Ujian Microsoft Excel

Quiz
•
10th Grade - University
55 questions
Câu hỏi về máy tính và Internet

Quiz
•
12th Grade
45 questions
Latihan Pemantapan Informatika

Quiz
•
9th - 12th Grade
50 questions
Persiapan PAT Genap 2024-2025

Quiz
•
8th Grade - University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade