Q6. Short answer questions.(Do any two)
1. How can you insert a chart in your worksheet?
2. What is formatting?
3. Name any two functions used in MS Excel
Q7. Long answer question. (Do any One)
1. What do you mean by MS Excel?
Or
What do you understand by column chart?
Answers
Answer:
1=To insert a chart:
Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart. ...
From the Insert tab, click the desired Chart command. ...
Choose the desired chart type from the drop-down menu. ...
The selected chart will be inserted in the worksheet.
2=What does formatting mean? Formatting refers to the appearance or presentation of your essay. Another word for formatting is layout. Most essays contain at least four different ds of text: headings, ordinary paragraphs, quotations and bibliographic references. You may also include footnotes and endnotes.
3=The TEXT Function. ...
The VLOOKUP Function. ...
The AVERAGE Function. ...
The CONCATENATE Funct
1=Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. ... Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.