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 20:10
Assume the existence of a bankaccount class. define a derived class, savingsaccount that contains two instance variables: the first a double, named interestrate, and the second an integer named interesttype. the value of the interesttype variable can be 1 for simple interest and 2 for compound interest. there is also a constructor that accepts two parameters: a double that is used to initialize the interestrate variable, and a string that you may assume will contain either "simple", or "compound", and which should be used to initialize the interesttype variable appropriately. there should also be a pair of functions getinterestrate and getinteresttype that return the values of the corresponding data members (as double and int respectively).
Answers: 2
question
Computers and Technology, 23.06.2019 12:40
Curriculum exam to process a resident's payment, you must click on onesite payments home page. from the a. reports b. my settings o c.transactions o d. rent tab
Answers: 1
question
Computers and Technology, 23.06.2019 18:30
Janice recently received her college degree and is looking for a job. she is worried that since she just finished school, she will be required to repay her perkins and direct subsidized loans immediately. janice pulls out the paperwork she signed and reviews it again for repayment information. after reading all of the information, janice discovers that
Answers: 2
question
Computers and Technology, 23.06.2019 19:30
You can apply several different worksheet themes from which tab?
Answers: 1
You know the right answer?
g Create an excel spreadsheet that will track information on campus buildings, classrooms, their max...
Questions
question
Biology, 12.10.2019 17:30
question
Mathematics, 12.10.2019 17:30
question
Mathematics, 12.10.2019 17:30
Questions on the website: 13722361