Pavatharni . S

size_t sz = buf->size();
while ( –sz >= 0 )
{
/* do something */
};

int i = 5;
int j = i++;

my_struct_t *bar;
/* … do stuff, including setting bar to point to a defined my_struct_t object … */
memset(bar, 0, sizeof(bar));

#include <iostream>

int main(int argc, char **argv)
{
std::cout << 25u – 50;
return 0;
}

The only difference between a class and struct are the access modifiers. Struct members are public by default; class members are private. It is good practice to use classes when you need an object that has methods and structs when you have a simple data object.

Select a cell adjacent to the cell you want the currency (Rupees) to be converted into words.
Enter the formula – NumberstoWords(A1) and press Enter. A1 is the cell containing the currency in Rupees.
Press Enter to confirm the formula.

Go to “File.”
Select Info>Protect>Unprotect Sheet
You can skip this step and also do the changes from the Review tab. Go to Changes>Unprotect Sheet.
Enter the password to proceed in case the sheet is password protected.
Otherwise, click OK to continue.

The easiest way to multiple in Excel is by using a simple formula for multiplication using the asterisk symbol. It enables users to multiply individuals cells and numbers. All you have to do is separate them by commas. To multiply a series, use a colon.

For example, using the formula – “=PRODUCT (A1, A2:A5, B1,12)”, Excel will multiply (A1XA…[Read more]

Select the cell or cells with the data you want to split.
Click the “Layout” tab.
Click “Split Cells” in the Merge group tab.
A dialog will appear. In the Split Cells dialog, enter the number of columns and rows you want.
Click OK to save changes.
The cell will be split into fragments.

Click the cell where you want the VLOOKUP formula to be calculated.
Go to the top of the screen and click “Formulas.”
Click on “Lookup and Reference” on the ribbon.
At the bottom of the drop-down menu, look for VLOOKUP.
Select the cell in which you want to apply the formula.
A VLOOKUP dialog box will open; specify the data you want to use for…[Read more]

Select the cells you want to contain in the drop-down list.
Go to ribbon and click “Data,” then “Data Validation.”
In the dialog box, select “Allow to List.”
Click on Source and type the numbers or text that you want in your drop-down lists.
Click OK to continue.
Note that commas should separate the numbers and texts.

First, select the cells containing the date.
Right-click on the mouse or keypad and select “Format” cells.
Go to the “Number” tab and select “Custom.”
Then type the date format you want in the Type box.
Click OK to continue.
It will format the selected dates.

ble of contents
Introduction to Excel
Microsoft Excel Interview Questions
Introduction to Excel
Microsoft Excel or MS Excel over the years has become more so a skill than an application. Although it is very underrated, the importance it has in daily life of a working professional is very significant. Listed are some of the most important Excel…[Read more]

Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.

Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.

Select the cell you want to merge the combined data.
Click on the first cell and select the range you want to merge.
Click Home.
Select “Merge &amp; Center” from the menu

Select the rows you want to freeze.
Click View in the main menu.
Go to the Ribbon, click ‘Freeze Panes’, and then again click ‘Freeze Panes.’

Select the desired cell to display the percentage.
Start by typing an equal (‘=’) sign.
Apply the basic formula for percentage which is = part/total.
Type A1/A2 and hit Enter.
Click Home and select the percent (% ) symbol from the numbers group.
The result will be displayed as decimal fractions.

Select the range of cells that you want to remove.
Click Data.
Under the columns in the Data Group, click Remove Duplicates.
Check or uncheck the columns where you want to remove duplicates.
Click OK.
A message will appear showing how many duplicates were removed.

Table of contents
Introduction to Excel
Microsoft Excel Interview Questions
Introduction to Excel
Microsoft Excel or MS Excel over the years has become more so a skill than an application. Although it is very underrated, the importance it has in daily life of a working professional is very significant. Listed are some of the most important Excel…[Read more]