Excel 2007, 2010, 2013 Questions and Answers

Excel 2007, 2010, 2013 Questions and Answers

 

1) What are the total no of cells in 2007 & 2010 Excel ?

Answer: 17,179,869,184 cells (16,384 columns X 1,048,576 rows)

2) what is the file extension of 2007 & 2010 excel ?

Answer: .xlsx format

3) What are the total no of rows and columns 2007 & 2010 Excel ?

Answer: 16,384 columns and 1,048,576 rows

4) What is the short cut key to go from 1st to the last cell?

Answer: CTRL+ARROW KEY (Go from 1st cell of the row/column to last cell of the raw/column)

5) How to write formula in Excel?

Answer:

1. Click the cell in which you want to enter the formula.


2. In the formula bar , type = (equal sign).


3. Do one of the following: To create a reference, select a cell, a range of cells, a location in another worksheet, or a location in another workbook.

6) Where is the address bar located in Excel?

 

7) Where is the formula bar located in Excel?

The formula bar in Excel is located above the work area of the spreadsheet. ( If not active then go to View tab and tick formula bar)

8) What is transpose in excel?

If data is entered in columns or rows, but you want to rearrange that data into rows or columns instead, you can quickly transpose the data from one to the other

1. On the Home tab, in the Clipboard group, click Copy.

2. Go to the cell that you want to transpose it.

3. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Transpose.

9) What is wrap text in excel?

Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.

1. In a worksheet, select the cells that you want to format.


2. On the Home tab, in the Alignment group, click Wrap Text .

10) What is merge & Center in excel?

When you merge two or more adjacent horizontal or vertical cells, the cells become one larger cell that is displayed across multiple columns or rows.

1. Select two or more adjacent cells that you want to merge.

2. On the Home tab, in the Alignment group, click Merge and Center.

11 How to Insert symbols in Excel?

1. On the worksheet, click the cell in which you want to insert the symbol.


2. On the Insert tab, in the Text group, click Symbol.


3. Click the Symbols tab.

12 ) what is Auto Sum in excel?

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on theHome tab, press Enter, and you’re done.

13) What is excel sort and filter? 

Sorting

When you enter data into your worksheet it is often unorganized making it difficult to examine. When analyzing the information in your spreadsheet, you may need to rearrange the data in different ways to answer different questions. Excel’s sorting feature can help your rearrange your data so you can use it more efficiently.

Note: If your spreadsheet contains formulas, be careful when using the sort feature. Formulas rely on cell references to perform their calculations and moving the data with the sort feature may destroy these references.

To sort a list of data:

Select a single cell in the column containing the data you want to sort.

Select the Home tab.

Under the Editing group, press the Sort and Filtering button and select the order you want your data to be sorted.

Note: If you select an entire column, Excel will sort only that column and will mismatch the data contained in the other columns.
Filtering

Filtering is a way that you can use Excel to quickly extract certain data from your spreadsheet. Unlike sorting, filtering doesn’t just reorder the list. It actually hides the rows or columns containing data that do not meet the filter criteria you define. Excel has an AutoFilter feature that makes it very easy to extract data from your spreadsheet.

To use the AutoFilter:

Click on any cell in your spreadsheet.

Select the Home tab.

Under the Editing group, press the Sort and Filtering button and select the Filter button.

Drop-down menus will appear next to each cell heading.

Clicking on any drop-down menu will provide you with options for sorting or filtering.

13) What is excel short cut key for current date and time? 

To insert the current date, press CTRL+; (semi-colon).

To insert the current time, press CTRL+SHIFT+; (semi-colon).

14) How to protect Excel workbook ?

 

 

Excel 2007, 2010, 2013 Questions and Answers