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




Question 181 :
In a worksheet you can select

  1. Entire worksheet
  2. Rows
  3. Columns
  4. a, b, and c
  

Question 182 :
If you press ..... the cell accepts your typing as its contents.

  1. Enter
  2. Ctrl + Enter
  3. TAB
  4. Insert
  

Question 183 :
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 184 :
Which of the following methods can not be used to enter data in a cell

  1. Pressing an arrow key
  2. Pressing the Tab key
  3. Pressing the Esc key
  4. Clicking on the formula bar
  

Question 185 :
Ctrl +p shortcut key in Excel will

  1. Open the font dialog box
  2. Apply double underline for the active cell
  3. Fill down in the selection
  4. All of above
  

Question 186 :
How can you find specific information in a list?

  1. Select Tools > Finder from the menu
  2. Click the Find button on the standard toolbar
  3. Select Insert > Find from the menu
  4. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
  

Question 187 :
You can copy data or formulas

  1. Wrth the copy, paste and cut commands on the edit menu
  2. With commands on the shortcut menu
  3. Wjth buttons on the standard toolbars
  4. All of the above
  

Question 188 :
Weight refers to

  1. The print density of characters
  2. The height of the printed character
  3. Upright or Santed shape
  4. The sign and appearance f characters
  

Question 189 :
To create a formula, you first:

  1. Select the cell you want to place the formula into
  2. Type the equals sign (-) to tell Excel that you're about to enter a formula
  3. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
  4. Choose the new command from the file menu
  

Question 190 :
Which area in an excel window allows entering values and formulas

  1. Title bar
  2. Menu bar
  3. Formula bar
  4. Standard toolbar
  

Question 191 :
Excel probably considers the cell entry January 1, 2000 to be a

  1. Label
  2. Value
  3. Formula
  4. Text string
  

Question 192 :
How many worksheets can a workbook have?

  1. 3
  2. 8
  3. 255
  4. All of above
  

Question 193 :
How do you select an entire column?

  1. Select Edit > Select > Column from the menu
  2. Click the column heading letter
  3. Hold down the shift key as you click anywhere in the column,
  4. Hold down the Ctrl key as you click anywhere in the column
  

Question 194 :
Status indicators are located on the

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

Question 195 :
To select an entire column in MS-EXCEL, press?

  1. CTRL + C
  2. CTRL + Arrow key
  3. CTRL + S
  4. All of the above
  

Question 196 :
Which of the following is the oldest spreadsheet package?

  1. VisiCalc
  2. Lotus 1-2-3
  3. Excel
  4. StarCalc
  

Question 197 :
Data marker on a chart are linked to data points in a . worksheet therefore,

  1. You can automatically apply formatting to a data series
  2. You can change the position of a data marker and automatically change the data point value in the worksheet
  3. You can change a data print value and automatically are draw the chart
  4. a and b
  

Question 198 :
All worksheet formula

  1. Manipulate values
  2. Manipulate labels
  3. Return a formula result
  4. Use the addition operator
  

Question 199 :
The Cancel and Enter buttons appear In the:

  1. Title bar
  2. Formula bar
  3. Menu bar
  4. Sheet tabs
  

Question 200 :
You can print

  1. A range of cells by range name
  2. An entire worksheet
  3. A single worksheet
  4. All of the above
  

Question 201 :
NOT, AND, OR and XOR are

  1. Logical Operators
  2. Arithmetic operators
  3. Relational operators
  4. None of the above
  

Question 202 :
You can automatically adjust the ! size of text in a cell if they do not fit in width by

  1. Double clicking on the right border of column header
  2. From Format choose Columns and then Autofit Selection
  3. From Format Cells dialog box mark Shrink to fit check box
  4. All of above
  

Question 203 :
what term describes a background that appears as a grainy, non smooth surface

  1. gradient
  2. pattern
  3. solid
  4. texture
  

Question 204 :
If you want all of the white cats grouped together In the database, you need to sort by__.

  1. Color, then Gender
  2. Pet Type, then Col or
  3. Pet Type, then Gender
  4. Color, then Pet Name
  

Question 205 :
When you see a cell with a red triangle in the top right corner, what does this signify?

  1. There is an error in the cell .
  2. There is a comment associated with the cell
  3. The font color for text in the cell is red
  4. A formula cannot be entered into the cell
  

Question 206 :
What will be the output If you format the cell containing 5436.8 as '#,##0.00'?

  1. 5,430.00
  2. 5,436.80.
  3. 5,436.8
  4. 6.8
  

Question 207 :
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 208 :
Which function calculates your monthly mortage payment?

  1. PMT (payments)
  2. NPER (number of periods)
  3. PV (present value)
  4. All of above
  

Question 209 :
The active cell:

  1. is defined by a bold border around the ceil.
  2. Receives the data the user enters.
  3. It is the formula bar.
  4. Only A and B
  

Question 210 :
Concatenation of text can be done using

  1. Apostrophe (')
  2. Exclamation (I)
  3. Hash(#)
  4. Ampersand (-)
  
Pages