50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
A manager needs to know how many employees worked fewer than 40 hours in a week. Which formula will provide this information?
Correct answer: B) =COUNTIF(A1:A10,"<40")
Explanation: The =COUNTIF() function counts the number of cells that meet a specified condition, such as employees who worked fewer than 40 hours.
Question 2 of 50
Which Excel function would you use to return the day of the month from a date stored in cell A2?
Correct answer: B) =DAY()
Explanation: The =DAY() function extracts the day portion from a date in a specific cell.
Question 3 of 50
A business owner wants to calculate the future value of monthly savings of $200 over 5 years with a 3% interest rate. Which function should they use?
Correct answer: B) =FV()
Explanation: The =FV() function calculates the future value of regular periodic payments based on a constant interest rate.
Question 4 of 50
A manager wants to determine the total number of items sold that exceeded 100 units. Which formula should they use?
Correct answer: B) =COUNTIF(A1:A10,">100")
Explanation: The =COUNTIF() function counts the number of cells in a range that meet a specified condition, such as items sold that exceeded 100 units.
Question 5 of 50
Which formula will calculate the difference between total sales in cells A1 and B1?
Correct answer: B) =B1-A1
Explanation: This formula subtracts the sales value in cell A1 from the value in cell B1 to calculate the difference.
Question 6 of 50
Which Excel function would calculate the number of periods required to pay off a loan with monthly payments of $300 and a 5% annual interest rate?
Correct answer: A) =NPER()
Explanation: The =NPER() function calculates the number of periods required to pay off a loan based on regular payments, interest rate, and loan amount.
Question 7 of 50
A client wants to calculate the total value of sales for all products that sold more than 500 units. Which function should they use?
Correct answer: B) =SUMIF()
Explanation: The =SUMIF() function sums the values in a specified range that meet a specific condition, such as products that sold more than 500 units.
Question 8 of 50
A student wants to calculate the number of days between two dates stored in cells A1 and A2. Which function will provide this result?
Correct answer: B) =DAYS()
Explanation: The =DAYS() function calculates the number of days between two dates.
Question 9 of 50
Which Excel function will count the number of non-blank cells in a range?
Correct answer: B) =COUNTA()
Explanation: The =COUNTA() function counts the number of non-blank cells in a specified range.
Question 10 of 50
A doctor wants to count the number of patients diagnosed with "Flu" from a dataset. Which Excel feature will help achieve this?
Correct answer: A) Filter
Explanation: The Filter feature allows the user to display only rows that meet specific criteria, such as filtering for patients diagnosed with "Flu."
Question 11 of 50
Which Excel function will return the first 3 characters of a text string in cell A2?
Correct answer: C) =LEFT(A2,3)
Explanation: The =LEFT() function extracts the specified number of characters from the beginning of a text string.
Question 12 of 50
Which formula will calculate the total loan payments made if the monthly payment is in C10 and the number of months is in C11?
Correct answer: B) =C10*C11
Explanation: This formula multiplies the monthly payment by the total number of months to calculate the total loan payments.
Question 13 of 50
Which Excel function would be used to calculate the number of months required to pay off a $12,000 loan with monthly payments of $500 and a 4% annual interest rate?
Correct answer: A) =NPER()
Explanation: The =NPER() function calculates the number of periods required to pay off a loan based on regular payments and interest rate.
Question 14 of 50
A student needs to calculate the percentage of total points scored in a course. Which formula will return the correct percentage if their score is in cell A2 and the total possible points are in B2?
Correct answer: A) =A2/B2
Explanation: This formula divides the student's score by the total possible points to calculate the percentage.
Question 15 of 50
Which feature in Excel allows users to highlight cells based on specific conditions, such as highlighting sales over $5,000?
Correct answer: A) Conditional Formatting
Explanation: Conditional Formatting allows users to apply formatting, such as color-coding, to cells that meet specified conditions, such as sales over $5,000.
Question 16 of 50
A company wants to summarize sales data for different regions in a report. Which Excel feature would allow them to filter the report by region?
Correct answer: A) Slicer
Explanation: Slicers provide a visual interface to filter data in reports or PivotTables by specific categories, such as region.
Question 17 of 50
A manager tracks monthly sales in cells A1 through L1. Which formula will return the maximum sales value?
Correct answer: C) =MAX(A1:L1)
Explanation: The =MAX() function returns the highest value in a specified range, such as sales data from cells A1 through L1.
Question 18 of 50
A user needs to calculate the total number of unique entries in a dataset. Which Excel function will help?
Correct answer: B) =COUNTA()
Explanation: The =COUNTA() function counts the number of non-blank cells in a specified range, making it useful for counting unique entries.
Question 19 of 50
A sales manager needs to calculate the commission earned by a salesperson. The sales amount is in cell A5 and the commission rate is in cell B5. Which formula will calculate the total commission?
Correct answer: A) =A5*B5
Explanation: This formula multiplies the sales amount by the commission rate to calculate the total commission earned.
Question 20 of 50
Which Excel feature allows users to restrict the type of data that can be entered into specific cells?
Correct answer: A) Data Validation
Explanation: Data Validation allows users to set rules that limit the type of data that can be entered into specific cells.
Question 21 of 50
A business owner wants to track monthly sales performance for multiple products. Which Excel feature allows them to summarize the data in a report?
Correct answer: A) PivotTable
Explanation: PivotTables allow users to summarize large datasets by categories, such as sales by product, in a concise report.
Question 22 of 50
Which formula will return the current date and time in Excel?
Correct answer: C) =NOW()
Explanation: The =NOW() function returns the current date and time, which updates whenever the worksheet is recalculated.
Question 23 of 50
A company wants to calculate the total interest paid over the course of a loan. Which function should they use?
Correct answer: A) =SUM()
Explanation: The =SUM() function will add up all interest payments made over the duration of the loan.
Question 24 of 50
Which formula will count the number of times the word "Completed" appears in a range of cells from A1 to A10?
Correct answer: A) =COUNTIF(A1:A10,"Completed")
Explanation: The =COUNTIF() function counts the number of cells in a range that contain a specific text, such as "Completed."
Question 25 of 50
A team wants to track the number of projects completed on time. Which Excel feature will allow them to filter the data by project status?
Correct answer: A) Filter
Explanation: The Filter feature allows users to display only rows that meet specific criteria, such as filtering by project status.
Question 26 of 50
Which Excel formula will display "Passed" if a student’s score in cell A2 is greater than or equal to 70 and "Failed" otherwise?
Correct answer: A) =IF(A2>=70,"Passed","Failed")
Explanation: The =IF() function checks if a condition is met and returns one value if true and another value if false.
Question 27 of 50
A store wants to calculate the total sales for products that sold more than 300 units. Which formula should they use?
Correct answer: B) =SUMIF(A1:A10,">300")
Explanation: The =SUMIF() function adds up values that meet a specified condition, such as products that sold more than 300 units.
Question 28 of 50
A manager needs to calculate the number of employees who worked more than 40 hours in a week. Which function will provide this information?
Correct answer: A) =COUNTIF(A1:A10,">40")
Explanation: The =COUNTIF() function counts the number of cells in a range that meet a specific condition, such as employees who worked more than 40 hours.
Question 29 of 50
A sales team tracks the number of units sold each month. Which formula will calculate the average number of units sold per month?
Correct answer: B) =AVERAGE(A1:A12)
Explanation: The =AVERAGE() function calculates the average of the values in a specified range, such as the total units sold each month.
Question 30 of 50
Which formula will calculate the total interest paid on a loan if the monthly interest payments are in cells D1 through D12?
Correct answer: A) =SUM(D1:D12)
Explanation: The =SUM() function adds up all the interest payments in the specified range.
Question 31 of 50
Which function calculates the total value of sales based on a specific condition, such as sales greater than $1,000?
Correct answer: A) =SUMIF()
Explanation: The =SUMIF() function adds up the values in a specified range that meet a specific condition, such as sales greater than $1,000.
Question 32 of 50
A client wants to calculate the number of months required to pay off a $15,000 loan with monthly payments of $500 and an interest rate of 5%. Which function should they use?
Correct answer: A) =NPER()
Explanation: The =NPER() function calculates the number of periods required to pay off a loan based on regular payments, the interest rate, and loan amount.
Question 33 of 50
A sales manager tracks monthly sales in cells A1 through L1. Which formula will return the minimum sales value?
Correct answer: C) =MIN(A1:L1)
Explanation: The =MIN() function returns the lowest value in a specified range, such as sales data from cells A1 through L1.
Question 34 of 50
A business owner tracks the number of customers who visit their store each month. Which formula will calculate the average number of customers per month?
Correct answer: B) =AVERAGE(A1:A12)
Explanation: The =AVERAGE() function calculates the average of the values in a specified range, such as the total number of customers each month.
Question 35 of 50
A financial analyst needs to calculate the present value of a series of monthly payments. Which Excel function will provide this information?
Correct answer: D) =PV()
Explanation: The =PV() function calculates the present value of future payments based on a constant interest rate.
Question 36 of 50
Which formula will calculate the total loan amount if the monthly payment is in cell C5 and the number of months is in cell C6?
Correct answer: B) =C5*C6
Explanation: This formula multiplies the monthly payment by the number of months to calculate the total loan amount.
Question 37 of 50
A team wants to calculate the total number of hours worked on a project. Which Excel function should they use?
Correct answer: B) =COUNT()
Explanation: The =SUM() function adds up the values in a specified range, such as the total hours worked on a project.
Question 38 of 50
Which feature in Excel allows users to visualize data differences in a chart by adding labels to indicate what each color represents?
Correct answer: B) Data Validation
Explanation: A Legend in a chart provides information about what different colors or symbols represent, helping to distinguish between data categories.
Question 39 of 50
A student wants to calculate the average test score for students who scored above 80. Which function will help achieve this?
Correct answer: B) =SUMIF(A1:A10,">80")
Explanation: The =AVERAGEIF() function calculates the average of values in a range that meet a specified condition, such as test scores above 80.
Question 40 of 50
A user wants to extract the last 5 characters from a text string in cell A1. Which function should they use?
Correct answer: C) =RIGHT(A1,5)
Explanation: The =RIGHT() function extracts the specified number of characters from the right side of a text string.
Question 41 of 50
A company wants to prevent users from entering incorrect data into a specific cell. Which Excel feature should they use?
Correct answer: A) Data Validation
Explanation: Data Validation allows users to set rules that restrict the type of data that can be entered into specific cells.
Question 42 of 50
A manager needs to calculate the total commissions paid to sales representatives based on the sales amount in column B and the commission rate in column C. Which formula will calculate the total commission for a salesperson?
Correct answer: B) =SUM(B5,C5)
Explanation: This formula multiplies the sales amount by the commission rate to calculate the total commission.
Question 43 of 50
A business wants to summarize monthly sales data for each product in a report. Which Excel feature allows them to organize and filter this data by product?
Correct answer: B) Slicer
Explanation: PivotTables allow users to organize and filter data, such as summarizing sales by product, in a report format.
Question 44 of 50
A financial analyst needs to forecast future sales based on past performance. Which function should they use?
Correct answer: B) =FORECAST()
Explanation: The =FORECAST() function predicts future values based on past data, making it ideal for estimating future sales.
Question 45 of 50
Which formula will return "Yes" if a value in cell A1 is greater than 50 and "No" if it is less than or equal to 50?
Correct answer: A) =IF(A1>50,"Yes","No")
Explanation: The =IF() function checks if a condition is met and returns one value if true and another if false.
Question 46 of 50
A store owner wants to calculate the total number of items sold for each product. Which Excel feature will allow them to summarize the sales data in a report?
Correct answer: B) Data Validation
Explanation: PivotTables allow users to summarize large datasets, such as total items sold for each product, in a concise report format.
Question 47 of 50
A user needs to calculate the total sales for each region in a report. Which feature in Excel allows them to filter the data by region?
Correct answer: B) Conditional Formatting
Explanation: Slicers provide an interactive way to filter data by specific categories, such as region, in reports or PivotTables.
Question 48 of 50
A client wants to calculate how much money they will have after making monthly savings deposits for 10 years with an interest rate of 3%. Which Excel function should they use?
Correct answer: B) =PV()
Explanation: The =FV() function calculates the future value of an investment based on periodic payments and a constant interest rate.
Question 49 of 50
A manager needs to calculate the total number of orders that exceeded $1,000 in value. Which function should they use?
Correct answer: A) =COUNTIF()
Explanation: The =COUNTIF() function counts the number of cells in a range that meet a specified condition, such as orders that exceeded $1,000 in value.
Question 50 of 50
A user wants to calculate the total revenue for each product in a table, based on the product’s price and the number of units sold. Which formula will provide the correct result?
Correct answer: D) =AVERAGE(B1,C1)
Explanation: This formula multiplies the product’s price by the number of units sold to calculate the total revenue.
Set 5 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).