26. Which sign we use to enter formula :
(a) =
(b) /
(c) *
(d) –
27. How many types of cell references are available in Excel :
(a) 3
(b) 4
(c) 8
(d) 10
28. Excel worksheet data can be shared with Word document by :
(a) Inserting an Excel file into Word
(b) Copy and Paste Excel worksheet into Word document
(c) Link Excel data in a Word document
(d) All the above
29. Which of the following is not a valid data type in Excel ?
(a) Number
(b) Label
(c) Character
(d) Date/Time
30. Which elements of a worksheet can be protected from accidental modification ?
(a) Contents
(b) Objects
(c) Scenarios
(d) All the above
Related Posts
Microsoft Excel » Exercise - 128. Excel worksheet data can be shared with Word document by : (a) Inserting an Excel file into Word (b) Copy and Paste Excel worksheet into Word document (c) Link Excel data in a Word document (d) All the above- Microsoft Excel » Exercise - 14. Anything that is typed in a worksheet appears : (a) in the formula bar only (b) in the active cell only (c) in both active cell and formula bar (d) in the formula bar first and when we press ENTER it appears in active cell
- Microsoft Excel » Exercise - 147. When we embed Excel worksheet into a Word document : (a) it leaves the data in its original Excel format and the data must be edited with Word features (b) it is inserted into Word (c) editing change the data and formatting gets changed in the original Excel worksheet (d) editing does not change the data and formatting in the original Excel worksheet
- Microsoft Excel » Exercise - 146. Getting data from a cell located in a different sheet is called .......... (a) Accessing (b) Referencing (c) Updating (d) Functioning
- Microsoft Excel » Exercise - 298. By which menu we can make database of our worksheet data : (a) Form (b) Filter (c) Database (d) Data