which tool will you use to enter a series of data such as Monday Tuesday and Wednesday in your worksheet
Answers
Answer:
Autofill
Explanation:
It is an easy way to fill in empty cells. Once data entered in one or two cells, we can use fill handle across multiple cells to automatically fill them in with similar data.
We can use it in rows as well as in column.
Answer:
How would you create a list where you need a word followed by a number? For example Participant 1, Participant 2, Participant 3 all the way to Participant 200, for example?
a) First type the word 'Participant' in the first cell then use the Autofill handle to copy the word down to 200th cell. Then insert a number in the first cell and copy it down using the Autofill handle again.
b) Type the word and number 'Participant 1' in the first cell and then copy it down to the 200th cell.
c) You need to create a customized list to do this using Autofill options located in the Excel Options – General section.
d) None of the above options are correct.
Correct! Well Done!
4) The correct answer is b.
5) Which of the options listed at a-d below will assist me in creating a workweek roster that contains only the days: Monday, Wednesday, Friday and Saturday?
a) Create a list containing Monday, Wednesday, Friday and Saturday. Select the entire list and use the Autofill handle to fill out the roster with this series.
b) Create a customized list containing Monday, Wednesday, Friday and Saturday using the Custom Lists option located in the Advanced Options – General section in the Backstage view.
c) Both options a and b are correct.
d) Neither option a nor b is correct.
Correct! Well Done!
5) The correct answer is c. You can use both the methods described in "a" and "b" to create a custom workweek.
