0
What can you treat a range of data as a distintinct object in a Excel worksheet?
Wiki User
∙ 11y ago
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoA range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
Add your answer:
Earn +20 pts
When you first select a range of cell or an object before starting the spell checker Excel checks the selected?
worksheet
How can you limit a specific range name to a particular worksheet in the workbook in Excel?
Set the scope to a named range.
What is a non adjacent range?
a collection of multiple ranges that are not positioned in a contiguous cluster in an Excel worksheet
What is non adjacent range?
a collection of multiple ranges that are not positioned in a contiguous cluster in an Excel worksheet
Which is easier Excel VBA or Access VBA?
I would say that there is no differences between Excel VBA and Access VBA. VBA is the acronym for visual basic for application and is the common language for the office suite. Excel vba gives you a native access to excel object (eg a worksheet, a cell, a range, etc.) but object of other applications can be made accessible via configuration (references). Access vba gives you a native access to access object.
What is the worksheet location where Excel copies records that meet comparison criteria is called?
It is the "Copy to" area or the extract range.
What combines a range of cells into one cell that occupies the same amount of space in an excel worksheet?
The Merge Cells option.
How do you put a multiple filter in Microsoft Excel spreadsheet?
It is not possible to have multiple autofilters in one worksheet. What you can do is select your range(s) and convert them to a list/table by going to Data->List in Excel 2003 or Insert->Table in Excel 2007. This will give you the functionality of an autofilter, but it can be applied to several ranges within the same worksheet.
Most excel specialists who build web queries use the worksheet returned from the web query as an engine to supply to another?
range
What is a spreadsheet is often called?
It can be called a worksheet. There is a range of actual spreadsheet programs, so people often refer to them directly, like Excel or Quattro or Works or Open Office or Lotus 123, instead of using the term spreadsheet.
What is a block of cells in an Excel worksheet?
column
Does data sheet view looks like Excel?
A datasheet in Access looks a bit like a worksheet in Excel, but it is different, like having row and column headings relating to records and fields, rather than just having numbers and letters. A worksheet in Excel has a wide range of facilities that a datasheet doesn't. A datasheet is mainly for displaying data and enables some manipulation of the data. A worksheet in Excel allows you do all sorts of complex operations using formulas and other facilities in Excel. Access and Excel are different kinds of applications, so naturally they have different facilities. So the similarities are visual rather than functional.
