1- What is Microsoft Excel?
Microsoft Excel is an electronic spreadsheet program, created by multiple highly skilled engineers from Microsoft. It enables users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and column.
2- How do you create a spreadsheet in Microsoft Excel?
When you start Excel without specifying a document to open you get a blank workbook in a new workbook window.
This workbook, temporarily named Book1, contains three blank worksheets
(Sheet1, Sheet2, and Sheet3). To begin to work on a new spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window.
3- How do you save a spreadsheet in Microsoft Excel?
Click the Save button on the Quick Access toolbar or press Ctrl+S; then designate the drive and folder directory where the file should be located.
4- What is the shortcut to put the filter on data in Microsoft Excel?
Ctrl+Shift+L is the shortcut key to put the filter in data.
5- What is the easiest solution to reduce the file size?
- Find the last cell that contains data in the sheet. Delete all rows and columns after this cell
- To delete the rows, press the key Shift+Space then press Ctrl+Shift+Down on your keyboard
- Rows will get selected till the last row. Press Ctrl+- on the keyboard to delete the blank rows
- To delete the column, Press the key Ctrl+Space then press Ctrl+Shift+Right Arrow key on your keyboard
- Columns will get selected till the last row
- Press Ctrl+- on the keyboard to delete the blank columns
6- What is the difference between function and formula in Microsoft Excel?
Formula:- In excel formula are the statement which is written by the user (user-created) to be calculated. A formula can contain values, cell references, defined names, and functions.
Functions:- Functions are in-built codes provided in MS-Excel, such as COUNT, SUM, AVERAGE etc. And, if additional functions are required we can create through VBA. This will carry out an operation of some kind and provide an output value. Functions are used inside formulas.