Premium Essay

Excel Chapter Questions

In: Computers and Technology

Submitted By bfss218
Words 986
Pages 4
Excel Textbook Questions
Chapter 5: Using a Spreadsheet (pages 185-224) 1) List three example uses for a spreadsheet. 2) a) What is an Excel file called? b) How many worksheets does a new workbook contain? 3) a) How are individual columns identified on a worksheet? b) How are individual rows identified on a worksheet? c) What is a cell? d) Give an example of cell reference. e) What does the name box display? f) What does the formula bar display? 4) When does a cell display ####? 5) a) Explain what a formula is and give two examples. b) If 10/20 is entered into a cell, Excel considers it a label. How must the entry be changed so that 10 will be divided by 20? c) How can a cell be formatted so that =10/20 will appear in the cell? 6) a) Which specific order of operations does Excel use to evaluate a mathematical expression/equation? 7) What is circular reference? 8) a) What is a relative cell reference? b) What are the contents of cells D22 and E22 after copying cell C22, which stores the formula =C5+C6, into cells D22 and E22? 9) Determine if the following is true or false. If False explain why. a) A cell reference consists of a column letter only. b) Selected cell and active cell mean the same thing. c) The contents of the active cell are displayed in the name box. d) There are over a million rows on a worksheet. e) The width of just a single cell can be changed/adjusted. f) A cell can contain only one line of text. g) The Accounting and Currency formats are the same. h) A range can consist of non-adjacent cells.

CHAPTER 6: Functions and Data Organization (page 243 -273) 1. What is a function? 2. Write the function to complete the following tasks:
a. the sum of the values stored in cells B4, B5, B6, B7.
b. the sum of the values stored in cells B4, C4, D4, E4.…...

Similar Documents

Premium Essay

Excel and Access for Accounting Chapter 2

...Excel Chapter 2 1. Entering data into an excel worksheet is very simple. The user just has to click on the desired cell where information is to be entered, and then type what they want in the box. Whatever the user types, whether it be labels such as text entries or values such as numbers and formulas, will be automatically entered into the formula bar as well. 2. Labels and values both refer to data entered into cells in an Excel worksheet. However, they differ in that labels are texts entries whereas values are number or formula entries. 3. A series of # signs means that the number entered into the cell was wider than the column permitted. This can be resolved by resizing the column with to show the entire number and removing the # signs. 4. Changing column width or row height is a very easy task in Excel. The user can place the mouse pointer between the gray area of the columns containing letter headings, click, and drag the column left or right to expand or reduce its size. The same can be done for rows, but the user must drag up or down to resize the row height. Another neat feature is that if the user double clicks in the gray area between letters, the column size will automatically adjust to fit the largest data entry. Furthermore, the user can automatically adjust all the rows and columns of a worksheet by clicking on the arrow in the gray box in the upper left corner and then double clicking the gray at the top between any column or row. 5. The appearance of......

Words: 940 - Pages: 4

Premium Essay

End Pf Chapter Questions

...End of Chapter Questions Chapter 28: 28-1: Hemmerling is an employee because he is supplied with a toll by the employer to do his job and the tool is the taxi cab. He also follows a set of rule that is enforced by the employer on how to take care of his cab. This all indicates he is an employee. 28-2: An agency was in existence at the time of the conversation between the two individuals about the selling of the coin. The agency was active because Wade convinced Brown he was an acting agent for Gett. Brown had no reason not to believe Wade and so the deal was sealed with an agreement that Gett would buy the coin from Brown, even though Gett did not know this he is held liable under the Estoppel act. Chapter 30: 30-1: Classen can hold Daniel liable as a partner with Ruby, because Ruby is receiving a percentage of the company’s profits and under law this is considered a partnership. Chapter 31: 31-1: The court will apply the Limited Liability Company Act under the ruling of the National Conference of Commissioners. The majority of states would rule in favor of the minority holders stating that in a LLC all profits shall be divided equally if there is no written agreement on how the profits will be divided. Chapter 32: 32-1: The board of directors would have to state before hand in writing if the president is allowed to take a private loan with the corporation co-signing the agreement. If......

Words: 391 - Pages: 2

Free Essay

Meteorology Chapter 5 Questions

...Chapter 5, Review Questions ________________________________________________________________________ 1. How does Dalton’s law apply to the atmosphere? 2. Provide a definition of air pressure that applies to Earth’s surface and any altitude within the atmosphere. 3. Compare the advantages and disadvantages of mercury barometer versus an aneroid barometer. 4. Explain how air pressure tendency can be a useful indicator of future weather. 5. Air is a compressible mixture of gases. How does this property of air affect the rate at which air pressure decreases with increasing altitude? 6. How does a change in temperature affect air density? How does a change in humidity affect air density? 7. Why does a cold, dry air mass exert a greater surface air pressure than an equally cold but more humid air mass? 8. Why are air pressure readings adjusted to what they would be if the weather station were actually located at sea level? 9. Distinguish between Charles’ law and Boyle’s law. 10. Why is the dry adiabatic lapse rate greater than the moist adiabatic lapse rate? Chapter 5, Critical Thinking Questions ________________________________________________________________________ 1. Is there some altitude which clearly marks the top of the atmosphere? Explain your response. 2. On televised weathercasts, air pressure is often reported in units of length (inches) rather than units of pressure (millibars). Explain why. 3. On a particularly warm...

Words: 423 - Pages: 2

Premium Essay

Chapter 1 Essay Questions

...Chapter 1 Essay Questions: 1. Explain the relationships among the four functions of management. The four basic management functions are planning, influencing, and controlling. a. Planning involves choosing tasks that must be performed to attain organizational goals, outlining how the tasks must be performed, and indicating when they should be performed. b. Organizing-can be thought of as assigning the tasks developed under the planning function to various individuals or groups within the organization. c. Influencing is referred to as motivating, leading, directing, or actuating. d. Controlling is the management function through which managers i. Gather information that measures recent performance within the organization ii. Compare present performance to pre-established performance standards. iii. From this comparison, determine whether the organization should be modified to meet pre-established standards. These functions are interrelated because the performance of one depends on the performance of the others. For example, organizing is based on well thought out plans developed during the planning process, and influencing systems must be tailored to reflect both these plans and the organizational design used to implement them. The fourth function, controlling, involves possible modification to existing plans, organizational structure, or the motivation system used to develop a more successful effort. ...

Words: 597 - Pages: 3

Premium Essay

Chapter 4 Questions

...Chapter 4 Extra Credit Questions: 1. Direct labor is a valid basis for allocating overhead for job order costing. 2. In recent industrial history advances in computerized systems, technology innovation, global competition, and automation has changed manufacturing environments. That is what reduced the usefulness of direct labor as the primary basis for allocating overhead to products. 3. Machine hours are frequently more relevant than direct labor hours. 4. Overhead allocation to high volume products is responsible for less overhead cost per period, where overhead allocation to low volume products under a traditional costing system is responsible for more overhead cost per unit than the high-volume. 5. Activity based costing (ABC) is an overhead cost allocation system that allocates overhead to multiple activity pools and assigns the activity cost pool to products or services. Traditional product costing is determined through overhead cost. 6. Activity-Based Overhead Rates = Overhead/ Direct Labor Hours 7. The steps involved in developing an activity based costing system are identify and classify the activities, identify the cost driver, compute the activity based overhead rate, and assign overhead costs to production. 8. A value-added/non-value added flowchart is based on an analysis of all the activities preformed to manufacture a product. The flow chart will record each activity done and the time correlating to the activity. 9. Activity...

Words: 557 - Pages: 3

Premium Essay

Chapter 1 Questions

...Chapter 1: Introduction to Project Management TRUE/FALSE 1. Until the 1980s, project management primarily focused on providing schedule and resource data to top management in the military, computer, and construction industries. ANS: T Until the 1980s, project management primarily focused on providing schedule and resource data to top management in the military, computer, and construction industries. Today’s project management involves much more, and people in every industry and every country manage projects. PTS: 1 DIF: Difficulty: Easy REF: p.2 OBJ: LO: 1-1 NAT: BUSPROG: Technology TOP: Introduction KEY: Bloom's: Knowledge 2. A difference between operations and projects is that operations end when their objectives have been reached, whereas projects do not. ANS: F Projects are different from operations in that they end when their objectives have been reached or the project has been terminated. PTS: 1 DIF: Difficulty: Moderate REF: p.4 OBJ: LO: 1-2 NAT: BUSPROG: Analytic TOP: What is a Project? KEY: Bloom's: Comprehension 3. Every project should have a well-defined objective. ANS: T A project has a unique purpose. Every project should have a well-defined objective. PTS: 1 DIF: Difficulty: Easy REF: p.6 OBJ: LO: 1-2 NAT: BUSPROG: Analytic TOP: What is a Project? KEY: Bloom's: Knowledge 4. Projects should be developed in increments. ANS: T A project is developed using progressive elaboration. Projects are often defined......

Words: 7714 - Pages: 31

Premium Essay

Chapter 2 Question

...Stacy Edelman Chapter 2 Questions 1. In what ways do Different ideologies and political systems influence the environment in which MNCs operate? In each country has there are own government controls and laws that have to be followed. You have to take the countries religious views into consideration. Whether the company is domestic, national, international, large or small political factors of the country it is located in will have an impact on it. A government could restrict a company's activity by intimidating and banning activities. 2. How do the following legal principles impact MNC operations. 1. The principle of sovereignty: An international principle of law which holds that governments have the right to rule themselves as they see fit. Implies that one countries court system cannot be used to determine wrongful conduct or impose penalties in another unless that country agrees. Each country has it's own rules and if that person was a U.S. citizen working in a different country and was providing equal opportunity, the employee has no right to sue the employer. 2. Nationality Principle: Recognizes a nations interest in maintaining some degree of control over it's citizen residing in different countries. Managers who violate American foreign corrupt practices when traveling could be found guilty in the U.S. 3. The territoriality Principle: accepted in the united states but not in all countries. each country has the right to it's own jurisdiction within...

Words: 318 - Pages: 2

Free Essay

Statistics and Excel 2 Questions

...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......

Words: 510 - Pages: 3

Free Essay

Chapter 2 Questions & Answers

...Linsey Cessor EDUC 2253 Dr. Shahan January 28, 2015 Professional Practice Chapter 2: Question for Discussion 2. Why is membership in an ethnic group more important to some individuals than to others? What characteristics might an educator look for to determine a student’s ethnic background and its importance in that student’s life? * Individuals may have multiples reasons of being more in tuned to their ethnicity than others. Most are drawn to their ethnic group because that is what is familiar to them. When the elderly generation is a dominate part of their raising then the younger generation has more information about their heritage. * Others are not so luck to grow up with the elderly generation influence and have are disconnected with their ethnic groups. Some people are a merge of two different ethnic groups and this causes confusion for the individual. With the merging of different ethnic groups, some people tend to loners. Not ever finding that “prefect” ethnic group that they belong in. As an educator there are many characteristics that will reveal the ethnicity of a student such as a student’s gender, race and religion. However, with all of this being said I do not think that the ethnicity of a student is completely important for an effective teacher. An effective teacher teaches on the level of their students, and then begins helping the student’s excel. An effective teacher is able to teacher all the curriculum to the students without biases...

Words: 344 - Pages: 2

Premium Essay

Chapter 2 Review Question

...Gunther Documet 9/14/2015 Applications in Info Security Chapter 4 Review Questions: 1)It might depend on the risk, although all risks should be addressed. The conditions that an organization might have is if they don't have a risk management plan or if they don't have the money to identify and mitigate the risk 2) 3)Alignment is important because it can align organizational goals with ICT works. The benefits to an organization as a whole is that it can align security processes with business goals. 4)Evaluation is important because it can determine if your team is achieving the objectives and this is usually done through gathering data and then analyzing it. Organizations benefit by collecting quantitative data because it can be used to evaluate the options and implications of a decision. 5)A contract is an agreement between a customer and a supplier, while the RFP is technically a bid solicitation. 6)Typically a subcontractor role is to perform specific tasks given by a general contractor. They can be controlled by the supplier to follow the right procedures that are given in the contract. 7)The problem resolution is important because it involves two parties in agreeing that all problems are identified, analyzed, managed, and controlled to resolution. 8)There are two types of reviews: Formal Reviews Informal Reviews In a formal review, the ICT is presented to a team or to an individual before the actual review. In the other hand the informal......

Words: 334 - Pages: 2

Premium Essay

Chapter Questions!

...Chapter 22 and 23 Questions 1. Do you have a personal disaster recovery plan? What steps have you taken to protect information contained on your personal computer? a. Yes, I do have a personal disaster recovery plan for the majority of my electronics, as well as my documents, pictures, and music on my computer, although I am not sure how effective these plans may be as I have not encountered a disaster as of yet. I have an Apple MacBook, which allows my phone and computer to sync by plugging my phone in. Recently, I have now been able to connect documents, or anything really, to the ‘cloud.’ I also save all my schoolwork on my flash drives. In the year 2015, I feel as though personal computer customers have many options for backups! 2. How can a staff nurse contribute to continuity planning within his or her facility? b. A staff nurse can contribute to continuity planning by paying careful attention to backup and storage methods and needs. They can also review and update continuity plans, plan and work through mock disasters (while assisting others), and post plans for themselves and their coworkers throughout the workplace. 3. Why is it important for nurses to be prepared with proper crisis management procedures during an information technology disaster? c. The patients! Safety is the number one concern and the patient or family may not be available or know the patient’s history, allergies, or current state of health. If we as nurses lose......

Words: 430 - Pages: 2

Free Essay

Chapter 6 Questions

...Alex Viger Chapter 6 Questions: 1,4,5,7,10-12,17,18,20,22 1.) When a parcel of air expands and cools or compresses and warms with no interchange of heat. 4.) The dry adiabatic rate is the rate of cooling or warming of unsaturated air. The environmental lapse rate is the rate of change in temperature with altitude. 5.) By releasing a radiosonde which is a balloon shaped instrument that sends back temperature data. 7.) Clouds formed in stable conditions will have usually form relatively thin layers and have flat tops and bases. Clouds formed in unstable conditions will be more vertically developed and will not always have smooth tops and bottoms. 10.) The air over the cold water will be relatively stable. 11.) This is when the air will be the most unstable and will have a lifting action. 12.) There is no mixing present. If there were, there wouldn’t be an inversion. 17.) Surface heating and free convection, uplift along topography, widespread ascent do to convergence of surface air, uplift along weather fronts. 18.) a. They appear to be motionless when viewed form the ground, b. leeward side 20.) If the top of the cloud deck cools while the bottom warms an altostratus cloud can turn into an altocumulus cloud. 22.) a. when stable air flows over a mountain and the air condenses as it rises and evaporates as it sinks b. when a rotating eddy forms c. along a region of rapidly changing wind speed d. when rising air currents within the cloud extend into......

Words: 268 - Pages: 2

Free Essay

Succeeding in Business Using Excel 2013 Chapter 5

...Chapter 5: Retrieving Data for Computation, Analysis, and Reference TRUE/FALSE 1. A data list that categorizes values you want to retrieve is called a linkup table. ANS: F PTS: 1 REF: 291 2. A vertical lookup table is a lookup table in which the data to be searched is organized in columns. ANS: T PTS: 1 REF: 294 3. When you write a VLOOKUP formula, you indicate the value you want to look up in a table. ANS: T PTS: 1 REF: 294 4. If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard. ANS: F PTS: 1 REF: 297 5. When using a VLOOKUP function it’s not always obvious when a returned value is incorrect. ANS: T PTS: 1 REF: 298 6. When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value. ANS: F PTS: 1 REF: 299 7. Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula. ANS: F PTS: 1 REF: 301 8. When creating a vertical lookup table with the TRUE type, be certain to start with the lowest possible value, such as 0, so that the table covers all the possible data. ANS: T PTS: 1 REF: 301 9. The syntax of the HLOOKUP function is as follows: HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) ANS: T PTS: 1 REF: 303 10. The rules for an HLOOKUP function with a TRUE lookup type test the values down the first column. ANS: F PTS: 1 REF: 304 11. A...

Words: 3779 - Pages: 16

Premium Essay

Concept Questions Chapter 20

...Concept Question Chapter 20 1. Personal selling involves the two-way flow of communication between a buyer and seller, often in a face-to-face encounter, designed to influence a person’s or group’s purchase decision. 2. What is involved in sales management? Sales management involves planning the selling program and implementing and controlling the personal selling effort of the firm. 1. What is the principal difference between an order taker and an order getter? An order taker processes routine orders or reorders for products that were already sold by the company. An order getter sells in a conventional sense and identifies prospective customers, provides customers with information, persuades customers to buy, closes sales, and follows up on their use of a product or service. 2. Team selling is the practice of using an entire team of professionals in selling to and servicing major customers. 1. The six stages in the personal selling are: prospecting, preapproach, approach, presentation, close, and follow-up. 2. What is the distinction between a lead and a qualified prospect? A lead is the name of a person who may be a possible customer. A qualified prospect is an individual who want the product, can afford to buy it, and is the decision maker. 3. Which presentation format is most consistent with the marketing concept? Why? The need-satisfaction presentation format probing and listening by the salesperson to identify needs and interests of prospective......

Words: 683 - Pages: 3

Premium Essay

Chapter 2 Review Questions

...Chapter 1 PLD Review questions Multiple choice 1. A program is a set of instructions that a computer follows to perform a task. 2. The physical devices that a computer is made of are referred to as Hardware. 3. The part of a computer that runs programs is called the CPU. 4. Today, CPUS are small chips known as Microprocessors. 5. The computer stores a program while the program is running, as well as the data that the program is working with, in Main memory. 6. This is a volatile type of memory that is used only for temporary storage while a program is running. A. RAM 7. A type of memory that can hold data for long periods of time—even when there is no power to the computer—is called Secondary storage. 8. A component that collects data from people or other devices and sends it to the computer is called an input device. 9. A video display is a(n)output device. 10. A byte is enough memory to store a letter of the alphabet or a small number. 11. A byte is made up of eight bits. 12. In a binary numbering system, all numeric values are written as sequences of 0s and 1s. 13. A bit that is turned off represents the following value: 0 14. A set of 128 numeric codes that represent the English letters, various punctuation marks, and other characters is ASCII. 15. An extensive encoding scheme that can represent the characters of many of the languages in the world is Unicode. 16. Negative......

Words: 727 - Pages: 3