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 spreadsheet contains sales data for different months. Which formula will return the minimum monthly sales?
Correct answer: C) =MIN()
Explanation: Explanation: The =MIN() function returns the smallest value from a given range of cells, such as monthly sales.
Question 2 of 50
Which formula will correctly calculate the monthly interest for a loan if the loan balance is in F10 and the annual interest rate is in C5?
Correct answer: C) =F10*C5/12
Explanation: Explanation: To calculate the monthly interest, divide the annual interest rate by 12 and multiply it by the loan balance.
Question 3 of 50
A student wants to calculate the average exam score for students who scored above 75. Which formula should they use?
Correct answer: C) =AVERAGEIF()
Explanation: Explanation: The =AVERAGEIF() function calculates the average of values that meet a specified condition, such as scores above 75.
Question 4 of 50
A business owner wants to display only the sales data for the "Manufacturing" industry from a large table. Which Excel feature should they use?
Correct answer: B) Filter
Explanation: Explanation: The Filter feature allows the user to display only rows that meet certain criteria, such as filtering by the "Manufacturing" industry.
Question 5 of 50
Which Excel function would calculate the payment required for a $10,000 loan over five years with monthly payments of $200?
Correct answer: C) =PMT()
Explanation: Explanation: The =PMT() function calculates the payment for a loan based on constant payments and a constant interest rate.
Question 6 of 50
Which Excel function calculates the total number of periods required to pay off a loan if the loan amount is in C10 and monthly payments are in C11?
Correct answer: B) =NPER()
Explanation: Explanation: The =NPER() function calculates the number of periods required to pay off a loan based on regular payments and a constant interest rate.
Question 7 of 50
Which formula would calculate the monthly sales tax for each month, based on a 7% tax rate stored in cell B2 and total monthly sales in cells A1 through L1?
Correct answer: B) =SUM(A1:L1)*B2
Explanation: Explanation: This formula calculates the total sales tax by multiplying the sum of the sales by the tax rate stored in cell B2.
Question 8 of 50
A table contains data for employees and their total work hours. Which function will count the number of employees who worked more than 40 hours?
Correct answer: A) =COUNTIF(B1:B10,">40")
Explanation: Explanation: The =COUNTIF() function counts the number of cells in a range that meet a specified condition, such as employees who worked more than 40 hours.
Question 9 of 50
A manager needs to calculate the total sales for products that sold more than 500 units. Which formula will accomplish this?
Correct answer: B) =SUMIF(B1:B10,">500")
Explanation: Explanation: The =SUMIF() function sums the values in a range that meet a specified condition, such as products that sold more than 500 units.
Question 10 of 50
Which Excel function will return the last 5 digits from a text string in cell A2?
Correct answer: C) =RIGHT(A2,5)
Explanation: Explanation: The =RIGHT() function extracts the specified number of characters from the right side of a text string.
Question 11 of 50
A business owner tracks monthly revenue in columns A through L. Which formula will calculate the total revenue for the year?
Correct answer: A) =SUM(A1:A12)
Explanation: Explanation: The =SUM() function adds the values in a specified range, such as total revenue from columns A through L.
Question 12 of 50
Which Excel function counts the number of entries in a dataset that are greater than or equal to 100?
Correct answer: B) =COUNTIF()
Explanation: Explanation: The =COUNTIF() function counts the number of cells in a range that meet the specified condition, such as entries greater than or equal to 100.
Question 13 of 50
A doctor wants to count the number of patients diagnosed with "Allergy" in a dataset. Which function should they use?
Correct answer: B) =COUNTIF()
Explanation: Explanation: The =COUNTIF() function counts the number of cells in a range that contain a specific text, such as "Allergy."
Question 14 of 50
A client wants to calculate the total interest paid over the course of a loan. Which formula should they use?
Correct answer: A) =SUM(D1:D12)
Explanation: Explanation: The =SUM() function will add all the interest payments made over the duration of the loan.
Question 15 of 50
A manager needs to identify the highest sales amount for the year. Which formula will return the maximum value from a list of sales data?
Correct answer: B) =MAX()
Explanation: Explanation: The =MAX() function returns the highest value in a specified range, such as sales data for the year.
Question 16 of 50
A doctor wants to track how many patients have been diagnosed with "Flu" over the last 12 months. Which feature should they use to filter the data?
Correct answer: B) Filter
Explanation: Explanation: The Filter feature allows users to display only the rows that meet specific criteria, such as patients diagnosed with "Flu."
Question 17 of 50
A sales team tracks the total 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: Explanation: The =AVERAGE() function calculates the average of the values in a specified range, such as the total units sold each month.
Question 18 of 50
A student wants to calculate the percentage of total points they scored in a course. Which formula will return the correct percentage if their score is in cell A2 and the total points possible is in B2?
Correct answer: A) =A2/B2
Explanation: Explanation: This formula divides the student's score by the total points possible to calculate the percentage.
Question 19 of 50
Which Excel function returns the number of days between two dates?
Correct answer: B) =DAYS()
Explanation: Explanation: The =DAYS() function calculates the number of days between two given dates.
Question 20 of 50
A manager wants to calculate the gross profit for a product, which is the sales amount minus the cost of goods sold (COGS). Which formula will calculate this if sales are in C15 and COGS are in C16?
Correct answer: B) =C15-C16
Explanation: Explanation: This formula subtracts the cost of goods sold from the sales amount to calculate the gross profit.
Question 21 of 50
A student tracks their daily study hours and grades in Excel. Which function calculates the correlation coefficient between these two variables?
Correct answer: A) =CORREL()
Explanation: Explanation: The =CORREL() function returns the correlation coefficient between two datasets, indicating the strength and direction of the relationship between study hours and grades.
Question 22 of 50
A business wants to track sales performance for different products over time. Which Excel feature allows them to summarize sales data by product in a report?
Correct answer: A) PivotTable
Explanation: Explanation: PivotTables allow users to summarize large datasets by categories, such as sales by product, in a concise report.
Question 23 of 50
A business wants to protect certain cells in a worksheet from being modified by other users. Which feature should they use?
Correct answer: C) Protect Sheet
Explanation: Explanation: The Protect Sheet feature allows users to prevent others from editing specific parts of the worksheet.
Question 24 of 50
A manager wants to calculate the payment required for a $10,000 loan over five years with monthly payments of $200. Which formula will return the correct result?
Correct answer: C) =PMT()
Explanation: Explanation: The =PMT() function calculates the payment for a loan based on constant payments and a constant interest rate.
Question 25 of 50
A sales team wants to calculate the average sales for employees who met or exceeded their monthly sales target of $5,000. Which formula will accomplish this?
Correct answer: A) =AVERAGEIF(A1:A10,">=5000")
Explanation: Explanation: The =AVERAGEIF() function calculates the average of values that meet a specified condition, such as sales of $5,000 or more.
Question 26 of 50
A store wants to display the total sales for items that sold at least 300 units. Which formula should they use?
Correct answer: A) =SUMIF(A1:A10,">=300")
Explanation: Explanation: The =SUMIF() function adds up values that meet a specific condition, such as items that sold at least 300 units.
Question 27 of 50
A client wants to calculate the maximum amount they can borrow with $200 monthly payments for 3 years at a 5% interest rate. Which function will help them determine this?
Correct answer: A) =PV()
Explanation: Explanation: The =PV() function calculates the present value of future payments, which is useful for determining the maximum loan amount based on monthly payments.
Question 28 of 50
Which function will calculate the number of payments required to pay off a loan if the loan amount is $8,000 with monthly payments of $250 and an interest rate of 6%?
Correct answer: A) =NPER()
Explanation: 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 29 of 50
A sales manager wants to calculate the percentage of sales attributed to each salesperson. Which formula will calculate this if the product’s sales are in A1 and the total sales are in B1?
Correct answer: A) =A1/B1
Explanation: Explanation: This formula divides the sales for a specific product by the total sales to calculate the percentage contribution.
Question 30 of 50
A team tracks their performance against monthly targets. Which Excel feature would help display whether each employee met their target in a visual way?
Correct answer: A) Conditional Formatting
Explanation: Explanation: Conditional Formatting allows users to visually highlight cells that meet specified criteria, such as meeting or exceeding a target.
Question 31 of 50
A user wants to display the number of unique entries in a dataset. Which function should they use?
Correct answer: C) =COUNTA()
Explanation: Explanation: The =COUNTA() function counts the number of non-blank cells in a range, making it useful for counting unique entries.
Question 32 of 50
Which formula will return the current date in Excel?
Correct answer: C) =TODAY()
Explanation: Explanation: The =TODAY() function returns the current date, which updates whenever the worksheet is recalculated.
Question 33 of 50
A doctor wants to calculate the percentage of patients diagnosed with a specific illness. Which formula should they use if the total number of patients is in A1 and the number diagnosed with the illness is in B1?
Correct answer: B) =B1/A1
Explanation: Explanation: This formula divides the number of patients diagnosed with the illness by the total number of patients to calculate the percentage.
Question 34 of 50
Which feature in Excel allows users to prevent specific cells from being modified?
Correct answer: B) Protect Sheet
Explanation: Explanation: The Protect Sheet feature allows users to prevent others from editing certain cells in a worksheet.
Question 35 of 50
A manager wants to calculate the gross profit for a product if the sales amount is in C5 and the cost of goods sold is in C6. Which formula will return the correct result?
Correct answer: B) =C5-C6
Explanation: Explanation: This formula subtracts the cost of goods sold from the sales amount to calculate the gross profit.
Question 36 of 50
A doctor wants to track the percentage of patients diagnosed with a specific illness. Which formula should they use if the total number of patients is in A1 and the number diagnosed with the illness is in B1?
Correct answer: B) =B1/A1
Explanation: Explanation: This formula divides the number of patients diagnosed with the illness by the total number of patients to calculate the percentage.
Question 37 of 50
Which feature in Excel allows users to highlight cells that contain values meeting specific criteria, such as sales below a certain threshold?
Correct answer: A) Conditional Formatting
Explanation: Explanation: Conditional Formatting allows users to visually highlight cells that meet specified criteria.
Question 38 of 50
A manager wants to calculate the total commission for a salesperson if the sales amount is in C5 and the commission rate is in C6. Which formula will return the correct result?
Correct answer: A) =C5*C6
Explanation: Explanation: This formula multiplies the sales amount by the commission rate to calculate the total commission.
Question 39 of 50
Which function calculates the number of products sold based on the sales data in cells A1 through A10?
Correct answer: A) =COUNT(A1:A10)
Explanation: Explanation: The =COUNT() function counts the number of cells in a range that contain numbers, making it useful for counting products sold.
Question 40 of 50
A client wants to calculate the monthly payment for a loan. Which Excel function should they use?
Correct answer: A) =PMT()
Explanation: Explanation: The =PMT() function calculates the payment for a loan based on the interest rate, number of periods, and loan amount.
Question 41 of 50
A store wants to count the number of items sold that cost more than $50. Which function should they use?
Correct answer: A) =COUNTIF(A1:A10,">50")
Explanation: Explanation: The =COUNTIF() function counts the number of cells in a range that meet the specified condition, such as items sold for more than $50.
Question 42 of 50
A user wants to calculate the number of months it will take to pay off a loan of $20,000 with monthly payments of $500. Which function will return the correct result?
Correct answer: A) =NPER()
Explanation: Explanation: The =NPER() function calculates the number of periods required to pay off a loan based on regular payments, the interest rate, and the loan amount.
Question 43 of 50
Which Excel function calculates the total value of sales based on specific criteria, such as sales greater than $1,000?
Correct answer: A) =SUMIF()
Explanation: Explanation: The =SUMIF() function adds up the values in a specified range that meet specific criteria, such as sales greater than $1,000.
Question 44 of 50
A manager wants to calculate the total commissions paid to sales representatives if the commission percentage is stored in cell B5 and the sales amount is in B6. Which formula will return the correct result?
Correct answer: A) =B6*B5
Explanation: Explanation: This formula multiplies the sales amount by the commission percentage to calculate the total commission paid.
Question 45 of 50
A user wants to calculate the difference between two dates in terms of days. Which function should they use?
Correct answer: A) =DAYS()
Explanation: Explanation: The =DAYS() function calculates the number of days between two dates.
Question 46 of 50
A manager wants to calculate the total salary expenses for a project based on the number of employees required and the salary per employee. Which formula will return the correct result?
Correct answer: A) =C5*C6
Explanation: Explanation: This formula multiplies the number of employees by the salary per employee to calculate the total salary expenses.
Question 47 of 50
In a spreadsheet formula, which reference stays fixed when the formula is copied to other cells?
Correct answer: B) $A$1
Explanation: The dollar signs in $A$1 lock both the column and the row, making it an absolute reference that does not change when copied.
Question 48 of 50
Which function returns the average of the values in cells B2 through B10?
Correct answer: C) =AVERAGE(B2:B10)
Explanation: AVERAGE adds the numbers in the range and divides by how many numeric values there are.
Question 49 of 50
Which feature summarizes large amounts of data by grouping and aggregating it interactively?
Correct answer: A) PivotTable
Explanation: A PivotTable groups, totals and rearranges data, letting users summarize large datasets without writing formulas.
Question 50 of 50
What does the formula =IF(C2>=70,"Pass","Fail") return when C2 contains 65?
Correct answer: D) Fail
Explanation: The IF function returns the second argument when the test is true and the third when it is false. Since 65 is less than 70, it returns "Fail".
Set 4 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).