DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
formula bar
|
|
|
adjacent cell
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You can use number formats to change the appearance of numbers, including dates and times, without changing the actual number. The number format does not affect the cell value that Excel uses to perform calculations. The actual value is displayed in the formula bar.
Detailed explanation-2: -If Microsoft Excel displays ##### in a cell after you apply number formatting to it, the cell probably isn’t wide enough to display the data. To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error. This automatically resizes the column to fit the number.
Detailed explanation-3: -The formula bar is a toolbar that appears at the top of our worksheet, below the Ribbon in our workbook. The formulas bar, sometimes called fx bar, displays text or number data in active or current cells, formulas in an active cell or range of cells in place of a selected data series in an Excel chart.
Detailed explanation-4: -In the Format Cells dialog box, in the Category list, click Currency or Accounting.