subject

g Create an excel spreadsheet that will track information on campus buildings, classrooms, their max capacity, and their capacity at 75%, 50% and 25% max capacity. For each room on campus, it should specify the building, the room number, the department responsible for the room, the type of room (office, storage, classroom or lab), max capacity, capacity at 75%, capacity at 50%, capacity at 25%. The fractional capacities should always be rounded up, and should never show a fractional value (e. g. if it is 9.1, it should display 10, not 9). The data should have filters and sorting enabled, with the data sorted by room number (e. g. LUTR101 and FORB102 would be next to each other). Additionally, for all of the capacities (either max, or those that were calculated), if the capacity is 19 or >, highlight it in green. Otherwise, highlight it in red. Note, you may need to create additional columns to complete this activity. Populate the spreadsheet with 20 test records. Calculate summary information for the capacity specifying the average, maximum, minimum and standard deviation

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 02:00
Consider how gaming consoles initially relied on joysticks and joypads and then made the switch to modern gaming controls, which include analog sticks, buttons and switches, touch controls, accelerometers, motion controls, etc. name at least two kinds of gaming experiences that are possible with these new control devices but were not possible on original joysticks. explain how new technologies made this newer game style possible.
Answers: 1
question
Computers and Technology, 22.06.2019 09:50
17. implement the jvm dload instruction for the mic-2. it has a 1-byte index and pushes the local variable at this position onto the stack. then it pushes the next higher word onto the stack as well
Answers: 2
question
Computers and Technology, 22.06.2019 17:30
Ou listened to a song on your computer. did you use hardware or software?
Answers: 2
question
Computers and Technology, 23.06.2019 01:20
Write a function balancechemical to balance chemical reactions by solving a linear set of equations. the inputs arguments are: reagents: symbols of reagents in string row array products: symbols of products in string row array elements: elements in the reaction in string row array elcmpreag: elemental composition of reactants in two dimensional numeric array elcmpprdcts: elemental composition of prducts in two dimensional numeric array hint: the first part of the problem is setting up the set of linear equations that should be solve. the second part of the problem is to find the integers from the solution. one way to do this is to mulitiply the rational basis for the nullspace by increasing larger integers until both the left-and right-side integers exist. for example, for the reaction that involves reacting with to produce and : reagents=["ch4", "o2"]; products =["co2", "h2o"]; elements =["c","h", "o"] elcmpreag=[1,4,0;
Answers: 3
You know the right answer?
g Create an excel spreadsheet that will track information on campus buildings, classrooms, their max...
Questions
question
Chemistry, 24.07.2019 08:00
Questions on the website: 13722360