DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Joe wants to copy the formatting of cells A1 through C1 in his workbook to use in another location. Which of the following commands should he use?
|
Cut Painter
|
|
Copy Painter
|
|
Paste Painter
|
|
Format Painter
|
Explanation:
Detailed explanation-1: -Answer. Copy Painter is the commands should he use. Hence, option B is correct.
Detailed explanation-2: -Single-click the Format Painter to copy the formatting from the selected cell, then click a different cell to paste the formatting. Alternatively, you can click and drag over a range of cells to paste the formatting to multiple cells.
Detailed explanation-3: -Excel Format Painter shortcut Press Alt, H, F, P keys. Click the target cell where you want to apply the formatting.
There is 1 question to complete.