Current Attempt in ProgressThe following Excel image has a VBA program (see below).What will be the result after the program is executed?Any cells not displayed are currently empty, and any cells with numbers are formatted numeric.BOROUGHBronx3 Queens4 ManhattanBronx6 QueensQueens8 Queens9 Manhattan10 Manhattan11 Manhattan12 Manhattan13 Bronx14 Queens15 Manhattan16 BronxEnd IfSub Object late_average_SAT_score_for_school_type()first row 2last_row Range ("A1000").End (x1Up) .RowEnd SubTYPE SAT READING SAT MATH SAT WRITINGPRIVATEPRIVATEPUBLICPRIVATEPUBLICPUBLICPRIVATEPUBLICPRIVATEPUBLICPRIVATEPRIVATEPUBLICPUBLICPUBLIC444397425O 1,395O 912O 1,365O 825O 1,358568524Save for I ater433430544395468452492471451459NextCells (last_row + 3, 1).Value = "SAT scores "Cells (last_row + 3, 5).Valuesum_sat_scoreD454688553455434435660455435454456For current_row last_row To first row Step -3If Cells (current_row, 1).Value = "Bronx" Or Cells (current_row, 1).Value = "Queens" Thensum_sat_score= sum_sat_score + Cells (current_row, 5).Value660449574688425492471524468568451544433459395430444452397Att The following Excel image has a VBA program (see below).What will be the result after the program is executed?Any cells not displayed are currently empty, and any cells with numbers are formatted numeric.1234567891011121314AExam NoBFirst Name1 ISMAEL2 YANCI3 CAROL4 MATT9 ADAM6 DAISub AFD ()tot - 0End Sub5 JAVANNA HAIMA6 DONIQUE9 FELIPE7 THOMAS LINсLast NameRODRIGUEZ JRCHENTOFFINO 1,845O 22,530O 25,040O 12,854O 10,845WALDRONRANALLALINDElseSave for LaterGRACE-FEARONRODRIGUEZNext iMsgBox "The final result isDSick DaysLastRow= Cells (Rows.Count, 1).End (x1Up).RowFor i Last Row To 9 Step -1If Cells (1, 1).Value = 9 Or Cells (i, 2).Value = 10 Thentot tot + Cells (1, 5)ESalary10 $15,000 ACCOUNTANT5 $25,000 ACCOUNTANT15 $15,000 POLICE OFFICERtot tot + Cells (i, 4)End IfFTitle5 $25,000 POLICE OFFICER5 $15,000 POLICE OFFICER15 $20,000 POLICE OFFICER10 $15,000 CHIEF FIREFIGHTER25 $15,000 CHIEF FIREFIGHTER$25,000 CHIEF FIREFIGHTER$10,000 CHIEF FIREFIGHTER105" & tot, . " 2200"Att

- We need to work on the code with the excel sheet to get to the correct output. - Since there are…

Current Attempt in Progress The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are currently empty, and any cells with numbers are formatted numeric. 1 BOROUGH 2 Bronx 3 Queens 4 Manhattan 5 TYPE SAT READING SAT MATH SAT WRITING PRIVATE PRIVATE PUBLIC PRIVATE PUBLIC Bronx Queens 7 Queens 8 Queens 9 Manhattan PUBLIC PRIVATE PUBLIC PRIVATE 10 Manhattan 11 Manhattan PUBLIC 12 Manhattan PRIVATE 13 Bronx PRIVATE 14 Queens PUBLIC PUBLIC 15 Manhattan 16 Bronx PUBLIC Sub Object first row – 2 last row Range ("A1000").End (x1Up).Row End If Next 444 397 425 late_average_SAT_score_for_school_type() End Sub 568 524 433 430 544 395 468 452 492 471 451 459 O 1,395 O 912 O 1.365 O 825 O 1,358 For current_row last_row To first row Step -3 If Cells (current_row, 1).Value = "Bronx" Or Cells (current_row, 1).Value = "Queens" Then sum_sat_score= sum_sat_score + Cells (current_row, 5).Value Cells (last_row+3, 1).Value = "SAT scores " Cells (last_row + 3, 5).Value sum_sat_score 454 688 553 455 434 435 660 455 435 454 456 660 449 574 688 425 492 471 524 468 568 451 544 433 459 395 430 444 452 397

Current Attempt in Progress The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are currently empty, and any cells with numbers are formatted numeric. 1 BOROUGH 2 Bronx 3 Queens 4 Manhattan 5 TYPE SAT READING SAT MATH SAT WRITING PRIVATE PRIVATE PUBLIC PRIVATE PUBLIC Bronx Queens 7 Queens 8 Queens 9 Manhattan PUBLIC PRIVATE PUBLIC PRIVATE 10 Manhattan 11 Manhattan PUBLIC 12 Manhattan PRIVATE 13 Bronx PRIVATE 14 Queens PUBLIC PUBLIC 15 Manhattan 16 Bronx PUBLIC Sub Object first row – 2 last row Range ("A1000").End (x1Up).Row End If Next 444 397 425 late_average_SAT_score_for_school_type() End Sub 568 524 433 430 544 395 468 452 492 471 451 459 O 1,395 O 912 O 1.365 O 825 O 1,358 For current_row last_row To first row Step -3 If Cells (current_row, 1).Value = "Bronx" Or Cells (current_row, 1).Value = "Queens" Then sum_sat_score= sum_sat_score + Cells (current_row, 5).Value Cells (last_row+3, 1).Value = "SAT scores " Cells (last_row + 3, 5).Value sum_sat_score 454 688 553 455 434 435 660 455 435 454 456 660 449 574 688 425 492 471 524 468 568 451 544 433 459 395 430 444 452 397

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write a for-loop that will write to the HTML document the value of each element in the array called myArray. Note: You only need to write a for-loop. Code on the outside of the for-loop is not necessary as we will assume that myArray has been declared and initialized with a series of array elements.
x = zeros(uint8(5,5)); for i = 1:5 for j = 1:5 a = 5/i; x(i,j) = 255/a; end end Which of the following best describes the black and white image x? 1. The columns of x will get lighter from left to right 2. The rows of x will get lighter from top to bottom 3. The rows of x will get darker from top to bottom 4. The columns of x will get darker from left to right
Write an algorithm that outline how to calculate the room area for the image below
c) Plot sin(0) and cos(0) for 0<0<2r_inthe same plot. i) add labels and a legend, i) Use different line styles and colors for the plots.
Hi I need help with this question please, my code failed the test.
Q3) Use the following rule in mathematical morphology to fill the holes inside the image A to be black. Let the first pixel in the hole is P=Xo.Then, proceed by finding Xk until Xi=X.1. Xc= (X1 @B) N A, K123, Origin Image A Structural element B
To fill the frames in between the keyframes, we use rendering O interpolation animation O shading
can you make it so it displays the like the image provided. Also i need the amount to be calculated and how i need the result is its the # of hours times hourly rate. and if the employee is comp sci add 1000 and if they are comp sec add 1000 and if they are both add 2000 to the total amount. also can you remove the 0s below each line.
Please written by computer source Create a histogram of the image. Note the dimensions are 300*300. Also equalize the histogram. DO IT ON PAPER NOT COMPUTER. SHOW ALL WORK
Exercise 1: Create an image with Numpy array manipulation that displays the part of the image as shown below. Exercise 2: Create an image with Numpy array manipulation that displays a black patch as shown in the following screenshot image. 15 100 154 24
For the equation >y =2x+1 1. Createx vector 0 to 10 with colon operator for each 1 point. 2. Create y vector with formula 3.Plot xy graphic. Graphic must be dotted and magenta. 4. Add title, xlabel, y label and grid
Using DrawingPanel.java (from chapter 3G), draw a grid for filling in a 4 x 4 square of cell containing integers. For this part of the assignment the values are not important, but you are welcome to use the values shown in the magic square from below. Note that the values in any horizontal row, vertical column or main diagonals add up to 34, in addition to various sub-squares in the larger square also add up to the same value. Requirements: The magic square should be centered in the panel The values in each of the cells should be centered in that cell (both horizontally and vertically). You can assume the values will be <= 99 (i.e., at most 2 digits). For this part of the assignment, you can hard-code the values; you will store them in a 2-dimensional array (from chapter 7) when implementing Part B of the assignment. The title "CSC 142 Magic Square" is centered horizontally in the panel and at y = 50 You are free to choose the colors, fonts, font sizes and effects. This is what I used…