FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

The word Jan was entered in cell A1, Apr was entered in cell B1, and you then used AutoFill to automatically fill cells C1 and D1. What would cell D1 contain?

A	Oct
B	May
C	Jun
D	Jul

Explanation:

Detailed explanation-1: -If your workbook is already open, then you can go to File > Save As to save the workbook with a different name. This will create a copy of the existing workbook.

Detailed explanation-2: -Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.

Detailed explanation-3: -Select the cell with the inconsistent formula, and then hold down the SHIFT key while pressing one of your arrow keys. This will select the inconsistent cell along with others. Then do one of the following: If you selected cells below, press CTRL+D to fill the formula down.

There is 1 question to complete.