Exam (elaborations)
Accounting Proficiency Exam Questions With Correct Answers (A+)
- Course
- Institution
Accounting Proficiency Exam Questions With Correct Answers (A+)...
[Show more]
Content preview
Accounting Proficiency Exam Questions WithCorrect Answers (A+)
Add a Total row to this table and display the maximum value for the KD column. - Answer
On the Table Tools Design tab, in the Table Style Options group, click the Total Row
check box. Click in the KD column in the Total row, and select Max.
Modify the formula in cell B9 so the cell reference to cell B8 is an absolute reference if
the cell is copied. Answer Double-click cell B9 to edit the formula. Change the formula to
be =E2*$B$8. Press Enter.
Apply the Accounting Number Format to the selected cells. Answer On the Home tab, in
the Number group, click the Accounting Number Format button.
Change the Office background for the application to Calligraphy. - Answer Click the File
tab. Click Account. Click the Office Background drop-down list. Click Calligraphy.
Use Goal Seek to find the value for cell B3 that will return a value of $400 for cell B7.
Accept the solution. - Answer On the Data tab, in the Data Tools group, click the What-If
Analysis button, and click Goal Seek. In the To value box, enter 400. In the By changing
cell box, enter B3 Click OK Click OK.
In cell B3, create a formula using the VLOOKUP function to return the total sales for the
date in cell B2. Use the named range DailySales as the table_array argument. The total
sales is the fourth column in the lookup table, so use 4 for the col_index_num argument.
Because you want an exact match request the FALSE logical value for the range_lookup
argument. Click the Lookup & Reference button in the Function Library group on the
Formulas tab and click VLOOKUP. Type B2 in the Lookup_value argument box Type
DailySales in the Table_array argument box Type 4 in the Col_num argument box Type
False in the Range_lookup box Click OK.
This workbook includes two named ranges that happen to have the same name:
, BonusRate Restrict the scoped BonusRate to the Bonus worksheet only and rename it
to: BonusRange - Answer On the Formulas tab, in the Defined Names group, click the
Name Manager button. Click the first BonusRate name in the list then click the Edit¿
button. Type BonusRange in the Name box. Click OK. Click Close.
Delete this row. - Answer On the Home tab, in the Cells group, click the Delete button
arrow then click Delete Sheet Rows.
In cell H12, insert a formula that uses a counting function to count numbers in the Value
Received column (cells H2:H11). - Answer On the Formulas tab, in the Function Library
group, click the More Functions button. Then on the Statistical list, under More
Functions select COUNT, then Click OK.
Filter the City column so only the rows with Arnold are displayed. Answer On the Home
tab, in the Editing group, click the Sort & Filter button then click Filter. Click the arrow at
the top of the City column Click the (Select All) check box to de-select all the
checkmarks Click the check box in front of Arnold Click OK.
Apply the Comma Style number format to the selected cells. - Answer On the Home tab,
in the Number group, click the Comma Style button.
In cell H12, enter a formula to calculate the minimum percent of items received in order
for the range H2:H11. - Answer On the Formulas tab, in the Function Library group,
under AutoSum, click Min. Press Enter.
Use the Create from Selection command to create named ranges for the data table
B2:E5 based on the labels in row 1. Solution Click the Create from Selection button on
the Formulas tab in the Defined Names group. The Top row check box is selected by
default. Click OK.
Change the chart type to the first line option. ANSWER On the Chart Tools Design tab, in
the Type group, click the Change Chart Type button Click Line category at the left side
of the Change Chart Type dialog Click OK.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75057 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now