In Windows, what do you get if you change the extension of an (unprotected) Excel file from .xlsx to .zip?

In Windows, what do you get if you change the extension of an (unprotected) Excel file from .xlsx to .zip?

• A file that MS EXCEL cannot open
• Nothing useful at all
• A corrupt ZIP file
• The original spreadsheet as a set of XML files within the ZIP 

EXPLANATION

Since Office 2007 Microsoft has used Open XML to store non-password protected documents.  These are then combined into a single compressed file using
the  docx, xlsx, pptx, etc. extensions.   Even though the XML files are quite large, they compress very well.

Read More

What is the not equals operator in Excel?

What is the not equals operator in Excel?

• NOT()
• <>
• >=
• !=

 

EXPLANATION

When comparing two pieces of data in Excel, what operator would you use to test if they were not equal?
If I were comparing cells A1 to B1, my formula would be:

=A1___B1

NOT() is a function, not an operator.

SOURCE

https://support.office.com/en-us/article/Calculation-operators-and-precedence-in-Excel-48be406d-4975-4d31-b2b8-7af9e0e2878a#tblID0EABCAFAAA

Read More

Which function key is used to check for spelling in MS Office?

Which function key is used to check for spelling in MS Office?

• Alt + F11
• F5
• Alt + F4
• F7

EXPLANATION

Function key assignments common to all Microsoft Office applications are: F7 to check spelling.



 In Microsoft PowerPoint, F5 starts the slide show.



 Alt+F11 calls the Visual Basic Editor



 Alt+F4 is used to quit the application.

 

Read More

The intersection of a column and row in a spreadsheet is called a bon or a __?

The intersection of a column and row in a spreadsheet is called a bon or a __?

• Cell
• Box
• Key
• Field 

 

EXPLANATION

The intersection of a vertical column and horizontal row is called a cell.The location, or address, of a specific cell is identified by using the headers of the column and row involved. For example, cell "F2" is located at the spot where column "F" and row "2" meet.

Read More

What version of Office are you using when the installation folder is Office14?

What version of Office are you using when the installation folder is Office14?

• Office 2014
• Office 2010
• Office 2013
• Office 2016 

 

EXPLANATION

Microsoft started office at version one and put the version number at the end of the folder. Beginning with Office 95, Microsoft started naming the versions after the years in which they were released, but they kept using the version number for the program folder.

SOURCE

http://www.ryadel.com/en/microsoft-office-default-installation-folders-versions/

Read More