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

Is B17 is a relative reference and B17 is an absolute reference.?

B17 is a relative reference. $B$17 is an absolute reference. See the related question below.

Which is the correct process for selecting the area to print?

If this is an excel spreadsheet then specify a cell range. If it is a word document and you wish to print a small area in a page, then just highlight the text and select print. On the print dialog make sure you selection "Selction" in the Page range setting.

What is a button that allows you to choose weather to copy the values from the source to the destination area with formatting without formatting or copy only the format?

After you paste your text into the new cell, before you click away from it there should be a small picture of a clipboard that pops up next to the pasted text. When you click on that it will give you the different formatting options.

Does Microsoft offer Excel training online?

Hi,

If you want to learn basic excel or advanced excel, I would suggest you to go with Analytics Training Hub data analytics certification courses. ATH is one of the best advanced excel training institute in Delhi Ncr for online excel & classroom training. All the faculty members have years of experience in teaching with excellent command over tools.

You can visit the website for further details & enquiry.

Why did Excel decide to use 256 and 65536 for the columns and rows?

They may seem like unusual numbers, but the do have a significance. Without getting into the real complexities of it, we can say that computers work on a system called Binary, relating to powers of 2. If you keep doubling up from 1, you will come through this list of numbers:

1

2

4

8

16

32

64

128

256

512

1024

2048

4096

8192

16384

32768

65536

131072

262144

524288

1048576

If you look into them, you will see that 256 is there, as is 65536. A lot of the other numbers that are there come up in other areas of computing. Computers often have 128 MB of memory or 512 MB of memory for example. The last number shown is the amount of rows in Excel 2007. If you continued doubling, you'd find other numbers that are in computers. If you multiply 256 by 65536 you get 16777216. Continuing the list from above you will get:

1048576

2097152

4194304

8388608

16777216

So you see there is a significance to 256 and 65536 and other numbers that you see sometimes in computers, that don't look particularly special.

An excel worksheet is divided into?

Rows and columns, which in turn gives you cells.

What are Keys that move the cursor in the directions indicated?

They are called the mouse keys. They Are:

8= Up

2= Down

4= Left

6= Right

1= Diagonal to Bottom Left

3= Diagonal to Bottom Right

7= Diagonal to Top Left

9= Diagonal to Top Right

How do you convert Excel into open office?

Usually there is no need to convert, since Open Office can read excel files (except Open Office probably will have problems with macros). If you have Excel 2007, then save the file in Office 2003 compatibility mode.

Why is using a cell reference between sheets in Excel useful?

Using cell references in a spreadsheet formula allow for easier use of calculations and formulas. This can be beneficial when having to perform the same calculations for processing data or applying the same formula to groups on information and data.

How do you display a hidden row in a Microsoft Excel?

To display a row that was hidden, select the row before and after the hidden row. (ie - if row 5 is hidden, select row 4 and 6) Once you have selected those rows, right click in the highlighted area and select UnHide.

Definition of Microsoft Excel?

When you create a spreadsheet or workbook then a corresponding file is created on your machine, that file is known as excel file.

What symbol must all formulas begin with?

Well, formulas in general don't always start with a sign, but it might be talking about Excel, where they always start with an equal sign (=).

What is NPER in Excel?

NPER is a financial function in Excel. It returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.