To count only numbers that exceed a particular value use the COUNTIF function. In your example, where the numbers to be counted are in the range A1:G1 use the following formula:
=COUNTIF(A1:G1,">5000")
They can represent values in cells. They also can represent columns (letters) and rows (numbers).
The hash tags appear because the cells are not wide enough to show their contents. You just need to widen the cells to show the values.
A radio button is a form control. It is usually part of a set where one can selected but no others. You can link them to cells to set values for them.
If you use the Autosum, Excel will try to detect cells that are above or right of it. If there are figures both immediately above it and immediately right of it, then it will try to sum the ones immediately above it. However, using the Autosum you can select a block of cells and Excel will put totals at the end of them, again opting for the bottom if columns of cells are involved, so you could select a row of values or a column of values. You can also just manually type in the cells you want to sum.
A range of cells, that can then be used in a function. The cells from B2 to E13 could be a range of cells that you want to total all the values in: =SUM(B2:E13)
36
Yes it does.
There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.
A semi-selection in Microsoft Excel is the action of selecting a few cells in a worksheet. To select the cells, you would click on them to highlight.
In Excel is it COUNT.
The actual lines are known as gridlines, both vertical and horizontal. A vertical line of cells is known as a row.
In order to do formulas that use values in cells, you need to be able to refer to those cells in the formulas. That is what a cell reference does. You can then create formulas that can be copied quickly and be used for any values that may appear in the cells. As much as possible cell references, rather than values, should be used in formulas.