IMPORTANT QUESTION ON MICROSOFT EXCEL

 Exercises:

1. State whether the following statements are True or False.

a. Ms. Excel is a spreadsheet package.

b. Ms. Excel is used to create documents like letters, essay etc.

c. Columns are labeled as A, B, C …………. IV.

d. MM300 is a valid cell address.

e. A cell is the basic unit for data entry.

f. There are 256 columns in Ms. Excel.

g. You can not perform calculation with DATE and TIME.

h. Ctrl key is used to select the non continuous data.

i. Column widths are fixed in Ms. Excel.

j. Goal Seek changes the target value with respect to the supporting cell.

k. Chart is a graphical representation of data in worksheet.

l. Many types of chart can be created using the same data.

m. Non-printing lines on the worksheet is called grid.

n. Rows are labeled as A, B, C …………

o. A cell is addressed by its column heading and row number.

p. = sign is given before entering formula.

q. A cell range is enclosed in a parenthesis.

2. Describe Ms. Excel in brief.

3. What is a cell? How is it addressed?

4. Differentiate between a worksheet and a workbook.

5. What are operators? Explain the different types of operators supported by Ms. Excel.

6. What are the advantages of freezing cells?

7. Name any 5 built in functions in Ms. Excel.

8. What is a chart?

9. What are the different types of number formats?

10. What is the purpose of creating custom list?

11. Name any 5 charts that can be created in Ms. Excel.

12. What is spreadsheet?

13. What is a worksheet?

14. What is a cell reference?

15. How is a cell addressed?

16. Define a row, column and a cell.

17. What is a function?

18. What is a chart?

19. Name any 4 charts that can be created by Ms. Excel.

20. What is an operator? Give examples.

21. What is sorting and filtering?

22. What is the importance of border and shading?

Comments

Post a Comment

Popular posts from this blog

COMPUTER SHORTCUT KEYS

CTRL Shortcuts from A-Z: CTRL + A = Select text CTRL + B =  Bold  text CTRL + C = Copy text CTRL + D = Open font formatting window CTRL + E = Center text  CTRL + F = Find a phrase  CTRL + G = Go To a specific page or bookmark CTRL + H = Replace text with another text or replace text with different formatting CTRL + I =  Italicize  text CTRL + J = Justify text CTRL + K = Open  Insert Hyperlink  window CTRL + L = Left align text CTRL + M = Indent a paragraph from the left CTRL + N = Open new Word document CTRL + O = Open an existing Word document CTRL + P = Print Word document CTRL + Q = Remove paragraph formatting CTRL + R = Right align text CTRL + S = Save Word document CTRL + T = Create a hanging indent CTRL + U = Underline text CTRL + V = Paste text CTRL + W = Close Word document CTRL + X = Cut text CTRL + Y = Redo an action previously undone OR repeat an action CTRL + Z = Undo a previous action
Read more

CCC IMPORTANT QUESTIONS WITH ANSWER

  Sample Question Paper: Information Technology Tools and Network Basics (M1-R5.1) CCC    TOTAL TIME: 2 HOURS                                                                 TOTAL MARKS: 100   (Answer all the questions; each question carries ONE mark) Answer the following multiple choice questions (1 to 100) 1x100=100   Note: For each question, four options are given, Choose the most appropriate option .   1.          In Which Generation Time sharing, Real time Network and Distributed Operating Systems were used? (A)    ...
Read more

MOST IMPORTANT EXCEL SHORTCUTS

Ctrl + Shift + L : This shortcut toggles the filter on or off for the selected range. It's handy for quickly applying or removing filters without using the mouse. Alt + E + S : This shortcut sequence opens the Paste Special dialog box, allowing you to choose specific paste options such as values, formats, formulas, and more. Alt + Enter : While editing a cell, pressing Alt + Enter allows you to insert a line break within the cell. This is useful for creating multi-line text entries. Ctrl + ' (Apostrophe) : This shortcut copies the value from the cell above the currently selected cell. It's a quick way to fill down a column with the value from the cell above. Ctrl + Alt + V : This shortcut opens the Paste Special dialog box directly in Values mode. It's a quicker way to paste values compared to using Alt + E + S followed by the V key. Ctrl + ; (semicolon) : This shortcut inserts the current date into the selected cell. Similarly, Ctrl + Shift + ; (semicolon) inserts the ...
Read more