• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Exam (elaborations)

DIT Semester 2 Exam Study Guide || Guaranteed Pass!!!

Document preview thumbnail
Preview 1 out of 4 pages

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 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 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 (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 dollar sign $ In Excel, what is an absolute cell reference? correct answers absolute cell reference 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 You can create a named range in Excel for each data category, and then use that name instead of the cell references. In Excel, which is the formula to add all cells in a range called SALES? correct answers Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. 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 File Options Formulas Calculation options section Workbook Calculation. 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 a comma In Excel, what functions do not use arguments? correct answers RAND, TODAY, NOW 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


Document information

Uploaded on
June 7, 2024
Number of pages
4
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers
$10.19

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
ProPerfomer
3.8
(84)
Sold
452
Followers
322
Items
8858
Last sold
1 week ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card or EFT and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.