Question

Multiple Choice Questions. Tick() the correct answer.
Which tab contains options to insert a chart on a worksheet?
b. Insert
d. Data
& Home
c File
A Pie chart is created
Using only
a.
b. Using two data series
d. All of these
which chart displays a series of points that are connected over time?
b. Pie chart
one data series
Using any number of data series
d. Barchart
a. Column chart
c. Line chart
4. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected
cells?
b. F5
d. F11
a. F3
C. F7
5.
Which statement is not true for sorting operation?
a. There should not be any blank row within datasheet to be sorted.
b. Sorting can only be done on one column.
c. Sorting can be done in ascending as well as descending order.
d. Headings should not be part of datasheet.
6. Which statement is not true for linking worksheets?
a. Source and destination sheet location must not be changed.
b. Formulas can use linking.
C. Worksheets should not be in different folders.
d. Linked formulas are protected by default​

Answer 1

Answer:

a

Explanation: