Excel Practice Set 2

-

 




Comments

Post a Comment

Popular posts from this blog

Computer Mcq Part 1 (1-50)

-
Image
 MCQ ABOUT COMPUTER FROM 1 TO 50 1. An Optical Input Device that interprets pencil marks on paper media is______ a) O.M.R b) Punch card reader c) Optical scanners d) Magnetic tape Answer: A 2. A Billionth of a second is defined as a______ a) Millisecond b) Microsecond c) Nanosecond d) Picoseconds Answer: C 3. CD-ROM stands for______ a) Compactable Read Only Memory b) Compact Data Read Only Memory c) Compactable Disk Read Only Memory d) Compact Disk Read Only Memory Answer: D 4. The Name box on to the left of formula bar______ a) shows the name of workbook currently working on b) shows the name of worksheet currently working on c) shows the name of cell or range currently working on d) None of above Answer: C 5. By Formatting a cell in Currency format, you can specify ? a) Decimal Places  b) Currency Symbol c) Both 1 and 2 Options d) None of above  Answer: C 6. The slide that is used to introduce a topic and set the tone for the presentat...
Read more

Computer MCQ Part 3 (101-150)

-
Image
 ALL ABOUT COMPUTER MCQ 101. Which command brings you to the first slide in your presentation? a) Next slide button b) Page up c) Ctrl + Home d) Ctrl + End Answer: C 102. Which file starts MS Word? a) Winword.exe b) word.exe c) word2003.exe d) 2007.exe Answer: A 103. Which is not a computer classification? a) Mainframe b) Maxframe c) Mini d) Notebook Answer: B 104. Which language is directly understood by the computer without translation program? a) Machine language b) Assembly language c) High level language d) None of above Answer: A 105. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition? a) Insert Menu b) Format Menu c) Tools Menu d) Slide Show Menu Answer: D 106. Which of the following features should you use while typing in the notes text box? a) Slide show  b) Insert c) Slide maser d) Zoom Answer: D 107. Which of the following is internal memory? a) Disks b) Pen Drives c) RAM d) CDs An...
Read more

COMPUTER MCQ PART 2 (51-100)

-
Image
 COMPUTER MCQ PART 2 (51-100) 51. Extension of a Database table file is ________ a) Wk4 b) .DBF c) .DBC d) .FDP Answer: B 52. Extension of a label file in FoxPro________ a) .qpr b) .css c) .lbx d) .xcs Answer: C 53. Extension of Excel 2007 file________ a) .xls b) .xlsx c) .exl d) none Answer: B 54. For Sorting the data we use are________ a) index b) Sort c) index and sort d) All of the Above Answer: D 55. Format Painter copy ? a) Text Formatting b) Object Formatting c) Both of these d) None Answer: C 56. FoxPro is a Kind of________ a) Database Application b) Spreadsheet Application c) Graphics Application d) None of These Answer: A 57. From which menu you can insert Header and Footer? a) Edit b) Insert c) View d) Home Answer: B 58. Getting data from a cell located in a different sheet is called ________ a) Accessing b) Referencing c) Updating d) Functioning Answer: B 59. How are data organized in a spreadsheet? a) Lines and s...
Read more