C. Short answer questions (11)
1. What is Excel?
2. What is Quick Access Toolbar?
3. Define Formula bar.
4. What is Name box?
5. What are the steps to open an existing worksheet in Excel?
6. Distinguish between 'Save' and 'Save As' option
7. What is a formula? Give an example,
8. Why do you apply Wrap Text formatting on cells?
9. What do you do to set your content in center of the selected cells?
10. Why do you use currency symbol?
answer fast
Answers
Q. 1 Answer:- Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.
Q. 2 Answer:- The Quick Access Toolbar, is located above the Ribbon (top-left) and provides access to commonly used features and commands, such as Save and Undo/Redo. Both the Ribbon and the Quick Access Toolbar can be customized.
Q. 3 Answer:- Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.
Q. 4 Answer:- The Name Box has several functions. It displays the address of the active cell. It displays the name of the cell, range or object selected if this has been named. It can be used to name a cell, range or object like a chart. It can be used to go to any address you type into it.
Q. 5 Answer:- To open an existing workbook:
Navigate to Backstage view, then click Open.
Select Computer, then click Browse. Alternatively, you can choose OneDrive to open files stored on your OneDrive.
The Open dialog box will appear.Locate and select your workbook, then click Open.
Q. 6 Answer:- The main difference between Save and Save As is that Save helps to update the lastly preserved file with the latest content while Save As helps to store a new file or to store an existing file to a new location with the same name or a different name.
Q. 7 Answer:- 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.
Q. 8 Answer:- "Wrapping text" means displaying the cell contents on multiple lines, rather than one long line. This will allow you to avoid the "truncated column" effect, make the text easier to read and better fit for printing. In addition, it will help you keep the column width consistent throughout the entire worksheet.
Q. 9 Answer:-Click the cell where you want to center the contents.
Click "Home," then click the small arrow in the bottom corner of the "Alignment" area of the ribbon.
Click the drop-down box next to "Horizontal" and choose "Center."
Do the same thing in the box next to "Vertical."
Click "OK" to center your text.
Q. 10 Answer:- Major currencies often have a unique symbol attached to them. This helps graphically show that a number is representing a specific currency amount. Some countries use the same currency symbol. The dollar symbol, $, is used by many countries.
Explanation:
Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.
The Quick Access Toolbar, is located above the Ribbon (top-left) and provides access to commonly used features and commands, such as Save and Undo/Redo. Both the Ribbon and the Quick Access Toolbar can be customized.
Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.
The Name Box has several functions. It displays the address of the active cell. It displays the name of the cell, range or object selected if this has been named. It can be used to name a cell, range or object like a chart. It can be used to go to any address you type into it.
To open an existing workbook in Excel 2010, select the FILE tab in the toolbar at the top of the screen. Then click on Recent in the left menu. You will see your "Recent Workbooks" listed on the right. To quickly open one of these workbooks, click on the workbook name under "Recent Workbooks
The main difference between Save and Save As is that Save helps to update the lastly preserved file with the latest content while Save As helps to store a new file or to store an existing file to a new location with the same name or a different name
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.
Wrapping text" means displaying the cell contents on multiple lines, rather than one long line. This will allow you to avoid the "truncated column" effect, make the text easier to read and better fit for printing. In addition, it will help you keep the column width consistent throughout the entire worksheet.
Click the cell where you want to center the contents. ...
Click "Home," then click the small arrow in the bottom corner of the "Alignment" area of the ribbon.
Click the drop-down box next to "Horizontal" and choose "Center." Do the same thing in the box next to "Vertical."
Click "OK" to center your text.
Major currencies often have a unique symbol attached to them. This helps graphically show that a number is representing a specific currency amount. Some countries use the same currency symbol. The dollar symbol, $, is used by many countries.