
Excel 2016 Lesson 4
Quiz
•
Computers
•
9th - 12th Grade
•
Medium
Jennie Phipps
Used 17+ times
FREE Resource
Enhance your content in a minute
19 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Would the formula (5*3)/4 give the same answer as 5*3/4?
Yes
No
It depends
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A/an ____________ cell reference is one that adjusts the cell identifier automatically if you insert or delete columns or rows or if you copy the formula to another cell.
relative
absolute
neither
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Where can you see formulas?
The formula bar
The cell that contains the answer to the formula if you double click on it.
Both A and B
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which type of reference uses dollar signs?
Relative
Absolute
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following would make the best name when naming a range?
adv time
adv?time
adv_time
None of these
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You can name a cell or a cell range by
Selecting the cell(s) to be named, click in the name box, type the name in and press enter
Click on Define Name on the Formulas tab
Select text to be named and click on Create from Selection
All of the above
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=(A1+A2+A3) is an example of a
value
label
formula
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
Asesmen Sumatif
Quiz
•
12th Grade
15 questions
HTML
Quiz
•
8th - 12th Grade
17 questions
Traffic Light Project Quiz
Quiz
•
9th Grade
20 questions
From Binary To Denary Conversion - IGCSE
Quiz
•
7th Grade - Professio...
16 questions
Kelas 8 - Bagian Microsoft Excel
Quiz
•
8th Grade - University
15 questions
History of Computers
Quiz
•
6th - 12th Grade
15 questions
Vocabulary of Computer
Quiz
•
12th Grade
15 questions
Networking Quiz
Quiz
•
8th - 9th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
