Create a flowchart that assigns a counselor to a student. You need to ask a student for the first letter of his/her last name. Assign a counselor based on the following criteria: • A through Mare assigned to Ms. Jones
• N through Z are assigned to Mr. Sanchez ​

What are some ways to use a range name in a formula? check all that apply. in the defined names group, click use in formula, and then select the desired name. begin typing the name in the formula, select a name from the autocomplete list, and use the arrow keys and tab key to enter the name in the formula. begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. right-click one of the cells in the range. click formula options, and use the dialog box to add the name.