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 do we press to select the entire worsheet?
In the top corner of the spreadsheet, above the 1 for row 1 and to the left of the A for column A, there is a blank button. Clicking on that will select the entire worksheet.
or even simpler, if you have a Windows computer, [Ctrl] + [A]
What happens if a column in a spreadsheet is too narrow for labels of values in a particular cell?
The value automatically "overflows" on top of the next cell. But you can manually change the formatting in a variety of ways to change this to a better appearing form in a variety of ways, including:
- widening the column
- making the labels or values "wrap" onto more lines of that cell (the height of the cell changes automatically)
- reducing the font size in the cell
What is difference between Excel and RDBMS?
Excel is a spreadsheet application. RDBMS is a Relational Database Management System. Excel has databasing capabilities, but does not have the capabilities of a relational database. There are many facilities in a RDBMS that Excel cannot do or can only do to a very limited amount. Excel is for numerical analysis and manipulation, which is what a spreadsheet is for. Databases are for managing lists of data. So while they both can manipulate data, they are for different kinds of jobs.
When does the function arguments box appear in Excel?
It shows you what needs to be put into a function for it to work. You can type the arguments directly into the boxes that are shown for the particular function you are using. It is particularly handy for more complex functions that you are not used to working with.
Why should shopkeepers use spreadsheets?
Excel / open office / google docs spreadsheets are very good calculators and given the price of a till or check out a spreadsheet offers a very cheap way to keep records in a digital format. The spreadsheet can then be uploaded to a database. For accounting needs. Also it means if the shop keeper. Has the data already in digital format then they would spend less time at home updating the record keeping program so the shop keeper would be less of a slave doing admin work for his or her business.
The columns in the spread sheet are identified by?
Columns are identified by letters, starting with column A.
this feature allows you to choose from predesigned formats to change the appearance of a worksheet
What are facts about Microsoft Excel?
1. You can undo the last 100 actions
2. Each worksheet holds 1,048,576 rows
3. Each worksheet holds16, 384 columns
4. There are 1,024 global fonts available to use, 512 per worksheet
5. Zoom range is from 10 percent to 400 percent
6. You can select 2,147,483,648 cells that are not touching
7. You can have up to 255 arguments in a function
8. You can nest 64 levels of functions per formula
9. You can have up to 255 data series in one chart
10. You can highlight 32,767 cells per worksheet
On the Ribbon is the place where documents are created?
Documents are not created on the ribbon. You create documents in the application window, located below the menu ribbon. You can create a new document in Office 2007 by clicking on the New option in the Office 2007 menu (a circle icon at the top right of the screen).
What do parentheses mean in an Excel formula?
Calculate the numbers in parentheses first.
****************************************
Whilst the above answer is perfectly correct - A formula in LibreOffice Calc is written within parentheses: =SUM(A1:A22) if this formula is put into A23, for example, it will show the total for A1 to A22 in A23
Where items are copied from in Excel?
They are copied to the 'clip board'. This is just a software name, for a portion of the memory reserved for temporary storage.
It is volatile and will be lost when the computer is shut down.
Do spreadsheets make learning arithmetic unnecessary?
Although spreadsheets can provide formulas, you will need to be able to explain the formula. Spreadsheets do help in learning arithmetic, which is a key component in understanding how to input formulas in a spreadsheet.
How do you insert three columns between column D and E at once in Microsoft Excel?
Select columns, E, F and G. You can do that by going to the column header for column E and when you see a black arrow pointing down, then drag across to select the other two columns. Then right click, and click Insert. What was column E will now be column H and there will be three new columns between it and column D.
What is better Microsoft Excel or Open Office?
It depends on your point of view - they are both equally good programs. They both do the same thing (ie create spreadsheets. The main difference is Excel is a single program, where Open Office is a 'suite' of programs comprising spreadsheet, database, word-processor etc.
Date and Time functions are normally classified together in Excel. Some of the common Date and Time functions are:
Date
Datevalue
Day
Days360
Edate
Eomonth
Hour
Minute
Month
Networkdays
Now
Second
Time
TimeValue
Today
Weekday
Weeknum
Workday
Year
Yearfrac
How do you display the multiplication symbol?
'x' is the most commonly used symbol. However, these are also acceptable ways of representing multiplication:
2 x 3 = 6
2(3) = 6
2.3 = 6
Also, in terms of how it is displayed on a computer, 2*3=6 would also suffice.
Move the insertion point to the beginning of a document the keyboard?
Using the CTRL+SHIFT+HOME command within the body of a document will move the cursor back to the beginning of that document. It is a very valuable command tool that can save the user a lot of time paging through lengthy documents.
Who is the founder of Microsoft Excel?
The first computerised spreadsheet was launched by Dan Bricklin and Bob Frankston in 1979. It was called Visicalc. Microsoft were just one of several companies to bring out their own spreadsheet programs after that. Excel was first launched in 1985, but Microsoft had other ones before that, like Multiplan.
What conclusion can be drawn from this chart?
You can conclude nothing, becasue there is no indication to which chart you are referring.
What process centers the spreadsheets content on the page?
In print preview click in the box in front of horizonal page alignment.
What is the formula to find the sum of cells a1 a2 and a3 in excel?
Excel formulas that will find the average of cells A1, A2, and A4 are:
=AVERAGE(A1 ,A2, A4)
or
=AVERAGE(A1:A2, A4)
How do you separate words by words in a cell of excel?
- Select a column of numeric data in a range of cells, or make sure that the active cell is in a table column containing numeric data.
- To sort from low numbers to high numbers, click Sort Smallest to Largest.
- To sort from high numbers to low numbers, click Sort Largest to Smallest.
- On the Data tab, in the Sort & Filter group, do one of the following:
Two formats you may choose from when creating a format task organization?
Matrix is one of the two formats used when creating a format task organization.
