Excel Basics and More
Authored by Greg Baker
Computers
7th - 12th Grade
CCSS covered
Used 47+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
22 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 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
2.
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)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which symbol must all formula begin with?
=
+
(
@
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Columns go...
Across
Down
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rows go...
Across
Down
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a cell reference, for example A1, what does the letter refer to?
The column
The cell
The row
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?
