Microsoft Excel (Basic-Advance Knowledge|Govt Exams/Competitive exam) MCQ's




Question 271 :
When you work with large worksheets, you may need to

  1. size the worksheet to fit on the specific number of pages
  2. add and remove page breaks
  3. specify only certain print areas
  4. all of above
  

Question 272 :
Which elements of worksheet can be protected from accidental modification

  1. Contents
  2. Objects
  3. Scenarios
  4. All of above
  

Question 273 :
How do you change column width to fit the contents?

  1. Single-click the boundary to the left to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in the column
  4. All of above
  

Question 274 :
How should you print a selected area of a worksheet, if you'll want to print a different area next time?

  1. On the file menu, point to print area, and then click set print area.
  2. On the file menu, click print, and then click selection under print what
  3. On the view menu, click custom views, then click add
  4. All of above
  

Question 275 :
Long text can be broken down into many lines within a cell. You can do this through We have 83

  1. Wrap Text in Format > > Cells guests online
  2. Justify in Edit > > Cells
  3. Text Wraping in Format ? Cells, Layout tab
  4. All of above
  

Question 276 :
How are data organised in a spreadsheet?

  1. Lines and spaces
  2. Layers and planes
  3. . Height and width
  4. Rows and columns
  

Question 277 :
Except for the ...... function, a formula with a logical function shows the word TRUE or FALSE as a result

  1. IF
  2. AND
  3. OR
  4. NOT
  

Question 278 :
Which is used to perform what if analysis?

  1. Solver
  2. Goal seek
  3. Scenario Manager
  4. Allof above
  

Question 279 :
An excel workbook is a collection of

  1. Workbooks
  2. Worksheets
  3. Charts
  4. Worksheets and charts
  

Question 280 :
What happens if you remove the check mark from Row - Column headers on Options dialog box?

  1. This will remove row headings and column headings of your data
  2. This will remove the column headings (A, B, C,
  3. This will remove row and column heading of chart
  4. This will remove row and column heading of table
  

Question 281 :
Files created with Lotus 1-2-3 have an extension

  1. DOC
  2. XLS
  3. 123
  4. WK1
  

Question 282 :
You can use the formula pallette to

  1. format cells containing numbers
  2. create and edit formula containing functions
  3. enter assumptions data
  4. copy a range of cells
  

Question 283 :
You can not link excel worksheet data to a word document

  1. With the right drag method
  2. With a hyperlink
  3. With the copy and paste special commands
  4. With the copy and paste buttons on the standard toolbar.
  

Question 284 :
Which of the cell pointer indicates that you can fill series?

  1. Doctor's symbol (Big Plus)
  2. small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. All of above
  

Question 285 :
You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?

  1. New
  2. Save As
  3. Edit
  4. Save
  

Question 286 :
A data map is helpful

  1. When you have too much data to chart
  2. To show a geographic distri-bution of data
  3. To compare data points
  4. To show changes in data over-time
  

Question 287 :
How can you show or hide the gridlines in Excel Worksheet?

  1. Go to Tools >> Options > > View tab and mark or remove the check box named Gridline
  2. Click Gridline tool on Forms toolbar
  3. Both of above
  4. Press F7
  

Question 288 :
To copy formatting from one area in a worksheet and apply it to another area you would use :

  1. The Edit > Copy Format and Edit>Paste Format commands form the menu.
  2. The Copy and Apply Formatting dialog box, located under the Formats Copy and Apply menu.
  3. There is no way to copy and apply formatting in Excel You have to do it manually
  4. The Format Painter button on the standard toolbar
  

Question 289 :
You can use the format painter multiple times before you turn it off by

  1. You can use the format painter button on ly one time when you click it
  2. Double clicking the format painter button
  3. Pressing the Ctrl key and clicking the format painter button
  4. Pressing the Alt key and clicking the format painter button
  

Question 290 :
You want to set such that when you type Baishakh and drag the fill .handle. Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

  1. Fill Across Worksheet
  2. Custom List
  3. Auto Fill Options
  4. Fill Series
  

Question 291 :
Macros are run or executed from the..... menu.

  1. Insert
  2. Format
  3. Tools
  4. Data
  

Question 292 :
Which of the following series type is not valid for Fill Series dialog box?

  1. Linear
  2. Growth
  3. Autofill
  4. Time
  

Question 293 :
Where can you set the shedding color for a range of cells in Excel?

  1. Choose required color form Patterns tab of Format Cells dialog box
  2. Choose required color on Fill Color tool in Formatting toolbar
  3. Choose required color on Fill Color tool in Drawing toolbar
  4. All of above
  

Question 294 :
While Finding and Replacing some data in Excel, which of the following statement is valid?

  1. You can Find and Replace within the sheet or workbook
  2. Excel does not have option to match case for find
  3. Excel cannot replace
  4. None are valid
  

Question 295 :
When integrating Ms-Word and Excel, Word is usually the

  1. Server
  2. Source
  3. Client
  4. None
  

Question 296 :
Bookl is an example of how ?... are numbered and named during each work session

  1. Active cell
  2. Formula bar
  3. Menu bar
  4. Name box
  

Question 297 :
On an Excel sheet the active cell in indicated by

  1. A dark wide border
  2. A dotted border
  3. A blinking border
  4. None of above
  

Question 298 :
What Is the correct way to refer the cell AID on sheets from sheetl?

  1. sheet3IA10
  2. sheetllAlO
  3. Sheets-A10
  4. A10
  

Question 299 :
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply t

  1. Use -ifO function to format the required numbers red
  2. Apply Conditional Formatting command on Format menu
  3. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  4. All of above
  

Question 300 :
You can add a hyperlink to your worksheet by pressing

  1. Alt + K
  2. Ctrl + H
  3. Ctrl + K
  4. Ctrl + Shift + K
  
Pages