
EA2 Ch4_WB
Authored by YS Kwok
Computers
10th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
1 min • 1 pt
Which of the following statements regarding spreadsheets is/are correct?
Spreadsheets can fill in other cells based on the pattern of selected cells.
A spreadsheet file can only contain one workbook.
A spreadsheet file can only contain one worksheet.
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The table shows a spreadsheet before and after using a certain function. Which of the following is the function used?
Filtering
Freeze panes
Wrap text
Column width
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following is the result of the formula below?
=AVERAGE ( (4+3) * (7+5), (50/5*2))
20
51
52
84
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following is the result of the formula below?
=MAX (B1: C2)
23
43
50
51
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If the value of cell A1 is 57, which of the following is the result of the formula below?
=IF (A1>90, "A", IF (A1>75, "B", IF (A1>50, "C", "F")))
A
B
C
F
6.
MULTIPLE SELECT QUESTION
1 min • 1 pt
Refer to the spreadsheet.
Which of the following formulas return(s) TRUE?
=LEN (A3) = LEN (A4)
=MIN (B2: D2) < MIN(B4:D4)
=LARGE(B3:D3,2) > LARGE(B5:D5,1)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the result of the function below?
=SUMIF (A1:B3, ">5")
13
57
51
91
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
15 questions
Chapter 3: Storage devices and media (Part 2):
Quiz
•
10th - 11th Grade
11 questions
What is a computer
Quiz
•
KG - University
10 questions
Fundamentals of Algorithms
Quiz
•
10th Grade
10 questions
Working with tables
Quiz
•
5th - 12th Grade
10 questions
Электронные таблицы. Основные понятия.
Quiz
•
5th - 11th Grade
15 questions
Ôn tập kỳ 2 tin 6
Quiz
•
1st - 12th Grade
11 questions
Cascading Style Sheets
Quiz
•
8th - 12th Grade
15 questions
REVISION-Primary & Secondary Storage
Quiz
•
10th - 11th Grade
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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