Home
Ask Question?
Business Account
Exam
Exam List
Exam Result
Category
1-12 Class
Board Exam
Admission
Job Solution
Skill Development
Book Collection
Video Content
Blog Content
Question
Ask Question?
Current Affairs
All MCQ Question
All Written Question
Upload Question
General
Study Plan
Hand Note
Notice | News
Other
FAQ
Point
Package
Feedback
Home
Academy
Admission
Job Assistant
Current Affairs
Skill
Forum
Blog
Package
Unauthenticate
Guest
example@gmail.com
Login
Description
Home
Edit Description
Back
Edit Description
Fill up the form and submit
Question
Suppose the value of cell E5 in MS-Excel sheet is 3500. If we apply the formula =IF(E5<20000,E5*10%,ES*20%), what will be the result ?
350
3500
700
500
ANSWER : 1
Descrption
<p dir = "ltr" style = "line - height: 1.38; text - indent: 36pt; margin - top: 0pt; margin - bottom: 0pt;"><span style = "font - size: 13.5pt; font - family: Arial; color: #212529; background - color: #ffffff; font - weight: 400; font - style: normal; font - variant: normal; text - decoration: none; vertical - align: baseline; white - space: pre - wrap;"> = IF (E5 < 20000, E5 * 10%,E5 * 20%)</span></p> <p dir = "ltr" style = "line - height: 1.38; text - indent: 36pt; margin - top: 0pt; margin - bottom: 0pt;"><span style = "font - size: 13.5pt; font - family: Arial; color: #212529; background - color: #ffffff; font - weight: 400; font - style: normal; font - variant: normal; text - decoration: none; vertical - align: baseline; white - space: pre - wrap;"><img style = "border: none;" src = "https://docs.google.com/drawings/u/0/d/slbKX36lkhOKUVIwSHHXArg/image?w = 273&h = 38&rev = 3&ac = 1&parent = 1th_F6JE1wgCP4hZ0oZ7K4JJLc - bJ6JqaAcZJ - zBSACE" width = "273" height = "38" aria - roledescription = "Drawing" /></span></p> <p dir = "ltr" style = "line - height: 1.38; text - indent: 36pt; margin - top: 0pt; margin - bottom: 0pt;"><span style = "font - size: 13.5pt; font - family: Arial; color: #212529; background - color: #ffffff; font - weight: 400; font - style: normal; font - variant: normal; text - decoration: none; vertical - align: baseline; white - space: pre - wrap;">প্রথমত এটি মাইক্রোসফট এক্সেলের একটি ফর্মুলা। উপরের সমীকরণের সাথে এটি মিলিয়ে দেখলে বোঝা যায় প্রথম অংশটি একটি Condition বা শর্ত। যদি Condition সত্য হয় তাহলে Value_if_true অনুযায়ী Execute হবে। যদি ভুল হয় তবে value_if_false অনুযায়ী Execute হবে।</span></p> <p><span id = "docs - internal - guid - 82a1b0cf - 7fff - 575e - df77 - ae9df062b470"></span></p> <p dir = "ltr" style = "line - height: 1.38; text - indent: 36pt; margin - top: 0pt; margin - bottom: 0pt;"><span style = "font - size: 13.5pt; font - family: Arial; color: #212529; background - color: #ffffff; font - weight: 400; font - style: normal; font - variant: normal; text - decoration: none; vertical - align: baseline; white - space: pre - wrap;">যেহেতু E5 এর মান 3500, সুতরাং E5 এর মান 20000 থেকে ছোট। অর্থাৎ, Condition বা শর্ত True. সেক্ষেত্রে, </span><span style = "background - color: #ffffff; color: #212529; font - family: Arial; font - size: 18px; white - space: pre - wrap;">Value_if_true অনুযায়ী Execute হবে।</span><span style = "background - color: #ffffff; color: #212529; font - family: Arial; font - size: 13.5pt; white - space: pre - wrap; text - indent: 36pt;"> 3500 এর 10% পার্সেন্ট = 350 হবে উত্তর। উত্তরঃ 350.</span></p>
Please, login first.
click here to login
Cancel
Login
©2024 SATT ACADEMY. All rights reserved.