answersLogoWhite

0

📱

Microsoft Excel

Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.

9,788 Questions

When copying the formula B3-B4SAS2 to the right what would be the formula in column C?

I presume the SAS2 is $A$2. First, there cannot be a cell called B4$A$2, so that can be assumed that you have left an operator out. So presuming your formula would be =B3-B4-$A$2 and is starting in column B, then when copying to the right, the column references will change by one letter. B3 would become C3. B4 would become C4. $A$2 would not change. as it is an absolute reference. So the formula =B3-B4-$A$2 would become =C3-C4-$A$2 when copied one cell to the right. The operators will not change, just the cell references.

What does the vlookup searches in a table until the matching value is found?

I'm not certain what this question is actually asking but...

VLOOKUP is used to search vertically down a specified column within a given range to find a specified value (either as an exact match or not) and then bring back a value in either that cell or (more typically) a cell to the right of it.

See the Excel help article on VLOOKUP for further information.

Which operation is performed last in a calculation in Excel?

Addition and subtraction are the last operations to be performed on a left to right basis. They have equal precedence, meaning that whichever of them comes last reading left to right is last to be done. The exception is when they are inside brackets, in which case anything outside will be done after. See the related question below.

What is a floating text box?

it is box which you can move around on the page

What are the functions of Cafpro?

Cafpro functions as a third party beneficiary service of a French family business run by the National Fund For Family Allowances called Caf. Caf support legal services and welfare for families.

What is ASCII delimited text?

ASCII is the acronym for American Standard Codes for Information Interchange. It is used to determine which character to display when a keyboard key is pressed, or code entered. So it can refer to basic text. A delimited file is a file that includes text separated by commas or full stops or semi-colons or spaces, or whatever the user designates as a delimiter. If you have something like firstnames and surnames and dates of birth, they could be in a file with a comma after each one, indicating to a program that reads the file, like a spreadsheet or database, as to how to arranged the data. If it was being opened by a spreadsheet, it would start putting the data into cells. It would use the delimiter to decided at what point something goes into the next cell. So if you had a firstname, a comma and a surname, the firstname would be put into one cell and the surname into the next cell.

What is a horizontal series of cells in a table called?

A horizontal series of cells in a table is usually called a "row". A vertical series of cells in a table is usually called a "column".

What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?

the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

Answer

How many workbooks are open on the taskbar when you first install Excel?

No workbooks are open when you first install excel. The first time you use excel, you will have one workbook open.

What does the term rank as a row of soldiers mean?

A rank refers to a horizontal row of foot soldiers as viewed from above, where a file refers to a vertical column of foot soldiers as viewed from above. A rank literally means a row of soldiers.

What purpose does the capital serve on top of the column?

It identifies the column. Columns are identified by letters. Rows are identified by numbers.

What is the axis on the chart that describes what is shown and is created from the row or column headings on Excel 2010?

The X-Axis will normally describe what is shown. That is the one going across the bottom. It will depend on the type of chart, as some don't have an axis, like pie charts. This is one of the reasons that all charts include legends to help indicate what values refer to.

How do you make a box plot in Excel?

Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.

A table in Excel is most similar to?

Sometimes it can be similar to a table in a database.

Can you move the leftmost and rightmost scroll buttons to the left of the sheet tabs move one worksheet to the left or right?

The scroll buttons do not change the position of sheet tabs, just which is the active sheet tab. You can drag a tab to change the order of the sheet tabs. The scroll buttons stay where they are, on the left, at all times.

Trending Questions
What separates imported data into columns? What is it called to print a range of cells in the active worksheet click what in the settings area in the print gallery? How can you format a whole row or column at once? Can any selection handle can be used to size a shape in excel? In order to multiply items in Excel you would use? Match the term in column 1 to the definition in column 2. A. Jihad Conforming to an approved doctrine B. Orthodox One who dies for his or her beliefs C. Martyr An organized massacre of a particular pe? 11. The view that puts a blue line around each page that would be printed is the .? The Percent style button on the Formatting toolbar is used to display a value determined by multiplying the cell entry by rounding the result to the nearest percent and adding a percent sign? How do you write an Excel equation to multiply the first cell in a row by the third cell in a row without directly referencing it such as A1C1? What does text formulas do in Microsoft Excel? How do you calculate mean squared error in Excel? Which information would be included on a nautical chart of a harbor? How do you navigate worksheets but not move an active cell excel? What is the difference between a chart sheet and an embedded chart? How do you change column width in Excel? When you copy data and paste in excel sheet it pasting only formulas not the data how can I copy the data when the content is formula made? How would you rate your Excel skills? How to read and write Excel Files with Perl? Excel features built-in preprogrammed formulas called? When the fill handle is used to copy to adjacent cells receiving the copy is called the destination area or paste area True or false?