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
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
