Home ≫ General Knowledge ≫ Computer ≫ Page 23
221. The letter and number of the intersecting column and row is the
  A.  cell location
  B.  cell address
  C.  cell position
  D.  cell coordinates
     
   
View Answer

222. Magnifier button is available on
  A.  Print Preview toolbar
  B.  Standard toolbar
  C.  Formatting toolbar
  D.  Both ‘A’ and ‘B’
     
   
View Answer

223. Which of the following is not a valid formula in Microsoft Excel?
  A.  =A2 + 1
  B.  =A2 + A1
  C.  =1 + A2
  D.  =1A + 2
     
   
View Answer

224. Which command is used to calculate total characters in a cell?
  A.  Length
  B.  Sid
  C.  Len
  D.  Mid
     
   
View Answer

225. The function TODAY( ) in Excel, enters the current
  A.  system time in a cell
  B.  time at which the current file was opened
  C.  system date and time in a cell
  D.  system date only
     
   
View Answer

226. Which of the following characteristics is used to compute dynamically the results from Excel data?
  A.  Goto
  B.  Diagram
  C.  Formula and function
  D.  Table
     
   
View Answer

227. Which area in an Excel window allows entering values and formulas?
  A.  Title Bar
  B.  Menu Bar
  C.  Standard Toolbar
  D.  Formula Bar
     
   
View Answer

228. In Excel, charts are created using which option?
  A.  Pivot table
  B.  Chart wizard
  C.  Pie chart
  D.  Bar chart
     
   
View Answer

229. Which of the following commands in Office 2007, can be used to go to the first cell in the current row?
  A.  Shift + Home
  B.  Shift + Tab
  C.  Esc + Home
  D.  Tab
     
   
View Answer

230. In a worksheet in MS-Excel, what is shortcut key to hide entire row?
  A.  Ctrl + 2
  B.  Ctrl + N
  C.  Ctrl + 9
  D.   Ctrl + −
     
   
View Answer

Copyright © 2020-2022. All rights reserved. Designed, Developed and content provided by Anjula Graphics & Web Desigining .