0
A range is always indicated by two cell references separated by a colon. If the range is on a single row it is the first and last cell of the range:
C4:K4
If the range is on a single column it is the first and last cell of the range:
A5:A13
If the range spreads over more than one row or more than one column, then the range is specified by the top left and bottom right cells:
D5:J20
What else can I help you with?
What is an Excel name box?
The name box shows the address of the current cell selected or the name of that cell if a special name has been given to it. It can also show the name of a range. You can type in a cell reference or a range name in the name box and it will bring you to that location. The name box appears to the left of the formula bar.
Which view shows you a reduced view of each of your worksheet?
Page Break Preview>>Microsoft Excel 2010
What function will show the smallest value in the selected range of cells?
The function that shows the smallest value in a selected range of cells in spreadsheet applications like Microsoft Excel or Google Sheets is the MIN function. For example, if you want to find the smallest value in the range A1 to A10, you would use the formula =MIN(A1:A10). This function will return the lowest number from the specified range.
How do you restore the undo command in Excel when the undoredo symbols are greyed out in the toolbar and the edit menu shows can't undo in greyed out state and customize or reset have no effect?
AnswerOne way: go to:tools--- (in the menu bar), then select "Customise"then scroll thru until you see itthen drag to the tool barfinishedTry this:For each version of Excel, use Regedit to go to:(For Excel 2007):HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options(For Excel 2003):HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options(For Excel 2002):HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\OptionsEdit "UndoHistory" and change the value to between 1 - 100
In Microsoft Excel when you filter data it shows only data that meets certain criteria?
Yes. Filtering data allows you to see on certain parts of it, based on the criteria you have specified. It is one of the things that a database does, but Excel can also do.
What is the difference between a Namebox and Formularbox in a Microsoft Excel?
The formula bar is where formulas are typed and where you can see what is in a cell. The name box shows a cell reference, or names of cells or ranges.
Which view shows a reduced view of each page of your worksheet?
Page Break Preview>>Microsoft Excel 2010
On Excel A numerical scale on the left side of a chart that shows the range of numbers for the data points and also referred to as the y-axis is?
value axis
What bar is the mode of Excel?
The status bar shows the current mode of Excel.
If you accidentally delete something in Microsoft Excel workbook that you are working in can you recover it?
Decision such question is corrupt xlsx. Tool allow to use modern interface owing to the program restores any versions of excel documents, starts under low system requirements, shows the results of working.
What does the layout button in excel do?
it shows the layout
The file name of a workbook shows in the?
The file name is displayed in a bar at the very top of the window. If the file name is workbook.xls, you would expect to see workbook.xls - Microsoft Excel at the top of your screen.
