...every student to input his roll number and scan his finger for attendance, you need to have a combination of: (a) Keypad, Mouse, OCR Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array, col_index_num, [range_lookup]) (b) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) (c) VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) (d) VLOOKUP(row_value, table_array, col_index_num, [range_lookup]) The maximum number of IF functions that can be nested as value_if_true and value_if_false arguments is: (a) 4 (b) 16 (c) 32 (d) 64 In an MS Excel worksheet...
Words: 2503 - Pages: 11
...every student to input his roll number and scan his finger for attendance, you need to have a combination of: (a) Keypad, Mouse, OCR Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array, col_index_num, [range_lookup]) (b) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) (c) VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) (d) VLOOKUP(row_value, table_array, col_index_num, [range_lookup]) The maximum number of IF functions that can be nested as value_if_true and value_if_false arguments is: (a) 4 (b) 16 (c) 32 (d) 64 In an MS Excel worksheet...
Words: 2503 - Pages: 11
...Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner 4. Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip 5. In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk 6. Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array, col_index_num, [range_lookup]) (b) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) (c) VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) (d) VLOOKUP(row_value, table_array, col_index_num, [range_lookup]) 7. The maximum number of IF functions that can be nested as value_if_true and value_if_false arguments is: (a) 4 (b) 16 (c) 32 (d) 64 8. In an MS Excel...
Words: 2510 - Pages: 11
...ACE2006 Agricultural Economics Guidelines for poster assessment You must decide on a research hypothesis and then extract the data you need to test that hypothesis from the Farm Business Service (FBS) dataset. This dataset contains a large number of variables, including measurements of farm income, farm size, total costs, fixed and variable costs, total revenue, revenue from farming, subsidies, farm diversification and agri-environment payments. It also contains details of farm location, enterprise revenue and variable costs (and gross margins), farm type. It is up to you to decide what data you need to test your research hypothesis. For example, you might wish to examine the economies/diseconomies of scale theory, or you may wish to show how farm business income varies with region and within region by farm type (or size). You may wish to determine which farm types earn what % of total revenue from agri-environment payments or from diversification payments. You could examine the labour used on different farms, and correlate this with a measure of farm income. There are endless possibilities. You are asked to decide on a research hypothesis yourself and to work alone this is individual work so DO NOT work in groups. The poster that you will present your research hypothesis and data analysis is described below, this exercise is assessed and is worth 20% of the module mark. This document contains guidelines for extracting data, and the pro-forma which you...
Words: 6430 - Pages: 26
...1) What is storage media? Write the names of a few commonly used storage media. 2) How will you use AutoFormat feature of MS Excel. 3) Define hyper linking. Write the steps of it. 4) Mention any two feature of good word document. 5) Define custom Path with an example. 6) Discuss the use of Max () function? Give the Syntax and explain with the help of suitable example. 7) Write the steps required to perform a mail merge. Explain with the help of an example. 8) Answer the following questions 9) Distinguish between Array sum and Auto sum. 10) List any three features of Web browser. 11) Mention any three formatting features of Ms Word. 12) Name the major types of customs animation. How to apply it on a text present in a slide. 13) How will you change the case of characters from lowercase to uppercase in Msword? 14) Differentiate between Web page and Website. 15) How will you use AutoSum feature of MS Excel. 16) What are the uses of Header and Footer in MS Word? 17) Mention any two uses of bullets and numbering? 18) Define custom Path with an example. 19) Discuss the use of Min () function? Give the Syntax and explain with the help of suitable example. 20) List all the steps required to perform a mail merge. Explain with the help of an example. 21) Answer the following questions from the given table below: | A | B | C | D | E | F | G | 1 | Sl.no | Name | English | Math | Computers | Total |...
Words: 1466 - Pages: 6
...1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Many tools of MS Excel are available to analyze statistical data beyond the basic statistical analysis. Such tools include regression analysis, simulations, control charts, summaries, and forecasting. Other important data that can be obtained using the expanded MS Excel financial functions is performance level calculations, principle payment calculation, depreciation of an asset, interest payment on investment, present value of investment, calculation of interest rate over time, annual duration of the security, current and future rates of investment, and amortization. The logical functions help calculation based on the requirements such as if, or, and, true and false. MS Excel also has an integration that allows to import information stored in COM applications. MS Excel also has a series of arithmetic and geometric functions. Additionally, MS Excel has a number of functions for engineering applications such as Bessel functions, binary and hexadecimal. Other functions include correlation, covariance, sum of squares, exponential means, permutations, quartiles, Student’s t-distribution, z test , and others. The manager can effectively utilize these tools in interpretation of data sets and creating queries without using MS Access. The manager can effectively calculate all the needed statistics without having to go through extensive calculations. By using Data...
Words: 510 - Pages: 3
...MS Project Familiarization Ida Casey Dr. Kimberly Malone-Haddox BUS 375: Project Management October 18th, 2015 At first, I thought the MS Project is very difficult from a user standpoint. I felt that using the MS Project is very time consuming. As I was trying to navigate them the system, I found that I was focusing more on the actual system them inputting information. Considering that I do have a lot of experience with man of the MS office programs, I thought this program would be similar to that. I feel that if I had more tutorials where I am taught then have a quiz or even a step-by-step guide then I would feel more comfortable using it. Overall, it is a great program, but it still think that I would be able to use MS Excel to perform these tasks in MS Excel instead of MS Project. I do feel that with a little more that MS Projects is very easy and simple to use. You just have to get used to the program and take your time. I’m actually very excited about using the program now because this would help me gain some experience on implementing practice and assessments so I would be more confidence using it. But after doing a little research, I did find its purpose and why it was created for the business professional world. Two challenges that I foresee using MS Project in this course would be doing the projects accurate and actually navigating through it. When it comes to navigating through the program, it is difficult due to the extra steps when in the other MS office programs...
Words: 442 - Pages: 2
...Microsoft Office Program: Helpful to Student’s Studies I. INTRODUCTION In this fast reaching world, the studies of every individual become more complicated. We have now going beyond the imagination of each human being and applying this through technology. Merely fact, technology is a very big help in the lives of each learners specifically to the highschool students here in Gonzalo Aler National High School. The school adapted technology as one of the most important tools in learning and computer is one of the best examples. Computer is one of the best systematic knowledge that can be used. Using this product of technology, learners challenged to be maximized in their learning by being more creative and become more interested in studying. Today, computer does not just help to the student but it is an essential one to give courage and help improves the skills of individual. With the ever increasing population of computer technology, it is almost impossible to find an educational establishment that does not use it. Computers are becoming a more and more important within education as both a learning tool for students and for keeping records of all individuals at the school. Computers allow students to access more information more easily and the introduction of the internet means that this information is available to hand 24/7. Whether this is a good prospect or not is something that is debated frequently. For every factual and accurate piece of information that can...
Words: 3073 - Pages: 13
...Unit 4 discussion Board By: Karen Horne 9 June 24, 2011 The tools that can be of use to Ms Excel for helping to interpret data is that it can be used for forecasting, control charts, summary charts and also regression analysis and the last would be the simulations. However when it comes to Ms Excel it will provide the necessary tools so the person (s) will be able to manage their projects. Ms Excel will help the manager keep track of all the important records and inventories and this can be done on different types of spreadsheets and charts. There are plenty of things that I never knew about the Ms Excel for one I never really used any of them until I started school I like the help button that will walk you step by step through the process. When it comes to MS Excel this is a very impeccable tool to use there are so many different spreadsheets that can not only help a manager inquire about procedures that would benefit from, this will help student s also to develop new ways of doing their math problems. I have learned that the functions that can be used will help to calculate all of your problems within the cells. However when it comes to the management side the data management tool is where the manager can be able to manage their records.the Excel 2010 has a feature that has “slicers” this will help to filter data and also to be able to view...
Words: 257 - Pages: 2
...Assignment 1: MS Project Familiarization Deedra Grace Strayer University BUS375 – Project Management Dr. LaShawn Johnson April 20, 2016 MS Project Familiarization MS Project easy or difficult? I’d say just from viewing all the training videos, and a few extra videos I searched on YouTube, that it will be easy to use. I believe if I weren't already familiar with other Microsoft software, Microsoft Excel especially, I’d most likely be overwhelmed. I’m sure any new software may be difficult at first, but MS Project seems to be easy to grasp. Two challenges I foresee in using MS Project would be; remembering all the features, and what does what. Compared to other Microsoft software, MS Project has too many features. In my opinion less is more. Although, I’ve used different types of other software before and felt “this is too much to learn and master”, but after some time on the software there didn’t seem to be enough features. The biggest problem I'll have in regards to MS Project is no patience, and wanting to get it, right away. Secondly, after having waterfall versus agile methods explained in class, and looking more in-depth to MS Project, and reading that this software doesn't lend itself to an agile type of model. I could easily use Excel for tracking simple tasks, but you don't get the flexibility of using MS Project. I foresee that being a problem because it’s stated: “agile development is taking more of a front seat now”. Not only would it be an issue for...
Words: 515 - Pages: 3
...applications were used in a business or home environment. Read more: Importance of the MS Office Suite | eHow.com http://www.ehow.com/about_6117563_importance-ms-office-suite.html#ixzz2KEFPdTt9 Suite Features * The basic MS Office suite package has the following applications: MS Word (Word Processing), MS Excel (Spreadsheet and Accounting), MS PowerPoint (Presentations), MS Access (Database Creation and Management and MS Front Page (Web Development). These applications are marketed for home use, professional use (small business) and enterprise use (for workgroups larger than 15 people). Microsoft's strategy, which is an important aspect of using these integrated suite packages, was to make the basic menu systems look the same so users can be comfortable when using different applications. Familiarity with the menu systems gained more users. Integrated Concept * An important factor of MS Office Suite is the integration of software applications in the suite package, but yet allows each software program to keep its own identity. For example, Mail Merge can be performed with MS Word, but it captures information from the mail file in Microsoft Outlook to create a mail out or bin label sheet. You can take a spreadsheet a place it into MS Word or integrate an Excel chart inside a PowerPoint slide. Workgroup Management * Sometimes, six or eight people must work on a project at the same time. MS Office Suite package...
Words: 612 - Pages: 3
...E&C PROPOSAL Converting data currently held in Microsoft® Excel® spreadsheets into a rational database using Microsoft® Access® can be useful in creating reports. These reports can be run at any time by users. “With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information” (Microsoft Office Access benefits). Access can be used by multiple users working on the data at the same time; even several users can work on the same data at the same time. Access locks in a record only while the user changes it; when users use Excel workbook it can be shared, but users should change data in Excel at separate times for the process to work best. “If you need to connect to several data sources and edit the data directly in those sources, then Access is your choice. You can view external data with Excel, but you can't change that data” (Office Microsoft). Wireless to IT uses The benefits of using Microsoft Access in the work place for the company would be one of the easier ways to create contacts, assets tracking, issue tracking, project tracking. With the program it would keep up with current customers, and their previous order. The company with and using this program can also share or forecast their...
Words: 813 - Pages: 4
...UNIT BRIEF Edexcel HND (Computing) Level 5 COMPUTER PLATFORMS 2011 EThames Graduate School. India 8-2-228 to 231 Punjagutta Cross Road Hyderabad 500082 Tel: +91 40 44432223 This handbook belongs to the following student; if found please hand in to Reception: NAME: ___________________________________________ Student ID: ________________________________________ |Unit Name: |Introduction to Computers | |Unit Number: | | |Course Duration: |09 Sessions | |Batch: |March, 2011 | |Tutor: |B Jagadish Chandra Reddy | A warm welcome to all the students enrolled for this unit. The unit handbook will give you a clear understanding of the aim and learning objectives of the unit. It will also portray the unit planning in terms of coverage, prerequisites for each session, tools and techniques used by the tutor and the level of efforts expected to be put by a student. It will make you aware of the assessment policy, assignment...
Words: 474 - Pages: 2
...Informação. Data Warehouse, SQL Server Business Intelligence Development Studio. Conceitos de CRM e Data Mining. Tabelas Dinâmicas no MS Excel. 417 slides. Sistemas de Informação Ricardo Campos (ricardo.campos@ipt.pt) © Ricardo Campos [ h t t p : / / w w w . c c c . i p t . p t / ~ r i c a r d o ] Sistemas de Informação Autoria Esta apresentação foi desenvolvida por Ricardo Campos, docente do Instituto Politécnico de Tomar. Encontra-se disponível na página web do autor no link Publications ao abrigo da seguinte licença: Mais detalhes em: http://creativecommons.org/licenses/by-nc/3.0/deed.pt O seu uso, de parte ou da totalidade, pressupõe a utilização da seguinte referência: Campos, Ricardo. (2008). Apresentação de Sistemas de Informação. Data Warehouse, SQL Server Business Intelligence Development Studio. Conceitos de CRM e Data Mining. Tabelas Dinâmicas no MS Excel. 417 slides. A sua disponibilização em formato PPT pode ser feita mediante solicitação (email: ricardo.campos@ipt.pt) © Ricardo Campos [ h t t p : / / w w w . c c c . i p t . p t / ~ r i c a r d o ] Sistemas de Informação Ricardo Campos [http://www.ccc.ipt.pt/~ricardo/] 1 Campos, Ricardo. (2008). Apresentação de Sistemas de Informação. Data Warehouse, SQL Server Business Intelligence Development Studio. Conceitos de CRM e Data Mining. Tabelas Dinâmicas no MS Excel. 417 slides. Bibliografia Recursos: Ralph Kimball, Laura Reeves, Margy Ross, Warren Thornthwaite The Data Warehouse Lifecycle...
Words: 35397 - Pages: 142
...Symbiosis Institute of Business Management, Pune MS Excel 2010 Preinduction Courseware Contents Introduction to Microsoft Excel 2010 ......................................................................................... 2 What is new in Excel 2010 ..................................................................................................... 2 Getting started with Excel 2010 .................................................................................................. 4 Excel worksheet movement keys ............................................................................................ 4 Entering and editing data in Excel worksheet............................................................................. 5 Using AutoFill to enter a series of values ............................................................................... 5 Creating Custom Lists............................................................................................................. 6 Adding comments in the cell .................................................................................................. 6 Editing data in Excel worksheet ............................................................................................. 8 Using Paste Special ................................................................................................................. 8 Formatting data in the worksheet ...........................................................................
Words: 3348 - Pages: 14
