Exam (elaborations)
DIT Final Exam Study Guide Questions And Answers
- Course
- Institution
DIT Final Exam Study Guide Questions And Answers
[Show more]
Content preview
DIT Final Exam Study Guide QuestionsAnd Answers
Excel provides the tools to create which type of documents? CORRECT ANSWERS
Workbook
2. 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 in the right hand
corner of a cell
Excel __________________ are files that include preset formatting and formulas.
CORRECT ANSWERS Templates
In order to display all formulas in your worksheet in Excel, what do you do? CORRECT
ANSWERS Command on Formulas tab
In Excel, which calculation would be performed first in this formula?(((3+1)*((2+2)-
2)*(1*1)))* (4+5) CORRECT ANSWERS (2+2)
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 $
In Excel, what is an absolute cell reference? CORRECT ANSWERS $A$1
In Excel, what is meant by naming a range of cells? CORRECT ANSWERS Enables
you to find location quickly
In Excel, which is the formula to add all cells in a range called SALES? CORRECT
ANSWERS =SUM and =SUM
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, what is the alternative to manually creating a formula? CORRECT ANSWERS
, 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
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
19. In Excel, all formulas must start with what character(s)? CORRECT ANSWERS =
In Excel, which is a valid syntax for the COUNT function? CORRECT ANSWERS
=COUNTA(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 Right
In Excel, when you insert a cell in a row, you force the other cells in the same row to the
__________. CORRECT ANSWERS Down
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 Account and Counting
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
In Excel, which option on the Conditional Formatting menu provides access to the
Conditional Formatting Rules Manager dialog box? CORRECT ANSWERS Manage
Rules
How do you change the orientation of row or column data in Excel? CORRECT
ANSWERS Transpose
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 $10.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