A) Answer the following
questions.
Q1)Describe the steps involved in changing row height.
Q2)what is the function of the autofit selection feature?
Q3)what is a formula? describe the elements of a formula.
Q4)what is the advantage of using functions? answer with the help of an example.
Q5)why do we use charts on a worksheet?
Answers
Q1)Describe the steps involved in changing row height.
ans:=STEPS TO CHANGE ROW HEIGHT:
• Select the row(s) you want to change.
•Home tab → Cells group → Format.
•Cell size → Row Height.
•Type the desired value.
Q2)what is the function of the autofit selection feature?
ans:=AutoFit is a feature in Excel that allows you to quickly adjust the row height or column width to fit the text completely (so that there is no spilling over to other cells). Autofit Row Height: This feature automatically adjusts the row height to fit the text in the cell. You can autofit multiple rows at once.
Q3)what is a formula? describe the elements of a formula.
ans:=A formula is an expression telling the computer what mathematical operation to perform upon a specific value. ... In the picture below is an example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the total of cells A1, A2, and A3. In this formula, SUM is the function of the formula.
Q4)what is the advantage of using functions? answer with the help of an example.
ans:=A function is a group of statements that together perform a task. ... A function declaration tells the compiler about a function's name, return type, and parameters. A function definition provides the actual body of the function. The C standard library provides numerous built-in functions that your program can call.
Q5)why do we use charts on a worksheet?
ans:=A chart is a tool you can use in Excel to communicate your data graphically. Charts allow your audience to more easily see the meaning behind the numbers in the spreadsheet, and to make showing comparisons and trends much easier.