Business 201 Exam 1 | 50+ Q&A | Excel Functions, Finance, Depreciation, Data Analysis – 2025/2026 – Liberty University

This document is a complete and well-organized Exam 1 study guide for Business 201 – Introduction to Business Applications at Liberty University, designed for the 2025/2026 academic year. It includes 50+ graded and verified questions with answers, specifically focused on applied Excel functions, financial calculations, and data management skills critical for business students. Key topics covered include: Excel formulas and functions: COUNT, COUNTA, COUNTIF, ROUND, RANK, RANK.EQ, RANK.AVG Financial calculations: PMT (loan payments), PV and FV (present and future value), and their time-based parameters Depreciation functions: SLN (straight-line) and DB (declining balance) Error checking tools: Trace dependents, auditing formulas Statistical tools: STDEV.S and STDEV.P for standard deviation Logical and structured formula usage: Syntax rules, use of quotes in logical tests, function-specific requirements This resource is particularly useful for students in business, finance, accounting, economics, or any program involving Microsoft Excel proficiency and quantitative reasoning. It’s also beneficial for preparation for Excel-based assessments, MOS certifications, or course-related lab tests. Keywords: Excel functions, COUNT, COUNTA, COUNTIF, PMT, PV, FV, RANK, RANK.EQ, ROUND, STDEV.S, STDEV.P, SLN, DB, depreciation, loan calculation, business applications, Liberty University, Business 201, formula auditing, financial functions, data analysis