6.Display the ManagerID, MFName, MLName, and number of buildings managed, for all managers that manage more than one building. Use the HAFHMORE schema. 7.Display the ManagerID, MFName, MLName, and the number of buildings managed, for all managers. Use the HAFHMORE schema.

8.Display the SMemberID, SMemberName, and the number of apartments that the staff members cleans, for all staff members. Use the HAFHMORE schema.

9.Display the total amount HAFH spends on manager salaries (as TotalSalary) and the total amount HAFH spends on manager bonuses (as TotalBonus). Use the HAFHMORE schema. Format the data returned by your query with a leading dollar sign ($), comas every three digits and two decimal places.

10.Display the answer to the following question: How many HAFH buildings have exactly 4 floors? Use the HAFHMORE schema.

To hide gridline when you display or print a worksheet

Formatting rows and columns is similar to cell formatting. in an openoffice calc spreadsheet, you can format data entered into rows and columns with the of the rows and columns options. you can insert rows and columns into, or delete rows and columns from, a spreadsheet. use the insert or delete rows and columns option on the insert tab. alternatively, select the row or column where you want new rows or columns to appear, right-click, and select insert only row or only column options. you can hide or show rows and columns in a spreadsheet. use the hide or show option on the format tab. for example, to hide a row, first select the row, then choose the insert tab, then select the row option, and then select hide. alternatively, you can select the row or columns, right-click, and select the hide or show option. you can adjust the height of rows and width of columns. select row and then select the height option on the format tab. similarly, select column, then select the width option on the format tab. alternatively, you can hold the mouse on the row and column divider, and drag the double arrow to the position. you can also use the autofit option on the table tab to resize rows and columns.

Text or graphics that print at the bottom of every page are called footings footers headers headings