Reference no: EM133793779

Project 1: Ch11_HOE_Halloween

Project Description:
Halloween Center is a supercenter corporation that opens stores around the country in September and October. The stores sell high-quality costumes and accessories. In addition, each location has a haunted house that generates revenue through admissions fees. You are the regional manager over Utah, Colorado, New Mexico, and Arizona, where stores are located in 10 major cities.

You created a workbook with three worksheets. The first two worksheets contain lists of store and state managers. Your first task will be to manipulate the text to make the lists easier to read. The third worksheet contains a list of gross sales by store at the end of each week. You will use advanced filtering and database functions to analyze the sales. The fourth worksheet contains a similar dataset. You will use array functions to create a unique list of locations, a list of record numbers, sorted and filtered data, and a sequence of the top values. Finally, the last worksheet contains a consolidated list of the weekly sales in an easy-to-read format. You will use lookup functions to search for and find data within the dataset

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp22_Excel_Ch11_HOE_Halloween.xlsx. Grader has automatically added your last name to the beginning of the filename.
0
2 The first column contains first and last names of the store managers. To facilitate future sorting by last name, you want to display last names and then first names in the second column.

In cell B2 in the Store Managers worksheet, type Lundgren, Gusten. Use Flash Fill to complete the pattern down column B. 3
3 The worksheet contains the complete addresses in the third column. You will separate the street addresses, cities, states, and postal codes into individual columns.

Select the range C2:C11 and convert the text to columns. Use the comma check box as the delimiter and deselect other delimiters. Change width of column C to 25 and the width of column D to 13. 3
4 Now you want to separate the state abbreviations and zip codes.

Select the range E2:E11 and convert the text to columns. Deselect the comma delimiter and select the space delimiter. Do not import the first column. In cell F1, apply Align Right horizontal alignment.
4
5 The State Managers worksheet contains a list of managers. You will combine the names using the TEXTJOIN function.

Display the State Managers worksheet. In cell D2, insert the TEXTJOIN function to combine the names in the range A2:C2 using a space as a delimiter and ignore empty cells. Copy the function to the range D3:D5. 4
6 To improve the readability of the names, you will convert the text to upper- and lowercase.

In cell E2, insert the PROPER function for the text contained in cell D2. Copy the function to the range E3:E5. 3
7 You want to extract the area code from the phone number.

In cell H2, insert the LEFT function to extract the first three characters from the phone number in cell G2. Copy the function to the range H3:H5. 4
8 You will use the Database worksheet for the next several steps. You will set up criteria and output ranges, enter the criteria, and then apply the filter.

Display the Database worksheet. Copy the range A2:E2 and Use the Keep Source Column Widths paste option to paste the headings in cell G2. Paste another copy of the headings starting in cell G9. In cell I3, type UT, In cell J3, type 11/2/2024. In cell C2, display the Advanced Filter dialog box. Apply the settings to copy the records to another location, using the dataset in range A2:E52. Select the range G2:K3 as the the criteria range and select the range G9:K9 as the copy-to range. 8
9 You want to calculate total sales for the Utah stores for the week ending 11/2/2024.

In cell N2, insert the DSUM function for the range A2:E52. Type Gross Sales for the field and use the range G2:K3 as the criteria. 3
10 Next, you want to calculate the average sales for the Utah stores for the week ending 11/2/2024.

In cell N3, insert the DAVERAGE function using the same arguments that you used for the DSUM function in Step 9. 3
11 The next function will identify the highest gross sales for the Utah stores for the week ending 11/2/2024.

In cell N4, insert the DMAX function using the same arguments that you used for the DSUM function in Step 9. 3
12 Next, you will identify the lowest gross sales for the Utah stores for the week ending 11/2/2024.

In cell N5, insert the DMIN function using the same arguments that you used for the DSUM function in Step 9. 3
13 You want to count the records to ensure all three stores are being included in the summary.

In cell N6, insert the DCOUNT function using the same arguments that you used for the DSUM function in Step 9. 3
14 Finally, you want to display the gross sales for Salt Lake City for the week ending 10/5/2024.

In cell O9, insert the DGET function for the database. Type Gross Sales for the field and use the range M8:N9 as the criteria. In cell N9, type 10/5/2024. 3
15 For the next several tasks, you will use the Arrays worksheet. You want to create a list of all store locations so that you can familiarize yourself with the local demographics and analyze sales data.

Display the Arrays worksheet. In cell H3, insert the UNIQUE function for the array located in the range C3:D53. In cell H16, insert the UNIQUE function using the range C3:D53 as the array and ensure the results reflect only locations that occur exactly once. 6
16 Your next step is to add a record number for each row.

In cell A3, insert the ROW function using the range A3:A53 as the reference. The result should subtract the result of another ROW function that references A$2. 4
17 Now you want to identify the number of rows in the dataset.

In cell F1, insert the ROWS function using the range F3:F53 as the reference.
3
18 You want to create an array of the dataset sorted by city within their respective states.

In cell K3, insert the SORT function to sort the range B3:F53 by the second column. Edit the function by nesting this SORT function as the array within another SORT function. For the outer SORT function, sort by the third column. 4
19 You will use the results from the SORT function to create an array that is filtered to display data for only UT and CO.

In cell Q3, type CO. In cell R3, type UT. In cell Q7, insert the FILTER function using the range K3:O53. Include the range M3:M53 when it equals the state abbreviation in cell Q3 or in cell R3. In cell Q3, type TX. In cell R3 type NY. Edit the FILTER function in cell Q7 by displaying the text Invalid Criteria in the criteria are not met. In cell Q3, type CO. In cell R3, type UT. 6
20 The next task is to display an array of the top three sales values within the filtered array.

In cell U2, insert the LARGE function for the range U7:U60 and nest a SEQUENCE function as the K argument to return three values. 4
21 The results of the LARGE function should be formatted.

Apply Accounting Number Format with zero decimal places to the range U2:U4.
1
22 For the rest of the tasks, you will use the Lookup worksheet. Your first task is to identify the positions for cells containing a specific store number and a specific date.

Display the Lookup worksheet. In cell D2, insert the XMATCH function to look up the store number in cell B2, compare it to the range A7:A16. In cell D3, insert the XMATCH function to lookup the date in cell B3, compare it to the range C6:G6. In cell B2, type 215. In cell B3, type 10/26/2024. 6
23 You will nest an XMATCH function within an INDEX function to retrieve the sales for the week based on the position of the store number and date.

In cell G2, insert the INDEX function for the range C7:G16. Nest an XMATCH function that looks up the store number in cell B2, compares it to the range A7:A16 to identify the position of the store number. Nest an XMATCH function that lookups up the date in cell B3, compares it to the range C6:G6 to return the position of the date. 4
24 Next, you will use the ADDRESS function to identify the cell address for the sales returned by the INDEX function you previously inserted.

In cell G3, insert the ADDRESS function. Add the result of D3 to the result of a ROW function for cell A6 to return the row. Add the result of D3 to the result of the COLUMN function for cell B6 to return the column. Enter the appropriate code in the Abs argument to display a relative cell address. 4
25 You are ready to assign range names to the city data so that you can then use the range names in a function.

Select the range B7:G16 and create range names from the selection. Use the left column to create the range names. In cell I7, paste a list of the range names.

Mac users: Use the Insert menu, select Name, and then select the submenu options to paste a list of range names. 4
26 You are ready to use the range names in an INDIRECT function to retrieve data.

In cell G4, insert a SUM function with a nested INDIRECT function. Within the nested INDIRECT function that refers to cell B4. In cell B2, type 440. In cell B10, type Las_Cruces. In cell B15, type Salt_Lake_City. 4
27 Your final task is to document the formulas.

In cell J2, insert the FORMULATEXT function for cell D2. Copy the function to cell J3. In cell J4, insert the FORMULATEXT function for cell G2. Copy the function to the range J5:J6.
3
28 Save and close Exp22_Excel_Ch11_ HOE_Halloween.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100

Project 2: Ch12_HOE - Invoice 1.1

Project Description:
Recently, you took a position as the senior account manager at Wilhelmina's Total Lawn Care (WTLC), a lawn care company located in Leland, Michigan. WTLC specializes in full service lawn care ranging from landscaping to weekly maintenance. The previous manager used a paper-based system to prepare expense reports, invoices, and payroll statements. However, this was a time-consuming process and required manual recalculation when any values changed.

You want to start automating tasks using your extensive experience with Excel. You decide to start with the client invoice report form. Because each of the company's billing representatives utilizes the same procedures, you will adapt an Excel template to use as a model for creating invoices. The template needs to be generic enough to accommodate a range of options, but it also needs to maintain a standard design to facilitate easy data entry.

You will download an existing Excel invoice template, customize the template for your business needs, and inspect the worksheet for accessibility. Finally, you will create macros to perform a series of tasks, such as clearing the values to reset the form and finalizing the invoice for management approval.

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp22_Excel_Ch12_HOE_Invoice.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 The Invoice template provides the basic design you need, but you want to add your company's contact information. You also want to delete the sample data and remove the developer's data validation comments.
Make the following edits to the template:

Type Wilhelmina's Total Lawn Care in cell B2
Type Every Lawn Needs TLC in cell B3
Type Lot Area in cell C5
Type 1234 Caesar Parkway, Leland, MI 49654 in cell B27
Apply Italics format to cell B3
Delete the values in the range D6:D10 0
3 Continue editing the template by making the following structural changes.

Insert a row before row 1
Insert a column before column A
Set the column width of column A to 2
Add an outside border to the range B2:F28
Clear all data validation that was included in the original template
Rename the worksheet Customer Invoice 10
4 Prior to distributing your template, you want to remove all personal information. You will use the Document Inspector to complete the task.

Use the Document Inspector to remove all Document Properties and Personal Information.

Mac users, on the Excel menu, click Preferences and then click the Security icon. In the Security dialog box, click Remove personal information from this file on save. 5
5 The invoice will be sent electronically, and you want to make sure the Invoice template does not contain content that might cause difficulties for users. To ensure this document is compliant with accessibility standards, you will check accessibility.

Use the Accessibility Checker to check the template for issues. Once completed, make the following changes to improve the template's accessibility.

Unmerge the following ranges C27:D27, C28:D28, C4:C5, C2:F2, D12:E12, D13:E13, D6:E6.
Set the text in cell C2 to left alignment.
Type Due on: in cell D13.
10
6 You know that some of remote staff members are using Excel 2010. You want to make sure the workbook does not have critical features that might not display when opened with the older version of the software.

Use the Compatibility Checker to check the template for compatibility with Excel 2010-2016 versions.

Mac users, on the Tools menu (or the Review tab), click Check Accessibility. 0
7 You want to add notes to the template to provide instruction to your staff. To do this you will annotate the worksheet using comments.

Clear the contents of cell C13. Then add the following comments to the template.

Cell C13 - Enter Business or Residential
Cell E3 - Insert Date
Cell E6 - Use the custom area function to calculate lot area
Cell E13 - Business jobs are due in 30 days, all others due upon receipt 10
8 After inserting comments, you decide you will automate the insertion of the date in a later step. Therefore, you will remove the comment from cell E3. You also want to edit the comment in cell E13 to make a small grammatical change.

Delete the comment in cell E3.
Edit the comment in cell E13 to reflect the following changes Business jobs are due in 30 days. All others due upon receipt 4
9 For your last step, you want to hide the comments to reduce screen clutter. Once the comments are hidden, the comment indicators will still be visible.

Hide all comments in the template. 4
10 You do not want to assume the level of Excel expertise throughout your company; therefore, you want to craft a macro that will automate as much as possible. The macro you will create automatically clears existing values in the workbook. Although the template is empty to start, users might open the template, save a workbook, and then want to use that workbook to prepare more invoices. Therefore, you want the macro to clear cells even though the original template has no values. Once completed, save the workbook as a macro enabled template.

Record a macro named ClearInvoice. Add the description: This macro clears existing values in the current invoice. when creating the macro. When run, the macro should do the following:

Delete the values in the cells E6, C13, E13, and the ranges C7:C11 and C15:E25. After deleting the values, the macro should enter the following default values.

C7 = Name
C8 = Company Name
C9 = Street Address
C10 = City, ST Zip Code
C11 = Phone 0
11 You want to make sure the ClearInvoice macro does what you want it to do. You will add some sample data and run the macro.

Enter the following sample values, then run the ClearInvoice macro.

C8 = John Doe Inc.
C9 = 123 Sample Street
C10 = Leland, MI 49654
C11 = (231) 555-5555
0
12 Your sales reps may not be Excel experts and not know how to run a macro. To make it easier to clear values from the form, you want to assign the ClearInvoice macro to a button. The users can click the button to clear the form to use it for another customer. You will also add a button to be utilized later in the project.

Insert a Button (Form Control) in the range H2:J2. Edit the button label to display the text Clear Form and assign the ClearInvoice macro. Next insert a Button (Form Control) spanning the range H4:J5. Edit the button text to display the text Insert Date.

Type Customer Name in cell C7 and then click the Clear Form button to run the macro. 5
13 In order to use VBA to automatically insert and format the date, you will first create a new module. You will then use the range object to insert the current date and adjust the font property to bold the current date.

Create a new module in the VBA Editor named DateStamp. Enter the following code to create the desired sub procedure.

Sub DateStamp ()

'Unprotect worksheet for editing
Worksheets("Customer Invoice").Unprotect Password:="Expl0r!ng"

'Insert current date in cell E3
Range("E3")=Date

'Adds bold format to cell E3
Range("E3").Font.Bold=True

'Protects worksheet using the password Expl0r!ng
Worksheets("Customer Invoice").Protect Password:="Expl0r!ng"

End Sub

After entering the code exit the VBA Editor and run the macro to test your work.
0
14 After running the sub procedure, you decide that the inserted date should be italic instead of bold. You will make this change in the VBA Editor by changing the Italic property. You will also add a statement to the ClearInvoice Macro to unprotect the worksheet when clearing its data.

Open the DateStamp module in the VBA Editor. Locate the code Range("E3").Font.Bold=True and replace the word Bold with italic.

Next open Module 1. Press enter twice at the end of the first line (Ln1, Col9) and type the following code.

'Unprotect worksheet for editing.
Worksheets("Customer Invoice").Unprotect password:="Expl0r!ng"

After entering the code save and exit the VBA Editor. Next assign the DateStamp macro to form control button 2. 0
15 You decide to create a custom function to enable users to manually calculate the area of a yard being serviced.

Open the VBA Editor and create a new module named CustomFunction then enter the following code:

FunctionArea(Length,Width)

'This function will calculate the area of the lawn being serviced
Area = Length * Width

End Function

Save and exit the VBA Editor. Type =area(20,45) in cell E6 to test your work. 0
16 Insert a new worksheet named Code. 7
17 Open the VBA Editor, open the ClearInvoice module, and copy the code. Paste the code in the Code worksheet starting in cell A1 then remove any rows containing blank cells. When complete, the code block should appear continuous with no blank cells between lines. 15
18 Open the DateStamp module, and copy the code. Paste the code in the Code worksheet starting in cell A31 then remove any rows containing blank cells. When complete, the code block should appear continuous with no blank cells between lines. 15
19 Open the Function module, and copy the code. Paste the code in the Code worksheet starting in cell A44 then remove any rows containing blank cells. When complete, the code block should appear continuous with no blank cells between lines. 15
20 Close EXP22_Excel_Ch12_HOE_Invoice.xlsx. Be sure to save the copy as a .xlsx file, not a macro-enabled workbook. Exit Excel. Submit the .xlsx file as directed. 0

Project 3: Ch11_CumulativeAssessment_Accountants

Project Description:
You work for a tax accounting firm that has offices in Albany, Columbus, Dallas, and Miami. Previously, you downloaded data from the employee database. Now you will use text, database, array, and lookup functions to obtain the results you want.

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp22_Excel_Ch11_CumulativeAssessment_Accountants.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 You will use the Data worksheet through Step 14. Your first step is to create a unique ID for each accountant using the year hired, date hired, and number.

In cell D2, enter 2007-1018-10 and use Flash Fill to complete the pattern to create the remaining IDs in the range D3:D26. 5
3 The accountants' full names are located in column E. You want to separate the first and last names.

Select the range E2:E26 and convert text to columns using the space as the delimiter. 8
4 Next, you want to display the accountants' names with the last name and first name, separated by a comma.

In cell G2, insert the TEXTJOIN function to join the last name and first name for the first accountant, using a comma and space as the delimiter. The name should display as Adams, Camille. Copy the function to the range G3:G26. 6
5 Column J contains the phone numbers. You want to extract the area codes.

In cell K2, use the MID function to extract the area code for the phone number for the first employee. The Start_num argument should be the position of the first digit in the area code to avoid including the opening parenthesis. Make sure the function extracts the three-digit area code. Copy the function to the range K3:K26. 6
6 The Location column displays the city names in all capital letters. Because this is hard to read, you will use a text function to display the cities in upper and lowercase.

In cell M2, use the PROPER function to display the first city name in upper and lowercase. Copy the function to the range M3:M26. 5
7 You want to create a criteria range to perform an advanced filter. The criteria are (1) Tax Accountants in Miami and (2) Tax Accountants in Columbus.

Copy the range A1:M1 and paste it in the range A28:M28. Enter Tax Accountant and Miami in the respective cells on row 29. Enter Tax Accountant and Columbus in the respective cells on row 30. Use column M for the city names. 5
8 Now you are ready to perform the advanced filter by copying the data below the criteria range.

Select a cell within the dataset. Select A1:M26 as the list, enter the criteria range you defined in the previous step, and type A32:M32 for the location for the copied records. 5
9 You want to identify the highest salary for Tax Accountants in Miami and Columbus.

In cell P2, insert the DMAX function. 5
10 Next, you want to identify the lowest salary of Tax Accountants in Miami and Columbus.

In cell P3, insert the DMIN function. 5
11 The range O5:P6 contains a new set of criteria to identify the one Senior Accountant in Columbus. You want to obtain that person's salary.

In cell P8, insert the DGET function to extract the correct salary. 6
12 The range O10:P13 is designed to look up a person's name to return the salary for that person and the cell containing that salary. First, you will look up the person's salary within the dataset.

In cell P12, insert an INDEX function with nested XMATCH functions. Type F2:I26 as the array. The first nested XMATCH function looks up the name entered in cell P11 and compares it to the range containing the last names in the dataset. The second XMATCH function looks up the text "Salary" in cell O12 and compares it to the range F1:I1. In cell P11, type Unice to test that the function returns the correct salary. 7
13 Now that you have retrieved the salary for the accountant, you are ready to identify the cell that contains that salary.

In cell P13, insert the ADDRESS function with nested XMATCH functions. The first XMATCH function looks up the name entered in cell P11 and compares it to the range F1:F26. The second XMATCH function looks up the text "Salary" in cell O12 and compares it to the range A1:M1. Enter the argument value to display the result as a relative cell address. 6
14 You want to document three formulas on the Data worksheet.

In cell P16, insert the FORMULATEXT function to display the formula that is stored in cell P8.
In cell P17, insert the FORMULATEXT function to display the formula that is stored in cell P12.
In cell P18, insert the FORMULATEXT function to display the formula that is stored in cell P13.
6
15 The Summary worksheet is designed to look up the average salary for a specific city. Each city has its own worksheet. On each city worksheet, cell F15 contains the average salary for the accountants in that city.

Display the Summary worksheet. In cell B3, insert the INDIRECT function that uses the city in cell B2 (which matches a sheet tab). Insert the symbols to point to cell F15. The function should retrieve the value in cell F15. In cell B2, type Columbus to test that the function result is correct. 7
16 You will use the Accountants worksheet for the remaining tasks. That worksheet contains a simplified version of the dataset used on the Data worksheet. Your first task is to create a filtered list.

In cell H2, insert the FILTER function to filter the data in the dataset range A2:F26. The filter should evaluate if the data below the Title column heading equals Tax Accountant. 6
17 Next, you want to create an alphabetical list of the cities contained in the dataset.

In cell O2, insert a SORT function with a nested UNIQUE function to for the range of cities contained in the dataset. 6
18 Finally, you want to list the top five salaries for tax accountants.

In cell O14, insert a LARGE function with a nested SEQUENCE function. Use the range of salaries from the filtered list and create a sequence of the top five salaries. 6
19 Save and close Exp22_Excel_Ch11_CumulativeAssessment_Accountants.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100

Project 4: Ch12_CumulativeAssessment_Business_Travel_Budget

Project Description:
You are the operations manager for MLD Medical Sales. As part of your tasks, you prepare travel reports for the company's executives. To save time, you have decided to create a template that can
be used by employees that travel. To complete this task, you will create a worksheet based on an Office.com template; you will also use the Macro Recorder and Visual Basic for Application to automate
sorting and calculations within the workbook. Your last steps will be to annotate the template to provide user direction and check the document for accessibility and compatibility issues.

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named EXP22_Excel_Ch12_Cumulative_Budget.xltx. Grader has automatically added your last name to the beginning of the filename. 0
2 Delete the sample values in the range B6:E15 and cell D2. 0
3 Clear all existing data validation in the range A1:K15. 0
4 Record a macro named Sort, be sure to use relative references. Ensure the macro sorts the data in descending order based on Amount (column F). Stop the Macro Recorder and Save the workbook as a Macro-Enabled Template. 0
5 Create a form control button that spans the cell J4:L5. Assign the Sort macro and edit the button text to Sort. 7
6 Use the VBA Editor to create a new module.

Type the following VBA code to create a custom Mileage function then save and exit the VBA Editor (be sure to leave a blank line between each line and before End Function):

Function Mileage (Miles, Rate)

'This function will calculate mileage reimbursement

Mileage = Miles * Rate 0
7 Type Mileage Calculator in cell F4. 5
8 AutoFit the width of column F. 0
9 Click or select cell G4 and test the newly created mileage function by calculating the reimbursement amount for 45 miles traveled at a reimbursement rate of .75 per mile. Delete the value in cell G4 after testing the function. 0
10 Use the VBA Editor to create a new module named ProtectWorkbook. Type the following VBA statements to create the sub procedure (leave appropriate line spacing).

Sub ProtectWorkbook()

'Protect workbook using the password Expl0r!ng
Worksheets("Business Trip Budget").Protect Password:="Expl0r!ng" 0
11 Insert a new module named UnprotectWorkbook. Type the following VBA statements to create the sub procedure and then save and exit the VBA Editor (leave appropriate line spacing).

Sub UnprotectWorkbook()

'Unprotect workbook using the password Expl0r!ng
Worksheets("Business Trip Budget").Unprotect Password:="Expl0r!ng" 0
12 Insert a Form Control Button spanning cells J7:L8 named Unprotect. Assign the UnprotectWorkbook macro to the newly created Control Button. 7
13 Insert a Form Control Button spanning the range J10:L11 named Protect. Assign the macro ProtectWorkbook. 7
14 Insert the comment Enter target trip budget in cell D2, insert the comment Please contact your supervisor if over budget in cell D4, and Insert the comment Please use the custom function
=MILEAGE(MILES,RATE) in cell G4. 9
15 Inspect the document for private information and hidden properties. Remove Document Properties and Personal Information, and Headers and Footers. Do not remove Comments, Macros, Forms, and ActiveX Controls, or Custom XML Data.

Note: Mac users, from the Excel menu, open your preferences, click or select Security, and then click or select the check box to Remove personal information from this file on save. Delete any headers or footers in the workbook. 0
16 Check the document for accessibility issues. Use the Accessibility Checker pane to Unmerge the Merged Cells. 0
17 Use the Accessibility Checker pane to assign the Quick Style White Table Style Medium 1. 12
18 Insert a new worksheet named Code. 5
19 Open the VBA Editor, open Module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1. 12
20 In the VBA Editor, open the CustomFunction Module, and copy the code. Paste the code in the Code worksheet starting in cell A22. 12
21 In the VBA Editor, open the ProtectWorkbook, and copy the code. Paste the code in the Code worksheet starting in cell A30. 12
22 In the VBA Editor, open the UnprotectWorkbook module, and copy the code. Paste the code in the Code worksheet starting in cell A38. 12
23 Close the VBA Editor and save the workbook as an xlsx file (not Macro-Enabled). 0
24 Close EXP22_Excel_Ch12_Cumulative_Budget.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100