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 does it mean to sort a table in ascending order?
To sort from smallest to largest. Ascending means to go up.
All of the above.
How do you enter the naka rushton function in Excel?
This is a very complicated function that assumes you have reliable data to input. Recommend you use the Solver Add-In. See related links for specific details about Solver and an example of how to use it with test data (including the formula to use in Excel).
If the Solver is not installed on your version of Excel, use the Excel help function to learn how to install the Solver in your particular application.
Here are some generic instructions for Excel 2007 for installing the Solver Add-In:
1) Click the Microsoft Office Button, and then click Excel Options.
2) Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3) Click Go.
4) In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
TIP: If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
5) If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
6) After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.
What makes it unnecessary to press the Enter key on the keyboard?
It depends on what you are doing and what application you are working in, but there are alternatives to pressing the Enter key for many activities. Usually it is one of the navigation keys, like the arrows or Page Up, End etc. The Tab key can also be used sometimes. Sometimes the mouse can be used in some way, like clicking on the tick in the Formula Bar.
What will happen if the Fill Handle in Excel is used to drag from a cell containing date formatting?
If there is a date in the cell, it will copied. If the cell is blank, but has date formatting, it will apply date formatting to all cells it is dragged to while also blanking out any content in those cells. If you then type a number into any of those cells, they will show as a date. Remember that dates start from the 1st of January 1900, so typing in a number will convert it to a date counting from that point. So, for example, if you typed in 5, it would put the date as the 5th of January 1900. If you typed in 10000 it will have the 18th of May 1927 as the date.
Which element do you click to insert a PMT function into a worksheet?
You can click on the Insert Function button and choose the Financial functions category to get the PMT function.
What command gives you precise control in setting column widths and row heights?
In the format section of the menu, select either column width or row height. You can adjust both to whatever you like.
Is diagram the visual representation of data in Excel?
A chart is a visual representation of data in Excel.
It follows the order of operations.
What tab in excel on the ribbon displays error checking tools?
It is in Formula Auditing on the Formulas tab.
It is a [horizontal] bar chart.
It is a [horizontal] bar chart.
It is a [horizontal] bar chart.
It is a [horizontal] bar chart.
How to find column and row in which the element belongs to?
To find the row and column of a specific element in a 2D array or matrix, you can iterate through the array using nested loops. For each element, check if it matches the target value. When a match is found, record the current indices of the outer and inner loops, which correspond to the row and column, respectively. Alternatively, if the matrix is sorted, you can apply a more efficient search algorithm, such as binary search.
What is a complex formula in Excel?
There are thousands of complex formulas you can create in Excel. Here are a few examples:
=CHOOSE(WEEKDAY(F$4 & " " & $F$1),"S","M","T","W","T","F","S")
{=SUM(($A$5:$A$154=$E$169)*($E12:$E161<>"")*1)}
=OFFSET(Data!$D$15,0,0,COUNTA(Data!$D:$D),1)
=IF(SUM(AUG!$O$7:$S$7)=0,"",SUM(AUG!$O$7:$S$7))
=REPLACE(B3,FIND("code",B3),3,"upc")
=SUBSTITUTE(TRIM(A2 & " "& B2 & " " & C2 & " " & IF(LEN(B2)=1," ", IF(LEN(D2)=0,"",IF(B2=D2," ","("&D2&")"))) & " " & E2), " ", " ")
=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1),
DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2)
<=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<MONTH(A1),DAY(A2)
>=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<DAY(A1)),-1)))&" months,
"&A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"
Why do supermarkets use Excel?
Supermarkets, like any business, deal a lot with numbers. Supermarkets are dealing with them in terms of things like prices and orders and stock levels. They would use a lot of specialised software to do some of these things, but they would be able to use Excel to do some of it too.
What button do you press on the formula bar when you make a mistake?
There is no button on the formula bar, but there is an UNDO button on the menu bar. You also can press ESC to cancel your edit.
Does a title identify the data series or bars in a column chart?
No. A title is for the overall chart. A legend will identify the bars and series on it.
How do you automatically vary cells in Excel?
If you mean you want to change the values in the cell randomly, then there is a good function to do it. It is called RANDBETWEEN. It can choose a number at random between a lower and upper limit. If anything is changed on the spreadsheet or the user presses the F9 key, it will regenerate a value. So to get a random number between 1 and 100, you would do:
=RANDBETWEEN(1,100)
What does Alt Page Up do when in Excel?
If you have moved a full screen across, then it will move the cursor back a full screen. If you first do an Alt Page Down, it will jump the screen across and then Alt Page Up will return you to where you were.
What does an active cell mean?
The active cell is the cell that the cursor is on or the cell where whatever you type appears.
