sagansiniard
contestada

MORE THAN ONE ANSWER!

What formatting changes do spreadsheet applications permit in the rows and columns of a spreadsheet?

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 help 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.]

Respuesta :

sylvain96

Answer:

YES to all the options given.

- Formatting rows and columns is similar to cell formatting.

- You can insert rows and columns into, or delete rows and columns from, a spreadsheet.

- You can hide or show rows and columns in a spreadsheet.

- You can adjust the height of rows and width of columns.

Explanation:

Formatting rows and columns is similar to cell formatting.

Yes, you can apply basically the same formats to columns and rows as you do with cells, like background, bold, text justification, number formats and much more.

You can insert rows and columns into, or delete rows and columns from, a spreadsheet.

Yes, you can easily add or delete rows and columns from a spreadsheet.

You can hide or show rows and columns in a spreadsheet.

Yes, that is common to hide rows or columns to mask some data, then to unhide them.

You can adjust the height of rows and width of columns.

Yes, absolutely, you can also specify to wrap text that is too long to fit in the width of the cells.

Answer:

There are various formatting changes that can be applied to rows and columns of a spreadsheet.

  • Modify the width of a column
  • Modify the height of a row
  • Insert more rows
  • Insert more columns

Explanation:

For the purpose of explaining the various concepts further, I will be using Microsoft Excel.

The attachments contains visual representation of each step.

Modify the width of a column

  • Click on Format on the Home Tab
  • Click Adjust Column Width
  • Enter an amount to increase or decrease the column width

Modify the height of a row

  • Click on Format on the Home Tab
  • Click Adjust Row Height
  • Enter an amount to increase or decrease the row height

Insert more rows

  • Select a row underneath where you need a new row. Place your cursor on the number which serves as the heading[eg row 10] for the row and right-click.
  • Click insert row

Insert more columns

  • Select a column after where you need a new column. Place your cursor on the Alphabet which serves as the heading[Column B] for the column and right-click.
  • Click Insert column
Ver imagen mtzion
Ver imagen mtzion
Ver imagen mtzion
Ver imagen mtzion
Ver imagen mtzion