Search Results

Learning Objectives Use the Page Layout tab to prepare a worksheet for printing. Add headers and footers to a printed worksheet. Examine how to print worksheets and workbooks. Once you have completed a workbook, it is good practice to select th...

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

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

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

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

To assess your understanding of the material covered in the chapter, complete the following assignment. Basic Monthly Budget For Medical Office Download Data File:  PR1 Data Creating and maintaining budgets are common practices in many careers. Budget...

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

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

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

Sales And Inventory Items Download Data File: SC1 Data A key activity for marketing professionals is to analyze projected sales and inventory information. This is especially important for retail environments. This exercise utilizes the skills covered i...

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