Correct Answer: AND
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
The underline format will underline ____
Tables are organized into rows, called ____.
The ____ aggregate function finds the largest value.
The ____ criteria filter requires the records displayed to have the current date.
The ____ dialog box provides options for moving charts between worksheets and chart sheets.
Cell A2 has the name DAVID HAWLEY in it. Which formula extracts the first name from the cell?
Which formula will provide the same result as the following: =CONCATENATE('Smarter','er')
Let's say your workbook has 5 worksheet tabs, and you want to group only the 1st, 3rd, and 5th sheets. How can you do this?
What does the VALUE function do?
Cell A1 contains 'Chang', and cell A2 contains 'Pie'. What is the result of the formula: =CONCATENATE(A1,' ','and',' ',A2)