Assume that the contents of cells a1 to a5 of a microsoft excel worksheet are 1, 2, 3, 4, and 5 respectively and the rest of the cells are empty. selecting a1 to a5 and clicking on the ‘autosum’ button will display 15 in the_______ cell.

Note Interested in developing solutions that extend the Office experience across Remarks The default member of Range forwards calls without parameters to the someRange = someOtherRange is equivalent to someRange.Value = someOtherRange.Value, someRange(1) to someRange.Item(1) and someRange(1,1) to someRange.Item(1,1). The following properties and methods for returning a Range object are described in the Example section: • Worksheet object • Range object • Worksheet object • Range object • Range object • Application object Example Use Range ( arg), where arg names the range, to return a Range object that represents a single cell or a range of cells. The following example places the value of cell A1 in cell A5. Worksheets("Sheet1").Range("A5").Value = _ Worksheets("Sheet1").Range("A1").Value The following example fills the range A1:H8 with random numbers by setting the formula for each cell in the range. When it's used without an object qualifier (an object to the left of the period), the Range property returns a range on the active sheet. If the active sheet isn't a worksheet, the method fails. Use the Worksheet object to activate a worksheet before you use the Range property without an explicit object qualifier. Worksheets("Sheet1").Activate Range("A1:H8").Formula = "=Rand()" 'Range is on the active sheet The following example clears the contents of the range named Criteria. Note If you use a text argument for the range address, you must specify the address in A1-style nota...

Lesson 5: Cell Basics /en/excel/saving-and-sharing-workbooks/content/ Introduction Whenever you work with Excel, you'll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our Watch the video below to learn more about the basics of working with cells. Understanding cells Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column. In other words, it's where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name—or cell address—based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: • Cell range A1:A8 • Cell range A1:F1 If the colu...

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: • Data from one or more contiguous cells on the worksheet. • Data contained in different areas of a worksheet. • Data on other worksheets in the same workbook. For example: This formula: Refers to: And Returns: =C2 Cell C2 The value in cell C2. =A1:F4 Cells A1 through F4 The values in all cells, but you must press Ctrl+Shift+Enter after you type in your formula. Note: This functionality doesn't work in Excel for the web. =Asset-Liability The cells named Asset and Liability The value in the cell named Liability subtracted from the value in the cell named Asset. The cell ranges named Week1 and Week2 The sum of the values of the cell ranges named Week1 and Week 2 as an array formula. =Sheet2!B2 Cell B2 on Sheet2 The value in cell B2 on Sheet2. • Click the cell in which you want to enter the formula. • In the formula bar , type = (equal sign). • Do one of the following: • Reference one or more cells To create a reference, select a cell or range of cells on the same worksheet. You can drag the border of the cell selection to move the selection, or drag the corner of the border to expand the selection. • Reference a defined name To create a reference to a defined name, do one of the following: • Type the name. • Pr...

Key Points AutoSumis a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. Assume that the contents of cells A1 to A5 of a Microsoft Excel worksheet are 1, 2, 3, 4, and 5 respectively and the rest of the cells are empty. Selecting A1 to A5 and clicking on the 'AutoSum' button will display 15 (1+2+3+4+5) in the A6cell. Hence the correct answer is A6.

Note: Formulas in Excel always begin with the equal sign. • Select a cell or type its address in the selected cell. • Enter an operator. For example, – for subtraction. • Select the next cell, or type its address in the selected cell. • Press Enter. The result of the calculation appears in the cell with the formula. See a formula • When a formula is entered into a cell, it also appears in the Formula bar. • To see a formula, select a cell, and it will appear in the formula bar. Enter a formula that contains a built-in function • Select an empty cell. • Type an equal sign = and then type a function. For example, =SUM for getting the total sales. • Type an opening parenthesis (. • Select the range of cells, and then type a closing parenthesis). • Press Enter to get the result. Download our Formulas tutorial workbook We've put together a Formulas in-depth You can browse through the individual sections below to learn more about specific formula elements. A formula can also contain any or all of the following: functions, references, operators, and constants. Parts of a formula 1. Functions: The 2. References: A2 returns the value in cell A2. 3. Constants: Numbers or text values entered directly into a formula, such as 2. 4. Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers. A constant is a value that is not calculated; it always stays the same. For example, the date 10/9/2008, the number 210, and the text "Quarterly E...

In this article Returns a Syntax expression. Range ( Cell1, Cell2) expression A variable that represents a Parameters Name Required/Optional Data type Description Cell1 Required Variant A String that is a range reference when one argument is used. Either a String that is a range reference or a Range object when two arguments are used. Cell2 Optional Variant Either a String that is a range reference or a Range object. Cell2 defines another extremity of the range returned by the property. Remarks Cell1 and Cell2 can be A1-style references in the language of the macro. The range references can include the range operator (a colon), intersection operator (a space), or union operator (a comma). They can also include dollar signs, which are ignored. A local defined name can be a range reference. If you use a name, the name is assumed to be in the language of the macro. Cell1 and Cell2 can be Range objects that contain a single cell, column, row, or any other range of cells. Often, Cell1 and Cell2 are single cells in the upper-left and lower-right corners of the range returned. When used without an object qualifier, this property is a shortcut for ActiveSheet.Range (it returns a range from the active sheet; if the active sheet isn't a worksheet, the property fails). When applied to a Range object, the property is relative to the Range object. For example, if the selection is cell C3, Selection.Range("B1") returns cell D3 because it is relative to the Range object returned by the S...

Key Points AutoSumis a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. Assume that the contents of cells A1 to A5 of a Microsoft Excel worksheet are 1, 2, 3, 4, and 5 respectively and the rest of the cells are empty. Selecting A1 to A5 and clicking on the 'AutoSum' button will display 15 (1+2+3+4+5) in the A6cell. Hence the correct answer is A6.

Note: Formulas in Excel always begin with the equal sign. • Select a cell or type its address in the selected cell. • Enter an operator. For example, – for subtraction. • Select the next cell, or type its address in the selected cell. • Press Enter. The result of the calculation appears in the cell with the formula. See a formula • When a formula is entered into a cell, it also appears in the Formula bar. • To see a formula, select a cell, and it will appear in the formula bar. Enter a formula that contains a built-in function • Select an empty cell. • Type an equal sign = and then type a function. For example, =SUM for getting the total sales. • Type an opening parenthesis (. • Select the range of cells, and then type a closing parenthesis). • Press Enter to get the result. Download our Formulas tutorial workbook We've put together a Formulas in-depth You can browse through the individual sections below to learn more about specific formula elements. A formula can also contain any or all of the following: functions, references, operators, and constants. Parts of a formula 1. Functions: The 2. References: A2 returns the value in cell A2. 3. Constants: Numbers or text values entered directly into a formula, such as 2. 4. Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers. A constant is a value that is not calculated; it always stays the same. For example, the date 10/9/2008, the number 210, and the text "Quarterly E...

Lesson 5: Cell Basics /en/excel/saving-and-sharing-workbooks/content/ Introduction Whenever you work with Excel, you'll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our Watch the video below to learn more about the basics of working with cells. Understanding cells Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column. In other words, it's where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name—or cell address—based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: • Cell range A1:A8 • Cell range A1:F1 If the colu...

In this article Returns a Syntax expression. Range ( Cell1, Cell2) expression A variable that represents a Parameters Name Required/Optional Data type Description Cell1 Required Variant A String that is a range reference when one argument is used. Either a String that is a range reference or a Range object when two arguments are used. Cell2 Optional Variant Either a String that is a range reference or a Range object. Cell2 defines another extremity of the range returned by the property. Remarks Cell1 and Cell2 can be A1-style references in the language of the macro. The range references can include the range operator (a colon), intersection operator (a space), or union operator (a comma). They can also include dollar signs, which are ignored. A local defined name can be a range reference. If you use a name, the name is assumed to be in the language of the macro. Cell1 and Cell2 can be Range objects that contain a single cell, column, row, or any other range of cells. Often, Cell1 and Cell2 are single cells in the upper-left and lower-right corners of the range returned. When used without an object qualifier, this property is a shortcut for ActiveSheet.Range (it returns a range from the active sheet; if the active sheet isn't a worksheet, the property fails). When applied to a Range object, the property is relative to the Range object. For example, if the selection is cell C3, Selection.Range("B1") returns cell D3 because it is relative to the Range object returned by the S...