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
Why would you bold a cell entry in excel?
To emphasise it and make it stand out amongst other values in the spreadsheet. Main headings may be bolded or significant totals could be.
How do you print all sheets in excel workbook one at a time?
Your question is not clear. If you want to print all sheets in the workbook, use the print command. In the print box there is a section called "Print what." The default setting is Active sheet(s). Select Entire workbook.
If you want to print only a single sheet "one at a time," then leave the setting at Active sheet(s).
How many panes can you split a large worksheet into on Excel?
You can only have two panes if you use Freeze Panes. If you are using the Split option you can have up to 4 windows on your worksheet.
How many parameters are possible using the IF function in Excel?
The IF function has 3 parameters. The condition, the true part and the false part.
What would be the EXCEL formula to calculate 15 percent of 6058.82?
15 / 6058.82 = 0.00247572959751238690041955364246. Formatting the cell for percentages will yield a result of 0.25%
How do you link Microsoft Excel and MS excess database?
it is the logical meaning of MICROSOFT ACESS,many people search for excess but its really called acess...
What is the difference between a formula cell a data cell and a label cell?
A formula cell is one with some sort of calculation in it. A data cell contains numbers usually, but it could be other kinds of data like dates or times. A label is normally a cell with text that acts as a heading for something in another. So you could have a formula that has a total in it of some kind, and beside it have a cell saying what that total is like "Total Sales".
Can tab move tabbed location within cell?
Excel does not support tabbing within a cell. To replicate the effect, format the cell as intented the number of characters you choose for a tab.
Example in Excel 2007:
- Highlight the cell or range of cells you would like to indent.
- On the Home tab, in the Cells section, click on Format. (or right-click and select Format Cells)
- Click Format Cells.
- In the Format Cells window, click on the Alignment tab.
- In the Text alignment section, select the Horizontal drop-down and click on Left (Indent).
- Set the Indent and click OK.
- Experiment with different Indent settings until the cells are formatted as you like.
How Create a chart the worksheet of the table select?
Highlight the area of the table that you want to create a chart of, and press the F11 function key.
What instructs Excel to print the worksheet currently on the screen or the selected worksheets?
PrintButton
The AutoSum.
What documents are created in mail merge?
Usually form letters and mailing labels. You can create just about any personalized printed product using mail merge techniques. One of my companies used to print and sell customized children's books, using mail merge technology.
What is a date stamp in excel?
It show the current date on the spreadsheet, and can include the time if you want. Using a few different functions you can display it, depending on what detail you want:
=NOW()
=TODAY()
=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")
The horizontal or vertical line that extends across the plot area of the graph to make it easier to read and understand data. Lines create visual breaks; this keeps one cell separate from another cell and helps the brain recognize the separate values.
A reference line is a vertical or horizontal line in a graph, corresponding with user-defined values on the x-axis and y-axis respectively. Reference lines further aid the determination of angular and linear measurements.
What four types of spark line charts does Excel include?
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
There are three, not four, different types of sparkline charts in Excel. They are Line, Column, and Win/Loss.
What is the formula to calculate average room rate?
Average room rate is the total revenue generated from all occupied rooms, divide by the number of occupied rooms (including complimentary rooms) - House use rooms. Example - The total revenue generated from a hotel room sales is = $5,000 The total rooms occupied is 50 (including complimentary rooms) The Average Room Rate = $100.00
Why is your Excel sheet cut and paste very slow?
Almost certainly is related to what is going on in your computer and has nothing to do with Excel itself (unless you have a monster spreadsheet with thousands of calculations. See if there are problems in other applications. If so, look at issues with your computer. If not, check the size of your Excel workbook. If it is huge (e.g. several MB), live with the slowness, get a faster computer, or see what you can do to reduce the size of the spreadsheet.
What is spreadsheet management in the work place?
Some organizations use many hundreds or thousands of different spreadsheets. Sometimes they hire or assign as extra duty, a spreadsheet manager to keep track of all the various spreadsheets. The primary duty of a spreadsheet manager is to organize the spreadsheets and establish a version control system to ensure the organization leverages the spredsheet assets they already have.
For what purpose would you use a cell reference?
To identify a specific cell. For example, if you want to identify the cell at the intersection of column G and row 13, you would use the cell reference G13.
How to take logarithm for a column of numbers in Excel?
If you want to know the logarithm of each individual number, type =LOG(A1), or whatever the first cell happens to be, for the first cell in the column of numbers, and then copy this cell downwards; Excel will automatically change the cell number to be relevant.
If you want to know the logarithm of the sum of all numbers in a column, type =SUM(A1:A5), or the relevant ends of your range, in an empty cell and then =LOG(B6), or whatever the label of that cell was.
Does pressing the Alt key activate the menu bar?
Many Microsoft products use this as a standard behavior.
How do you adjust height in excel rows?
You can either adjust it manually by right clicking the cell you'd like to change and altering its properties, or simply mouse over the bottom edge of the row's label and drag it to your desired height.
