0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is the default file extension for an Excel 2010 workbook?
The default file ext for Excel 2010 default install is .xlsx as it was in 2007. 2003 was the last version with a different extension, which was .xls for workbooks.Te default file ext may be changed by going into File-> Options -> Save -> Save in this format.If there is a group policy in place, Excel will inherit the default file extension specified.
Can you convert an Excel 2003 spreadsheet to 2010 to add more rows?
If you have 2010, then you can open it and save it as a 2010 workbook. It won't open with Excel 2003 after that though so you cannot have the benefit of the extra rows in Excel 2003. That is one of the reasons for using 2007 or 2010.
Can you have a password on an Excel file?
Yes, you can protect the entire workbook or sheet in different levels according to your need - for example you can protect from changing the data in the workbook and only by entering a password in can be unlock it. To do so {in excel 2010} go to the Review menu and choose Protect workbook or Protect sheet
How many worksheets can a workbook have in excel 2010?
As many as the memory in your computer can store. The number of worksheets in each workbook is limited only by the amount of memory available.
How do you change Excel file into xml file?
By default Excel should save files in the .xml or .xmlx format (the latter being the default format for Excel 2007 & 2010). Other common formats that Excel accepts include .cvs and .txt. If you have that (or any other format) this is the easiest way to change the format:Open the file in Excel. Select "Save As" from the tile menu/office button (depending on your version of Excel). When you're prompted to select a location and file name, change the file type (using the drop down menu at the bottom of the screen) to Excel workbook (if you're using a version older than 2007) or Excel 97 - 2003 workbook (if you using 2007 or newer).There other methods, but they require slightly higher degrees of technical proficiency than this one.
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 meaning of ms Excel 2010?
ms excel 2010
Which type of VLOOKUP is default in Excel 2010?
To have the column being searched sorted in ascending order and to find the nearest value equal to or below the search value.
Where you can change margin settings and page?
Page Layout tab,Page setup section in word,excel 2007/2010
How can you save and Excel 2010 workbook if some is still using Excell 2003 or 2007?
Do a Save As, and pick the 2003 version. It can then be opened by any of the 3 versions. Depending on what is in the original document, it is possible that you could lose some things. Most Excel spreadsheets will not lose anything when they are saved into an earlier version.
How do you play billiards in Excel 2010?
There are no hidden games in Microsoft Excel 2010. The last version that had a hidden game was in Excel 2000. There is a game called Billiards Excel and there are Billiard 2010 games, but these have nothing to do with Microsoft Excel, or any Microsoft software.
Can you use Excel 2010 as Excel 2007?
The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.
