MS Excel

  Home  Applications Programs  MS Excel


“MS Excel Interview Questions and Answers will guide us that Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. Get MS Excel Job interview preparation with this MS Excel Interview Questions and Answer Guide”



120 MS Excel Questions And Answers

101⟩ Excel Uses for the INDIRECT and ADDRESS Functions or Formulas?

To increment a formula reference by rows, when copying across columns you need a combination of the INDIRECT and ADDRESS Function. For example, place this formula in any row in Column "D".

=SUM(INDIRECT(ADDRESS(1,1)&":"&ADDRESS(COLUMN()-2,1)))

Now copy it across any amount of Columns. You will note that at each Column the row number increases by 1. In affect it will look like:

=SUM($A$1:$A$2) at Column D

=SUM($A$1:$A$3) at Column E

=SUM($A$1:$A$4) at Column F

=SUM($A$1:$A$5) at Column G

etc

The Syntax for the ADDRESS Function is

ADDRESS(row_num,column_num,abs_num,a1,sheet_text)

The last 3 arguments (abs_num,a1,sheet_text) are all optional. If your range resides on another sheet, it is the sheet_text that you need, eg

=SUM(INDIRECT(ADDRESS(1,1,,,"Sheet 2")&":"&ADDRESS(COLUMN()-2,1)))

Note that the Sheet name is supplied to the first ADDRESS function only

 157 views

103⟩ How can I change the color of the sheet tabs?

In Excel 2002, and later versions, you can colour the sheet tabs. Right-click on a sheet tab, and choose Tab Color.

Note: When the sheet is selected, the colour will show in a thin strip at the bottom of the sheet tab. The full tab is coloured for non-selected sheets.

 175 views

104⟩ How to access my Copy file?

If you open a Excel file using the OPEN AS COPY option, then a new file is created and saved in the same directory of the original file. So if you have a file, say test.xls in D drive. Then if you open the file as copy, then Excel creates a file in the D drive with the name Copy(1) of test.xls.

You can access this file through the path D:/Copy(1) of test.xls. You can always rename and copy your file somewhere else but by default Excel saves the copy of the file in the same drive. Also, Excel duplicates the original file and whatever is in the original file, it is copied including formats, formulas and other functionalities.

 169 views

108⟩ How to open a new copy of a Excel file?

To open a file as copy, just follow the steps

* Select your file through the file open box (CTRL+O)

* Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)

* Click the arrow and select OPEN AS COPY.

* Now you could be having a copy of the original version of the file.

 161 views

109⟩ What is Excel and When Would I use it?

Microsoft Excel is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.

In olden days we have Lotus 123, it is also having spread sheets for using accounts purpose. Now excel having spread sheets not only accounts purpose but also for various types of formats with calculations.

 173 views

110⟩ How Do You Use IF Functions in Excel?

One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. This article covers how to write an IF function.

 183 views

111⟩ Upload data from Excel into SAP?

* Some of the Business functions (BAPI's / RFC unctions) offer data upload

* The general tool in SAP for data upload is the Batch input / call transactions

In the batch input file you specify screen by screen and field by field the input to SAP.

SAP has a recorder to create the sample file. Just run trans SHDB. Within this transaction, you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel. Manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.

 195 views

112⟩ What are Excel Spreadsheet Number Formats?

Number formatting in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.

 161 views

113⟩ How Do You Use the SUM and AutoSUM Functions in Excel?

The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.

 165 views

114⟩ Show Excel Toolbars on Two Rows?

The default setting for Excel toolbars is to display them on a single row, thereby hiding many of the toolbar buttons. It is quite easy to change the default settings to show Excel toolbars on two rows, making for a easier time formatting your spreadsheet.

 167 views

115⟩ How to Change the Sheet Tab Color of Excel Spreadsheets?

In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the color of worksheets tabs containing related information can make it easier to navigate through very . Or to use tab colors to differentiate between sheets containing unrelated information.

 169 views

116⟩ Best regards, i have some problems in regression of my data, i am pleasured to solve my problem and create new regression in these data. x y1267.4 0.011267.5 0.021267.6 0.031267.7 0.041267.8 0.061267.9 0.081268.0 0.101268.1 0.131268.2 0.161268.3 0.191268.4 0.241268.5 0.291268.6 0.341268.7 0.401268.8 0.461268.9 0.521269.0 0.591269.1 0.661269.2 0.731269.3 0.811269.4 0.901269.5 0.981269.6 1.071269.7 1.161269.8 1.261269.9 1.361270.0 1.481270.1 1.621270.2 1.771270.3 1.941270.4 2.131270.5 2.321270.6 2.531270.7 2.741270.8 2.971270.9 3.211271.0 3.461271.1 3.731271.2 4.001271.3 4.281271.4 4.561271.5 4.861271.6 5.161271.7 5.461271.8 5.781271.9 6.101272.0 6.421272.1 6.761272.2 7.101272.3 7.451272.4 7.811272.5 8.171272.6 8.541272.7 8.911272.8 9.281272.9 9.661273.0 10.051273.1 10.441273.2 10.841273.3 11.241273.4 11.641273.5 12.051273.6 12.461273.7 12.881273.8 13.301273.9 13.721274.0 14.141274.1 14.581274.2 15.011274.3 15.451274.4 15.901274.5 16.341274.6 16.791274.7 17.241274.8 17.701274.9 18.161275

 159 views

117⟩ I have some problems in regression of my data, i am pleasured to solve my problem and create new regression in these data. x=(1267.4 - 1267.5 - 1267.6 - 1267.7 - 1267.8 - 1267.9 - 1268.0 - 1268.1 - 1268.2 - 1268.3 - 1268.4 - 1268.5 - 1268.6 - 1268.7 - 1268.8 - 1268.9 - 1269.0 - 1269.1 - 1269.2 - 1269.3 - 1269.4 - 1269.5 - 1269.6 - 1269.7 - 1269.8 - 1269.9 - 1270.0 - 1270.1 - 1270.2 - 1270.3 - 1270.4 - 1270.5 - 1270.6 - 1270.7 - 1270.8 - 1270.9 - 1271.0 - 1271.1 - 1271.2 - 1271.2 - 1271.3 - 1271.4 - 1271.5 - 1271.6 - 1271.7 - 1271.8 - 1271.9 - 1272.0 - 1272.1 - 1272.2 - 1272.3 - 1272.4 - 1272.5 - 1272.6 - 1272.7 - 1272.8 - 1272.9 - 1273.0 - 1273.1 - 1273.2 - 1273.3 - 1273.4 - 1273.5 - 1273.6 - 1273.7 - 1273.8 - 1273.9 - 1274.0 - 1274.1 - 1274.2 - 1274.3 - 1274.4 - 1274.5 - 1274.6 - 1274.7 - 1274.8 - 1274.9 - 1275.0 - 1275.1 - 1275.2 - 1275.3 - 1275.4 - 1275.5 - 1275.6 - 1275.7 - 1275.8 - 1275.9 - 1276.0 - 1276.1 - 1276.2 - 1276.3 - 1276.4 - 1276.5 - 1276.6 - 1276.7 - 1276.8 - 1276.9 - 1

 175 views

118⟩ Is there a way in excel to write a formula to mark a cell with a symbol or letter or number that is the inverse of coordinates marked. example if i mark the coordinates c/p with a "1" then excel will automatically mark its inverse p/c. and if i erase a symbol from, lets say, d/g, then excel removes a symbol from the inverse which would be g/d. i will need to mark any particular (several, many) particular cells more than once such as 2 or three times. can i do it all with the same symbol or number (or letter).reason i want to make a table of sorts where the names of badminton players are listed down vertically and in the same order horizontally. therefore b,b would have the same name such as carol, c/c might be joe, d,d might be shaun, etc. that way when, lets say carol and shaun are partners in a game and i type the symbol in the coordinates b/d, then excel will mark d/b automatically. that way i can keep track by seeing who has played with who already, not at all, or even pl

 186 views