QBA CORE EXAM SET 2025/2026 QUESTIONS AND SOLUTION RATED A+

QBA CORE EXAM SET 2025/2026 QUESTIONS AND
SOLUTION RATED A+
✔✔Which of the following functions can be used to calculate monthly mortgage
payments for a house? - ✔✔PMT

✔✔The following is entered into cell C2: $B$2. If cell C2 is copied and pasted into cell
E3 which of the following will appear when cell E3 is double clicked. - ✔✔=$B$2

✔✔Which of the following functions can be used to calculate monthly payments for a
lease? - ✔✔PMT

✔✔Charles Minard's graphic analysis of Napolean's Russian campaign displays data in
how many dimensions? - ✔✔6

✔✔To apply the underline format to an activated cell, hold the CTRL key and tap which
of the following keys? - ✔✔U

✔✔Which of the following Ribbon tabs contains the Spell Check command? -
✔✔Review

✔✔To apply the Italics font to an activated cell, hold the CTRL key and tap which of the
following keys? - ✔✔I

✔✔Which of the following is one of the components of the DATA Analytics Framework?
- ✔✔Decisions

✔✔A dataset contains the following columns: Year, Month, and Total Sales Dollars. If a
PivotTable is going to becreated to sum the sales dollars by year, the Total Sales
Dollars field should be dragged into which area of thePivotTable? - ✔✔VALUES

✔✔Which of the following Ribbon tabs would be used to add a header or footer to a
worksheet? - ✔✔Insert

✔✔Which of the following is the first step of the DATA Analytics framework? -
✔✔Decision

✔✔Which of the following commands is used to center data horizontally in a cell? -
✔✔Center

, ✔✔Which of the following are true with respect to the grand totals displayed for columns
and rows on a PivotTable? - ✔✔The grand totals can be removed by clicking the Grand
Totals button in the Design tab of the Ribbon and making the desired selection.

✔✔Which of the following functions can be used to identify the highest value in a range
of cells? - ✔✔Max

✔✔The mouse pointer will turn into a black plus sign when it is dragged over the: -
✔✔Fill Handle

✔✔In time-series of money - ✔✔Units should be deflated and standardized

✔✔Anscombe's quartet demonstrates that - ✔✔Basic statistical measures can hide as
much as they reveal

✔✔To apply the bold font to an activated cell, hold the CTRL key and tap which of the
following keys? - ✔✔B

✔✔Which of the following is NOT one of the components of the DATA Analytics
Framework? - ✔✔Data Design

✔✔What is the center area of a chart that displays data and labels based on the type of
chart that is being created? - ✔✔Plot Area

✔✔Which of the following is where you would find commands to hide or unhide a
column? - ✔✔Home tab, Format Button

✔✔Which of the following is a valid reason for using the Paste Formulas command? -
✔✔when it is necessary to only paste a formula and not any formats that were applied
to the cells that were copied

✔✔Which of the following functions can be used to calculate monthly payments for a
lease? - ✔✔PMT

✔✔The number 10 is typed into the following cell locations: B2, B3, B4, and B5. The
following is typed into cellC7: =COUNT(B2:B5). Which of the following values will be
displayed in cell C7? - ✔✔4

✔✔If the [type] argument in the PMT function is defined with the number 1, which of the
following is true? - ✔✔The function will assume that payments will be made at the
beginning of each period.