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
Which Excel tab would you use to insert charts, pictures, or shapes into a worksheet?
Correct answer: B) Insert Tab
Explanation: The Insert Tab is used to add specialized elements like charts, pictures, or shapes to a workbook. The Home Tab is mainly used for formatting, the View Tab controls display settings, and the Data Tab manages data import and large datasets.
Question 2 of 50
Which of the following is a possible outcome when using Boolean logic in Excel?
Correct answer: B) Only the numbers 0 and 1
Explanation: Boolean logic in Excel results in binary values, specifically 0 for FALSE and 1 for TRUE. The other options refer to non-Boolean outputs.
Question 3 of 50
What does the Freeze Panes feature in Excel allow you to do?
Correct answer: B) Freeze a specific row above where you are working
Explanation: Freeze Panes in Excel allows you to freeze rows or columns so that they remain visible when scrolling through the worksheet. This is useful for large datasets.
Question 4 of 50
Which of the following functions would you use to sum a range of cells automatically?
Correct answer: B) =SUM()
Explanation: The =SUM() function adds together the values of a selected range of cells. =COUNT() counts the number of entries, =MAX() finds the highest value, and =PRODUCT() multiplies the values.
Question 5 of 50
Which formula will correctly calculate the commission dollars in cell C2 based on a 2% commission rate in cell A5 and sales value in cell B2?
Correct answer: B) =A5*B2
Explanation: To calculate commission, you need to multiply the sales figure in B2 by the commission rate in A5. The other formulas either add or incorrectly calculate percentages.
Question 6 of 50
Which Excel function is best used to calculate the correlation coefficient between hours of studying and test grades?
Correct answer: B) =SUM()
Explanation: The =CORREL() function is specifically used to calculate the correlation coefficient between two datasets, such as hours of studying and test grades.
Question 7 of 50
Which Excel tab includes tools to protect sheets and track changes in a workbook?
Correct answer: B) Review Tab
Explanation: The Review Tab contains options for protecting worksheets, tracking changes, and collaborating on a workbook.
Question 8 of 50
Which Excel function returns the present value of future cash flows?
Correct answer: B) =FV()
Explanation: The =PV() function calculates the present value of a series of future payments or investments. The other functions calculate future value, number of periods, and payments, respectively.
Question 9 of 50
Which function would you use to determine the number of periods needed to pay off a loan of $3,500 with monthly payments of $100 at 3% interest?
Correct answer: B) =NPER()
Explanation: The =NPER() function calculates the number of periods for an investment based on periodic payments and a constant interest rate.
Question 10 of 50
A manager wants to sort a table first by company name and then by sales dollars, from largest to smallest. What steps should they follow?
Correct answer: B) Click in the table, use the Sort option, select “Name” and then “Sales dollars”
Explanation: Sorting data can be done easily by using the Sort option in Excel, where you can choose multiple sorting criteria, such as sorting by name first and then by sales figures.
Question 11 of 50
Which function will count the number of responses that indicate an age in a survey dataset where non-respondents are marked with "N"?
Correct answer: B) =COUNT()
Explanation: The =COUNT() function will count the number of numeric entries, such as ages, while excluding non-numeric entries like "N" for no response.
Question 12 of 50
Which two options are available under the “Review” tab in the Excel ribbon?
Correct answer: A) Protect Sheet and Track Changes
Explanation: The Review tab provides tools to protect a sheet from changes and to track edits made by multiple users.
Question 13 of 50
Which Excel function would be used to find the number of jobs completed by a specific employee in a project table?
Correct answer: B) =COUNTIF()
Explanation: The =COUNTIF() function counts the number of cells that meet a specified condition, such as jobs completed by a particular employee.
Question 14 of 50
What is the main use of the CONCAT (or CONCATENATE) function in Excel?
Correct answer: B) To combine text from different cells
Explanation: The CONCAT (or CONCATENATE) function is used to join text from multiple cells into a single cell.
Question 15 of 50
A doctor’s assistant has a table of patient diagnoses and wants to filter the table to show only patients diagnosed with strep throat. What should they do?
Correct answer: B) Click the filter icon and select "Strep Throat" from the drop-down menu
Explanation: The Filter tool in Excel allows you to view only the rows that meet specific criteria, such as displaying only patients diagnosed with strep throat.
Question 16 of 50
Which formula will calculate the markup price in cell D4 for items with costs in cells C4 through C30, where the markup percentage is stored in cell A1?
Correct answer: B) =C4+$A1
Explanation: The correct formula adds the cost in C4 to the markup percentage in A1. The $ symbol ensures that A1 is treated as an absolute reference.
Question 17 of 50
A local golf course held a charity tournament and collected data on golfers' names, ages, handicaps, and scores. Which function will count the number of scores recorded?
Correct answer: B) =COUNT()
Explanation: The =COUNT() function will count the number of numeric entries in the score column.
Question 18 of 50
Which formula will show the result of TRUE when the sum of cells A1 through A4 equals 140?
Correct answer: B) =SUM(A1:A4)=140
Explanation: The =SUM(A1:A4)=140 formula checks if the sum of the values in cells A1 through A4 equals 140, returning TRUE if it does.
Question 19 of 50
Which Excel function returns the month from a date value?
Correct answer: A) =MONTH()
Explanation: The =MONTH() function extracts and returns the month component of a date.
Question 20 of 50
Which function in Excel provides the present value of an annuity based on periodic, constant payments and a constant interest rate?
Correct answer: B) =PV()
Explanation: The =PV() function calculates the present value of an annuity or loan based on constant periodic payments and a constant interest rate.
Question 21 of 50
Which Excel function returns the total number of children attending an event, where “N” is used to indicate no children?
Correct answer: C) =SUM()
Explanation: The =SUM() function adds up the numeric values, giving the total number of children attending, while excluding non-numeric values like "N."
Question 22 of 50
Which Excel function is used to display only the last 10 digits of an account number stored in cell A2?
Correct answer: B) =RIGHT()
Explanation: The =RIGHT() function extracts a specified number of characters from the right side of a text string, such as the last 10 digits of an account number.
Question 23 of 50
A salesperson tracks their appointments per month. Which formula will show if the goal of 10 appointments was met in January?
Correct answer: A) =IF(B2<10,"Did Not Meet Goal","Met Goal")
Explanation: This formula checks if the number of appointments in B2 is less than 10. If it is, the output will be "Did Not Meet Goal"; otherwise, it will be "Met Goal."
Question 24 of 50
Which of the following functions would you use to find the commission dollars in cells E5 through E20 if the commission rate is stored in B2?
Correct answer: A) =SUMIF(E5:E20,B2)
Explanation: The =SUMIF() function adds the values in a range (E5 through E20) based on a condition, such as the commission rate stored in B2.
Question 25 of 50
Which Excel formula will calculate the monthly interest rate on a loan, where F19 contains the loan balance and C13 contains the annual interest rate?
Correct answer: A) =F19*$C$13/12
Explanation: To calculate the monthly interest rate, divide the annual rate in C13 by 12 and multiply by the loan balance in F19.
Question 26 of 50
An Excel model contains employee salaries. Which function will calculate the total salary paid annually?
Correct answer: A) =SUM()
Explanation: The =SUM() function adds all the values in the salary column to provide the total annual salary paid.
Question 27 of 50
Which formula will result in the sum of sales values in cells B2 through B4?
Correct answer: D) All of the above
Explanation: All three options correctly add the sales values in B2, B3, and B4. The =SUM() function is commonly used, but the other options are also valid.
Question 28 of 50
Which Excel function calculates the future value of monthly payments of $100 over two years with a 5% interest rate?
Correct answer: A) =FV()
Explanation: The =FV() function calculates the future value of an investment or loan based on constant periodic payments and a fixed interest rate.
Question 29 of 50
Which chart type can be used to compare total sales over the last four years?
Correct answer: D) Both b) and c)
Explanation: Both Line Charts and Column Charts can effectively display trends over time, such as total sales over a period of years.
Question 30 of 50
Which Excel feature can you use to track changes made by other users in a shared workbook?
Correct answer: B) Track Changes
Explanation: The Track Changes feature allows users to track edits made by others in a shared Excel workbook.
Question 31 of 50
An analyst wants to know the position of a specific character in a text string. Which Excel function should they use?
Correct answer: B) =SEARCH()
Explanation: The =SEARCH() function returns the position of a specified character or substring within a text string.
Question 32 of 50
Which of the following is a feature of a PivotTable in Excel?
Correct answer: C) It can analyze large datasets by summarizing information in multiple ways
Explanation: PivotTables allow you to summarize, filter, and analyze large datasets by various metrics, such as sums, averages, and percentages.
Question 33 of 50
A manager wants to use Solver to maximize profit by changing the number of products produced, but wants to ensure that no more than the demand is met. What should the constraint be?
Correct answer: A) Produced <= Demand
Explanation: The constraint ensures that the number of products produced is less than or equal to the demand.
Question 34 of 50
Which function calculates the upper limit for a sales forecast if expected attendance is 18,000 people and a confidence interval has been set up?
Correct answer: D) =I16+J8
Explanation: This formula adds the calculated confidence interval (J8) to the forecasted sales (I16) to find the upper limit.
Question 35 of 50
In which situation would you use a circular reference in a spreadsheet model?
Correct answer: B) To calculate two dependent values simultaneously
Explanation: Circular references occur when two calculations depend on each other’s result and are used in certain advanced spreadsheet models.
Question 36 of 50
An owner wants to summarize all purchase data for Product A from four vendors using named ranges in separate tabs. Which formula should be used?
Correct answer: B) =SUM(V1PA+V2PA+V3PA+V4PA)
Explanation: The =SUM() function adds the values from all four named ranges (V1PA, V2PA, V3PA, V4PA) representing the purchases made for Product A.
Question 37 of 50
A mechanic uses the CORREL function to find the correlation coefficient of 0.234 between teenage drivers and car repairs. What can be inferred about the reliability of the forecast based on this correlation?
Correct answer: C) Unreliable
Explanation: A correlation coefficient of 0.234 indicates a weak relationship, making any forecast based on this correlation unreliable.
Question 38 of 50
Which feature of PivotTables allows you to add an additional filter to your data fields?
Correct answer: A) Slicer
Explanation: A Slicer is a visual filtering tool that allows you to filter data fields in a PivotTable easily.
Question 39 of 50
Which feature of Excel is most useful for comparing investment returns at different points in time using a chart?
Correct answer: B) Stacked Column Chart
Explanation: A Stacked Column Chart is ideal for comparing the proportion of different investments relative to the total portfolio over time.
Question 40 of 50
Which formula will determine the total sales made by Person B in May, where the data is organized in cells A1 through A5 (names) and B1 through B5 (sales)?
Correct answer: A) =SUMIF(A1:A5,"Person B",B1:B5)
Explanation: The =SUMIF() function adds the sales values from B1 through B5 for rows where the name is "Person B."
Question 41 of 50
Which formula calculates whether sales met the goal of $800 in cell B2?
Correct answer: C) =IF(B2>=800,"Met Goal","Did Not Meet Goal")
Explanation: This formula checks if the value in B2 is greater than or equal to 800, indicating whether the goal was met.
Question 42 of 50
A person wants to pay off a loan in five years by making $200 monthly payments. Which function will calculate the maximum annual interest rate?
Correct answer: C) =RATE()
Explanation: The =RATE() function calculates the interest rate on a loan given the number of periods, payments, and loan amount.
Question 43 of 50
A data validation rule needs to restrict user inputs to numbers from a specific list. Which setting should be selected?
Correct answer: C) List
Explanation: Data validation with the "List" option restricts user inputs to a predefined set of values.
Question 44 of 50
A person wants to buy a laptop with a maximum budget of $40 per month for 18 months. Which formula will help determine if the laptop priced at $700 is affordable?
Correct answer: A) =700/18<=40
Explanation: The formula divides the price of the laptop ($700) by the number of months (18) to check if the monthly payment is less than or equal to $40.
Question 45 of 50
Which feature in Excel should you use to combine multiple rows or columns into one line of text?
Correct answer: A) CONCAT
Explanation: The CONCAT function combines text from multiple cells into one cell, creating a single line of text.
Question 46 of 50
Which Excel function helps calculate the total operating expenses for a product by summing salaries, commissions, and fixed costs?
Correct answer: C) =SUM()
Explanation: The =SUM() function adds together the values for salaries, commissions, and fixed costs to calculate total operating expenses.
Question 47 of 50
An employee has been paid $250 per month for 36 months at an interest rate of 4.99%. Which function provides the present value of these payments?
Correct answer: A) =PV()
Explanation: The =PV() function calculates the present value of a series of future payments based on a constant interest rate and periodic payments.
Question 48 of 50
An Excel model needs to calculate the difference between the total amount paid over a loan period and the original loan amount. Which formula should be used?
Correct answer: C) =G12-ABS(C11)
Explanation: This formula calculates the total interest by subtracting the original loan amount (absolute value) from the total amount paid over the loan period.
Question 49 of 50
A doctor’s assistant tracks patient diagnoses and wants to filter for patients diagnosed with the flu. What Excel feature should they use?
Correct answer: A) Filter
Explanation: The Filter tool allows the assistant to display only the rows containing "Flu" in the diagnosis column.
Question 50 of 50
Which formula will provide the total number of products sold that have a quantity greater than or equal to 500 in a dataset?
Correct answer: A) =COUNTIF(C1:C6,">=500")
Explanation: The =COUNTIF() function counts the number of cells in the specified range (C1) that have a value greater than or equal to 500.
Set 1 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).