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.
copy and paste
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.
What formula do you use to calculate the amount of work?
Work is computed by figuring how much energy is being used.
What is a collection of cell styles and other syles that have common characteristics?
Cell Styles Gallery
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
A named group of formatting characteristics that you can apply to text is called?
A style or a format template.
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.
A fast way to add up this column of numbers is to click in the cell below the numbers and then what?
click the auto-sum button on the menu
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 (=).
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.