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
What command will lock rows and columns in position on the screen?
Go to the Window Menu Button on top. Select and experiment with Freeze Panes and Split in the drop-down menu, in order to learn how to use them.
What is on the left side of the formula bar and displays the active cell reference?
The Name Box. If you put the mouse over it, this will appear to tip text.
When do you use the '-' symbol in a spreadsheet?
The most common use is in a formula that includes subtraction.
What tab in the chart options window can you add or modify axis labels in excel?
This would be under the tools tab. Go into excel and click on this tab to see all of the options that are available for modifying your axis labels.
What is the file extension that indicates an Excel file?
Excel 2003:
.xls = Workbook
.xla = VBA Add-in
.xlb = Toolbar (where custom toolbar settings are stored)
.xlc = Chart
.xld = Dialog (from older versions of Excel)
.xlk = Archive (Excel spreadsheet backup)
.xll = DLL Add-in
.xlm = Macro
.xlt = Template
.xlv = VBA Module
.xlw = Workspace (collection of multiple Workbooks)
Excel 2007 and Excel 2010:
.xlsx = Workbook (XML format)
.xlsm = Macro-enabled Workbook
.xlsb = Excel Binary Workbook (instead of XML format)
.xltm = Macro-enabled Template
.xlam = Add-in (XML format)
What is the exponent symbol in Excel?
You use the ^ symbol, or you can use the Power function:
=10^2
=Power(10,2)
What the benefit of using the paste link option?
However, Excel also has other, less well known paste options that makes it easier to maintain and update your spreadsheet once it has been created.
One such feature is Paste Link, which creates a link between the data or formula in the original cell and the destination cell where it is pasted
A picture that is positioned directly in the text at the insertion point is?
Not Really A Good Question But Here.
If A Picture Is Over Text Then You Need To Change Were The Picture Is.
In Your Code Look For:
margin-top:100px;
margin-bottom:100px;
margin-right:50px;
margin-left:50px;
And Change The Numbers.
Answered By DjLowseYou Know You love Me :]Is cell referencing used for all formulas in Excel?
No. You can have formulas that just use numbers, though for those it is better to put the numbers into the cells and refer to the cells. There are also some functions that do not refer to cells, like the TODAY() function.
How do you use vlookup in excel?
A vLookup is a vertical lookup function. You have a similar function called a hLookup or horizontal lookup. Bot allow you to set up a table of data and then search either vertically or horizontally through it to find particular values. That will depend on what way your data is laid out.
For example, you could have a table of 10 different products being sold in 10 different shops. Each shop charges a different price. You could arrange these in a table, say with the names of the shops across the top and the products down the side and with the correct prices in the correct cells. Then in another part of the spreadsheet, you could type in the name of one of the shops in one cell and the name of the product in another. The vlookup or hlookup functions can go to your table, find the name of the shop and the name of the product and display the correct price for you. This would be a lot quicker than trying to find the price yourself.
What does formatting of CD mean?
In simple terms, formatting a CD prepares it for use, so that data can be written on to it.
In Microsoft Excel can you rotate cell contents so that they appear at any angle or orientation?
Yes, with limitations. You will find the option under Format Cells > Alignment > Orientation. You can select from a graphic showing the angle of the cell contents or select a specific degree of rotation. You can rotate between 90 and -90 degrees. You can not rotate 120 degrees to make the text appear upside down.
How many database functions does excel use to evaluate numeric data in a table?
No, it has far less than that. It has 12 specialised database functions. They are DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP. In addition, it would be possible to use many other functions to manipulate data in a database. Even the total amount of functions in Excel is much less than 1000 functions.
What does it mean to merge cells?
It is merging the cells. There is a Merge and Center option in Excel. You can have a big heading that you want to spread across several columns. You can use this option to take the cells at the top of those columns and make them into one big cell and have your heading in it. First you would select the cells you want to merge. If you then go to the Format menu and pick Cells and then Alignment, you will find the Merge Cells option.
What does the COUNT function do in Excel?
The COUNT function counts the number of cells that contain numbers.
Syntax: =COUNT(value1, value2,...value30)
The arguments (e.g. value1) can be cell references or values typed into the Excel COUNT formula.
What provides easy central access to the tasks you perform while creating a database in Access?
A Ribbon
Formula for sum of cells A1 to A5?
While there are many ways of doing it, the simplest way is to use the SUM function and a range in it like this:
=SUM(A1:A5)
They could use it to keep lists of payments made to them by patients. They could use it to keep other details on patients. They could use it for some of the financial data that is needed to run their business. They could use it to keep track of amounts of pills they use or doses for things they administer to their patients. They could keep track of the amount of patients they deal with. They could keep track of the amount of times certain illnesses are occurring. There are many other ways they could use a spreadsheet.
Why should you be careful when deleting a worksheet?
because in deleting worksheet it is contraceptive but logically
is this answer can help u? click answers
Answers
It means that the right side of the line is the base point and the left side will be 'ragged.' It is typically done with the left side aligned. You can also align both sides which is the way most books and newspapers are printed.
