
EXCEL 4
Quiz
•
Other
•
University
•
Practice Problem
•
Hard

Gozde Erdogan
Used 2+ times
FREE Resource
Enhance your content in a minute
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Question 1: The name Rate has been given to cell B1. Cell B4 contains the formula =$A4*Rate. If you copy this formula to C4, what will be the outcome?
0
135
1522.5
1350
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which function from the below options will get us the last name in both the cells when dragged after entering in cell B2 to B3?
=RIGHT(A2,LEN(A2)-SEARCH(" ",A2))
=LEFT(A2,SEARCH(" ",A2)-1)
=RIGHT(A2,SEARCH(" ",A2)-1)
=LEFT(A2,LEN(A2)-SEARCH(" ",A2))
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
I entered a date in cell B4 and I need to replace the value in that cell with 10.5 (to be used in the calculation) and have it displayed as “10.5” (without the quotes) how can I do this?
I should change the formatting of the cell to Number
First I should delete the date with the delete key
I can only enter a date in cell B4, not any other type of value
I should press the space-bar before entering the value 10.5
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Expecting cell A1 is showing the number "14000.7489". What function ought to be utilized to round this number to the nearest integer?
=ROUND(A1,0)
=MROUND(A1,100)
=MROUND(A1,10)
=ROUND(A1,1
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Assume an organization expected that its income should be $180,000 for 2014-2018. What function ought to be entered in cell E6 so it shows income in 2016 if it was above budget, else it'll display 0?
=IF(E2<$B$6,E2,0)
= IF(E2<$B$6,0,E2)
=IF(E2>$B$6,0,E2)
=IF(E2>$B$6,E2,0)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You entered below formula in cell E3 =VLOOKUP(2000,A2:C9,2,TRUE). What will be the outcome?
Alameda
#N/A
Phoenix
Antioch
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would be the result of this function shown in the image?
18.500%
17.5000%
4.340%
2.770%
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
13 questions
disney princesses
Quiz
•
KG - Professional Dev...
14 questions
AFIOTR Basic
Quiz
•
6th Grade - University
20 questions
Planning lessons
Quiz
•
University
20 questions
CB CHAPTER 8 Pay for Performance Plans
Quiz
•
University
15 questions
Science Report 1 - Summary
Quiz
•
University
17 questions
Questionnaire Design
Quiz
•
University
22 questions
Guess The Rapper?
Quiz
•
7th Grade - Professio...
20 questions
Module 8: State and Non-state Institutions
Quiz
•
11th Grade - University
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
Discover more resources for Other
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
5 questions
Helping Build the Internet: Valerie Thomas | Great Minds
Interactive video
•
11th Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
19 questions
Review2-TEACHER
Quiz
•
University
15 questions
Pre2_STUDENT
Quiz
•
University
20 questions
Ch. 7 Quadrilateral Quiz Review
Quiz
•
KG - University
