When we open a new workbook in MS Excel, the Title bar appears on the topmost portion of the screen.
It displays the name of the open document.
Excel spreadsheets are typically saved in the .xlsx format,
It is the default file format introduced with Excel 2007.
F11 Creates a chart of the data in the current range in a separate Chart sheet.
Some important shortcuts used in MS Excel
•F1 Opens Excel Help
•F2 Edit contents of an excel
•F3 Paste Named Range or Named List
•F4 Toggles between cell references – Absolute, Relative, and Mixed Reference
•F5 Displays the “Go To” dialog box
•F6 Switch between the panes of an Excel workbook if you have a split window
•F7 Opens the “Spelling” option in Excel using which you can check the spellings in your workbook
•F8 Enables and disables the “Extend Mode” selection in Excel.
•F9 Recalculates the output of all formulas in your Excel workbook.
• F10 Displays the keyboard shortcut for the Excel ribbon also known as Excel tips
• F12 Opens the “Save As” dialog box like the “Alt + F2” keys
In MS Excel, the term “data categories” refers to the horizontal axis (also known as the X-axis) in a chart.
It organizes individual values within the chart’s data series and represents different categories or labels along this axis.
The VLOOKUP function in Excel is used to search for a value in the first column of a range
And return a value in the same row from a specified column.
It is commonly used for looking up data in a table or range.
The VLOOKUP function in Excel searches for a specified value in the first column of a table and returns a value from another column in the same row.
The VLOOKUP or Vertical Lookup function is used when data is listed in columns.
A worksheet consists of rows (horizontal) and columns (vertical) where data is entered into cells at their intersections.
After = symbol you can enter either a calculation or functions
Filtering in Excel enables you to display rows that meet certain criteria, hiding the others.
This Excel feature allows you to display only the rows that meet specific conditions while hiding the others.
