Archives

Name: Class: Date: Excel Module 01: Getting Started with Excel Copyright Cengage Learning. Powered by Cognero. Page 1 1. The name of the active workbook appears in the status bar of the Excel window. _________________________ a. True b. False ANSWER: […]

Name: Class: Date: Excel Module 02: Formatting Workbook Text and Data Copyright Cengage Learning. Powered by Cognero. Page 1 1. Formatting changes only the appearance of data—it does not affect the data itself. _________________________ a. True b. False ANSWER: True […]

Name: Class: Date: Excel Module 03: Performing Calculations with Formulas and Functions Copyright Cengage Learning. Powered by Cognero. Page 1 1. A constant is a value in a formula that doesn’t change. _______________ a. True b. False ANSWER: True POINTS: […]

Name: Class: Date: Excel Module 04: Analyzing and Charting Financial Data Copyright Cengage Learning. Powered by Cognero. Page 1 1. Each slice in a pie chart represents a single value from a data series. ____________ a. True b. False ANSWER: […]

Name: Class: Date: Excel Module 05: Working with Excel Tables, PivotTables, and PivotCharts Copyright Cengage Learning. Powered by Cognero. Page 1 1. If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell […]

Name: Class: Date: Excel Module 06: Managing Multiple Worksheets and Workbooks Copyright Cengage Learning. Powered by Cognero. Page 1 1. Using multiple worksheets makes it more difficult for you to group your data. a. True b. False ANSWER: False REFERENCES: […]

Name: Class: Date: Excel Module 07: Developing an Excel Application Copyright Cengage Learning. Powered by Cognero. Page 1 1. For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 […]

Name: Class: Date: Excel Module 08: Working with Advanced Functions Copyright Cengage Learning. Powered by Cognero. Page 1 1. All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value. […]

8. Because it’s a date; all dates are numbers formatted to appear in standard date formats. 9. Double-click its right border or select the column, go to the Home tab, click the Format button in the Cells group, and then […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

Henderson Pediatric Care Center Author Kari Essen Date 3/1/2017 Purpose To record donations made to the Pediatric Care Center in Henderson, West Virginia Donor List Total Donors 7 Total Donations $975 Average Donation $139.29 Last Name First Name Street City […]

Author Sean Patel Date Wednesday, March 1, 2017 Purpose To develop a projected income statement for Green Clean Homes Projected Income Financial Assumptions Income Projects per Day 12 Gross Sales 305,718$ Hours per Project 4 Cost of Sales Percent of […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

while the Accounting style fixes the currency symbol on the left edge of the cell, encloses negative values in parenthesis, and displays zero values using dashes. either increase the width of the cell column or reduce the number of digits […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

7. Excel does not treat blanks as zeroes and will skip the blank values in calculating an average from a range of cell. Goal Seek the value for the calculated value is specified and Excel determines the input value needed […]

Gorecki Construction Author Date Purpose Gorecki Construction Budget Analysis Estimated Monthly Budget 31-Jan-18 28-Feb-18 31-Mar-18 30-Apr-18 31-May-18 30-Jun-18 31-Jul-18 31-Aug-18 30-Sep-18 31-Oct-18 30-Nov-18 31-Dec-18 Total Income Income Construction 33,580 Construction 20,781.48 18,481.47 28,311.14 32,145.87 34,005.21 41,004.87 37,578.91 36,414.34 34,308.10 57,207.15 […]

4. the chart title, the chart legend, and data labels increases, the harder it is to distinguish different slice values. Generally, you should not have more than 5 or 6 slices in the pie chart for readability. 7. Because the […]

Stefanek Family Budget Author Edmund and Lydia Stefanek Date 3/1/2017 Purpose To provide an overview of the monthly budget of Edmund and Lydia Stefanek Stefanek Family Budget Mortage 285,000$ Monthly Payment (1,551.94)$ Income & Expenses Jan Feb Mar Apr May […]

4/11/2013 1.63M 136.46 137.78 133.75 136.94 4/10/2013 2.28M 141.97 142.04 137.31 137.64 4/9/2013 2.77M 141.57 142.05 137.18 140.90 4/8/2013 1.61M 145.24 147.20 143.40 144.73 4/5/2013 1.06M 144.20 145.20 142.29 143.65 4/4/2013 1.10M 148.21 148.54 143.66 144.40 4/3/2013 1.20M 150.69 150.69 […]

SID467 Male Urban Travel 100K price SID468 Female Outdoors Sport 90K price SID478 Female Urban School 100K quality SID479 Male Outdoors Sport 90K brand name SID480 Male Urban School 120K brand name SID481 Male Urban Travel 90K brand name SID482 […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

12/1/2016 3.21M 42.39 43.68 42.03 43.63 11/30/2016 2.87M 42.00 42.47 41.40 41.75 11/29/2016 3.71M 42.01 42.01 39.88 40.86 11/28/2016 3.67M 43.88 43.98 41.51 41.83 11/25/2016 1.87M 44.72 45.34 43.72 44.55 11/23/2016 1.99M 44.52 45.39 43.47 44.60 11/22/2016 1.46M 43.94 44.65 […]

8/13/2009 2.02M 111.22 112.90 109.04 111.64 8/12/2009 3.18M 108.12 112.25 105.50 109.92 8/11/2009 3.74M 114.50 115.50 108.03 109.40 8/10/2009 3.94M 114.49 116.30 110.20 112.05 8/7/2009 2.62M 114.42 118.39 113.30 115.97 8/6/2009 2.53M 114.00 116.28 111.06 114.56 8/5/2009 2.83M 113.50 115.88 […]

don’t scroll out of view as you move around the worksheet. By freezing the rows and columns that contain headings, it’s easier to understand the data in each record as you scroll. 4. filter buttons appear in the column headers, […]

Food for All Author Samuel Hamilton Date 11/15/2017 Purpose To track food bank donations Field Description Data Type Notes Donation ID Donor ID Number Date Date of Donation Date Use mm/dd/yyyy format Name Donor Name Text Address Donor Address Text […]

Victoria’s Veggies Author Victoria Calderon Date 11/16/2017 Purpose To track daily sales for July Field Description Data Type Notes Sale Date Date of the sale Date Use the mm/dd/yyyy format and business type Data Definition Table Day Day of the […]

BePresent Author Alana Laidlaw Date 11/16/2017 Purpose Track social networking campaigns Field Description Data Type Notes Name Company name Text Data Definition Table Type Type of social media Text Twitter, Facebook, and Pinterest Description Description of campaign Text Month Month […]

Collegiate Seminars Author Phillip Cunningham Date 11/16/2017 Purpose To track seminar bookings Field Description Data Type Notes Seminar ID Seminar ID Number Topic Seminar Topic Text Accounting, Finance, Marketing, Management, Undecided Type Type of Seminar Text General Interest, Graduate, Post […]

Go Sports Author Anton Aliyev Date 11/16/2017 Purpose To analyze shirt inventory for Go Sports Field Description Data Type Notes Item ID ID for shirt Number ID for shirt (auto generated) Data Definition Table Style Style of shirt Text T-shirt, […]

Victoria’s Veggies Author Victoria Calderon Date 11/15/2017 Purpose To track daily sales for June Field Description Data Type Notes Sale Date Date of the sale Date Use the mm/dd/yyyy format Data Definition Table Day Day of the week Text Monday, […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

ELS Summary 2017 Summary Economic Landscape Supplies Author Kyle Walker Date 9/15/2017 Purpose To summarize current and projected sales Economic Landscape Supplies Summary 2018 Gross Sales 2019 Projected Sales January 321,993 293,208 February #VALUE! 286,214 March 239,500 251,827 April 279,600 […]

Summary Reveries Urban Centers Author Timothy Root Date 11/20/2017 Purpose To compile rental income data for the Jackson location Fiscal Year – 2017 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Child Care Centers 16,388$ 15,376$ 11,426$ 14,076$ 57,266$ […]

ELS Maryland Summary Economic Landscape Supplies Author Kyle Walker Date 9/15/2017 Purpose To summarize current and projected sales Economic Landscape Supplies Summary 2018 Gross Sales 2019 Projected Sales January 42,993 181,108 February 104,930 110,622 March 105,550 111,236 April 144,900 152,408 […]

RoomGroom 2017 Service by Month Room and Groom Author Samuel Wooten Date 9/15/2017 Purpose To analyze kennel services data Room and Groom Service by Month Month Groom Room- Room- Total January 111 38 20 169 February 79 35 16 130 […]

ELS Virginia Summary Economic Landscape Supplies Author Kyle Walker Date 9/15/2017 Purpose To summarize current and projected sales Economic Landscape Supplies Summary 2018 Gross Sales 2019 Projected Sales January 133,100 139,755 February 135,500 142,275 March 118,200 124,110 April 110,000 115,500 […]

nonadjacent group of worksheets, click the sheet tab of one of the worksheets in the group, press and hold the Ctrl key, and then click the sheet tabs of the remaining worksheets in the group. Deselect a worksheet group by […]

ELS Author Kyle Walker Date 9/15/2017 Purpose To summarize current and projected sales ELS Summary Gross Sales Projected Sales January 10,000 12,000 February 10,000 12,000 March 10,000 12,000 April 10,000 12,000 May 10,000 12,000 June 10,000 12,000 July 10,000 12,000 […]

Reveries Urban Centers Author Date Purpose To compile rental income data for the [Rental Center] Enter Fiscal Year – yyyy] Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Child Care Centers –$ –$ –$ –$ –$ Music Practice –$ […]

New UC Audited 2018 Summary Reveries Urban Centers Author Michael Verhallen Date 11/21/2017 Purpose To compile rental income data for all of the Reveries Urban Centers Fiscal Year – 2017 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Child […]

Employee: Employee phone: Manager: Employee email: Week ending: Regular Hours Overtime Sick Total Monday 8/20/2017 8.00 8.00 Tuesday 8/21/2017 8.00 1.50 9.50 Employee signature Date Manager signature Date Weekly time record 8/26/2017 Day Vacation Gordon Warren Reveries Urban Centers Timothy […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

Reveries Urban Centers Author Timothy Root Date 11/20/2017 Purpose To compile rental income data for all of the Reveries Urban Centers Fiscal Year – 2017 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Child Care Centers 44,263$ 46,896$ 34,426$ […]

New ELS Maryland Summary Economic Landscape Supplies Author Kyle Walker Date 9/15/2017 Purpose To summarize current and projected sales Economic Landscape Supplies Summary 2018 Gross 2019 Projected June 129,000 135,893 July 128,500 135,284 August 196,100 206,610 September 169,250 178,466 October […]

Summary Sales Paige’s Tea Room Author Paige Sapienza Date 11/21/2017 Purpose To summarize quarterly sales data for each tea room location Summary Sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Totals Green 30$ 30$ 30$ 30$ 120$ Black 30 […]

ELS Delaware Summary Economic Landscape Supplies Author Kyle Walker Date 9/15/2017 Purpose To summarize current and projected sales Economic Landscape Supplies Summary 2018 Gross Sales 2019 Projected Sales June 129,000 135,450 July 128,500 134,925 August 196,100 205,905 September 169,250 177,713 […]

Summary Reveries Urban Centers Author Date Purpose To compile rental income data for Jackson Fiscal Year – 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Totals Child Care Centers 100$ 100$ 100$ 100$ 400$ Music Practice 100 – – […]

Barstow 2017 Barstow Clara’s Goodie Bags Author Clara Perry Date 11/21/2017 Purpose To analyze sales in the Barstow store Clara’s Goodie Bags Barstow Wedding Birthday Holiday Graduation Retirement Custom Total Quarter 1 3,245 2,102 4,265 2,134 1,623 1,407 14,776 Clara […]

The Chair Guy Author: Alexander Wilson Date: 12/1/2017 Style List Color Adult Beige Animal Black Child Blue Customer Name Glenn Cole Loveseat Brown Address 1044 Sycamore Lake Road Oversized Green City, State Zip Castle Rock Lake, WI 43573 Rocking – […]

12/7/2017 Parent Sharon Williams Rockport Youth Center – Events Henry Registration Date Youth Name 747 Main Street Rockport, IN 47635 Event Registration Receipt Address 3642 Washington Ave City State Zip Rockport, IN 47635 G5 Telephone 812-555-1234 L 80$ Total Event […]

Resale Shoppe Elm Street Anacortes, Washington 98221 360-888-8129 Date: 10/12/2017 Customer: Anna Smith 123 Main St Anacortes Associate Debbie Item Group Age Group Description Price 1 Coats Adult Winter Coat 20.00 2 3 4 Sub Total 20.00 Tax (8.5%) 1.70 […]

Rockport Youth Center – Events Author Juldy Harte Date 10/1/2017 Purpose To collect registration information for Winter Youth Events and print receipts Defined Names City_State_Zip =Receipt!$B$10 Event =Receipt!$B$5 Events =Receipt!$A$13:$B$16 Grade =Receipt!$B$6 Guardian =Receipt!$B$8 Registration_Date =Receipt!$B$3 Shirt_Size =Receipt!$B$7 Street_Address =Receipt!$B$9 […]

Frontier School’s Out Event Author Lourdes Dreyer Date 12/1/2017 Purpose To record reservations for the Schools Out Event Defined Names Amount_to_Pay =’Reservation Input’!$B$11 City__State__Zip =’Reservation Input’!$B$7 Confirmation =’Reservation Input’!$B$10 Date_Paid =’Reservation Input’!$B$2 e_mail_address =’Reservation Input’!$B$9 Event =’Reservation Input’!$B$3 Guests =’Reservation […]

Rockport Youth Center – Activities Author Stephen Maynard Date 1/15/2017 Purpose To collect registration information for winter activities and print receipts Defined Names Activity =Receipt!$B$5 ActivityFee =Receipt!$E$11 Address =Receipt!$B$10 City__State_Zip =Receipt!$B$11 Grade =Receipt!$B$6 Guardian =Receipt!$B$9 ReceiptDisc =Receipt!$E$34 ReceiptFee =Receipt!$E$33 Registration_Date […]

Row Labels Sum of Guests Breakfast with the Principal 11 Frontier School’s Out Event Totals Lunch with the Teachers and Staff 10 Grand Total 21

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

Rockport Youth Center – Events Author Juldy Harte Date 10/1/2017 Purpose To collect registration information for Winter Youth Events and print receipts Defined Names City_State_Zip =Receipt!$B$10 Event =Receipt!$B$5 Events =Receipt!$A$13:$B$16 Grade =Receipt!$B$6 Guardian =Receipt!$B$8 Registration_Date =Receipt!$B$3 Shirt_Size =Receipt!$B$7 Street_Address =Receipt!$B$9 […]

Resale Shoppe Author: Debbie Oboyle Date: 12/1/2017 To generate a sales receipt using Purpose: standardized information for Item Groups and Age Groups Resale Shoppe 451 Elm Street Anacortes, Washington 98221 360-555-8129 Date: 3/28/2022 Customer: Associate: Item Group Age Group Description […]

2. data input, data storage, and data output defined name to a different location, any formula using that named range reflects the new location. 5. No. It contains a space. Replacing that space with an underscore (_) or removing the […]

Vintage Posters Author Earnest Loden Date 12/1/2017 Purpose To collect information about a vintage poster collection Date Purchased Brief Description Vintage Poster Input Category Size Purchase Price Classification Location Comments 1/0/1900 0 0 0 0 0 0 0 Transfer Area […]

12/4/2017 Activity Registration Receipt Rockport Youth Center 727 Main Street Rockport, IN 47635 Registration Date Guardian Rosie Thompson Address 1231 Main St. City, State Zip Rockport, IN 47635 G6 Telephone 812-555-8848 M 80 5 75$ Activity Fee Kids Game Night […]

The Chair Guy Author: Alexander Wilson Date: 12/1/2017 Purpose: To input, print, and save chair orders Style List Color Adult Beige Animal Black Child Blue Customer Name Loveseat Brown Address 0 0 0 0 Chair Sale Transfer Area Order Form […]

Barrett Furniture Rentals Author Elise Williams Date 7/1/2017 Purpose To track furniture rentals Field Description Data Type Notes Renter Renter’s name Text Furniture Type of furniture Text Rental Date Date rental begins Date Enter dates using mm/dd/yyyy Rental Period Number […]

© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website […]

MB Hobbies & Crafts Author Vanessa Beals Date 12/1/2017 Purpose To analyze the MBHC employees and products Field Description Data Type Notes Employee ID Employee ID Number 1000-9999 Store Employee store Text Bonham, Bowie, Garland, or Graham Job Status Employee […]

LKE Distribution Author Laura Easterling Date 12/1/2017 Purpose To analyze the Accounts Receivable and prepare summary reports Field Description Data Type Notes Invoice Number Invoice number Number Invoice Date Date of invoice Date Enter dates using mm/dd/yyyy Company Name of […]

2. a calculated column 4. The AND function is a logical function that returns a TRUE value if all logical conditions are TRUE; otherwise, it returns a FALSE value. 6. structured references 2. Younger compares the lookup value to the […]

MB Hobbies & Crafts Author Vanessa Beals Date 11/9/2017 Purpose To analyze the MBHC employees and products Field Description Data Type Notes Employee ID Employee ID Number 1000-9999 Last Name Employee last name Text First Name Employee first name Text […]

Athey Department Store Author Mitchell Athey Date 11/10/2017 Purpose To create a return routing slip Field Description Data Type Notes Date Date of Return Date Enter dates using mm/dd/yyyy Data Definition Table – Return Data Department Department Text Accessories, Baby, […]

Whitney, Elizabeth Billings MT 59101 (406) 364-3409 October 2014 237.00 p Callahan, John Ballantine MT 59006 (307) 867-2579 March 2015 154.00 p Lausier, John Huntley MT 59037 (406) 294-6043 March 2015 188.00 p Outram, Barbara Laurel MT 59044 (307) 994-3832 […]

Members Billings Cooking Club – Youth Division Author: Shirley McGregor Date: 11/23/2017 Purpose: To collect data about cooking club members – Youth Division Last Name First Name Phone Date of Birth Status Street Cty St City State Coulahan Linda (406) […]

First Thursday Book Club Author: Fred Arnett Date: 11/23/2015 Purpose: To collect data about the First Thursday Book Club Telephone First Name Last Name City, State Zip Member Since Membership ID (501) 356-4575 EDWARD FORRESTER Hot Springs, AK 71901 1992 […]

Tidy House Author: Tierra Waggoner Date: 11/23/2017 Purpose: To collect payroll data for the Tidy House employees First Name Last Name Address City State Zip SS Number Type of Work Hourly Rate Regular Hours Overtime Hours Michelle Brayton 4957 Poplar […]