
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
20 questions
NMMS MAT 7காலம் சார்ந்த கணக்குகள்
Quiz
•
University
15 questions
PLANE TABLE SURVEYING
Quiz
•
University
15 questions
VARIAÇÃO LIGUÍSTICA COM ROBISMAR ALENCAR
Quiz
•
University
14 questions
All of piggy roblox by MiniToon
Quiz
•
1st Grade - Professio...
20 questions
MIS Chapter 4
Quiz
•
University
15 questions
STOCK MARKET
Quiz
•
8th Grade - University
16 questions
Adopt me Questions #1
Quiz
•
KG - University
15 questions
Barcode Verification Basics
Quiz
•
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Other
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
5 questions
Poetry Interpretation
Interactive video
•
4th Grade - University
19 questions
Black History Month Trivia
Quiz
•
6th Grade - Professio...
15 questions
Review1
Quiz
•
University
15 questions
Pre1
Quiz
•
University
