Question

IT TOPIC - MS EXCEL
Q1. Which type of software is Excel?
Q2. Which was first electronic version of spreadsheet?
Q3. In which tab background option is available?
Q4. In which group of page layout tab background option is present?
Q5. What is the default name of MS Excel file?
Q6. What is worksheet?
Q7. By default how many worksheets are present in a workbook?
Q8. How many columns are present in a single worksheet?
Q9. How many rows are present in a single worksheet?
Q10. What is cell? How many character can you store in a cell ?

Q11. What are the different types of data type available in MS Excel?
Q12.The cell surrounded by thick black border is called?
Q13. What is range?
Q14. In range starting address and ending address is separated by …… separator.
Q15.which area displays the location of the cell pointer?
Q16. Which bar shows the data and formula that you enter in an active cell?
Q17. Alphabets across the top border of each worksheet are called?
Q18.In worksheet Columns are represented by ?
Q19. What is the last column address?
Q20. What is the last cell address?

Q22. Which key is used to move cell pointer one column right?
Q23. Which key is used to move cell pointer one column left?
Q24. Which key is used to move cell pointer one row up?
Q26. Which key is used to move cell pointer one row down?
Q27. Which key is used to move cell pointer one screen up in a worksheet?
Q28. Which key is used to move cell pointer one screen down in a worksheet?
Q29. Which key is used to move cell pointer to the first cell of the topmost row i.e. A1?
Q30. Which key is used to move cell pointer to the last used cell on a worksheet?
Q31. What is a default alignment for text?

Q32. What is a default alignment for number?
Q33. Which shortcut key is used to insert new worksheet?
Q35. Which short cut key is used to go to specific cell?
Q36. Formula begin with an ……….. sign.
Q37.which function key is used to display save as dialog box?
Q38. Which shortcut key is use to save file?
Q39. Which option is use to remove a worksheet?
Q40. In MS Excel which button is used to perform addition of a range in a cell?

Answer 1

Answer:

Ans : 1 - Microsoft Excel, spreadsheet application launched in 1985 by the Microsoft Corporation. Excel is a popular spreadsheet system, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data.

Ans:2- By creating VisiCalc, the first electronic spreadsheet, that's exactly what they did. Bricklin and Frankston would work at night because computer time was cheaper at night. They thought of it as a "visual calculator" and that is why they gave it the name VisiCalc.

Ans:3-On the Themes tab, under Theme Options, click Background. On the pop-up menu, click Format Background. In the sidebar, click Fill, and then click the Solid, Gradient, Picture or Texture, or Pattern tab. Choose the background fills that you want.

Ans:4-The Page Layout tab holds the themes, page setup, page background, paragraph and arrange groups.