What is Excel functions with examples?

Common functions

S/N FUNCTION DESCRIPTION
01 SUM Adds all the values in a range of cells
02 MIN Finds the minimum value in a range of cells
03 MAX Finds the maximum value in a range of cells
04 AVERAGE Calculates the average value in a range of cells

What is worksheet in MS Excel?

The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

How do you create and save a worksheet in MS Excel?

Save a worksheet

  1. Right-click the worksheet name tab.
  2. Click select Move or Copy.
  3. Click on the Move selected sheets to Book drop-down menu. Select (new book).
  4. Click OK. Your new workbook opens with your moved worksheet.
  5. Click File > Save in your new workbook.

How do you not show formulas in Excel?

To hide formulas:

  1. Select the cells for which you to want to hide the formulas.
  2. Right-click the cell (or cells) and choose Format Cells.
  3. In the Format Cells dialog box, click the Protection tab.
  4. Check the Hidden box. Note: Hidden is what prevents the user from seeing the formula.
  5. Click OK.

What are the steps to open MS Excel?

Open Excel Starter with the Windows Start button.

  1. Click the Start button. . If Excel Starter is not included among the list of programs you see, click All Programs, and then click Microsoft Office Starter.
  2. Click Microsoft Excel Starter 2010. The Excel Starter startup screen appears, and a blank spreadsheet is displayed.

Why formula is not working in Excel?

Cause: The cell is formatted as Text, which causes Excel to ignore any formulas. Fix: Change the format of the cell(s) to General or some other format. However, the formulas still won’t start working until you force Excel to reconsider the content. You can do this in one of two ways.

What are the parts of Excel?

Also called a spreadsheet, the workbook is a unique file created by Excel XP.

  • Title bar. The title bar displays both the name of the application and the name of the spreadsheet.
  • Menu bar.
  • Column headings.
  • Row headings.
  • Name box.
  • Formula bar.
  • Cell.
  • Navigation buttons and sheet tabs.

How many types of formulas in MS Excel?

300

How do I fix formulas in Excel?

Select the cell with the formula you want to make it constant. 2. In the Formula Bar, put the cursor in the cell which you want to make it constant, then press the F4 key.

Why is Excel showing formula?

The reason Show Formulas can be accidentally enabled is because it has the keyboard shortcut (Control `) that a user might unknowingly type. Try Control ` in a worksheet to see how it works. You’ll see you can quickly toggles all formulas on and off. Show Formulas toggles the display of every formula in a worksheet.

Which key is used for help in MS Excel?

Shortcut keys in Excel – Function Keys (6 of 8)

Key Description
F1 F1: Displays the Excel Help task pane.
Ctrl+F1: Displays or hides the ribbon.
Alt+F1: Creates an embedded chart of the data in the current range.
Alt+Shift+F1: inserts a new worksheet.

What is the shortcut key to hide formula in Excel?

You can show or hide formulas using a keyboard shortcut. Press Ctrl + tilde (~) or Ctrl + accent grave (`) to show or hide formulas. The tilde / accent grave key appears on the top left of most keyboards below the Esc key. This shortcut works in all versions of Excel.

What are the basics in Excel?

Seven Basic Excel Formulas For Your Workflow

  • SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments.
  • AVERAGE. The AVERAGE function.
  • COUNT. The COUNT function.
  • COUNTA. Like the COUNT function, COUNTA.
  • IF. The IF function.
  • TRIM. The TRIM function.
  • MAX & MIN. The MAX.

Why is Excel not dragging formulas?

If you’re still having an issue with drag-to-fill, make sure your advanced options (File –> Options –> Advanced) have “Enable fill handle…” checked. You might also run into drag-to-fill issues if you’re filtering. Try removing all filters and dragging again.

How do you show formulas in one cell in Excel?

Show Formulas in a Single Cell If you want to show a formula in a single Excel cell, you can do this by simply inserting an apostrophe at the start of the cell. This forces the cell to display the formula, rather than its result.

How do you hide formulas in Excel without protecting sheet?

How to hide formula but display the result without protecting worksheet in Excel?

  1. Hide formula but display result without protecting worksheet with VBA code.
  2. In the worksheet you need to hide formulas but displaying the results, please right click the sheet tab, and select View Code from the right-clicking menu.

How do you display formulas in a worksheet?

How to Display Formulas in Excel

  1. Click the Formulas tab.
  2. Click the Show Formulas button. Formulas are displayed in the worksheet and the columns widen to accommodate the formulas, if necessary.
  3. Click the Show Formulas button again to hide the formulas.

How do I write a formula in Excel?

To enter a formula, execute the following steps.

  1. Select a cell.
  2. To let Excel know that you want to enter a formula, type an equal sign (=).
  3. For example, type the formula A1+A2. Tip: instead of typing A1 and A2, simply select cell A1 and cell A2.
  4. Change the value of cell A1 to 3.
By