How to Use Total Formula in Excel – 2022’s Secret

Sum or Total Formula in Excel

To use a total formula in excel, one must know the excel interface and basic knowledge over a cell, cell reference, row, column, range, mathematical operators, and the difference b/w formulas and functions. To return the total in excel, we have many formulas and functions. Total Formula and Function in Excel: To add numbers in … Read more

How to Use Paste Link in Excel – 2022’s Light

Copy Range of Cells in a Worksheet

Paste link is copying the range of a workbook’s sheet (with or without text) and linking it to another worksheet of the same workbook or another workbook’s sheet. Doing so will automatically update the content in the pasted range when you update or enter the content in the copied range. Link Range of Cells Between … Read more

Difference Between Functions and Formulas in Microsoft Excel

Sum Function in Difference Between Functions and Formulas​

Difference Between Functions and Formulas: A function is a pre-defined operation, developed by Microsoft Corporation in an Excel application. The formula is similar to a simple calculation, which is defined according to the user’s need and desire. Difference Between Functions and formulas in Excel: S. No. Function Formula 1. It is a pre-defined (built-in) operation … Read more

Create a Custom AutoFill Series List in Excel

Opening a file menu in excel

Create a Custom AutoFill Series List in Excel Create a Custom AutoFill Series List in MS-Excel:  Do you often waste your time by listing product names, country names, state names, currency names, employee names, or your family names in an Excel worksheet?  So, the custom Autofill series is a solution for you to stop typing … Read more

Multiple Choice Questions and Answers (MCQ & A) – MS Office

Multiple Choice Questions and Answers (MCQ & A) - MS Office

(Objective) MCQ – Multiple Choice Questions and Answers – MS Office This article on Objective-Multiple Choice Questions of MS-Office is useful for any interviews and competitive exams. Objective-(MCQ) Multiple Choice Questions – MS-Word (Office 360): Home, Insert, Design Layout, References, Mailings, Review, and View in MS Office Word, Excel, and PPT are called—- Tabs or … Read more

Introduction to MS Excel & User Interface to MS Excel

Introduction to MS Excel & User Interface to MS Excel 2020

Introduction to MS Excel Introduction to MS Excel & User Interface to Excel: Excel is an electronic spreadsheet program, developed by Microsoft Corporation.  An Excel Spreadsheet is used to record, validate and analyze the numeric data for maintaining Payrolls, Selling and purchasing product orders, Progress Reports, family budgets, and more. These are calculated whether using … Read more

6-Ways to Insert New Worksheet In Microsoft Excel

How to Insert New Worksheet In MS-Excel: In an excel spreadsheet, there are several options are there to insert the “New Worksheet”. These are whether the Keyboard shortcuts or other options from the ribbon. in this article, 6 different ways are provided below to insert a new worksheet in excel. Method-1: Click the New Sheet Tab Button: Click on … Read more

Change Worksheet Tab Color in 5-Ways in MS-Excel

Change worksheet Tab Color in MS-Excel

There are several ways to change the worksheet tab colour by using the shortcut keys or other commands in excel. Changing the worksheet tabs colours helps us to understand the difference between the tabs of different works easily. So, follow one of the 5 methods you like or all. Method-1 to Change Worksheet Tab Color … Read more

4 Ways to Rename a Worksheet in MS-Excel

It is essential to rename the worksheet to suit our content. A name change is useful to identify different types of sheet. Below is explained how to change the sheet name in 4 different ways. Rename a Worksheet in MS-Excel: 1. Rename a sheet by double clicking the sheet tab: Double-click the Sheet tab, and … Read more

6-Ways to Duplicate a Worksheet in MS-Excel

6-Ways to Duplicate a Worksheet in MS-Excel

There are several ways to duplicate a worksheet in excel using the shortcut keys or other commands in excel. To do so, learn all of the following methods. Copy or Duplicate a Worksheet in Excel: 1. Duplicate a worksheet by using move or copy: Right-click on any “Sheet tab” Then click “Move or Copy” (or … Read more

Apply Borders to the Cells in MS-Excel

Apply Borders to the Cells in MS-Excel

It is necessary to apply color and style to the borders/lines to a range of cells for certain categorized contents to make the content easy to identify and beautify. To apply borders to the cells in Excel, you can select the Line Color or Line Style or Both you want for a different border format, … Read more

How to Merge or Unmerge Cells in MS-Excel – 2022

Merge and Unmerge Cells in Excel

Combining two or more cells into a single cell is called merging cells. Similarly, division of a cell into multiple cells is called unmerged cells. Let’s see how to do them! 1. Merge & Center: Combining more cells into one cell and centring the text is called the Merge & Centre. Go to the Home tab Select … Read more