facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

– Using Autofill in Excel Test – Free Excel Tests – Excel 2010 – Entering Data

Using Autofill in Excel Test

Free Online Microsoft Excel Tests
Excel 2010 – Entering Data

* What is Autofill?
* Autofill Day and Month Series
* Autofill Number Sequences
* Autofill Custom Lists

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Using Auto Fill Test

Question 1 -  Microsoft Excel Tests -
            Entering Data - Using Auto Fill Test
1) Study the example above. How can you activate and use the Autofill option to copy the contents of cell B2 down to B50?
a) Select cells B2 to B50, right click and select Autofill.
b) Drag the Autofill Handle located at the bottom right-hand corner of the selected cell down to cell B50.
c) Go to File and select Options – Advanced Options.  Go to the General section and select the AutoFill Options button to create this fill.
d) Autofill can only be used to create series or sequences.  You cannot use it to copy data.


Question 2 -  Microsoft Excel Tests -
            Entering Data - Using Auto Fill Test
2) A user wanted to create a numbered list numbered: 1 -10.  When they used the Autofill Handle it created a list of 10 number 1s (as pictured above).  What is the solution?
a) Insert the formula =Sum(1) in the first cell before using the Autofill handle to increment each successive fill by 1 step.
b) On the Home tab, go to the Editing group and click the Fill button.
c) Select cells A2 to A11.  On the Home tab select Merge and Centre to create a numbered list.
d) Click on the Autofill Options icon that appears just after completing an Autofill and select ‘Fill Series’ from the options.


3) For which of the following lists can you NOT use the Autofill function?
a) Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
b) Apples, Pears, Oranges, Passion Fruit, Bananas.
c) January, February, March, April, May, June.
d) You can use Autofill to create all of the above types of lists.


4) 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.


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.


Question 6 -  Microsoft Excel Tests -
            Entering Data - Using Auto Fill Test

6) How can you use Autofill to QUICKLY recreate the list pictured in the example above?

a) Type the first number in the series, ‘0’, then drag the fill handle down and select ‘Series’ from the Autofill Options.
b) Launch the Fill Options dialogue box in the Editing group.  Check the options for ‘column’ and ‘linear’.  For step value insert ’50’ and for stop value insert ‘450’ and press OK.
c) It is not possible to use Autofill to copy down lists of non-sequential numbers.
d) Type ‘0’ in the first cell and ’50’ in the second.  Select both cells and then use the Fill handle to drag down to the ‘450’ value.


7) Which of the following is the correct sequence of actions for CREATING a customized list with four items:  Bread, Milk, Cereal, Sugar:
a) Go to the following: Home Tab – Fill – Series – Autofill – Bread, Milk, Cereal, Sugar – Add – OK, to achieve this.
b) Go to the following: File – Options – Advanced – Edit Custom Lists – Bread, Milk, Cereal, Sugar – OK – OK, to achieve this.
c) Go to the following: File – Options – Advanced – Edit Custom Lists – Bread, Milk, Cereal, Sugar – Add – OK – OK, to achieve this.
d) Go to the following: General Options – AutoFill – Bread, Milk, Cereal, Sugar – Add – OK – OK – AutoFill, to achieve this.


Question 8 -  Microsoft Excel Tests -
            Entering Data - Using Auto Fill Test
8) How do you use a customized Autofill list after you have created it?
a) Type the first item in the list and use the Autofill handle to recreate the series in adjacent cells.
b) Go to the Insert tab on the Ribbon and select ‘Insert Table’ to insert the list of items you created.
c) Launch the Series Options dialogue box in the Editing group on the Home tab and select Autofill.
d) Go to the Backstage view, select Options, Advanced Options and in the General section, select ‘Insert Custom Autofill’.




9) How do you add an additional item in the middle of a custom list you have previously created.  For example, we want to add ‘Butter’ to the list containing: Bread, Milk, Cereal, Sugar so that ‘Butter’ will appear after ‘Bread’ in the list (as in the example above).
a) Go back to the ‘Edit Custom List’ option located under Excel Advanced Options.  Click on the list you wish to edit and in the ‘List entry box’ insert ‘Butter’ after ‘Milk’ in the series and press: Add, OK, OK.
b) Insert the word ‘Butter’ after the word ‘Bread’ (as pictured above) and click save.  Excel will automatically adjust the Autofill for future fills.
c) Go back to the ‘Edit Custom List’ option located under Advanced Options and create a new list that includes the word ‘Butter’.
d) None of the above options will be successful.


Question 10 -  Microsoft Excel Tests -
            Entering Data - Using Auto Fill Test
10) Study the example above. How would you go about getting Excel to only Autofill the dates for the rest of August that fall on a WEEKDAY (Monday – Friday) in the Action list above?
a) Click the Autofill Options icon (at the bottom right-hand corner of the last filled cell) and select:  ‘Fill Months’ .
b) Manually delete the dates you don’t need using a calendar.
c) Create a custom list of the dates that fall on a weekday for each month of the year, using the ‘Edit Custom List’ option located in the Backstage view under Advanced Options.
d) Click the Autofill Options icon (at the bottom right-hand corner of the last filled cell) and select:  ‘Fill Weekdays’




* More from TestsTestsTests.com