Multiple Choice
Charlie imported data that displays "Albany, NY" in cell A24.What formula can he use to display "NY" in cell D3?
A) =LEFT(A24, 2)
B) =RIGHT(A24, 2)
C) =LOWER(A24)
D) =EXTRACT(A24, 2)
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q10: Helen wants to resize slicer buttons to
Q78: Which of the following formulas totals the
Q130: The COUNTIF function counts blank cells.
Q132: The score of a student is inserted
Q133: Angie created a PivotTable that includes two
Q134: When you right-click a cell containing a
Q136: To display a duplicate of a chart
Q137: Which of the following is not a
Q139: Jonathan wants to filter a table, but
Q140: Martha created a table where employees can