Computer/Microsoft%20Excel%20MCQ%20Questions%20Part%206 Sample Test,Sample questions

Question:
Which elements of a worksheet can be protected from accidental modification?

1.Contents

2.Objects

3.Scenarios

4.All of above

Posted Date:-2021-02-11 17:39:23


Question:
 B7:B9 indicates

1.Cells B7 and cell B9 only.

2.Cells B7 through B9

3.Cell B8 only

4.None of above

Posted Date:-2021-02-11 17:39:23


Question:
 How many worksheets can a workbook have?

1.3

2.8

3.255

4.None of above

Posted Date:-2021-02-11 17:39:23


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

1.A type of chart.

2.A cell reference.

3. A collection of related data

4.A division of results

Posted Date:-2021-02-11 17:39:23


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

1.$

2.*

3.%

4.&

Posted Date:-2021-02-11 17:39:23


Question:
 Which key do you press to check spelling?

1.F3

2.F5

3.F7

4.F9

Posted Date:-2021-02-11 17:39:23


Question:
A numeric value can be treated as label value if …… precedes it.

1.Apostrophe

2.Exclamation

3.Hash

4.Tilde

Posted Date:-2021-02-11 17:39:23


Question:
A __________ is a grid with labeled columns and rows.

1.Dialog box

2.Worksheet

3.Clipboard

4.Toolbar

Posted Date:-2021-02-11 17:39:23


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

1.Workbooks

2.Worksheets

3.Charts

4. Worksheets and Charts

Posted Date:-2021-02-11 17:39:23


Question:
Concatenation of text can be done using

1.Apostrophe

2. Exclamation

3.Hash

4.Ampersand

Posted Date:-2021-02-11 17:39:23


Question:
Excel displays the current cell address in the ……….

1.Formula bar

2. Status Bar

3.Name Box

4.Title Bar

Posted Date:-2021-02-11 17:39:23


Question:
Getting data from a cell located in a different sheet is called

1.Accessing

2.Referencing

3.Updating

4.Functioning

Posted Date:-2021-02-11 17:39:23


Question:
How do you display current date and time in MS Excel?

1.date

2.Today

3.now

4.time

Posted Date:-2021-02-11 17:39:23


Question:
How do you display current date only in MS Excel?

1.date

2.Today

3.now

4.time

Posted Date:-2021-02-11 17:39:23


Question:
How do you rearrange the data in ascending or descending order?

1.Data Sort

2.Data Form

3.Data Table

4. Data Subtotals

Posted Date:-2021-02-11 17:39:23


Question:
How do you wrap the text in a cell?

1.Format cells font

2.Format cells protection

3.format cells number

4.Format cells alignment

Posted Date:-2021-02-11 17:39:23


Question:
In Excel the Fill Color button on the Formatting toolbar is used for what?

1.To insert a background.

2.To add borders.

3. To select a distribution of figures.

4.To add shading or color to a cell range.

Posted Date:-2021-02-11 17:39:23


Question:
In EXCEL you can sum a large range of data by simply selecting a tool button called …..?

1.AutoFill

2.Auto correct

3.Auto sum

4.Auto format

Posted Date:-2021-02-11 17:39:23


Question:
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 above

Posted Date:-2021-02-11 17:39:23


Question:
Which menu option can be used to split windows into two?

1.Format -> Window

2.View -> Window-> Split

3. Window -> Split

4.View –> Split

Posted Date:-2021-02-11 17:39:23


Question:
Microsoft Excel is a powerful………..

1. Word processing package

2.Spreadsheet package

3.Communication S/W Package

4.DBMS package

Posted Date:-2021-02-11 17:39:23


Question:
MS-EXCEL is based on ……….?

1.WINDOWS

2.DOS

3.UNIX

4.OS/2

Posted Date:-2021-02-11 17:39:23


Question:
Multiple calculations can be made in a single formula using…..

1.Standard Formulas

2.Array Formula

3.Complex Formulas

4. Smart Formula

Posted Date:-2021-02-11 17:39:23


Question:
The active cell:

1. is defined by a bold border around the cell.

2.Receives the data the user enters.

3.It is the formula bar

4.Only A and B.

Posted Date:-2021-02-11 17:39:23


Question:
The Cancel and Enter buttons appear in the

1.Title bar

2.Formula bar

3. Menu bar

4.Sheet tabs

Posted Date:-2021-02-11 17:39:23


Question:
The first cell in EXCEL worksheet is labeled as

1.AA

2.A1

3.Aa

4.A0

Posted Date:-2021-02-11 17:39:23


Question:
The spelling dialog box can be involved by choosing spelling from ________ menu.

1.insert

2.file

3.tools

4.view

Posted Date:-2021-02-11 17:39:23


Question:
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

Posted Date:-2021-02-11 17:39:23


Question:
To return the remainder after a number is divided by a divisor in EXCEL we use the function?

1.ROUND

2.FACT

3.MOD

4.DIV

Posted Date:-2021-02-11 17:39:23


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

1.CTRL + C

2.CTRL + Arrow key

3.CTRL + S

4.None of above

Posted Date:-2021-02-11 17:39:23


Question:
We can save and protect the workbook by

1.Write Reservation Password

2.Protection Password

3.Read-only Recommended

4.Any of the above

Posted Date:-2021-02-11 17:39:23


Question:
What are the tabs that appear at the bottom of each workbook called?

1.Reference tabs

2.Position tabs

3.Location tabs

4. Sheet tabs

Posted Date:-2021-02-11 17:39:23


Question:
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

1.XY Chart

2.Line Chart

3.Pie Chart

4.Column Chart

Posted Date:-2021-02-11 17:39:23


Question:
What do you mean by a Workspace?

1.Group of Columns

2.Group of Worksheets

3.Group of Rows

4.Group of Workbooks

Posted Date:-2021-02-11 17:39:23


Question:
What does COUNTA () function do?

1.counts cells having alphabets

2.counts empty cells

3.counts cells having number

4.counts non-empty cells

Posted Date:-2021-02-11 17:39:23


Question:
What happens when dollar signs ($) are entered in a cell address? 

1.An absolute cell address is created.

2.Cell address will change when it is copied to another cell.

3.The sheet tab is changed.

4.The status bar does not display the cell address.

Posted Date:-2021-02-11 17:39:23


Question:
What is represented by the small black square in the lower-right corner of an active cell or range?

1.Copy handle

2.Fill handle

3.Insert handle

4.Border

Posted Date:-2021-02-11 17:39:23


Question:
What is the correct way to refer the cell A10 on sheet3 from sheet1?

1.sheet3!A10

2.sheet1!A10

3.Sheet3.A10

4.A10

Posted Date:-2021-02-11 17:39:23


Question:
What is the short cut key to highlight the entire column?

1.Ctrl+C

2.Ctrl+Enter

3.Ctrl+Page Up

4.Ctrl+Space Bar

Posted Date:-2021-02-11 17:39:23


Question:
What will be the output if you format the cell containing 5436.8 as ‘###0.00′?

1.5430

2.5436.8

3.5436.8

4.6.8

Posted Date:-2021-02-11 17:39:23


Question:
Which area in an Excel window allows entering values and formulas?

1.Title Bar

2.Menu Bar

3.Formula Bar

4.Standard Tool Bar

Posted Date:-2021-02-11 17:39:23


Question:
Which Chart can be created in Excel?

1.Area

2.Line

3.Pie

4.all of above

Posted Date:-2021-02-11 17:39:23


Question:
Which function is not available in the Consolidate dialog box?

1.Pmt

2.Average

3.Max

4.Sum

Posted Date:-2021-02-11 17:39:23


Question:
Which function is used to calculate depreciation rates of return future values and loan payment amounts?

1.Logical

2. Math & Trigonometry

3.Statistical

4.Financial

Posted Date:-2021-02-11 17:39:23


Question:
Which is not the function of “Edit Clear” command?

1.Delete contents

2.Delete notes

3.Delete cells

4.Delete formats

Posted Date:-2021-02-11 17:39:23


Question:
Which language is used to create macros in Excel?

1.Visual Basic

2.C

3.Visual C++

4.Java

Posted Date:-2021-02-11 17:39:23


Question:
Which of the following is not a term of MS-Excel?

1.Cells

2.Rows

3.Columns

4.Document

Posted Date:-2021-02-11 17:39:23


Question:
Which of the following is not a valid data type in Excel?

1.Number

2.Character

3.Label

4.Date/Time

Posted Date:-2021-02-11 17:39:23


Question:
Which setting you must modify to print a worksheet using letterhead?

1.Paper

2.Margin

3.Layout

4.Orientation

Posted Date:-2021-02-11 17:39:23


Question:
Which would you choose to create a bar diagram?

1.Edit Chart

2.Insert Chart

3.Tools Chart

4.Format Chart

Posted Date:-2021-02-11 17:39:23


More MCQS

  1. Computer fundamentals
  2. Computer Basic MCQS
  3. CCC MCQ Sample Paper 1
  4. CCC Exams MCQS Sample Paper Test 2
  5. Computer Basics MCQS Paper 1
  6. Computer Basics MCQS Paper 2
  7. FUNDAMENTALS OF COMPUTERS MCQs PART 2
  8. FUNDAMENTALS OF COMPUTERS MCQs PART 1
  9. FUNDAMENTALS OF COMPUTERS MCQs PART 3
  10. Computer mcqs smaple paper 1
  11. Computer mcqs smaple paper 2
  12. Computer mcqs smaple paper 3
  13. Fundamentals of Computers
  14. Fundamentals of Computers (New) Part 1
  15. Fundamentals of Computers (New) Part 2
  16. Computer Networks MCQ Questions
  17. Computer Networks Transition from IPV4 to IPV6
  18. Computer Fundamentals (New) Part 1
  19. Computer Fundamentals (New) Part 2
  20. Computer Fundamentals (New) Part 3
  21. Computer Fundamentals (New) Part 4
  22. Computer Fundamentals (New) Part 5
  23. Computer Fundamentals (New) Part 6
  24. Computer Fundamentals (New) Part 7
  25. Computer Fundamentals (New) Part 8
  26. Operating Systems MCQs Part 1
  27. Operating Systems MCQs Part 2
  28. OS(Computer Operating Systems) Part 1
  29. OS(Computer Operating Systems) Part 2
  30. OS(Computer Operating Systems) Part 3
  31. OS(Computer Operating Systems) Part 4
  32. OS - Computer Operating Systems Part 5
  33. OS - Computer Operating Systems Part 6
  34. OS - Computer Operating Systems Part 7
  35. MS Word MCQ Questions Part 1
  36. MS Word MCQ Questions Part 2
  37. MS Word MCQ Questions Part 3
  38. MS Word MCQ Questions Part 4
  39. MS Word MCQ Questions Part 5
  40. MS Word MCQ Questions Part 7
  41. MS Word MCQ Questions Part 6
  42. Microsoft Excel MCQ Questions Part 1
  43. Microsoft Excel MCQ Questions Part 2
  44. Microsoft Excel MCQ Questions Part 3
  45. Microsoft Excel MCQ Questions Part 4
  46. Microsoft Excel MCQ Questions Part 5
  47. Microsoft Excel MCQ Questions Part 6
  48. Microsoft Excel MCQ Questions Part 7
  49. MS PowerPoint MCQ Questions PART 1
  50. MS PowerPoint MCQ Questions PART 2
  51. MS PowerPoint MCQ Questions PART 3
  52. MS PowerPoint MCQ Questions PART 4
  53. MS PowerPoint MCQ Questions PART 5
  54. MS PowerPoint MCQ Questions PART 6
  55. MS PowerPoint MCQ Questions PART 7
  56. MS Access MCQ Questions Part 1
  57. MS Access MCQ Questions Part 2
  58. MS Access MCQ Questions Part 3
  59. MS Access MCQ Questions Part 4
  60. MS Access MCQ Questions Part 5
  61. MS Access MCQ Questions Part 6
  62. MS Access MCQ Questions Part 7
  63. MS Access MCQ Questions Part 8
  64. Query of MS Access MCQS Part 1
  65. Query of MS Access MCQS Part 2
  66. Computer Communication and Networking Quiz
  67. Computer Graphics MCQ Quiz Questions and Answers
  68. Computer Basics Quiz Questions
  69. Computer Quiz Questions with Answers
  70. Computer Hardware MCQS Quiz
  71. MCQ Computer Organization & Architecture
  72. MCQ Computer Organisation - Input & output Organisation SET1
  73. MCQ Computer Organisation - Input & output Organisation SET2
  74. MCQ Computer Organisation - Input & output Organisation SET3
  75. MCQS on addressing modes SET 1
  76. MCQS on addressing modes SET 2
  77. Software Engineering MCQs SET 1
  78. Software Engineering MCQs SET 2
  79. Software Engineering MCQs Set 3
  80. Software Engineering MCQs Set 4
  81. Software Engineering MCQs Set 5
  82. Software Engineering MCQs Set 6
  83. Software Engineering MCQs Set 7
  84. mcqs data structures
  85. CCC Exam Sample MCQ Paper
  86. Computer MCQ Questions set-1
  87. Computer MCQ Questions set-2
  88. Computer MCQ Questions set-3
  89. Current affairs mcq Database management
  90. Programming arcitecture
  91. Computer Graphics MCQ Questions part 1
  92. Computer Graphics MCQ Questions part 2
  93. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 1
  94. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 2
  95. Computer Science MCQs
  96. Computer Mcq Question
  97. MCQs based on Fundamentals of Computer 1 set
  98. Computer Mcq Question set 2
  99. MCQ Encoding Schemes
  100. Data Entry and Keyboarding Skills MCQ
  101. Computer Science Number System
  102. Computer Network MCQ
  103. MCQ Questions on Tally
  104. MCQ Questions on Tally Set 2
  105. MCQ Questions on Tally Set 3
  106. MCQ Questions on Tally Set 4
  107. Internet Technology MCQ Questions for Competitive Exams
  108. Computer Software MCQ GK Questions
  109. Computer Organization and Architecture MCQs
  110. Basic Computer GK Questions
  111. Computer Graphics MCQ Set 1
  112. Operating System MCQ Set 1
  113. Operating System MCQ Set 2
  114. Operating System MCQ Set 3
  115. Operating System MCQ Set 4
  116. Operating System MCQ Set 5
  117. Operating System MCQ Set 6
  118. Operating System MCQ Set 7
  119. Operating System MCQ Set 8
  120. Operating System MCQ Set 9
  121. Operating System MCQ Set 10
  122. Operating System MCQ Set 11
  123. Operating System MCQ Set 12
  124. Operating System MCQ Set 13
  125. Operating System MCQ Set 14
  126. Operating System MCQ Set 15
  127. Operating System MCQ Set 16
  128. Operating System MCQ Set 17
  129. Operating System MCQ Set 18
  130. Operating System MCQ Set 19
  131. Operating System MCQ Set 20
  132. Operating System MCQ Set 21
  133. Computer Graphics MCQ Question Set 1
  134. Computer Networks MCQs
  135. Computer Networks MCQs Set-2
  136. Computer Networks MCQs Set-3
  137. Computer Networks MCQs Set-4
  138. Bachelor of Computer Applications MCQs set-1
  139. Bachelor of Computer Applications MCQs set-2
  140. NET Programming MCQ
  141. Artificial Intelligence and Robotics (AIR) Set 1
  142. Artificial Intelligence and Robotics (AIR) Set 2
  143. Computer Engineering Soft Computing Set 1
  144. Computer Engineering Soft Computing Set 2
  145. COMPUTERS AND IT MCQs QUESTIONS
  146. Ancient Indian History MCQ
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!