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




Question 301 :
Which of the following is the latest version of Excel

  1. Excel 2000
  2. Excel 2002
  3. Excel ME
  4. Excel XP
  

Question 302 :
The Name box on to the left of formula bar

  1. shows the name of workbook currently working on
  2. shows tne name of worksheet currently working on
  3. shows the name of cell or range currently working on
  4. All of above
  

Question 303 :
Two common wildcard characters that Excel recognizes are

  1. * and?
  2. < and >
  3. * and /
  4. + and ?
  

Question 304 :
Which Is an example of a formula?

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

Question 305 :
The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

  1. Click the Currency Style button on the formatting toolbar
  2. You have to retype everything and manually add the dollar signs, commas, and decimals.
  3. Select Format > Money from the menu
  4. All the above
  

Question 306 :
You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

  1. F9
  2. F5
  3. F8
  4. F11
  

Question 307 :
In order to perform a calculation in a spreadsheet, you need to use a:

  1. table
  2. formula
  3. field
  4. variable
  

Question 308 :
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

  1. Format Report
  2. Pivot Table
  3. ,'Refresh Data
  4. Show Detail
  

Question 309 :
The autofill feature

  1. extends a sequential series of data
  2. automatically adds range of cell values
  3. applies a boarder around the selected cells
  4. none of the above j
  

Question 310 :
The short cut key Ctrl +R is used in Excel to

  1. Right align the content of cell
  2. Remove the cell contents of selected cells
  3. Fill the selection with active t cells to the right
  4. All of above
  

Question 311 :
Status indicators are located on the

  1. Vertical scroll bar
  2. . Horizontal scroll bar
  3. Formula bar
  4. .Formatting toolbar
  

Question 312 :
We can save and protect 1he workbook by

  1. Write Reservation Password
  2. Protection Password
  3. Read-only Recommended
  4. Any of the above
  

Question 313 :
How are data organized in a spreadsheet?

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

Question 314 :
How are data organized in a spreadsheet?

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

Question 315 :
The arrows created by Auditing can be removed by

  1. Click on the arrow and press Delete '
  2. Click on Remove All arrows on Formula Auditing toolbar
  3. Both of above
  4. Press insert
  

Question 316 :
A function incite another function is called a .....function.

  1. Nested
  2. Round
  3. Sum
  4. Text
  

Question 317 :
Which of the following is invalid regarding the Protection in Excel?

  1. Protect Sheet
  2. Protect Workbook
  3. Protect Workspace
  4. All of above are valid
  

Question 318 :
Excel uniquely identifies cells within a worksheet with a cell name

  1. Cell names
  2. Column numbers and row letters
  3. Column letters and row numbers
  4. Cell locator coordinates
  

Question 319 :
Which command will you choose to convert a column of data into row?

  1. Cut and Paste
  2. Edit ? Paste Special ? Transpose
  3. Both of above
  4. Press F7
  

Question 320 :
You can use the drag and drop method to

  1. Copy cell contents
  2. Move cell contents
  3. Add cell contents
  4. a and b
  

Question 321 :
There are three types of data found in a spreadsheet.

  1. data, words, numbers
  2. equations, data, numbers
  3. words, numbers, labels
  4. numbers formulas, labels
  

Question 322 :
A constant is another name for this type of data:

  1. number
  2. equation
  3. formula
  4. description
  

Question 323 :
The divide symbol is

  1. /
  2. D
  3. )
  

Question 324 :
Which key do you press to check spelling?

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

Question 325 :
In help menu of Excel, which of the following tabs are found?

  1. Contents tab
  2. Answer Wizard tab
  3. Index tab
  4. all of the above
  

Question 326 :
How can you print three copies of a workbook?

  1. Select File>Properties form the menu and type 3 in the Copies to print text box.
  2. Select File >Print from the menu and type 3 in the Number of copies text box.
  3. Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made
  4. Press Ctri+P+3
  

Question 327 :
The intersection of a row and column is called :

  1. data
  2. afield
  3. a cell
  4. an equation
  

Question 328 :
Which of the following is not a way to complete a cell entry?

  1. Pressing enter
  2. Pressing any arrow key on the keyboard
  3. Clicking the Enter button on the Formula bar
  4. Pressing spacebar
  

Question 329 :
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

  1. From Edit menu choose Clear and then Formats
  2. From Edit menu choose Delete
  3. Click on Remove Formatting tool on Standard Toolbar
  4. Double click the Format Painter and then press Esc key in keyboard
  

Question 330 :
Which of the following formulas will Excel Not be able to calculate?

  1. =SUM(Sales)-A3
  2. =SUM(A1:A5)*.5
  3. =SUM(A1:A5)/(10-10)
  4. =SUM(A1:A5)-10
  
Pages