Company: Accenture NIT Patna mcq
Difficulty: medium
Write pseudocode to initialize an array named ages with values [25, 30, 22, 28, 35] and print the second element of the array. 1 ARRAY ages[5] = [25, 30, 22, 28, 35] 2 PRINT ages[2] 1 ARRAY ages[5] 2 ages[1] = 25 3 ages[2] = 30 4 ages[3] = 22 5 ages[4] = 28 6 ages[5] = 35 7 8 PRINT ages[2] 1 ARRAY ages[5] = [25, 30, 22, 28, 35] 2 3 PRINT ages[1] 1 ARRAY ages[5] = [25, 30, 22, 28, 35] 2 PRINT ages[0] In the dataset provided below, your regional head wants to know how many units were sold in the "North" region. You use the following formula: SUMIFS(D2:D9, G2:G9, "North") What result does this formula return? Table Data (A: Product, B: Category, C: Unit Price, D: Units Sold, E: Discount %, F: Sale Date, G: Region): Laptop, Electronics, 850, 10, 5, 10-01-2023, North Monitor, Electronics, 200, 25, 10, 15-01-2023, South Mouse, Accessories, 25, 100, 0, 01-02-2023, North Keyboard, Accessories, 45, 60, 0, 10-02-2023, East Printer, Electronics, 300, 15, 15, 05-03-2023, West Tablet, Electronics,