How do I make a question and answer sheet on excel?
952409
That is a good question needs a GOOD answer.\nYou have some tools in Excel to do this.\nTry:\n1- View > Toolbars > Forms\nand draw the object you want (Use Checkbox and OptionBox will help you alot)\nRight click on each of these boxes and go to Properties > Control where you can select the way this control controls the action.\nYou can alos use ListBox or ComboBoxes.\n2- You may need some VBA macros to complete the job\n\nI can do alot of these for you, need you to send me more info here in Y! Answers and I can promise I will help\n\nEnjoy my profile, I am the VBAXLMan
968999
Perhaps if you phrased your questions as ideas, \n\nLike, \n\n"I'm going to use Excel to create a spreadsheet and enter all the data that way." \n\nIt will give your boss a chance to say, "No I want you to enter the data through...." or say, "Yes, that would work well." \n\nOr, there's always the option of Monster.com
970446
Although i didn't understand your question correctly, I guess you need to make a form that have some question and some people would answer them.\n\nyou have two choices :\nfirst :\nyou may save their answers to a file then you call this file to get the answers\nsecond:\nyou may create a data base to get answers for each one who use ur program\n\nfor more Details contact me :\nm.zatari@yahoo.com
128367
There is actually a good one as a sample spreadsheet template in Microsoft Excel. there is even a better one in the older versions of Microsoft Works spreadsheet tool.
980495
i had to make a pamphlet for school once.  I'm not sure of an easier way, but you can make columns on a word document in the format option.
84624
1. Double click the question.\n2.Click the window that sayd "answer question."\n3. Answer question.\n4. Click "Preview."\n5. Click "Submit."
831601
Create a table. Fill in each number you want to add in the same column, but different rows. Leave one column empty at the end. Go to the Toolbar and click on Table. Then click on formulas. In the Formula box you add your formula:\n=SUM(above).\n\nCreate a table. Fill in each number you want to add in the same row, but different column Leave one column empty at the the far right. Go to the Toolbar and click on Table. Then click on formulas. In the Formula box you add your formula:\n=SUM(left).\n\nFor autotext features:\nAuto Correct Tab:  Fill in a word you want to replace in the box and then type the word you want to replace it with. I do this for words I tend to misspell. (I.e., wierd with weird)\nOn the auto text text you can fill in a phrase that you would like completed so you don't have to type it in. You could use your name. John A Doe. When you type John the rest of the name will appear and all you have to do is hit enter and the name is completed.
1135073
If you have a spreadsheet application like Microsoft Excel, then you can place all the items of the buget into the columns or rows of the spreadsheet.  How you have them organised is up to you.\n\nIf you want a sub total, for some items, but not others, etc, you could make a cell.  A cell is the name of the component where you type stuff in.  In this cell, you would want to write something like '=sum(B3:B4)' if you had some buget items in cells B3, and B4.\n\nExample:\n----------------------------------------------\n| - |          A          |          B           | \n| 1 | Mum             |                        |\n| 2 | Income         |                        |\n| 3 | Employment |   $10.00         |\n| 4 | Investments |    $20.00         |\n| 5 | Sub-Total     | =SUM(B3:B4) |\n\n'=SUM(B3:B4)' would be viewed as $30.00\n\nIf you want to make a total, it is the same as making a sub-total, except you would want to use more cells for the sum.\n\nFor more help on the 'sum' function, check the help included with Microsoft Excel under the topic 'sum' or 'function' or both :)
932140
Define and solve a problem by using Solver\nOn the Tools menu, click Solver. \nIf the Solver command is not on the Tools menu, you need to install the Solver add-in. \n\nHow? \n\nIn the Set Target Cell box, enter a cell reference or name for the target cell. The target cell must contain a formula.\n\n\nTo have the value of the target cell be as large as possible, click Max. \nTo have the value of the target cell be as small as possible, click Min. \n\nTo have the target cell be a certain value, click Value of, and then type the value in the box. \n\nIn the By Changing Cells box, enter a name or reference for each adjustable cell, separating nonadjacent references with commas. The adjustable cells must be related directly or indirectly to the target cell. You can specify up to 200 adjustable cells. \nTo have Solver automatically propose the adjustable cells based on the target cell, click Guess. \n\nIn the Subject to the Constraints box, enter any constraints you want to apply.\n\n\nClick Solve.\n\n\nTo keep the solution values on the worksheet, click Keep Solver Solution in the Solver Results dialog box. \nTo restore the original data, click Restore Original Values. \n\nTips \n\nYou can interrupt the solution process by pressing ESC. Microsoft Excel recalculates the worksheet with the last values found for the adjustable cells.
1038128
Yes there is a way to do this, but you'll have to split the master document up into about 4 spreadsheets.  There's only one good way of doing this if you don't want to spend years matching these together and that is with a macro.  The problem is that macros take a descent little bit of expertise to develop.  So it's time for me to give you a crash course in macros.  First you need to make sure that your security level in Excel for macros is set to Medium or Low.  From the menu bar, go to Tools, Macro, Security.  Reset it to Medium save the file, then restart Excel.  Excel needs to be restarted for the change to take effect.  Now on to creating macros.  Go to Tools, Macro, Record New Macro.  Pick a name for your macro then click OK.  Don't do anything whatsoever to the Excel workbook, just click the stop button.  This creates basically a blank macro named Macro1 or whatever you called it in your workbook.  Now we want to go edit that macro.  Go to Tools, Macro, Macros.  \n\nNow select your macro and click Edit.  Now past the following text in as macro code:\n\n'Set column A to your part number and column B to your lead time\nFor Each x In [Doc2! A:A]           'Looks through every cell in column A in a worksheet called Doc2\n    If x.FormulaR1C1 = "" Then      'Tells computer to end the search if it reaches\n        Exit For                    'a blank cell in column A of Doc2\n    End If\n    \n    For Each y In [Doc1! A:A]       'Looks through every cell in column A in a worksheet called Doc1\n        If y.FormulaR1C1 = "" Then  'Tells computer to go to the next part number in Doc2 if it reaches\n            Exit For                'a blank cell in column A of Doc1\n        End If\n        \n        If x.FormulaR1C1 = y.FormulaR1C1 Then           'Compares the part numbers to see if they match\n            x.Offset(0, 1).Value = y.Offset(0, 1).Value 'Sets column B in Doc2 equal to column B in Doc1 (your lead times)\n            Exit For                                    'Moves to next part number in Doc2\n        End If\n    Next y  'Moves to next part number in Doc1\nNext x      'Moves to next part number in Doc2\n\n\nEverything after an apostrophe is comments and will appear green.  This will have no affect on how the macro runs.  You will need to modify the macro or you worksheets so the macro works properly.  The code gets pasted between the Sub Macroname and End Sub portions.  The comments I listed should help you understand how the macro works.  Here's something REALLY IMPORTANT!!!  Save your workbook BEFORE you run the macro.  You can't undo what a macro does by hitting the undo button.  So if it doesn't do what you want, simply close the file without saving it.\n\nContact me, I probably need to explain a few more things too you.  Since your master list is over one spreadsheet long there are going to be some complications you'll have to work through that could make it very difficult, even for a macro.  \n\nMacros can save hours or days of time, but they can be difficult to a new user.  The Visual Basic 6 Blackbook by Coriolis is a good reference guide if you want to learn to write macros in Excel.  Just remember the coding may be a little different in Excel than for writing a program in VB6.
653602
Do you have Excel, if you do, then Excel can do that.  I think the formulas are self explanatory but if it isn't obvious to you, a Google search should turn up on how to do this in Excel.
1154342
Assuming you are using VB6 and your data is in Columns with headings on top you can do the following.\n\nPlace a Data component on your form. Its normally  the second last component in your tool box. Then place 4 text boxes on your form.\n\nclick on your Data component and change the properties as follows.\nConnect =>set to Excel 5.0 \nDataBaseName => (Brows to the excel file that has the data)\nRecordSet => Specify the page in excel eg. Sheet1\n\nNow click on each text box one at at time and change the values as follows.\nDataSource => Data1 or whatever you called your Data component\nDataField =>Select the heading for the column you want to view. Select a different one for each text box, X values and Y values\n\nNow Run your project \nBy clicking the forward and reverse buttons you can scroll through your data. Read the help menus to write the rest of your program.\n\nI hope this helps\nGood luck.
554626
Do you have word? If you do, then you can go to tools - envelopes and labels and choose the type of label you have. Then you need to click on "new document" this will put the lines where they are supposed to be. \n\nIf you don't have word, all I can say is to set up the cells in excel to be where the labels fall by trying it on blank pieces of paper. \n\nIt would be easier in Word though...
943819
There is new software out called Open Office and it works a lot like excel, I think they are interchangable. It is free and it has something like word too.\nhttp://www.openoffice.org/\nGive it a try and see what you think...
544272
File.. Get External Data.. Link Tables .. browse to the xls file    would set up a permanent link to the excel data and give the spreadsheet a kind of table name. Then it can be queried. You want to use several columns over time and you can use an 'Append query' to append data to a table; but experiment with a crosstab query. In that way, your Access table would always have 2 fields plus maybe a ColumnNumber field where you could have a default value of 1 the first week, 2 the next week, etc.. A crosstab query would present that data as several several columns (one for each ColumnNumber value). When your Access skills increase, you might be very glad that you used a small number of fields because it makes the querying of the data simpler to maintain, in my opinion.\nAs for VLOOKUP, you can research "query table joins" and see how a query in design view lets you choose the field which 2 tables have in common. One table is really the excel spreadsheet presented as if it is a table; the other table is the real access table.
999231
use the Macro Recorder to code the procedure you want...then you can convert it to VBA (Visual BASIC for Applications) and edit it.
778313
Hi this is directly from the help files of excel on linking two work books together:\n\nCreate a link to another cell, workbook, or program\n*********************************************************************\nCreate a link between cells in the same worksheet or workbook\n\nClick the cell that contains the data you want to link to, and then click Copy  on the Standard toolbar. \nClick the cell you want to link from, and then click Paste . \nClick Paste Options  and then click Link Cells. \n\n**********************************************************************\nCreate a link between cells in different workbooks\n\nOpen both the workbook that will contain the link (called the destination workbook), and the workbook that contains the data you want to link to (called the source workbook). \nIn the destination workbook, click Save . \nSelect a cell or cells you want to link from. \nIf you are creating a new formula, type = (an equal sign). \nIf you are entering the link elsewhere in the formula, type the operator or function that you want to precede the link. \n\nOn the Window menu, click the name of the source workbook, and then click the worksheet that contains the cells you want to link to. \n\nSelect the cells you want to link to. \nComplete the formula. When you finish entering the formula, press ENTER. \n\n**********************************************************************\n\nHope this helps