And create range names using the create from selection button tab

Print Info

	Week 1: Independent Project: Excel 2019 In Practice -Ch 2 Independent Project 2-4

COURSE NAMEBIS155 MAY21 Master | Data Analysis with Spreadsheets with Lab - 10037

File Needed: CentralSierra-02.xlsx(Available from the Start File link.)
Completed Project File Name: [your name]-CentralSierra-02.xlsx

Skills Covered in This Project

7. Set order of operations to
calculate total earnings.

8. Create and copy a SUMIF function to calculate total earnings by branch office.

10. Create and format the current date.

(Figure 2-101).

b.

Start the VLOOKUP function and use cell E6 as the

Use the second column as the col_index_num The range_lookup argument is empty.

f.

Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.

Center align cells H6:H20.

This study source was downloaded by 100000857982359 from CourseHero.com on 01-01-2023 00:46:51 GMT -06:00