|Press Enter.

Move the mouse pointer over the fill handle a small black dot in the bottom right corner of the active cell, openoffice calc. When the pointer changes to openoffice black plus sign, openoffice and hold down the left mouse button and drag the fill handle down to cell C The formula in C9 openoffice be copied to cells Openoffice through C Select cell D9, openoffice calc. Repeat steps 2 and 3 and drag the fill handle down to cell D The formula in D9 will be copied to cells Calc - D Select Merge Cells on the Formatting calc to merge the calc cells, openoffice calc.

Calc Align Center Horizontally on the Formatting calc to center the title across the selected area, openoffice calc. Drag select cells B4 - B6. Select Align right on the Formatting toolbar to openoffice align the data in these cells.

Drag select cells A9 - A Drag select cells A8 - D8, openoffice calc. Openoffice Align Center Horizontally on the Formatting toolbar to center the data in these cells. Drag select cells C4 - C6, openoffice calc. Drag select cells B9 - D Adding Number Formatting Number formatting refers to the addition of currency symbols, openoffice calc, decimal markers, percent signs, and other symbols that help to identify the type of data present calc a cell and to make it easier to read.

In this step, we add percent signs and currency symbols to our data. Adding calc Percent Sign Openoffice cell C6, openoffice calc. Select Number Format: Percent on the Formatting toolbar to calc the openoffice symbol to the selected cell. Select Number Format: Currency on the Formatting toolbar to add calc dollar sign to the selected cells, openoffice calc.

Select Background Color on the Formatting toolbar looks like a paint can to open openoffice background color drop-down list, openoffice calc.

Choose Openoffice Blue from the list to change the background color of merged calc A2 - D2 to blue.❷