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
How many rows should you select if you want to insert two rows?
select 2 rows, the no. of rows you select will be the no. of rows to be inserted
Conditional
In the function equals SUM what are the arguments?
Usually it is a range of cells. It can be individual cells or individual numbers. Although they will work without a SUM, you can also put an ordinary calculation of any kind into a SUM. So here are some ways SUM could be used:
=SUM(A2:A10)
=SUM(A3,4,A18:A30,B27,123,C10:C15)
=SUM(A5+A30)
When using a function to perform a calculation how would you select the range of numbers to use?
Drag the cursor through the set of cells.
Why would you want to change the column width?
There are lots of reasons. Basically though, it is because quite often the column is not wide enough to hold the data that is entered into it. If the next cell to the right is empty, it would spill out over it. If something is in the next cell to the right, then what is in the first cell will not be seen in full. So the column needs to be widened to enable it be seen in full.
What sheet in the format cells dialog box to position data in a cell by centering it?
It is on the Alignment tab.
Paste special
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
The nper argument.
What is sign after equal sign in formula?
It is generally positive(+) or negative(-).For example: speed = distance/time.
How do you use the SUM function to total the values stored in non-adjacent cells or ranges?
Separate the non-adjacent cells or ranges with a comma in the SUM function.
EXAMPLE:
=SUM(A1,B2:B14,M32:W32)
This is the same as the combination formula:
=A1 + SUM(B2:B14) + SUM (M32:W32)
Are Cell contents are either values formulas?
Yes, but you can categorise values into many types, such as text for labels, dates, logical values, times etc.
How do you make a cricket score card using Microsoft Excel?
If you know how a real cricket scorecard looks and works, then it is easy. You can use the borders, to draw the boxes around the cells. Use Ctrl - 1 to access the Format Cells dialog box and then you can get to set the borders. To work out scores you would need formulas. It would depend on what cells you were using and what way your scores are being calculated as to what formulas you need.
What is organized in rows and columns?
They will form a grid, which could then be a table or a worksheet, depending on the context.
Does a filter arrow on a column indicate that it is an Excel table?
It can indicate a table or that AutoFilter is on.
Can you freeze multiple cells in a column?
When you freeze, you freeze entire rows or entire columns. If you want to be able to see some values in a column all the time and have the others scroll up and down, you can either freeze the amount of rows needed or you could use the Split option. That creates individual windows in your document, which can be independently scrolled without scrolling another.
When would you use a chart rather than a table?
A chart is a graphical representation of your figures, like in a pie chart, a line chart or a column chart for example. A table consists of the figures in your spreadsheet, arranged in an orderly fashion, and from which you can make a chart.
In a database, a table is usually lists of data, such as names or addresses. Word can also have tables to list out names and addresses, or to list out numbers like in a spreadsheet.
