excel e-h GRADE A Q&A
which text function capitalizes the first letter in a string of text - (correct answer)proper
cell references that reference other sheets behind the summary sheet are known as -
(correct answer)3-d
which excel function counts the number of cells in a range - (correct answer)COUNTIF
which excel function checks for errors and displays a message you specify if there is an
error in a formula - (correct answer)IFERROR
one way to display formulas is by pressing this key combination - (correct
answer)[CTRL][']
which error code will display if a value in a formula is not available - (correct
answer)#NA
which of the following is not a valid named range - (correct answer)New quote
The_____refers to where you will be able to use a named cell or range in worksheets -
(correct answer)scope
which of the following is NOT A comparison operator you can use in Excel - (correct
answer)$
in the accompanying figure, what is the name of the figure in the formula of the active
cell - (correct answer)PMT
in the accompanying figure, in the formula in a active cell why is B6 entered as B6 -
(correct answer)To show monthly payment
, In the accompanying figure, which of the three bank offers the lowest interest rate -
(correct answer)commercial bank
in the accompanying figure, item 1 refers to the___ - (correct answer)workbook
in the accompanying figure, item 2 indicates a(n) - (correct answer)horizontal split
which of the following save options should you use so that someone who has an earlier
version of excel can view your excel document - (correct answer)excel 97-2003
the coding format used for all web documents is called - (correct answer)HTML
A_______will print behind worksheet data - (correct answer)watermark
Which of the following can not be a target - (correct answer)hyperlinks
______help users locate, identify and understand a file - (correct answer)properties
which of the following can users search for to help them locate a workbook - (correct
answer)keywords
in the accompanying figure, there are ______links to choices - (correct answer)4
a hyperlink jumps to a - (correct answer)target
the first row of a table that contains field names is called a - (correct answer)header row
which text function capitalizes the first letter in a string of text - (correct answer)proper
cell references that reference other sheets behind the summary sheet are known as -
(correct answer)3-d
which excel function counts the number of cells in a range - (correct answer)COUNTIF
which excel function checks for errors and displays a message you specify if there is an
error in a formula - (correct answer)IFERROR
one way to display formulas is by pressing this key combination - (correct
answer)[CTRL][']
which error code will display if a value in a formula is not available - (correct
answer)#NA
which of the following is not a valid named range - (correct answer)New quote
The_____refers to where you will be able to use a named cell or range in worksheets -
(correct answer)scope
which of the following is NOT A comparison operator you can use in Excel - (correct
answer)$
in the accompanying figure, what is the name of the figure in the formula of the active
cell - (correct answer)PMT
in the accompanying figure, in the formula in a active cell why is B6 entered as B6 -
(correct answer)To show monthly payment
, In the accompanying figure, which of the three bank offers the lowest interest rate -
(correct answer)commercial bank
in the accompanying figure, item 1 refers to the___ - (correct answer)workbook
in the accompanying figure, item 2 indicates a(n) - (correct answer)horizontal split
which of the following save options should you use so that someone who has an earlier
version of excel can view your excel document - (correct answer)excel 97-2003
the coding format used for all web documents is called - (correct answer)HTML
A_______will print behind worksheet data - (correct answer)watermark
Which of the following can not be a target - (correct answer)hyperlinks
______help users locate, identify and understand a file - (correct answer)properties
which of the following can users search for to help them locate a workbook - (correct
answer)keywords
in the accompanying figure, there are ______links to choices - (correct answer)4
a hyperlink jumps to a - (correct answer)target
the first row of a table that contains field names is called a - (correct answer)header row
