DIT Final Exam Study Guide Questions with Correct Answers.

DIT Final Exam Study Guide Questions with Correct
Answers.
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