Suppose that only 80% of the STUDENT records from Exercise 16.28 have a value for Phone, 85% for Major_dept_code, 15% for Minor_dept_code, and 90% for Degree_program; and suppose that we use a variable-length record file. Each record has a 1-byte field type for each field in the record, plus the 1-byte deletion marker and a 1-byte end-of-record marker. Suppose that we use a spanned record organization, where each block has a 5-byte pointer to the next block (this space is not used for record storage). Requried:
a. Calculate the average record length R in bytes.
b. Calculate the number of blocks needed for the file.

Match the following. 1. formatting that is applied when cell data meets certain criteria 2. borders with formats not found on the border tool 3. a shortcut bar that contains tools for commonly used formats 4. formats that can be applied to numbers conditional formatting custom borders format bar number formats

Your program should prompt the user for the dimensions of the two squares matrices, making sure that the user input is greater than or equal to 4.[ yes, an example would be a4x4matrix]2.if the above is not met, prompt the user for a new value.3.now generate random integernumbers to fill both matrices.4.display these two matrices on the screen.5.multiply the two matrices and display the result on the scre

Design a payroll class with the following fields: • name: a string containing the employee's name • idnumber: an int representing the employee's id number • rate: a double containing the employee's hourly pay rate • hours: an int representing the number of hours this employee has worked the class should also have the following methods: • constructor: takes the employee's name and id number as arguments • accessors: allow access to all of the fields of the payroll class • mutators: let the user assign values to the fields of the payroll class • grosspay: returns the employee's gross pay, which is calculated as the number of hours worked times the hourly pay rate. write another program that demonstrates the class by creating a payroll object, then asking the user to enter the data for an employee in the order: name, id number, rate, hours. the program should then print out a statement in the following format (for example, if you had an employee named chris jacobsen with id number 11111, who works for 5 hours at $10/hr): chris jacobsen, employee number 11111, made $50.00 in gross pay. using text forming so that the gross pay is rounded to two decimal places.