MIS 112 Problem Sets #11-#13 || Verified for Accuracy.
How does the Excel search/replace function work for dates?
A) It searched a cell for any feasible date format including numbers and text dates, and then does
a replace
B) It searches for a sate as displayed in the Formulas bar, and then does a replace
C) It can find dates, but not replace them
D) It cannot find dates correct answers It searches for a sate as displayed in the Formulas bar,
and then does a replace
In excel, the DATE function takes _____ arguments.
A) 3
B) 2
C) 4
D) 5 (the 6th is optional) correct answers 3
Which of the following formulas returns the number of days in the corresponding month for a
date in cell B2?
A) =DAY(DATE(YEAR(B2), MONTH(B2)+1,0))
B) =DATE(YEAR(B2)+1, MONTH(B2)+1,0))
C) =DAY(DATE(YEAR(B2)+1, MONTH(B2)+1,0))
D) None of the answers provided is correct correct answers =DAY(DATE(YEAR(B2),
MONTH(B2)+1,0))
, To generate a series of dates 1 year apart in Excel, which of the following formulas is correct?
(assuming the first date is entered in cell A1, and you are trying to compute the next year in the
series)
A) =DATE(YEAR(A1) + 1, DAY(A1))
B) =A + 7
C) =DATE(YEAR(A1) + 1, MONTH(A1), DAY(A1))
D) =DATE(YEAR(A1), MONTH(A1), DAY(A1) + 1) correct answers =DATE(YEAR(A1) + 1,
MONTH(A1), DAY(A1))
If the date serial number of March 15, 2014 is represented as 41713 then how will noon (half
way through the day) be represented?
A) 41713.75
B) 41713.25
C) 41713.5
D) 41713 correct answers 41713.5
What does the WEEKDAY function return when you provide a date as an argument?
A) an integer between 1 and 7
B) an alphabetical representation of the day of the week, e.g., "MON" / "TUE"
C) an integer between 0 and 7
D) either 0 or 1 correct answers an integer between 1 and 7
The __________ function can be used to find the count of characters in a word or text string.
A) COUNTCHARS()
How does the Excel search/replace function work for dates?
A) It searched a cell for any feasible date format including numbers and text dates, and then does
a replace
B) It searches for a sate as displayed in the Formulas bar, and then does a replace
C) It can find dates, but not replace them
D) It cannot find dates correct answers It searches for a sate as displayed in the Formulas bar,
and then does a replace
In excel, the DATE function takes _____ arguments.
A) 3
B) 2
C) 4
D) 5 (the 6th is optional) correct answers 3
Which of the following formulas returns the number of days in the corresponding month for a
date in cell B2?
A) =DAY(DATE(YEAR(B2), MONTH(B2)+1,0))
B) =DATE(YEAR(B2)+1, MONTH(B2)+1,0))
C) =DAY(DATE(YEAR(B2)+1, MONTH(B2)+1,0))
D) None of the answers provided is correct correct answers =DAY(DATE(YEAR(B2),
MONTH(B2)+1,0))
, To generate a series of dates 1 year apart in Excel, which of the following formulas is correct?
(assuming the first date is entered in cell A1, and you are trying to compute the next year in the
series)
A) =DATE(YEAR(A1) + 1, DAY(A1))
B) =A + 7
C) =DATE(YEAR(A1) + 1, MONTH(A1), DAY(A1))
D) =DATE(YEAR(A1), MONTH(A1), DAY(A1) + 1) correct answers =DATE(YEAR(A1) + 1,
MONTH(A1), DAY(A1))
If the date serial number of March 15, 2014 is represented as 41713 then how will noon (half
way through the day) be represented?
A) 41713.75
B) 41713.25
C) 41713.5
D) 41713 correct answers 41713.5
What does the WEEKDAY function return when you provide a date as an argument?
A) an integer between 1 and 7
B) an alphabetical representation of the day of the week, e.g., "MON" / "TUE"
C) an integer between 0 and 7
D) either 0 or 1 correct answers an integer between 1 and 7
The __________ function can be used to find the count of characters in a word or text string.
A) COUNTCHARS()
