Words for Names of People

Words for Names of People Words for Names of People Words for Names of People By Mark Nichol Words that include the element nym, and some that include nom, pertain to names and naming. Such terms as anonymous (literally, â€Å"without a name†) and pseudonym (â€Å"false name†) are ubiquitous, but most others in this class are more or less obscure. This post lists and defines such terms that pertain to individuals and groups of people. An allonym (â€Å"other name†) is the name of one person employed as a pseudonym by one or more other people, as in the case of the name Publius, the non de plume of Alexander Hamilton, James Madison, and John Jay, which called back to Publius Valerius Publicola, a founder of the Roman Republic. (â€Å"Non de plume† itself, and â€Å"nom de guerre,† which mean, respectively, â€Å"pen name† and â€Å"war name,† are terms adopted from French that are synonyms of pseudonym.) An anthroponym (â€Å"man name†) is a proper name or a surname. (A gamonym is a name acquired as a result of marriage.) Aptronym is a recent coinage playing on apt, denoting a surname coincidentally appropriate to a person’s profession, such as when someone who makes beer is named Brewer. Autonym (self name)- or the synonym endonym, or â€Å"inner name†- refers to a term used by inhabitants of a place for that place (or themselves or their language), as in Deutsch, the German term for the German language; German is an exonym (â€Å"outer name†). (An ethnonym- people name- is a name for an ethnic group.) A charactonym is a fictitious character’s name that alludes to a quality of that person; literature is replete with such names, including those characterizing combative spouses in the early radio sitcom The Bickersons and the comic strip The Lockhorns. An eponym (â€Å"above name†) is a person, place, or thing after which someone or something is named. A mononym (â€Å"one name†) is a single name, such as Leonardo or Madonna. A patronym (â€Å"father name†), or patronymic, is a name based on a male ancestor’s given name, especially those with prefixes and suffixes integrated into surnames, such as Mac- or Mc- or Fitz- in Gaelic, -ez and -es in Spanish and Portuguese, and -son and variants such as -sen in Germanic languages. The female equivalents are matronym/matronymic; such forms are rare (at least in Indo-European languages), though -dottir is used in Icelandic surnames. Want to improve your English in five minutes a day? Get a subscription and start receiving our writing tips and exercises daily! Keep learning! Browse the Vocabulary category, check our popular posts, or choose a related post below:What Is Irony? (With Examples)How Long Should a Paragraph Be?Empathic or Empathetic?

What is the difference between imperialism and colonialims Essay

What is the difference between imperialism and colonialims - Essay Example These raw materials were then to be crafted into finished products that the colonies must then buy from the home nation. The focus of the home nation under colonialism is settlement and establishment of colonies in areas that provided economic advantages. All they expect from the colonies is a steady flow of raw goods and fixed export markets for those same finished goods. Imperialism is different in that the goal in establishing an empire is political as well as economic. The goal of imperialism is to make other nations or territories conform to an ideology that is supported at the imperial center. In colonialism, the interaction and focus of power is in the colonies. Imperialism involves the conquest of lands on the periphery of the empire, subjugating them to the ideology that emanates from the center of the empire. While colonialism and imperialism both have economic advantages for the home nation or center of power, imperialism gains this advantage through forced conformity to an ideology while colonialism creates this advantage through economic, not political

Sleep Essay Example | Topics and Well Written Essays - 750 words

Sleep - Essay Example There are some health effects of sleep which are very imperative to consider and comprehend. These include the fact that sleep is very directly linked with the overall health and quality of life of individuals under discussion. It is a well-known fact that restoration, growth and development come about when a person is sleeping in a deep manner. This goes to suggest how important deep sleep is to human beings. The resistance to viral infections is increased and the natural immunity within the human body becomes better. Since lack of sleep may mean breakdown in the human body’s health processes, researchers and medical practitioners are against this dictum adopted by a few people. When it comes to classification of sleep, there are two tangents which come under it. One is the sleep deprivation and the other – sleep debt. Sleep deprivation looks at the utter lack of time required for sufficient sleep. This is ideally a condition that would affect in impairing physical, em otional as well as cognitive working of the human body. On the other hand, sleep debt is essentially the variation in the time between the attained sleep and the sleep which is required to maintain alert wakefulness, most of which comes about during the day. Lack of proper sleep measures can lead to a number of disorders in the human body. These are linked up with some serious mental as well as physical health considerations. Some of these include the mental health disparities, obesity and overweight patterns in the human body, cardiovascular issues, immunological disorders, respiratory problems, endocrine concerns, metabolic diseases and a number of other ailments which keep on happening within the human body. The need is to comprehend how important sleep is and give it the priority that it richly deserves. It will solve quite a few issues during the daytime as well as keep the person alert. Some of the common sleep disorders include dyssomnias and parasomnias. Dyssomnia usually in cludes within its fore the insomnia, sleep paralysis, hypersomnia, sleep apnea, narcolepsy, restless legs syndrome and the Circadian Rhythm sleep disorder. Parasomnia takes into account the REM behavior disorder, the night eating syndrome, the nocturnal eating disorder, sleepwalking issue, sleep terror disorder, sexomnia and the nightmare disorder. There are gender differences also existent within sleep that need to be given significance. These differences come about when a child is merely 6 months old. It has been researched that women usually have more relaxed sleep when compared to men. Also it has been noticed that women take less sleep than men while the latter have more rapid eye movements during sleep. In the same footing, men usually experience a decline in slow wave sleep which happens earlier but takes place quicker than women. Hence men tend to sleep well as compared to women for a number of scientific reasons. In order to attain a good night’s sleep, it is importa nt to have a proper sleep schedule in place. It is usually a common phrase ‘early to bed, early to rise – makes you healthy, wealthy and wise’. One can learn quite a few things from this phrase as it sums up nearly all the concerns which sleep can address, not only in the present times but also in the future. A sleep friendly environment is the key to having a good night’s sleep because it usually tells the person that he is safe, sound

The development of a marketing plan Personal Statement

The development of a marketing plan - Personal Statement Example The business entrepreneur desires to launch a new business of interior decoration. The business segment of interior decoration is highly competitive in nature. The entrepreneur would not be able to successfully run its business without the help of an appropriate marketing plan. Tastes and preferences of the individuals change drastically, when it comes to interior decorations. Thus, the mogul would face high expenses in business innovation and manufacture process. Moreover, the discounts offered by the potential rivals (Wal-Mart, Home-Depot) in the market would create price pressures on the entrepreneur. The cost of inputs (catalogue resources like pottery barn) used in interior decorations are also increasing with time. So, if the entrepreneur aspires to run its new business successfully he must set up an appropriate marketing plan for the business (SBA, 2013). The entrepreneur would never be able to fruitfully market its business services if the goals and objectives of the marketing plan are not set at the beginning. The goals and objectives of the marketing plan for the interior designing business are:- The desired objectives of the business plan should be measurable in terms of target. The target of 15% growth in sales and 10% growth in profit should be achievable in reality. The target should be attained in a span of say 5 years from the date of inception of the business. It is considered that the above mentioned objectives for the marketing plan are not only specific but also achievable for the business (Westwood, 2005). The interior designing business should offer excellent services to the business clients. The designing should not only be a mark of class, but should also be superior in terms of quality. The company should maintain admirably designed retail outlets and should offer other complementary services that would impress the clients. The

The Advantages And Disadvantages Of Operating Systems Information Technology Essay

The Advantages And Disadvantages Of Operating Systems Information Technology Essay Level of involvement is one of the characteristic of honeypot and this level of involvement is used to measure the degree of interaction of the attacker with the operating system. Commonly a low-involvement honeypot will provide certain fake services [Spi01] and these services can only be implemented if somebody listen on a specific port. It is not possible to catch complex protocols communication with such a simple solution. An SMTP handshake will not give much useful information because an answering service is not listening. On a low-involvement honeypot there is no real operating system on which the attacker can operate and this will minimize the risk as there will be no complexity of the operating system. This is a disadvantage as it is not possible to watch an attacker interacting with the operating system. Role of this low-involvement honeypot is very passive as it is like a one-way connection in which we can only listen, but we do not ask questions ourselves. Figure 5.1: Low-involvement honeypot: A low-involvement honeypot does reduce risk to a minimum by minimizing interaction with the attacker Both low-level involvement honeypot and passive IDS are comparable as both the systems will not alter any traffic or interact with the attacker or the traffic flow. If the incoming packets match their patterns they are used to create logs and alerts. 5.1.2 Mid-involvement Honeypot A mid-involvement honeypot provides more interaction, but doesnt provide a real operating system. The fake daemons have deeper knowledge about the particular services they provide and are complicated. And risk will also increase. As the complexity of the honeypot increases the probability of the attacker to find the security hole or vulnerability is getting bigger. As there are no boundaries for the security and logging mechanisms built for this kind of events, a compromise of this system is still unlikely and certainly no goal. In the higher level of interaction, there is a possibility of more complex attacks and can be logged and analyzed. In general, the attacker has more possibilities to interact and probe the system and gets a better illusion of a real operating system. It is complex and time consuming for developing a mid-involvement honeypot and special care has to be taken for checking the security as all developed fake daemons must be as secure as possible. The developed versions must be very secure than their real counterparts, because this is the main reason to substitute these with fake variants. As each protocol and service must be understood in detail the knowledge for developing such a system must be very high. Figure 5.2: Mid-involvement honeypot: A mid-involvement honeypot does interact with the user in a minimal way 5.1.3 High-involvement Honeypot A high-involvement honeypot consists of an operating system and this leads to a much higher risk as the complexity increases and also at the same time, the possibility for gathering information, the possible attacks and the attractiveness increases a lot. One of the goal of the hacker is to gain root and to have the access to a shell,connected to the Internet 24/7. Such an environment is offered by high-involvement honeypot. As soon as a hacker gains the access, his real work and the interesting part begins. To get this level of freedom the attacker has to compromise the system, and then he will have the root rights on the system and can do everything at any instance on the compromised system. According to se, this system is not secure and even the whole machine cannot be considered as secure. This doesnot matter if he is in a sandbox, in a jail or a VMW box as there can be ways to get out of these software boundaries. Figure 5.3: High-involvement honeypot: A high-involvement honeypot has great risk as the attacker can compromise the system and use all its resources. This honeypot is very time consuming and the system should be kept under observation most of the time. If a honeypot is not under control then it is not of much help and it can become a danger or security hole itself. As the honeypot can be used by the blackhats as if its a real compromised system,it is very important to limit a honeypots access to the local intranet. As the danger once a system is fully compromised can b e reduced, limiting outbound traffic is also an important point to consider. If a full operating system is provided to the attacker, he can upload and install new files. As all actions can be recorded and analyzed, here a high-involvement honeypot can show its strength. One of the main goals of a high-involvement honeypot is to gather new information about the blackhat community and legitimates the higher risk. 5.1.4 Overview There are advantages and disadvantages of each level of involvement. Table 5.1: Overview of each level of Involvement advantages and disadvantages The danger is reduced as much as possible by choosing the lowest as possible risk honeypot. While choosing a honeypot and its level of involvement the required maintenance time must be considered. Honeynets are another possible honeypot architecture. 5.2 HONEYNETS NETWORK TOPOLOGIES Here the discussion is regarding the placement of honeypots in a network and a special, more complex version of honeypots which can also be called as honeynet. 5.2.1 Honeypot Location A honeypot does not require a specific environment to live as it is a standard server with no special needs. A honeypot can be placed anywhere a server is placed but some places are better for some approaches than others. Based on the service required, honeypot can be used on the internet as well as on the intranet. If the detection of some bad guys in a private network had wished it would be better to place a honeypot on the intranet which can be useful. Since this system can easily be compromised without immediate knowledge, it is important to set the internal thrust for a honeypot as low as possible. A honeypot can be placed at two locations with Internet as the main concern:  · In front of the firewall  · Behind the firewall (intranet) There are advantages and disadvantages of each approach. Because of the fact that placing a server in front of a firewall is simply not possible or not wished it is sometimes even impossible to choose freely. 5.2.1.1 In Front of the Firewall The risk for the internal network does not increase by placing the honeypot in front of a firewall. Behind the firewall the danger of having a compromised system is eliminated. This can be a problem if no additional firewalls are being used to shield some resources or if the IP is used for the purpose of authentication. A lot of unwished traffic like portscans or attack patterns will be attracted and generated by a honeypot and by placing a honeypot outside the firewall such events does not get logged by the firewall and an internal IDS system will not generate alerts. Or else, lot of alerts will be generated on the firewall or IDS. The biggest advantage of the firewall or IDS and any other resources, is that they need not be adjusted as the honeypot is outside the firewall and viewed as any other machine on the external network. Therefore if a honeypot is running it will not increase the risk of the internal network nor does it introduce new risks. If the honeypot is placed in front of the firewall then internal attackers cannot be located or trapped that easy, particularly if the firewall limits outbound traffic and therefore limits the traffic to the honeypot. 5.2.1.2 Behind the Firewall New security risks to the internal network can be introduced by a honeypot behind the firewall, in particular if the internal network is not secured against the honeypot through additional firewalls. A honeypot provides a lot of services; most of them are not used as exported services to the Internet and are blocked by the firewall. It is inevitable to adjust the firewall rules and also the IDS signatures by placing the honeypot behind the firewall, as it can be wished not to generate an alert every time the honeypot is attacked or scanned. If internal honeypot is compromised by an external attacker the biggest problem will arise. He can then access the internal network through the honeypot. This traffic will not be stopped by the firewall as it is regarded as traffic to the honeypot only, which in turn is granted. It is mandatory for securing an internal honeypot, in particular if it is a high-involvement honeypot. The main reason for placing a honeypot behind a firewall is to detect internal attackers. By making use of the internal honeypot it is possible to detect a mis-configured firewall. It is not possible to place a honeypot in front of a firewall sometimes because no external IPs are available nor access to the network in front of the firewall is possible. 5.2.2 Honeynets A honeypot is a single machine which is used for running multiple virtual operating systems. As the traffic goes directly on to the network it is not possible to control the outbound traffic. Preliminary firewall can be used to limit outbound traffic. Such a complex environment is honeynet. Multiple honeypots and a firewall (or firewalled-bridge) to limit and log network traffic is contained by a typical honeynet. To watch the potential attacks and decode and store network traffic on the preliminary system an IDS can be used. Figure 5.5: Different types of honeypot topologies: Simple honeypot, honeynet and a virtual honeynet If a firewall is placed in front of a honeypot (or multiple honeypots) the risk based on the honeypot can be reduced. Both the inbound as well as the outbound connections can be controlled; it is possible to control the network flow. As logging of network traffic can be done on one centralized location for all honeypots it is very easy. The data that is captured need not be placed on the honeypot itself and the risk of this data detection by an attacker is eliminated. More hardware is required by introducing new machines to the honeypot itself. Only one machine solution is thinkable. It is possible to set up multiple virtual systems on a physical machine by making use of Virtualization software. By this attempt, a firewall can also be placed on the same machine as all virtual honeypots but the security of this solution is not that good compared to different physical machines. If the honeynet is a virtual environment, the attacker could be able to break out of the virtual machine and the system could be compromised. As the attacker cannot see the bridge it is safe to place the bridge with firewall capabilities in front of a honeypot. As the bridge has no IP it is not possible to attack the bridge and therefore no attack point exists. There is complexity of the environment raised when additional hardware is introduced. In order to provide best security networking and associated tools must be understood.

Purchasing Drill Accessories :: Informative Essay

The use of drill accessories are increasing for commercial as well as domestic projects. The reason is that these cordless drill accessories can perform multiple tasks in a short time. Whether you are making a hole in a wall or mixing liquid for painting, it is essential to include drill accessories with other equipment. While purchasing for drill tools, you can get all essential drill parts in form of drill accessory set. This set is considered an essential item for wood and metal applications and also used for other construction tasks. Many experts are of the view that drill accessory works on the base of rotating technology and saves much time and labor cost. It works on the base of rotating terminology that can make a hole or cut the concrete walls. For the accomplishment of multiple tasks, drill bits prove helpful in the space mission and screw driving applications. Electric motor is fitted in this accessory that can make a hole in an object within a few seconds. While working with different applications, you can adjust the speed of the drill that fits to the needs of the task. However, Cordless drill accessories are preferred than others because of their ease of use and built in batter features. In the cordless drill accessories, you will find the battery that can be used in case of electricity supply shortage. The use of this amazing tool has facilitated the workers because they can now complete the task of drilling without much efforts and labor. When you are using drill accessories, you must adopt some essential security measures. It will save you from any type of serious injury. When you plan for cordless drill accessories shopping, you will find different types of drill tools in the market. Here, I am giving you an overvi ew of some functional drill accessories so that you can buy the right drilling driver for your task. Compact drill The purchase of a compact drill will prove cost effective for you because it can be used for drilling and screw driving application at the same time. It is available with integrated keyless chuck and some adjustment tools. In addition, industrial metal and gears are used in its manufacturing that increases its durability. It works similar to cordless drill accessories and easy to use for all drilling applications. Rotary mixer drill Rotary mixer drill is another latest tool that is designed for plastering, painting and concrete applications.

Shool Work

Excel Chapter 2 – Formulas, Functions, Formatting, and Web Queries MULTIPLE CHOICE 1. To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys. a. |ALT+ENTER|c. |SHIFT+ENTER| b. |CTRL+ENTER|d. |TAB+ENTER| ANS:APTS:1REF:EX 87 2. If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____. a. |1732|c. |1932| b. |1832|d. |2032| ANS:CPTS:1REF:EX 88 3. Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. . |recalculates new|c. |recalculates old| b. |recalculates some|d. |recalculates all| ANS:DPTS:1REF:EX 90 4. To save a previously saved workbook with a new name or on a different drive, ____. a. |click the Save button on the Quick Access Toolbar| b. |click Save As on the File menu| c. |press CTRL+S| d. |click Save on the File menu| ANS:APTS:1REF:EX 90 5. All of the following are valid Excel arithmetic operators except ____. a. |^|c. |%| b. |*|d. |>| ANS:DPTS:1REF:EX 92 6. When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. a. |40|c. |48| b. |26|d. |13| ANS:BPTS:1REF:EX 92 7. When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell. a. |Smart Tag Actions|c. |Trace Error| b. |AutoCorrect Options|d. |Auto Fill Options| ANS:CPTS:1REF:EX 96 8. The ____ button lists formatting options following an insertion of cells, row, or columns. a. |Paste Options|c. |Auto Fill Options| b. |Insert Options|d. |AutoCorrect Options| ANS:BPTS:1REF:EX 97 9. In Excel, functions can be entered using any of the following methods except the ____. . |Function command on the Tools menu|c. |Insert Function box in the formula bar| b. |keyboard or mouse|d. |AutoSum command on the Formulas tab| ANS:APTS:1REF:EX 98 10. How do you activate Range Finder to verify a formula in a cell? a. |Range Finder does not verify formulas|c. |Double-click in the cell| b. |Press the ESC key|d. |Click the Range Finder button| ANS:CPTS:1REF:EX 106 11. Us ing the ____ button on the Ribbon instructs Excel to display additional decimal places in a cell. a. |AutoFormat|c. |Increase Decimal| b. |Currency Style|d. |Percent Style| ANS:CPTS:1REF:EX 116 2. Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box. a. |Rule Format|c. |New Format| b. |New Rule|d. |Format Rule| ANS:BPTS:1REF:EX 119 13. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____. a. |8. 43 characters, or 64 pixels|c. |12. 75 points, or 17 pixels| b. |64 characters, or 8. 43 pixels|d. |17 points, or 12. 75 pixels| ANS:APTS:1REF:EX 122 14. ____ means that the width of the column will be increased or decreased so the widest entry will fit in the column. a. Auto column adjust|c. |Auto adjust| b. |Width fit|d. |Best fit| ANS:DPTS:1REF:EX 122 15. To instruct Excel to display a hidden column, position the mouse pointer to the ____. a. |left of the column heading boundary where th e hidden column is located and then drag to the right| b. |right of the column heading boundary where the hidden column is located and then drag to the left| c. |left of the column heading boundary where the hidden column is located and then drag to the left| d. |right of the column heading boundary where the hidden column is located and then drag to the right| ANS:DPTS:1REF:EX 122 16. If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column’s width. a. |Column Width|c. |Width Adjustment| b. |Adjust Width|d. |Increase Column| ANS:APTS:1REF:EX 123 17. As with column widths, when you decrease the row height to 0, the row is ____. a. |hidden| b. |visible temporarily at the top of the worksheet| c. |deleted| d. |visible temporarily on the left side of the worksheet| ANS:APTS:1REF:EX 126 18. To check the spelling of the text in a single cell, ____ to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon. a. |double-click the formula bar|c. |double-click the cell| b. |right-click the cell|d. |right-click the formula bar| ANS:CPTS:1REF:EX 129 19. If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____. a. |only the text in the selected cell| b. |the remainder of the worksheet, including notes and embedded charts| c. |the spelling of all sheets in the workbook| d. the remainder of the worksheet, not including notes and embedded charts| ANS:BPTS:1REF:EX 129 20. Which view allows you to create or modify a worksheet while viewing how it will look in printed format. a. |Print View|c. |Page Layout View| b. |Normal View|d. |Print Layout View| ANS:CPTS:1REF:EX 129 21. You can check formulas for errors by clicking the ____ button on the Formulas tab on the Ribbon. a. |Formul a Checker|c. |Formula| b. |Error Checking|d. |Error Validating| ANS:BPTS:1REF:EX 129 Figure 2-3 22. In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print the selected range. . |Selection option button|c. |Active sheet(s) option button| b. |Print to file check box|d. |Collate check box| ANS:APTS:1REF:EX 133 23. In the Print dialog shown in the accompanying figure, the ____ instructs Excel to print the worksheet currently on the screen or the selected worksheets. a. |Selection option button|c. |Active sheet(s) option button| b. |Print to file check box|d. |Collate check box| ANS:CPTS:1REF:EX 133 24. In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print all the worksheets with content in the workbook. a. |Entire workbook option button|c. Selection option button| b. |All option button|d. |Active sheet(s) option button| ANS:APTS:1REF:EX 133 25. In the accompanying figure, what will be printed when you click the O K button? a. |The entire workbook|c. |All pages in the worksheet| b. |The active workbook|d. |The active worksheet| ANS:DPTS:1REF:EX 133 26. Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used. a. |Print button in a dialog box|c. |Print button in the Preview window| b. |Print command on the File menu|d. |Print button on the Quick Access Toolbar| ANS:DPTS:1REF:EX 133 Figure 2-2 27. In the accompanying figure, the Page Setup button displays the ____ dialog box. a. |Print setup for the page|c. |Page Setup| b. |Setup|d. |Page| ANS:CPTS:1REF:EX 133 28. The ____ button, in the accompanying figure, allows you to view the page in larger or smaller sizes in the Preview window. a. |Next page|c. |Page Setup| b. |Zoom|d. |Preview| ANS:BPTS:1REF:EX 133 29. To toggle between the values version and the formulas version of a worksheet, hold down the ____ key. a. |ALT key while pressing the ACCENT MARK (`)| b. |ALT key while pressing the SINGLE QUOTATION MARK (‘)| c. |CTRL key while pressing the ACCENT MARK (`)| . |CTRL key while pressing the SINGLE QUOTATION MARK (‘)| ANS:CPTS:1REF:EX 135 30. The formulas version verifies that you entered formulas, rather than ____, in formula-based cells. a. |text|c. |functions| b. |numbers|d. |dollar signs| ANS:BPTS:1REF:EX 135 31. The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting va lues. a. |Actual symbol|c. |formulas version| b. |current version|d. |Formulas Print symbol| ANS:CPTS:1REF:EX 135 32. The process of finding and correcting errors in a worksheet is called ____. a. |searching and replacing|c. |verifying| b. |debugging|d. |validating| ANS:BPTS:1REF:EX 135 33. To import data stored on a Web site use a ____. a. |Web query|c. |Web import| b. |Web search|d. |Web copy| ANS:APTS:1REF:EX 137 34. Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another ____ in the workbook. a. |range|c. |cell| b. |dialog box|d. |worksheet| ANS:DPTS:1REF:EX 137 35. What name does Excel give the first blank worksheet? a. |Book1|c. |Worksheet1| b. |Workbook1|d. |Sheet1| ANS:DPTS:1REF:EX 140 36. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ____. . |click the Cancel box|c. |click the Name box| b. |press the ESC key|d. |press the ENTER key| ANS:DPTS:1REF:EX 141 Figure 2-5 37. In the accompanying figure, what is the first step in renaming the worksheet? a. |Copy the name from an existing worksheet. | b. |Double-click the worksheet tab. | c. |Type the new name next to the old one. | d. |Delete the firs t worksheet in the workbook. | ANS:BPTS:1REF:EX 141 38. In the accompanying figure, to move between worksheets, use the ____ to the left of the sheet tabs. a. |worksheet scrolling button|c. |tab scrolling buttons| b. |worksheet advancing button|d. sheet open-close button| ANS:CPTS:1REF:EX 141 39. Longer worksheet names also can mean that ____ sheet tabs will show. a. |fewer|c. |more| b. |all|d. |no more| ANS:APTS:1REF:EX 141 40. E-mailing a workbook from Excel sends the workbook as a(n) ____ in the e-mail. a. |picture|c. |box| b. |attachment|d. |table | ANS:BPTS:1REF:EX 143 MULTIPLE RESPONSE Modified Multiple Choice 1. Which of the following are considered guidelines to use when making decisions about creating a new workbook? a. |Determine the necessary formulas and functions needed| b. |Identify how to format various elements of the worksheet| c. Specify how the printed worksheet should appear| d. |Enter data into the worksheets and format the cells| ANS:A, B, CPTS:1REF:EX 85 2. Us ing arithmetic operation, the formula, =d4*e4, is the same as which formulas? a. |D4 * E4|c. |=D4 * E4| b. |d4 * e4|d. |=d4 * e4| ANS:C, DPTS:1REF:EX 92 3. You can apply conditional formatting to ____. a. |a cell|c. |a range of cells| b. |the entire worksheet|d. |the entire workbook| ANS:A, B, C, DPTS:1REF:EX 118 4. Which buttons in the Spelling dialog box will not change the spelling of the word? a. |AutoCorrect|c. |Ignore Once| b. |Undo Last|d. |Ignore All| ANS:C, DPTS:1REF:EX 128 . Which statements are true about the Excel spell checker? a. |It can check notes and embedded charts. | b. |It can check all sheets in a workbook. | c. |It can check in one language and offer suggestions in another language. | d. |When it reaches the end of the worksheet, it will ask if you want to continue checking at the beginning. | ANS:A, B, DPTS:1REF:EX 129 TRUE/FALSE 1. The arithmetic operator, ^, directs Excel to perform the division operation. ANS:FPTS:1REF:EX 92 2. Cell references in formulas m ust be entered in uppercase, and spaces cannot be added before or after arithmetic operators. ANS:FPTS:1REF:EX 92 . Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard. ANS:FPTS:1REF:EX 94 4. When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values. ANS:TPTS:1REF:EX 96 5. A smart tag indicator is a block plus sign located in the center of the cell. ANS:FPTS:1REF:EX 96 6. The AVERAGE function requires that the argument (the range) be included within parentheses before the function name. ANS:FPTS:1REF:EX 98 7. When Point mode is used to enter a formula or function, the arrow keys can be used to complete the entry. ANS:FPTS:1REF:EX 100 8. Excel has more than 400 functions. ANS:TPTS:1REF:EX 104 9. One of the least common mistakes made with Excel is to include the wrong cell reference in a formula. ANS:FPTS:1REF:EX 106 10. To use Range Finder to verify that a formula contains the intended cell references, right-click the cell with the formula to be checked. ANS:FPTS:1REF:EX 106 11. Excel does not allow the contents of a cell to be aligned vertically. ANS:FPTS:1REF:EX 114 12. The Comma Style button is located on the Ribbon. ANS:TPTS:1REF:EX 115 13. When using conditional formatting, if the condition is true, then Excel applies the formatting. ANS:TPTS:1REF:EX 118 14. With conditional formatting, if the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting. ANS:TPTS:1REF:EX 121 15. A character is a dot on the screen that contains a color. ANS:FPTS:1REF:EX 122 16. A pixel is defined as a letter, number, symbol, or punctuation mark in 10-point Arial font, the default font used by Excel. ANS:FPTS:1REF:EX 122 17. The default row height in a blank worksheet is 12. 75 points (or 17 pixels). ANS:FPTS:1REF:EX 122 18. To skip correcting a word identified by the spell checker, click the Ignore Once button in the Spelling dialog box. ANS:TPTS:1REF:EX 128 19. If a cell other than cell A1 is selected before starting the spell checker, Excel will display a dialog box when the spell checker reaches the end of the worksheet, asking if the spell checker should continue checking at the beginning. ANS:TPTS:1REF:EX 129 20. You can preview a worksheet using the Print Preview button on the menu bar. ANS:FPTS:1REF:EX 133 21. To import external data from a World Wide Web site, it is necessary to have access to the Internet. ANS:TPTS:1REF:EX 137 Figure 2-1 22. In the accompanying figure, the two middle scroll buttons to the left of the sheet tabs move to the first or last worksheet in the workbook. ANS:FPTS:1REF:EX 141 23. In the accompanying figure, the leftmost and rightmost scroll buttons to the left of the sheet tabs move one worksheet to the left or right. ANS:FPTS:1REF:EX 141 24. The tabs at the bottom of the worksheet window, in the accompanying figure, allow any of the worksheets in the workbook to be viewed. ANS:TPTS:1REF:EX 141 25. When a workbook is sent as an attachment to an e-mail, the recipient can double-click the attachment to open it in Excel, or save it on disk and then open it at a later time. ANS:TPTS:1REF:EX 143 COMPLETION 1. The ____________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text. ANS:equal sign PTS:1REF:EX 91 2. Excel places a small purple triangle, called a(n) ____________________, in a cell to indicate that a smart tag is available. ANS:smart tag indicator PTS:1REF:EX 96 3. A blank cell in Excel has a numerical value of ____________________. ANS: zero 0 PTS:1REF:EX 98 . The values used with a function are called ____________________. ANS:arguments PTS:1REF:EX 98 5. The ____________________ function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range. ANS:AVERAGE function PTS:1REF:EX 99 6. The ____________________ function displays the highest value in a ran ge. ANS:MAX PTS:1REF:EX 101 7. The ____________________ function determines the lowest value in a range. ANS:MIN PTS:1REF:EX 102 8. The ____________________ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. ANS:Comma Style format PTS:1REF:EX 114 9. A(n) ____________________ is a dollar sign that appears immediately to the left of the first digit in a cell with no spaces. ANS:floating dollar sign PTS:1REF:EX 117 10. Formatting that appears only when the value in a cell meets specified conditions is called ____________________. ANS:conditional formatting PTS:1REF:EX 118 11. A(n) ____________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel. ANS:character PTS:1REF:EX 122 12. A(n) ____________________ is a dot on the screen that contains a color. ANS:pixel PTS:1REF:EX 122 13. ____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column. ANS:Best fit PTS:1REF:EX 122 14. ____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see. ANS:Hiding cells PTS:1REF:EX 122 Figure 2-4 15. To correct a word throughout a worksheet, click the ____________________ in the Spelling dialog box shown in the accompanying figure. ANS:Change All button PTS:1REF:EX 127 16. To append words to the dictionary, click the ____________________ in the Spelling dialog box shown in the accompanying figure when Excel identifies the word as not in the dictionary. ANS:Add to Dictionary button PTS:1REF:EX 127 17. Click the ____________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change. ANS:AutoCorrect button PTS:1REF:EX 127 18. The ____________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas. ANS:values version PTS:1REF:EX 135 19. The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values. ANS:formulas version PTS:1REF:EX 135 20. ____________________ is the process of finding and correcting errors in a worksheet. ANS:Debugging PTS:1REF:EX 135 MODIFIED TRUE/FALSE 1. The TOTAL function sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. ANS:F, AVERAGE PTS:1REF:EX 99TOP:Critical Thinking 2. The HIGHVALUE function displays the highest value in a range. ANS:F, MAX PTS:1REF:EX 101TOP:Critical Thinking 3. The AVERAGE function displays the lowest value in a range. ANS:F, MIN PTS:1REF:EX 102TOP:Critical Thinking 4. A theme is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook. . ANS:TPTS:1REF:EX 107 TOP:Critical Thinking 5. A fixed dollar sign appears to the far left in the cell, often with spaces between it and the first digit; whereas a moving dollar sign appears immediately to the left of the first digit with no spaces. . ANS:F, floating PTS:1REF:EX 114TOP:Critical Thinking MATCHING Identify the letter of the choice that best matches the phrase or definition. a. |Web query|f. |smart tag| b. |order of operations|g. |function| c. |arguments|h. |pixel| d. |theme|i. |debugging| e. |condition|j. |spell checker| 1. Identifies certain actions to take on specific data in workbooks. 2. Used for importing into Excel data that is stored on a Web site. 3. Takes a value or values, performs an operation, and returns a result to the cell. 4. When more than one arithmetic operator is involved in a formula, Excel follows an order from left to right in a formula calculation. 5. A predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook. 6. A dot on the screen that contains a color and its size is based on the screen’s resolution. 7. If true, then Excel applies the formatting. If false, then Excel suppresses the formatting. 8. Compares words on the worksheet to words contained in its standard dictionary. 9. Values that are used with a function. 10. Finding and correcting errors in the worksheet. 1. ANS:FPTS:1REF:EX 96 2. ANS:APTS:1REF:EX 137 3. ANS:GPTS:1REF:EX 98 4. ANS:BPTS:1REF:EX 92 5. ANS:DPTS:1REF:EX 107 6. ANS:HPTS:1REF:EX 122 7. ANS:EPTS:1REF:EX 118 8. ANS:JPTS:1REF:EX 127 9. ANS:CPTS:1REF:EX 98 10. ANS:IPTS:1REF:EX 135 ESSAY 1. Excel’s strength lies in its handling of numbers and the presentation of them. Discuss some of the considerations to keep in mind when formatting numbers. In the discussion, include the terms fixed dollar sign, floating dollar sign, currency, and percent. ANS: Excel displays numbers using the Accounting Number Format with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place). Clicking the Accounting Number Format button on the Ribbon assigns the desired accounting number format. When you use the Accounting Number Format button to assign the accounting number format, Excel displays a fixed dollar sign to the far left in the cell, often with spaces between it and the first digit. The Accounting Number Format button assigns a fixed dollar sign to the numbers. To assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cells dialog box. The Comma Style format is used to instruct Excel to display numbers with commas and no dollar signs. The Comma Style format, which can be assigned to a range of cells by clicking the Comma Style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. You can choose from 12 categories of formats. Once you select a category, you can select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. Selecting the appropriate negative numbers format is important, because doing so adds a space to the right of the number in order to align the numbers in the worksheet on the decimal points. Some of the available negative number formats do not align the numbers in the worksheet on the decimal points. The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. PTS:1TOP:Critical Thinking 2. Discuss how to use conditional formatting, which is the feature of applying conditional operators to a cell, range, worksheet, or workbook. ANS: Excel allows an applied formatting to appear only when the value in a cell meets conditions specified by the user. This type of formatting is called conditional formatting. Any format can be conditionally assigned to a cell, a range of cells, a worksheet, or an entire workbook. If the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting. Usually, conditional formatting is applied to a range of cells that contains values to highlight, if conditions warrant. For example, instructing Excel to change the color of the background of a cell if the value in the cell meets a condition, such as being less than 0. A condition, which is made up of two values and a relational operator, is true or false for each cell in the range. If the condition is true, then Excel applies the formatting. If the condition is false, then Excel suppresses the formatting. What makes conditional formatting so powerful is that the cell’s appearance can change as you enter new values in the worksheet. Conditional formatting (relational) operators include cell values that are: between or not between two numbers; equal to or not equal to a number; greater than or less than a number; greater than or equal to a number; and less than or equal to a number. PTS:1TOP:Critical Thinking 3. Discuss the relationship of debugging and displaying or printing the formulas version of a worksheet. Also describe the difference between the formulas version and the values version. ANS: The values version of the worksheet shows the results of the formulas entered, rather than the actual formulas. Excel also can display and print the formulas version of the worksheet, which shows the actual formulas entered, rather than the resulting values. Toggling between the values version and formulas version is possible by holding down the CTRL key while ressing the ACCENT MARK (`) key. The formulas version is useful for debugging a worksheet. Debugging is the process of finding and correcting errors in the worksheet. Viewing and printing the formulas version instead of the values version makes it easier to see any mistakes in the formulas. When changing from the values version to the formulas version, Excel increases the width of the columns so the formulas and text do not overflow to adjacent cells on the right. The formulas version of the worksheet usually is significantly wider than the values version. To fit the wide printout on one page, set the orientation to landscape, and the Fit to option in the Page sheet in the Page Setup dialog box. PTS:1TOP:Critical Thinking CASE Critical Thinking Questions Case 1 Leo, owner of Leo’s Bread Company, has recently acquired Excel 2007. He would like to set up a workbook to track sales of different types of breads to determine which types are the most popular among customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo uses the Accounting Number Format with the sales numbers he enters into the cells. . After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by white spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the number. To format the location of the dollar sign, which category on the Number tab in the Format Cells dialog box would he select? a. |General|c. |Currency| b. |Number|d. |Accounting| ANS: C PTS:1REF:EX 114 | 116TOP:Critical Thinking 2. The worksheets still have the default names assigned to them automatically by Excel. How would Leo rename the worksheets to Rye Bread, Onion Rolls, and Bagels? a. |In cell A1, press ALT+ENTER keys and type the new name. |c. |Select cell A1 of the worksheet and type the new name. | b. |Double-click the worksheet tab, type the new name, and press the ENTER key. |d. |Click the top center cell on the worksheet and type the new name. | ANS: B PTS:1REF:EX 141TOP:Critical Thinking Critical Thinking Questions Case 2 Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year affects performance numbers. On a single worksheet, she labels the columns B through E as follows: (B) Start Time, (C) End Time, (D) Total Time, (E) Distance. The rows are labeled: (2) Date, (3)Maximum, (4) Average, (5) Minimum. 3. After three months, Anna wants to know the longest total time she has run, as listed in the Total Time column. By looking at the values in the column, she finds the longest total time to be 54 minutes. Instead of manually entering that value in cell D3 (Maximum Total Time), Anna decides to use the MAX function to determine the value rather than manually entering the 54 minutes. Why did Anna prefer to use the MAX function? a. |She believes that 54 minutes is her best running time. |c. |She believes that 54 minutes is not her best running time. | b. |The MAX function recalculates the highest value each time a new value is entered into the worksheet. |d. |The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet. | ANS: B PTS:1REF:EX 102TOP:Critical Thinking 4. When she sets up the worksheet, Anna wants to the know the average distance she runs. What should she do in cell E4 to determine the average distance? a. |Enter the text =av and then select the AVERAGE function from the AutoComplete list; then enter the cell range. |c. |Enter the text =function and then select the AVERAGE function from the AutoFunction list; then enter the cell range. | b. |Enter the text E2:E9 and then enter the cell range. |d. |Enter the text E2:E9/9 and then enter the cell range. | ANS: A PTS:1REF:EX 99TOP:Critical Thinking