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

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 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 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 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.

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.

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 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

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.