FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Excel’s AutoComplete feature automatically inserts data in a cell that ____
A
Has a date format
B
Begins with a letter rather than a number
C
Begins with a word that is in Excels international dictionary
D
Begins with the same letters as a previous entry
Explanation: 

Detailed explanation-1: -AutoComplete helps you quickly insert functions and arguments while minimizing typing and syntax errors. The AutoComplete menu shows you available options based on context, and you choose what you want to insert into your formula.

Detailed explanation-2: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

Detailed explanation-3: -Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.

There is 1 question to complete.