DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Answer: A chart must be located in a specific cell or at a specific address range. Any data changed in the worksheet is automatically updated in the chart. Dragging a chart object to a new location on the worksheet will change the data in the worksheet.
Detailed explanation-2: -False: Achart is updated automatically with the change in data. You can modify the chart by changing its colours and patterns. The X-axis is the horizontal axis.
Detailed explanation-3: -You can change the calculation options to manual to stop chart from updating automatically in Excel. Please do as follows. Click Formulas > Calculation Options > Manual, then when updating the original data in the range, the chart won’t update anymore.
Detailed explanation-4: -Right-click on the chart whose formatting you want to copy and select copy (or select it and use the keyboard shortcut Control + C). Go to Home –> Clipboard –> Paste –> Paste Special. This will open a Paste Special dialog box. In the paste special dialog box, select Formats.