Logo
    Logo

    Subject

    Bank Exam

    Topic

    বাংলাদেশ ব্যাংক (সহকারী পরিচালক) - ২০.১০.২০২৩

    What will be the result of the formula =Min (Average (B1, B2), Product (B3 : B4) where value of B1 = 20, B2 = 24, B3 = 15, B4 = 20?

    ক)
    20
    খ)
    22
    গ)
    300
    ঘ)
    None of the above

    Explanation

    Let's break down the formula step by step: 1. `Average(B1, B2)` is the average of B1 and B2, which is `(20 + 24) / 2 = 44 / 2 = 22`. 2. `Product(B3:B4)` is the product of the values in cells B3 and B4, which is `15 * 20 = 300`. 3. Finally, `Min(Average(B1, B2), Product(B3:B4))` takes the minimum value between the results of the two previous calculations: `Min(22, 300)`. The minimum value between 22 and 300 is 22. So, the result of the formula is B) 22.

    Related questions

    'আমাকে কি মাল্য দেবে দাও' কবিতার রচয়িতা কে?The profit earned by selling an article for Tk 900 is double the loss incurred when the same article is sold for Tk 450. At what price should the article be sold to make 25% profit?'পাক' এর সঠিক প্রকৃতি প্রত্যয় কোনটি?A man purchases two clocks A and B at a total cost of Tk. 650. He sells A with a 20% profit and B at a loss of 25% and gets the same selling price for both clocks. What are the purchasing prices of A and B respectively?কাজী নজরুল ইসলামের কাব্য খ্যাতিতে কোন পত্রিকার অবদান রয়েছে?Fresh grapes contain 80 percent water while dry grapes contain 10 percent water. If the weight of the dry grapes is 250 kg what is total weight when it was fresh?'শবল' এর বিপরীতার্থক শব্দ কোনটি?When 30% of one number is subtracted from another number, the second number reduces to its four-fifths. What is the ratio of the first to the second number?

    Find Tutors

    View all Tutors