Uncategorized

Excel project 3

Be sure to save your work often!
Skills needed to complete this project:
Using Date and Time Functions (Skill 3.5)
Using CONCAT to Combine Text (Skill 3.8)
Formatting Text Using Functions (Skill 3.7)
Creating Formulas Using Counting Functions (Skill 3.6)
Using Formula AutoComplete to Enter Functions (Skill 3.2)
Displaying and Printing Formulas (Skill 3.20)
Naming Ranges of Cells (Skill 3.11)
Using the Logical Function IF (Skill 3.15)
Using the Function Arguments Dialog to Enter Functions (Skill 3.1)
Working with Named Ranges (Skill 3.12)
Finding Minimum and Maximum Values (Skill 3.4)
Calculating Averages (Skill 3.3)
Finding Data Using the VLOOKUP Function (Skill 3.17)
Checking Formulas for Errors (Skill 3.18)
Open the start file EX2019-SkillReview-3-2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it.
NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.
Take a look at the two sheets. The first sheet contains the students’ names and their scores. The second sheet will be used to look up the letter grade for each student.
On the Scores worksheet, enter a function in cell B3 to display the current date and time. If necessary, click the Scores worksheet tab. Click cell B3.
On the Formulas tab, in the Function Library group, click the Date