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




Question 241 :
Which of the following is not the correct method of editing the cell content?

  1. Press the Alt key
  2. Press the F2 key
  3. Click the formula bar
  4. Double click the cell
  

Question 242 :
What does SUMIF function do?

  1. Adds up cell values based on a condition
  2. Adds all the numbers in a range of cells
  3. Returns a subtotal in a list or database
  4. All of above
  

Question 243 :
How can you remove borders applied In cells?

  1. Choose None on Border , tab of Format cells
  2. Open the list on Border tool in Formatting toolbar then choose first tool (no border)
  3. Both of above
  4. None of above
  

Question 244 :
Tab scrolling button

  1. Allow you to view a different worksheet
  2. Allow you to view additional worksheet rows down
  3. Allow you to view additional worksheet columns to the right
  4. Allow you to view additional sheets tabs
  

Question 245 :
Which of the following is a popular DOS based spreadsheet package?

  1. Word
  2. Smart cell
  3. Excel
  4. Lotus 1-2-3
  

Question 246 :
How do you tell one cell from another?

  1. By numbers
  2. By letters
  3. By its address
  4. by color
  

Question 247 :
What happens when you press Ctrl + X after selecting some cells in Excel?

  1. The cell content of selected cells disappear from cell and stored in clipboard
  2. The cells selected are marked for cutting
  3. The selected cells are deleted and the ceils are shifted left
  4. The selected cells are deleted and cells are shifted up
  

Question 248 :
What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

  1. Select both cells, and then drag the fill handle over the range you- want, for instance 18 more rows
  2. Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
  3. Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
  4. All of above
  

Question 249 :
Which button do you click to add up a series of numbers?

  1. The autosum button
  2. The Formula button
  3. The quicktotal button
  4. The total button
  

Question 250 :
Getting data from a cell located in a different sheet is called.

  1. Accessing
  2. Referencing
  3. Updating
  4. Functioning
  

Question 251 :
Which types of charts can excel produce?

  1. Line graphs and pie charts only
  2. Only line graphs
  3. Bar charts, line graphs and pie charts
  4. Bar charts and line graphs only
  

Question 252 :
The horizontal and vertical lines on a worksheet are called

  1. cells
  2. sheets
  3. blocklines
  4. gridlines
  

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

  1. You can use the format painter button only 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 254 :
The minimum and maximum value you can set for Save AutoRecovery Info in Excel are

  1. 1 and 120 minutes
  2. O and 120 minutes
  3. 2 and 60 minutes
  4. 1 and 10 minutes
  

Question 255 :
How many characters can be typed in a single cell in Excel?

  1. 256
  2. 1024
  3. 32,000
  4. 65,535
  

Question 256 :
When you group worksheets

  1. You can enter variable data on multiple worksheets at one time
  2. You can print more than*one worksheet at a time
  3. You can enter common data, formats, and formulas on multiple worksheets at one time
  4. b, and c
  

Question 257 :
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 are
  2. On the file menu, click print, j and then click selection | under print what
  3. On the view menu, click custom views, then click add
  4. All of above
  

Question 258 :
Which of the following is not information you can specify using the solver?

  1. Input cells
  2. Constraints
  3. Target cell
  4. Changing cells
  

Question 259 :
You can merge the main document with data source in Excel. In mail merge operation, Word is usually

  1. server
  2. source
  3. client
  4. none
  

Question 260 :
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 261 :
Be default, Excel positions text in a cell ___.

  1. left-aligned
  2. right-aligned
  3. centered
  4. justified
  

Question 262 :
Which function Is not available In the Consolidate dialog box?

  1. Pmt
  2. Average
  3. Max
  4. Sum
  

Question 263 :
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

  1. Press the Erase key
  2. Press Esc
  3. Press the Enter button
  4. Press the Edit Formula button
  

Question 264 :
Which of the following Excel screen components can NOT be turned on or off ?

  1. Formula Bar
  2. Status Bar
  3. Tool Bar
  4. None of these
  

Question 265 :
You can use the formula palette to

  1. Format cells containing numbers
  2. Create and edit formulas containing functions
  3. Enter assumptions data
  4. Copy a range of cells
  

Question 266 :
Which of the following will not set text in selected cells to italics?

  1. Pressing Ctrl + I on the keyboard
  2. Using the Tools - Wizard -Web Form menu item
  3. Using the Format - Cells -Font menu item
  4. All of the above
  

Question 267 :
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

  1. Use Ctr! to select all three cells, then click the paste button on the standard toolbar
  2. Copy the selected cell, then elect the other two cells, click style on the Format menu, then click Modify
  3. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
  4. All of above
  

Question 268 :
Which of the following is invalid statement?

  1. Sheet tabs can be colored
  2. Some picture can be applied as a background of a sheet
  3. You can set the column width automatically fit the amount of text
  4. The width of a row and be specified manually or fit automatically
  

Question 269 :
A numeric value can be treated as label value If...... precedes It.

  1. Apostrophe (')
  2. Exclamation (I)
  3. Hash (#)
  4. Tilde(~)
  

Question 270 :
Got functions? No? You need the insert function dialog box. How do you get it?

  1. Right click a cell and then click insert
  2. Click the insert menu and then click function
  3. Type - in a cell
  4. All of the above
  
Pages