Exam (elaborations)
DIT FINAL EXAM STUDY GUIDE WITH 100% VERIFIED SOLUTIONS
- Course
- Institution
DIT FINAL EXAM STUDY GUIDE WITH 100% VERIFIED SOLUTIONS
[Show more]
Content preview
DIT FINAL EXAM STUDY GUIDE WITH100% VERIFIED SOLUTIONS
Define: Resampling CORRECT ANSWERS __Changing the pixel dimensions of an
image is called resampling.__
What type of chart should be used for analyzing trends in Excel? CORRECT
ANSWERS __Line chart______________________________
Excel provides the tools to create which type of documents CORRECT ANSWERS
__workbooks______________________________
In Excel, the commands on each ribbon tab are organized into logical command
CORRECT ANSWERS groups
In Excel, where is the Fill handle located CORRECT ANSWERS bottom right cell of the
selected cells
Excel templates are files that include present formatting and formulas CORRECT
ANSWERS formatting and formulas
In order to display all formulas in your worksheet in Excel, what do you do CORRECT
ANSWERS Click the SHow formulas command button on the formulas tab
In Excel, which calculation would be performed first in this formula?(((3+1)*((2+2)-
2)*(1*1)))* (4+5) CORRECT ANSWERS Everything in the parenthesis
In Excel, any formula that includes cells whose values change should include what
CORRECT ANSWERS cell reference
In Excel, an absolute cell reference requires which symbol? CORRECT ANSWERS
dollar sign
In Excel, what is an absolute cell reference? CORRECT ANSWERS is one that does
not change when it's moved, copied or filled
In Excel, what is meant by naming a range of cells? CORRECT ANSWERS it makes it
easier to refer back to the data in excel
In Excel, which function quickly adds a contiguous range of cells? CORRECT
ANSWERS ___AUTOSUM_________________________
In Excel, which of the following is a predefined formula that performs a calculation?
CORRECT ANSWERS _function_____________
, In Excel, if you want to calculate how much interest you will pay on your mortgage,
which function icon would you click in the Formulas tab? CORRECT ANSWERS
Financial hjh
In Excel, what separates a function containing multiple arguments CORRECT
ANSWERS _comma_______________________________
In Excel, what functions do not use arguments? __ CORRECT ANSWERS TODAY, and
DATE______
In Excel, which of the following is a valid TODAY formula to calculate the number of
years you have lived if you were born in 1975? ______ CORRECT ANSWERS
=YEAR(TODAY())-1975
In Excel, all formulas must start with what character(s)? CORRECT ANSWERS equal
sign =
In Excel, which is a valid syntax for the COUNT function? CORRECT ANSWERS
=COUNT(A1:C38)
In Excel, which of the following formulas will find the average value between the range
of B7 and P7? CORRECT ANSWERS =AVERAGE(B7:P7)
In Excel, when you insert a cell in a column, you force the other cells in the same
column to move CORRECT ANSWERS down
In Excel, when you insert a cell in a row, you force the other cells in the same row to the
CORRECT ANSWERS right
In Excel, on the _________________________________ tab in the Font menu in the
Font group, select the desired font to change the selected cells. CORRECT ANSWERS
home _
In Excel, which number format displays the default currency symbol with two decimal
places? CORRECT ANSWERS currency
In Excel, in which group can you find the Paste Special command on the Home tab?
CORRECT ANSWERS __clipboard___
The Conditional Formatting menu is located in which group on the Home tab in Excel?
CORRECT ANSWERS __ Styles group______________
In Excel, which option on the Conditional Formatting menu provides access to the
Conditional Formatting Rules Manager dialog box? ____ CORRECT ANSWERS
Manage Rules
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 ElevatedExcellence. 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