1. What do you mean by worksheet and workbook ?
Worksheet : An Excel worksheet is a single spreadsheet that containes cells organized by rows and columns.
Workbook : A workbook is an Excel file that contains one or more worksheets.
2. What is active cell ?
Ans : An active cell is a rectangular box, highlighting the cell in the spreadsheet.
3. How to freeze and unfreeze panes ?
Ans : If we have a large table of data in Excel, it can be useful to freeze rows or columns. This way we can keep rows or columns visible while scrolling through the rest of the worksheet.
To freeze the top row, execute the following steps.
ð On the View tab, click Freeze Panes, Freeze Top Row.
To unlock all rows and columns, execute the following steps.
ð On the View tab, click Freeze Panes, Unfreeze Panes.
4. What is Auto Fill & Fill Handle in MS Excel 2007 ?
Ans: Auto fill : It is a process in MS Excel which is used to replicate a series of numbers, number and text combination, dates or time periods, Formulas, functions based on a pattern that we establish.
Fill handle : The fill handle is a small black dot or square in the bottom right corner of the active cell. The fill handle has a number of uses including copying a cell’s contents to adjacent cells or to create a series.
5. What is Formula in MS Excel ?
Ans : Excel formulas allow us to perform calculations on data we have entered into the spreadsheet.
6. What is a function in Ms Excel ? Discuss the common functiones ?
Ans: A function allows us to calculate a result such as adding numbers together or finding the average of a range of numbers.
Functions :
AVERAGE:Used to determine the average value of the selected cells contents.
COLUMNS : Used to return the number of columns within a reference.
COUNT : Used to count how many numbers are in the list.
COUNTA : Used to count the number of cells that are not empty and the values within the list of arguments.
COUNTBLANK : Used to count empty cells within a cell range.
MAX : Used to return the maximum number from a list.
MIN : Used to return the minimum number from a list.
ROUND : Used to round off numbers to a specified number of decimal points.
SUM : Used to add the contents of selected cells.
7. Elaborate the following error messages :
####### : Too narrow.
#NAME? : Not recognized the text in formula.
#VALUE! : Wrong type of argument in formula.
#DIV/0! : Divide a number by zero (0).
#REF! : A cell references is invalid.
#NULL! : Two or more cell references are not separated correctly.
8. Discuss the IF function ?
Ans : Excel has a number of functions which allow us to evaluate values and make decision based on the result of the evaluation. The IF( ) FUNCTION is one of these.
9. What is an absolute and relative cell reference ?
Ans : Absolute : Situations arise in which the cell references must remain the same when copied or when using autofill.
Relative : Relative cell references are basic cell references that adjust and change when copied or when using autofill.
10. What is formatting cell ?
Ans : In Excel, a cell format refers to the program that shows us what we expect to see in the selected cell. It shows us how the cell can be formatted and aligned.
11. How to print selected cells in MS Excel ?
Ans : Select the cell or range of cells we want to print => On the File menu, click Print => Under Print what, click Selection, and then click OK.
12. How to copy series of cells in a row into column ?
Ans : 1. To rearrange data from rows to columns, select the cells in the rows that contain the data.
- On the Home tab, in the Clipboard group, click Copy.Keyboard shortcut ( CTRL+C ).
- On the worksheet, select the first cell of the destination rows or columns into which you want to rearrange the copied data.
- On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Transpose.
- After that the data is transposed successfully.
13. What is a sorting? How can you sort a cell range in Ms excel?
Ans: Sorting arrange the data within a table into Alphabetical or numerical order. Ex: book, address are sorted alphabetically from A-Z and calendar are sorted by data order.
14.How can you select a range of cells not next to each other ?
An : Sometimes we need to select multiple cells that are not next to each other. To do this click on the first cell, i.e.C3 then while keeping the ctrl key pressed click on the cell G3.
15.How can you rename a worksheet ?
Ans : We can rename a worksheet at bottom left corner of excel window and write down new name than press enter.
16. What is Numbers & Date formatting? How can you apply that in your MS Excel Worksheet?
Ans: Number formatting store number values with decimal places.
Date format holds date in a cell.
The format can be user specific. We can apply number and date formatting by selecting a cell and then from the keyboard press Ctrl+1. From the format cell window we can select our desired cell format.
17. What is the default text and number alignment in MS Excel?
Ans: Default text alignment is left and default number alignment is right.
18. How can you move the contents of a cell or a range of cell between worksheets (in different workbooks)?
Ans: Select the cells/range of cells and cut ( ctrl + X) it to place it to the clipboard.
Select the destination worksheet and Click at the location we wish to paste the data and press Ctrl+ V.
19 .Why do you use the absolute cell referencing?
Ans: We use absolute references to refer to cells that we don’t want to change as the formula is copied.
20. What is chart in MS Excel? Name three types of charts?
Ans: charts present data in a visual way that makes it easier to see the meaning behind the numbers.
- Column chart
- Line chart
- Bar chart
21. How can you select a range of cells located next to each other?
Ans: Select the first cell-> shift + Click to the last cell to select the range of cell.
22. What is wrap text ? How to do it ?
Ans : When text exceeds a column width, it is possible to manually or automatically wrap the text.
Procedure :
- In a worksheet, select the cells that we want to format.
- On the Home tab, in the Alignment group, click Wrap Text.
23. What is paste special ? How to use paste special ?
Ans : This allows us several choices of how the text will be formatted when pasted. In the same way, we can use this command in Excel or Calculation to copy formulas and calculations when pasting data into cells.
Procedure :
- Click the Home tab;
- Get into the Clipboard group;
- Click the drop down symbol under Paste button;
- Then you will get the Paste Special.
24. Definition of Raw, Column & Cell ?
Ans : Row : A row is a grouping of cells that run from the left to right of a page. Rows run horizontally in an Excel worksheet.
Column : A column is a grouping of cells that run from the top to the bottom of a page. Column run vertically in an Excel worksheet.
Cell : The intersection point between a row and a column is a cell, which is the basic storage unit for data in a spreadsheet.
25. How to Change Date Formats in Microsoft Excel ?
Ans : Open the spreadsheet => Select the date fields => Select “Format” on the bar at the top of the screen => Select “Formet Cells” from the drop menu => Make sure the “Number” tab is highlighted => Select “Date” in the column at the left of the screen => Select the date format we would like => Click OK to save the format.
Advertisements
