Microsoft Excel Set-26

251. Which menu option can be used to split windows into two?
     a. Format -> Window
     b. View -> Window-> Split
     c. Window -> Split
     d. View –> Split
252. Getting data from a cell located in a different sheet is called….
     a. Accessing
     b. Referencing
     c. Updating
     d. Functioning
253. Which of the following is not a valid data type in Excel?
     a. Number
     b. Character
     c. Label
     d. Date/Time
254. Which elements of a worksheet can be protected from accidental modification?
     a. Contents
     b. Objects
     c. Scenarios
     d. All of the above
255. A numeric value can be treated as label value if …… precedes it.
     a. Apostrophe (‘)
     b. Exclamation (!)
     c. Hash (#)
     d. Tilde (~)
256. Concatenation of text can be done using
     a. Apostrophe (‘)
     b. Exclamation (!)
     c. Hash (#)
     d. Ampersand (&)
257. Which area in an Excel window allows entering values and formulas?
     a. Title Bar
     b. Menu Bar
     c. Formula Bar
     d. Standard Tool Bar
258. Multiple calculations can be made in a single formula using…..
     a. Standard Formulas
     b. Array Formula
     c. Complex Formulas
     d. Smart Formula
259. An Excel Workbook is a collection of …….
     a. Workbooks
     b. Worksheets
     c. Charts
     d. Worksheets and Charts
260. What do you mean by a Workspace?
     a. Group of Columns
     b. Group of Worksheets
     c. Group of Rows
     d. Group of Workbooks

_________________________________________________________________________________________________