ICT - Quis Term 2 Grade 7
Authored by saras wati
Computers
7th Grade
Used 24+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you're about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you insert a new row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You can edit a cell by...
Clicking the formula button
Double clicking the cell
Selecting Edit>Edit Cell from the menu
None of above
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula gets the biggest value of a range of cells?
MAX
MIN
LARGE
SUM
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol must all formula begin with?
=
+
(
@
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?
