Spreadsheet for Business Bangalore University B.com 1st Semester NEP Notes

Unit 1 Introduction {Book}
Introduction to spreadsheets, Office Suite overview	VIEW	VIEW
Basic Text and cell formatting		VIEW
Basic Arithmetic calculation, Special paste, Freeze pane		VIEW
Auto completion of Series, Sort and filter, Charts		VIEW

Unit 2 Summarize data using functions {Book}
Perform calculations by using the SUM function	VIEW
Perform calculations by using MIN and MAX function	VIEW
Perform calculations by using the COUNT function	VIEW
Perform calculations by using the AVERAGE function	VIEW
Perform logical operations by using the IF function	VIEW
Perform logical operations by using the SUMIF function	VIEW
Perform logical operations by using the AVERAGEIF function	VIEW
Perform statistical operations by using the COUNTIF function	VIEW

Unit 3 Text Functions {Book}
Data validation	VIEW
Text Functions: LEN, TRIM, PROPER, UPPER, LOWER, CONCATENATE	VIEW

One thought on “Spreadsheet for Business Bangalore University B.com 1st Semester NEP Notes”