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




Question 211 :
Which of the cell pointer indicates you that you can make selection?

  1. Doctor's symbol (Big Plus)
  2. small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. Press F3 + Ctrl
  

Question 212 :
Hounding errors can occur

  1. When you use multiplication, division or exponentiation in a formula
  2. When you use addition and subtraction in a formula
  3. Because Excel uses hidden decimal places in computation
  4. When you show the results of formulas with different decimal places' than the calculated results
  

Question 213 :
To record a sequence of keystrokes and mouse actions to play back later we use:

  1. Media player
  2. Sound Recorder
  3. Calculator
  4. Macro Recorder
  

Question 214 :
when working in the page break preview, you can

  1. view exactly where each page break occurs
  2. add or remove page breaks
  3. change the print area
  4. all of above
  

Question 215 :
An Excel Workbook is a collection of.......

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

Question 216 :
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

  1. Right click on Sheet Tab of third sheet and choose Delete from the context menu
  2. Click on Sheet 3 and from Edit menu choose Delete
  3. Click on Sheet 3 and from Edit menu choose Insert
  4. None of above
  

Question 217 :
What does the VLOOKUP function do?

  1. Looks up text that contain V
  2. Checks whether text is the same in one cell as in the next
  3. Finds related records
  4. All of above
  

Question 218 :
You can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.

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

Question 219 :
You can print only an embedded chart by

  1. Moving the chart to a chart sheet before you print.
  2. Formatting the chart before you print
  3. Selecting the chart before you print
  4. a and c
  

Question 220 :
Give me an example of a cell address.

  1. 1125
  2. 911
  3. 41A
  4. A21
  

Question 221 :
To center 'worksheet titles across a range of cells, you must

  1. Select the cells containing the title text plus the range over which the title text is to be centered
  2. Widen the columns
  3. Select the cells containing the title text plus the range over which the title text is to be enfettered
  4. Format the cells with the comma style
  

Question 222 :
You can auto fit the width of column by

  1. double clicking on the column name orr-column header
  2. Double click on the cell pointer in worksheet
  3. Double clicking on column right border on column header
  4. Double clicking on the column left border of column header
  

Question 223 :
In the formula, which symbol specifies the fixed columns or rows?

  1. A.S
  2. *
  3. -
  

Question 224 :
Which is an example of a function?

  1. =add(AI:A2)
  2. =A1+A2
  3. ?SUM(A1:A2)
  4. A1+A2
  

Question 225 :
Which of the following formulas is not entered correctly?

  1. =10+50
  2. =B7*B1
  3. =B7+14
  4. 10+50
  

Question 226 :
You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?

  1. - (ampersand)
  2. = (equal sign)
  3. (space)
  4. All of the above
  

Question 227 :
What function cJtsplays row data in a column or column data in a row?

  1. Hypertink
  2. Index
  3. Transpose
  4. Rows
  

Question 228 :
You can check the conditions against ___ when applying conditional formatting

  1. Cell value
  2. Formula
  3. Both of above
  4. writing
  

Question 229 :
You can set Page Border in Excel from

  1. From Border tab in Format Cells dialog box
  2. From Border tool in Formatting toolbar
  3. From Line Style tool in Drawing toolbar
  4. You can not set page border in Excel
  

Question 230 :
Which of the following describes how to select all the cells in a single column?

  1. Right click on column and select Pick from list
  2. Use data - text to columns menu item
  3. Left click on the gray column title button
  4. Pressing Ctrl + A on the keyboard
  

Question 231 :
L Edit? Delete command

  1. Deletes the content of a cell
  2. Deletes Formats of cell
  3. Deletes the comment of cell
  4. Deletes selected cells
  

Question 232 :
In Excel, a Data Series is defined as what?

  1. A type of chart.
  2. A eel I reference.
  3. A collection of related data
  4. Adivision of results
  

Question 233 :
Data can be arranged in a worksheet in a easy to understand manner using

  1. auto formatting
  2. applying styles
  3. changing fonts
  4. all of above
  

Question 234 :
In a worksheet you can select

  1. The entire worksheet
  2. Rows
  3. Columns
  4. All of the above
  

Question 235 :
Hyperlinks can be

  1. Text
  2. Drawing objects
  3. Pictures
  4. All of above
  

Question 236 :
Which is not an advantage of using computerized spread sheets?

  1. flexibility of moving entries
  2. speed of calculation
  3. ability of generate tables
  4. cost of initial setup
  

Question 237 :
The Name box

  1. Shows the location of the previously active cell
  2. Appears t the left of the formula bar
  3. Appears below the status bar
  4. Appears below the menu bar
  

Question 238 :
The view that puts a blue a blue line around each page that would be printed is the......

  1. Print Preview
  2. Normal View
  3. Page Break Preview
  4. Split View
  

Question 239 :
In MS Access-,-a table can have__ primary key /keys.

  1. One
  2. Two
  3. Three
  4. Four
  

Question 240 :
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

  1. F8
  2. F9
  3. F10
  4. F11
  
Pages