Possible answers: Connections; Text to columns; Consolidate; Outline; External data; Sort; Filter; Flash Fill; Forecast
0 of 9 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 9 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Exercise 1
Excel supports pulling from a wide variety of sources. Examples include data stored on web pages, in text files, or in other programs.
Exercise 2
The tool helps you manage one or more connections to external data sources in your workbook.
Exercise 3
By using the option we can arrange our data in ascending or descending order.
Exercise 4
The allows you to easily extract matching records from a larger set of source data based on criteria you provide.
Exercise 5
automatically fills your data when it senses a pattern.
Exercise 6
The feature splits text in a cell into multiple columns.
Exercise 7
The allows you to gather together your data from separate worksheets into a master worksheet.
Exercise 8
is used for easily collecting data through patterns without using the fill tool.
Exercise 9
We can Use an to quickly display summary rows or columns.