Exam (elaborations)
DIT Final Exam Study Guide Questions with Correct Answers.
- Course
- Institution
DIT Final Exam Study Guide Questions with Correct Answers.DIT Final Exam Study Guide Questions with Correct Answers.
[Show more]
Content preview
DIT Final Exam Study Guide Questions with CorrectAnswers.
Excel provides the tools to create which type of documents? - ANS Workbook
2. In Excel, the commands on each ribbon tab are organized into logical
command____________. - ANS groups
In Excel, where is the Fill handle located? - ANS in the right hand corner of a cell
Excel __________________ are files that include preset formatting and formulas. - ANS
Templates
In order to display all formulas in your worksheet in Excel, what do you do? - ANS
Command on Formulas tab
In Excel, which calculation would be performed first in this formula?(((3+1)*((2+2)-
2)*(1*1)))* (4+5) - ANS (2+2)
In Excel, any formula that includes cells whose values change should include what? -
ANS Cell Reference
In Excel, an absolute cell reference requires which symbol? - ANS $
In Excel, what is an absolute cell reference? - ANS $A$1
In Excel, what is meant by naming a range of cells? - ANS Enables you to find location
quickly
In Excel, which is the formula to add all cells in a range called SALES? - ANS =SUM
and =SUM
In Excel, which function quickly adds a contiguous range of cells? - ANS AutoSum
In Excel, which of the following is a predefined formula that performs a calculation? -
ANS Function
In Excel, what is the alternative to manually creating a formula? - ANS
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? - ANS Financial
In Excel, what separates a function containing multiple arguments? - ANS Comma
In Excel, what functions do not use arguments? - ANS 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? - ANS =YEAR(TODAY())-1975
19. In Excel, all formulas must start with what character(s)? - ANS =
In Excel, which is a valid syntax for the COUNT function? - ANS =COUNTA(A1:C38)
In Excel, which of the following formulas will find the average value between the range
of B7 and P7? - ANS =AVERAGE(B7:P7)
In Excel, when you insert a cell in a column, you force the other cells in the same
column to move________. - ANS Right
In Excel, when you insert a cell in a row, you force the other cells in the same row to the
__________. - ANS Down
In Excel, on the _____________________ tab in the Font menu in the Font group,
select the desired font to change the selected cells. - ANS Home
In Excel, which number format displays the default currency symbol with two decimal
places? - ANS Account and Counting
In Excel, in which group can you find the Paste Special command on the Home tab? -
ANS Clipboard
The Conditional Formatting menu is located in which group on the Home tab in Excel? -
ANS Styles
In Excel, which option on the Conditional Formatting menu provides access to the
Conditional Formatting Rules Manager dialog box? - ANS Manage Rules
How do you change the orientation of row or column data in Excel? - ANS Transpose
What can you do to keep the top row headers of a worksheet visible while you scroll
down the worksheet in
Excel? - ANS Freeze Panes
In Excel, what are the keystrokes for utilizing the Find command? - ANS Ctrl+F
In Excel, which function adds the cells in a range specified by a given criteria? - ANS
SUMIF
In Excel, what is the term for the values that a function uses to perform operations or
calculations? - ANS Arguments
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 Realler. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $21.49. 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