Search Results

What is Microsoft Excel?a) A word processorb) A presentation softwarec) A spreadsheet applicationd) A graphics editor Answer Answer: c) A spreadsheet application Which of the following is not a component of an Excel workbook?a) Worksheetb) Chartc) Table...

Learning Objectives Locate and fix formatting consistency errors. Apply new formatting techniques. Use Print Titles to repeat rows and columns on each page of a multiple page worksheet. Control where page breaks occur in a multiple page workshe...

To assess your understanding of the material covered in the chapter, please complete the following assignments. Although Excel is primarily used in business and scientific applications, you will find it useful in other areas of study as well. In these exe...

Learning Objectives Review each worksheet in a workbook in Print Preview. Modify worksheets as needed to professionally print data and charts. In this section, we will take a look at each of the worksheets created in the previous sections. Since...

Learning Objectives Learn how to paste an image of an Excel chart into a Word document. Learn how to paste a link to an Excel chart into a PowerPoint slide. Charts that are created in Excel are commonly used in Microsoft Word documents or for pres...

Learning Objectives Apply formatting commands to the X and Y axes. Assign titles to the X and Y axes that clarify labels and numeric values for the reader. Apply labels and formatting techniques to the data series in the plot area of a chart. Apply...

Learning Objectives Construct a line chart to show timeline and comparison trends. Learn how to use a column chart to show one and two frequency distributions. Create and format a map chart. Insert a funnel chart. Learn how to use a pie chart to...

Midascoffee Company Download Data File: SC3 data  MidasCoffee: Ruth Kobran owns a coffee supply company named MidasCoffee. She needs some help writing the formulas for the order form she uses to invoice customers. You will need to write the formulas for ...

Household Budget Download Data File: PR3 Data Etta and Lucian Redding are a recently married couple living in Portland, Oregon. Lucian works part time and attends the local community college. Etta works as a marketing manager at a clothing company in Nor...

Learning Objectives Use Conditional Formatting techniques to provide flexible highlighting, applying specified formatting only when certain conditions are met.  Techniques include: Data bars — to make it easy to visualize values in a range of c...

Learning Objectives Learn how to create basic formulas. Understand relative referencing when copying and pasting formulas. Work with complex formulas by controlling the order of mathematical operations. Understand formula auditing tools. ...

Learning Objectives Use an IF Function to make logical comparisons between a value and what you expect. Create a VLOOKUP calculation to look up information in a table. Understand error messages. Understand how to enter and format Date/Time Func...

Learning Objectives Review the use of the =MAX function. Examine the Quick Analysis Tool to create standard calculations, formatting, and charts very quickly. Create Percentage calculation.– Use the Smart Lookup tool to acquire additional inform...

What is the shortcut key to create a new workbook in Excel?A) Ctrl + NB) Ctrl + OC) Ctrl + WD) Ctrl + S Answer Answer: A) Ctrl + N Which tab in the Ribbon contains the command to insert a new worksheet?A) HomeB) InsertC) Page LayoutD) Data Answer An...

Hotel Occupancy And Expenses Download Data File: SC2-Data The hotel management industry presents a wide variety of career opportunities. These range from running a bed and breakfast to a management position at a large hotel. No matter what hotel manage...

Financial Plan For A Lawn Care Business Download Data File: PR2-Data Running your own lawn care business can be an excellent way to make money over the summer while on break from college. It can also be a way to supplement your existing income for the ...

Learning Objectives Review and learn new cell formatting techniques. Understand how to modify page scaling and margins. Create custom headers and footers to automatically update information. In this section, we will review some of the formatt...

Learning Objectives Understand the fundamentals of loans. Use the PMT function to calculate monthly car loan payments. Use the PMT function to calculate monthly mortgage payments on a house using a down payment. Learn how to summarize data in a wor...

Learning Objectives Use the SUM function to calculate totals. Use the COUNT function to count cell locations with numerical values. Use the AVERAGE function to calculate the arithmetic mean. Use the MAX and MIN functions to find the highest and...

Charting  Sales Data Download Data File: SC4 Data An effective way to communicate findings in Excel is by graphing data. Graph the attached sales information, visualizing profit margin trends, and production patterns, and the sales pipeline; enabling d...