CIS 30 Excel - Final Exam prep
Questions with Correct Answers
The __________feature automatically adjusts a column width or row height to
accommodate its widest or tallest entry. - ANSWERSAutoFit
Number data is any number that can be used in a mathematical calculation. -
ANSWERSTrue
What function would you enter to add the values in cells B4, B5, and B6? -
ANSWERS=SUM(B4:B6)
What is the result of the expression =50+20/10*5-2? - ANSWERS58
Cell E11 contains the formula = SUM(E1:E10). How is the formula adjusted when a new
row inserted above row 5? - ANSWERS=SUM(E1:E11)
To count cells containing non-numeric data such as text strings, you need to use the
___________ function. - ANSWERSCOUNTA
What is the range reference for the block of cells from A5 through F8 _________. -
ANSWERSA5:F8
________ makes it easier to enter repetitive text in cells. - ANSWERSAutoComplete
The formula to divide the value in cell C9 by the value in cell B9 is ___________. -
ANSWERS=C9/B9
To change the order of operations, enclose part of the formula in ______________. -
ANSWERSparentheses
Changing the number of decimal places displayed in a cell does not change the value
stored in the cell. - ANSWERSTrue
In Excel, dates are _________-aligned in the cell by default, regardless of date format. -
ANSWERSright
One way to ensure that you are using consistent formats is to copy and paste your
formats using Format __________. - ANSWERSPainter
Italic, bold, bold italic, and underline are examples of ________________. -
ANSWERSfont styles
, ___________ is the process of changing a workbook's appearance by defining the
fonts, styles, colors, and decorative features. - ANSWERSFormatting
A _________ format applies formatting only when a cell's value meets a specified
condition. - ANSWERSconditional
In a worksheet you can select the cells you want to print and then define them as a
________ area. - ANSWERSprint
A cell containing a number displays #####, why does this occur? - ANSWERSThe
number of digits could not fit within the width of the cell.
You can repeat information, such as company name, by specifying which rows or
columns in the worksheet act as ____________ , information that prints on each page. -
ANSWERSprint titles
The range A1:H1 is merged into a single cell. What is the cell reference of this merged
cell? - ANSWERSA1
When you copy a formula that contains an absolute reference to a new location, the
reference changes. - ANSWERSFalse
_________ functions find values in tables of data and insert them in another location in
the worksheet such as cells or formulas. - ANSWERSLOOKUP
Fill handle copies ________. - ANSWERScontent and formats
The conditional formula: =IF(G22="x",SUM(H22:J22), "") will display ________ if G22 is
not equal "x". - ANSWERSa blank cell
The first three selected values in a series are 3, 6, and 9. What are the next three
values that will be inserted using AtuoFill? - ANSWERS12,15,18
What formula would you use to display the text string "Yes" if the value in cell A1 is
greater than the value in cell B1 and "No" if otherwise? - ANSWERS=IF(A1>B1, "Yes",
"No")
Provide the formula to perform an exact match lookup with the lookup value from cell
G5 using lookup table located in range A1:F5. Return the value from the third column of
the table: _______________. - ANSWERS=VLOOKUP(G5,A1:F5,3,FALSE)
Cell B2 contains the formula, =SUME(A1:A100), with the name of the SUM function
misspelled as SUME. What error value will appear in the cell? - ANSWERS#NAME?
Questions with Correct Answers
The __________feature automatically adjusts a column width or row height to
accommodate its widest or tallest entry. - ANSWERSAutoFit
Number data is any number that can be used in a mathematical calculation. -
ANSWERSTrue
What function would you enter to add the values in cells B4, B5, and B6? -
ANSWERS=SUM(B4:B6)
What is the result of the expression =50+20/10*5-2? - ANSWERS58
Cell E11 contains the formula = SUM(E1:E10). How is the formula adjusted when a new
row inserted above row 5? - ANSWERS=SUM(E1:E11)
To count cells containing non-numeric data such as text strings, you need to use the
___________ function. - ANSWERSCOUNTA
What is the range reference for the block of cells from A5 through F8 _________. -
ANSWERSA5:F8
________ makes it easier to enter repetitive text in cells. - ANSWERSAutoComplete
The formula to divide the value in cell C9 by the value in cell B9 is ___________. -
ANSWERS=C9/B9
To change the order of operations, enclose part of the formula in ______________. -
ANSWERSparentheses
Changing the number of decimal places displayed in a cell does not change the value
stored in the cell. - ANSWERSTrue
In Excel, dates are _________-aligned in the cell by default, regardless of date format. -
ANSWERSright
One way to ensure that you are using consistent formats is to copy and paste your
formats using Format __________. - ANSWERSPainter
Italic, bold, bold italic, and underline are examples of ________________. -
ANSWERSfont styles
, ___________ is the process of changing a workbook's appearance by defining the
fonts, styles, colors, and decorative features. - ANSWERSFormatting
A _________ format applies formatting only when a cell's value meets a specified
condition. - ANSWERSconditional
In a worksheet you can select the cells you want to print and then define them as a
________ area. - ANSWERSprint
A cell containing a number displays #####, why does this occur? - ANSWERSThe
number of digits could not fit within the width of the cell.
You can repeat information, such as company name, by specifying which rows or
columns in the worksheet act as ____________ , information that prints on each page. -
ANSWERSprint titles
The range A1:H1 is merged into a single cell. What is the cell reference of this merged
cell? - ANSWERSA1
When you copy a formula that contains an absolute reference to a new location, the
reference changes. - ANSWERSFalse
_________ functions find values in tables of data and insert them in another location in
the worksheet such as cells or formulas. - ANSWERSLOOKUP
Fill handle copies ________. - ANSWERScontent and formats
The conditional formula: =IF(G22="x",SUM(H22:J22), "") will display ________ if G22 is
not equal "x". - ANSWERSa blank cell
The first three selected values in a series are 3, 6, and 9. What are the next three
values that will be inserted using AtuoFill? - ANSWERS12,15,18
What formula would you use to display the text string "Yes" if the value in cell A1 is
greater than the value in cell B1 and "No" if otherwise? - ANSWERS=IF(A1>B1, "Yes",
"No")
Provide the formula to perform an exact match lookup with the lookup value from cell
G5 using lookup table located in range A1:F5. Return the value from the third column of
the table: _______________. - ANSWERS=VLOOKUP(G5,A1:F5,3,FALSE)
Cell B2 contains the formula, =SUME(A1:A100), with the name of the SUM function
misspelled as SUME. What error value will appear in the cell? - ANSWERS#NAME?
