USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -When you have selected a range of cells and then you press CTRL+P. Excel will automatically print the selected range. To use the Spell check function you go to the “View” tab on the ribbon. You can move a chart in a wordbook from one sheet to another.
Detailed explanation-2: -What is Autocomplete? As can be seen in the above image, Excel recognises the text “Peter” from cell A2 so as soon as you type the letter “P” into cell A5 it attempts to autocomplete with “Peter” for you. Excels autocomplete can be helpful when managing large data-entry based spreadsheets.
Detailed explanation-3: -On the worksheet, click and drag to select the cells you want to print. Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.
Detailed explanation-4: -To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.