The worksheet is not protected and there are invalid data.
Two cells have wrong input.
Which of the following cell addresses currently contain invalid data.
SST8 Summary Quiz
Quiz
•
Computers
•
10th Grade
•
Hard
Chen Xia
Used 3+ times
FREE Resource
7 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
1 min • 1 pt
The worksheet is not protected and there are invalid data.
Two cells have wrong input.
Which of the following cell addresses currently contain invalid data.
B6
B10
F4
G3
G7
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Cell F3 is the number of paper plate bought.
Which of the following is the validation criteria for the cell?
Type check: Whole number
Type check: Decimal numbers
Type check: Text length
3.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
We can protect the worksheet to avoid data input errors.
The worksheet is protected to ensure only the amount donated by each participant and quantity of item bought are editable.
Write down the range of cell addresses that should be unlocked.
Enter your answer as such: __:__ and __:__
4.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
Write down the formula for cell G7.
5.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
Cell A10 calculates the amount of money left after all the donations are collected and the specified number of items are bought.
Write down ONE cell that would be affected if the value in cell F6 is changed. [There are 3 possible answers.]
6.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
Cell A10 calculates the amount of money left after all the donations are collected and the specified number of items are bought.
Suggest a formula for cell A10.
7.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
We wish to "break even" (i.e., no profit or loss) by only varying the quantity of drinks bought.
Write down what we should enter for
"set cell", "to value" and "by varying cell"
in the Goal Seek window to calculate the new quantity of drinks to be bought.
Enter your answer as:
__,__,__
10 questions
Câu hỏi về hàm SUMIF trong Excel
Quiz
•
9th Grade - University
12 questions
Ex - Basic Functions 2
Quiz
•
9th - 12th Grade
10 questions
QUIS APLIKASI PENGOLAH ANGKA
Quiz
•
10th Grade
12 questions
Spreadsheets-grade-10
Quiz
•
10th Grade
10 questions
Analisis Data
Quiz
•
9th - 12th Grade
12 questions
PowerPoint Quiz
Quiz
•
7th Grade - University
12 questions
Excel Lanjut
Quiz
•
9th - 12th Grade
10 questions
LATIHAN PENGETAHUAN MS EXCEL FUNGSI SUMIF
Quiz
•
10th Grade
25 questions
Equations of Circles
Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)
Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System
Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice
Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers
Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons
Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)
Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review
Quiz
•
10th Grade