A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant

**value**or**formula**stored in the active cell. A tool that helps you create or edit a**formula**and also provides information about functions and their arguments.In this manner, what are constants in coding?

In computer

**programming**, a**constant**is a value that cannot be altered by the program during normal execution, i.e., the value is**constant**. This is contrasted with a variable, which is an identifier with a value that can be changed during normal execution, i.e., the value is variable.What is a constant and a variable?

Algebra is the branch of mathematics that uses letters to represent numbers. Usually, the letters are called

**variables**, since they are unknown and can change or vary. Some letters can be designated as**constants**, since their values remain**constant**, once assigned.1

## How do you keep a cell constant in a formula?

To

**keep cell**reference**constant**in**formula**, you just need to add the $ symbol to the**cell**reference with pressing the F4 key. Please do as follows. 1. Select the**cell**with the**formula**you want to make it**constant**.2

## What is computer work book?

Updated: 01/24/2018 by

**Computer**Hope. In Microsoft Excel a**workbook**is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called "Sheet1" in an Excel**workbook**file called "Book1."3

## What does Sumif function do?

The

**SUMIF function is**a worksheet**function**that adds all numbers in a range of cells based on one criteria (for example,**is**equal to 2000). To add numbers in a range based on multiple criteria, try the**SUMIFS function**.4

## What are the three main types of data that can be entered into a spreadsheet?

In Excel 2010, the

**worksheet**consists of a grid of columns and rows that form**cells**. You enter**three types of data**in**cells**: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.5

## What is the function of Excel?

**Functions**are predefined formulas and are already available in

**Excel**. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. For example, cell A3 below contains the SUM

**function**which calculates the sum of the range A1:A2.

6

## What is the keyboard shortcut to make a cell reference absolute?

**Toggle**absolute and relative references. It's much faster and easier than typing $ characters manually. To convert an existing formula, enter cell

**edit**mode, place the

**cursor**in or next to the reference you'

**d**like to convert, then use the shortcut. Note: in Excel 2016 for the Mac, you can also use fn +

**F4**.

7

## How do you keep a cell constant in Excel?

Create a cell with the

**constant value**you want to reference. Create a formula in a cell that performs your calculation. In the formula where you reference the**value**you created in step 1, add a “$” before the letter (representing the column) and number (representing the row).8

## What is an active cell in a spreadsheet?

Alternatively referred to as a

**cell**pointer, current**cell**, or**selected cell**, an**active cell**is a rectangular box, highlighting the**cell**in a spreadsheet. An**active cell**helps identify what**cell**is being worked with and where data will be entered.9

## How do you lock a column in Excel?

**There are two quick steps to freezing or locking rows.**

- Select the row right below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze.
- Go to the View tab.
- Select the Freeze Panes command and choose "Freeze Panes."

10

## How do you save a file if you want it to be compatible with older versions of Microsoft Excel?

**To save in Compatibility Mode**

- Click File.
- Click Save As.
- Navigate to the folder where you wish to save the workbook.
- Type a name for your file.
- Change the Save as type to Excel 97-2003 workbook.
- Click Save.

11

## How do you lock a row in Excel?

**To freeze rows:**

- Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3.
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
- The rows will be frozen in place, as indicated by the gray line.

12

## What is the cell reference?

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 contained in different areas of a worksheet.13

## How do you keep a formula constant in Excel?

Use this trick to make that cell absolute/

**constant**in order to make it**remain**the same when you drag the**formula**to other cells. In order to make the reference cell absolute, add the $ symbol before the cell letter and again between the cell letter and cell number. In my video, I want cell D2 to**remain constant**.14

## What is the cell's address?

Summary. The

**Excel ADDRESS**function returns the**address**for a**cell**based on a given row and column number. For example, =**ADDRESS**(1,1) returns $A$1.**ADDRESS**can return an**address**in relative or absolute format, and can be used to construct a**cell**reference inside a formula.15

## What is a page within an Excel workbook?

They represent worksheets

**within**the**workbook**.**Workbook**– An**Excel file that**contains individual worksheets. Also called a**spreadsheet**file.**Worksheet**– A “**page**”**within an Excel workbook**that contains columns, rows, and cells.16

## What do all formulas in Excel begin with?

**Microsoft Excel formulas - the basics**

- All Excel formulas begin with an equal sign (=).
- After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.
- Press the Enter key to complete the formula. Done!

17

## What is a relative reference?

By default, all cell

**references**are**relative references**. When copied across multiple**cells**, they change based on the**relative**position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.18

## What do you mean by range in Excel?

**Range**. Cell, Row, Column |

**Range**Examples | Fill a

**Range**| Move a

**Range**| Copy/Paste a

**Range**| Insert Row, Column. A

**range in Excel**is a collection of two or more cells.

19

## How do you remove a constant in Excel?

**Step to retain only Values and deleting non formula cells**

- Select the range where you want to delete only values, retaining formulas.
- Chose Home->Editing->Find&Select->Go to Special.
- In the Go To Special dialog box, select the Constants option and then select Numbers.
- Click OK.
- Press Delete to delete the values.

20

## What is the row in Excel?

MS

**Excel**is in tabular format consisting of**rows**and columns.**Row**runs horizontally while Column runs vertically. Each**row**is identified by**row**number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet.