
ict test
Quiz
•
Computers
•
University
•
Practice Problem
•
Medium
ayakoz.zheksenbay apple_user
Used 18+ times
FREE Resource
Enhance your content in a minute
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the AVERAGE() function?
Calculates the sum of a range of numbers.
Calculates the mean of a range of numbers.
Finds the maximum value in a range of numbers.
Finds the minimum value in a range of numbers.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Before writing any formula, we select the cell and press…
+
=
:
;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choose the wrong expression in Excel.
=SUM(A1:A5)
=AVERAGE(B1:B5)
=SUM(A1:A5;B1:B5)
=COUNT(A1:A5)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choose the correct expression in Excel.
=SUM(A1:A5)
=SUM(A1+A5)
=SUM(A1:A5)
=TOTAL(A1:A5)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will A3 contain if A1=500, A2=450, and autofill is used?
400
450
300
500
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will A3 contain if A1=300, A2=350, and autofill is used?
400
300
350
5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Can a cell be transferred from horizontal to vertical?
No
Yes, using Copy-Paste only.
Yes, using the Transpose option.
Yes, using Autofill.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
42 questions
Final Coverage_Quiz 1
Quiz
•
University
40 questions
Tugas Informatika Kelas X SMAN 1 Tjb
Quiz
•
10th Grade - University
40 questions
IOT_SARS
Quiz
•
University
40 questions
การผลิตสื่อสิ่งพิมพ์
Quiz
•
University
40 questions
C++ Basics
Quiz
•
University
40 questions
Evaluación de MS word
Quiz
•
University
40 questions
quiz informatika
Quiz
•
8th Grade - University
40 questions
KUIS JARINGAN DASAR MEI 2024
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
