blank cell

[′blaŋk ‚sel]

(computer science)

A cell of a spreadsheet that contains no text or numeric values, and for which no formatting is specified other than the global formats of the spreadsheet.

References in periodicals archive ?

For the Column Input Cell, select any blank cell in the worksheet (such as C32).

Capital budgeting simulation using excel: enhancing the discussion of risk in managerial accounting classes

At a distant location, the genome is going to be synthesised and inserted into what will amount to a blank cell, and "booted up", as Venter puts it.

Scientist developing 'biological fax machine' to copy Martian life

Using the IF function instructs the spreadsheet to display the results of the calculation only if it is appropriate for a particular loan; otherwise, a blank cell will appear.

A SPREADSHEET TEMPLATE FOR INSTALLMENT LOAN AMORTIZATION TABLES

To begin, click on a blank cell in the worksheet (otherwise, Excel will try to guess which data should be selected for the chart) and from the Insert tab's Charts group, select Column, 3-D Column, 3-D Clustered Column.

Simplify your future with rolling charts: expand your excel skills with this step-by-step guide

Once the label is entered, the blank cell to the right of the label is used to display the corresponding result.

Using Lotus 1-2-3 to assist with indicator monitors

This command will leave the cell blank and the macro will stop at this blank cell when it is invoked.

Spreadsheet keyboard macros

Create a forecast in any blank cell (for example, cell F2) by selecting that cell and typing = forecast and then using Ctrl+A to bring up the Function Arguments dialog box for the linear regression forecast function.

Forecasting with Excel: regression analysis can help predict revenues and costs

When a macro is run, it is read cell by cell, down the column until a blank cell, a cell containing a numeric value, or the macro command QUIT is encountered.

Lotus 1-2-3 data entry made easy with a macro

Leave a single blank cell (F6) above the column of project numbers.

A DSUM, DMAX, DMIN on every row

Start by typing 100 in cell D22 (any blank cell will do).

Dial a forecast: a speedy way to examine multiple business scenarios

Begin by highlighting the rows you want to format--presumably an entire worksheet by clicking on the blank cell to the left of column A and above the 1.

Technology Q&A: command word to repair itself ... create an Excel contents tab ... shade alternating rows or columns ... a better idea ... the right way to count the zeros ... shortcuts

If none of the conditions are met, the results will be a blank cell.

Creating accurate nested IF statements

Full browser ?

CITE

Site: Follow: Share:

Open / Close