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




Question 361 :
The cell reference fro a range of cells that starts in cell Bl and goes over to column G and down to row lOis......

  1. DB1-G10
  2. B1.G10
  3. B1;G10
  4. B1:G10
  

Question 362 :
You can activate a cell by

  1. Pressing the Tab key
  2. Clicking the cell
  3. Pressing an arrow key
  4. All of the above
  

Question 363 :
The autofill feature

  1. Extends a sequential series of data
  2. Automatically adds a range of cell values
  3. Applies a boarder around selected cells
  4. All of above
  

Question 364 :
When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as

  1. AutoFill
  2. AutoCorrect
  3. AutoComplete
  4. AutoFormat
  

Question 365 :
Which of the following is not a valid data type in Excel?

  1. Number
  2. Character
  3. Label
  4. Date/Time
  

Question 366 :
When a label is too long to fit within a worksheet cell, you typically must

  1. Shorten the label
  2. Increase the column width
  3. Decrease the column width
  4. Adjust the row height
  

Question 367 :
Which of the following is not a worksheet design criterion?

  1. Efficiency
  2. Auditabiiity
  3. Description
  4. Clarity
  

Question 368 :
Using the Fl 1 shortcut key to create a chart on chart sheet creates

  1. A default chart
  2. A 2-dimensional column chart
  3. A 2-dimensional bar chart
  4. A 3-dimensional line chart
  

Question 369 :
When a range is selected, how can you activate the previous cell?

  1. Press the Alt key
  2. Press Tab
  3. Press Enter
  4. All of above
  

Question 370 :
It is acceptable to let long text flow into adjacent cells on a worksheet when

  1. data will be entered in the adjecent cells
  2. no data will be entered in the adjacent cells
  3. there is no suitable abbrevition for the text
  4. there is not time to format the text
  

Question 371 :
What is the keyboard shortcut {button or buttons to be pressed) for creating a chart from the selected cells?

  1. F3
  2. F5
  3. F7
  4. F11
  

Question 372 :
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

  1. Scenario Summary report
  2. Goal Seek
  3. Forecasting
  4. Trend line
  

Question 373 :
To view a cell comment

  1. click the edit comment command on the insert menu
  2. click the display comment command on the window menu
  3. position the mouse pointer over the cell
  4. click the comment command on the view menu
  

Question 374 :
If you need a text to show vertically In a cell. How will you achieve this?

  1. Choose Vertical on Text alignment In Format Cells dialog box
  2. Choose 90 Degrees in Orientation of Format Cells dialog box
  3. Choose Distributed from the Vertical drop down list of Format Cells dialog box
  4. 'Choose Center Across Selection from Horizontal combo box In Format Cells dialog box
  

Question 375 :
Which of the following is not a valid Zoom

  1. 10
  2. 100
  3. 300
  4. 500
  

Question 376 :
You can use the horizontal and vertical scroll bars to

  1. Split a worksheet into two panes
  2. View different rows and columns
  3. Edit the contents of a cell
  4. View different worksheets
  

Question 377 :
You can select a single range of cells by

  1. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
  2. Pressing the Ctrl key while dragging over the desired cells
  3. Pressing the Shift key and an arrow key
  4. Dragging over the desired cells Correct
  

Question 378 :
To create a formula, you can use:

  1. Values but not cell references
  2. Cell references but not values
  3. Values or cell references although not both at the same time
  4. Value and cell references
  

Question 379 :
This type of software is similar to an accountant's worksheet

  1. Word processing
  2. Database
  3. Spreadsheets
  4. Graphics
  

Question 380 :
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 381 :
A worksheet range is a

  1. A command used for data modeling
  2. A range of values such as from 23 to 234
  3. A group of cells
  4. A group of worksheets
  

Question 382 :
Microsoft Excel Is a powerful...........

  1. Word processing package
  2. Spreadsheet package
  3. Communication S/W Package ,
  4. DBMS package
  

Question 383 :
A circular reference is

  1. Geometric modeling tool
  2. A cell that points to a drawing object
  3. A formula that either directly or indirectly depends on itself
  4. Always erroneous
  

Question 384 :
Comments can be added to cells using.....

  1. Edlt-> Comments
  2. Insert ?> Comment
  3. Fl I e-> Qomments
  4. Vlew-> Comments
  

Question 385 :
Which of the following can not be hidden from Tools > > Options then View tab?

  1. Startup Task Pane
  2. Formula bar
  3. Status bar
  4. Scroll Bar
  

Question 386 :
To save a workbook, you:

  1. Click the save button on the standard toolbar from the menu
  2. Press Ctrl+F5
  3. Click Save on the Windows Start button
  4. Select Edit>Save
  

Question 387 :
Each excel file is called a workbook because

  1. It can contain text and data
  2. It can be modified
  3. It can contain many sheets including worksheets and chart sheets
  4. You have to work hard to create it
  

Question 388 :
Which elements of a worksheet can be protected from accidental modification?

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

Question 389 :
Which of the following is not a worksheet design criterion?

  1. Efficiency
  2. Aditibility
  3. Description
  4. Clarity
  

Question 390 :
The chart wizard term data series refers to

  1. A chart legend
  2. A collection of chart data markers
  3. A set of values you plot in a chart
  4. A data label
  
Pages