Computer/Microsoft Excel MCQ Questions Part 6 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


Question:
 B7:B9 indicates

1.Cells B7 and cell B9 only.

2.Cells B7 through B9

3.Cell B8 only

4.None of above


Question:
 How many worksheets can a workbook have?

1.3

2.8

3.255

4.None of above


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


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

1.$

2.*

3.%

4.&


Question:
 Which key do you press to check spelling?

1.F3

2.F5

3.F7

4.F9


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

1.Apostrophe

2.Exclamation

3.Hash

4.Tilde


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

1.Dialog box

2.Worksheet

3.Clipboard

4.Toolbar


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

1.Workbooks

2.Worksheets

3.Charts

4. Worksheets and Charts


Question:
Concatenation of text can be done using

1.Apostrophe

2. Exclamation

3.Hash

4.Ampersand


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

1.Formula bar

2. Status Bar

3.Name Box

4.Title Bar


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

1.Accessing

2.Referencing

3.Updating

4.Functioning


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

1.date

2.Today

3.now

4.time


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

1.date

2.Today

3.now

4.time


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

1.Data Sort

2.Data Form

3.Data Table

4. Data Subtotals


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


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.


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


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


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


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

1. Word processing package

2.Spreadsheet package

3.Communication S/W Package

4.DBMS package


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

1.WINDOWS

2.DOS

3.UNIX

4.OS/2


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

1.Standard Formulas

2.Array Formula

3.Complex Formulas

4. Smart Formula


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.


Question:
The Cancel and Enter buttons appear in the

1.Title bar

2.Formula bar

3. Menu bar

4.Sheet tabs


Question:
The first cell in EXCEL worksheet is labeled as

1.AA

2.A1

3.Aa

4.A0


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

1.insert

2.file

3.tools

4.view


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


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


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

1.CTRL + C

2.CTRL + Arrow key

3.CTRL + S

4.None of above


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


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


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


Question:
What do you mean by a Workspace?

1.Group of Columns

2.Group of Worksheets

3.Group of Rows

4.Group of Workbooks


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


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.


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


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


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


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


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


Question:
Which Chart can be created in Excel?

1.Area

2.Line

3.Pie

4.all of above


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

1.Pmt

2.Average

3.Max

4.Sum


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


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

1.Delete contents

2.Delete notes

3.Delete cells

4.Delete formats


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

1.Visual Basic

2.C

3.Visual C++

4.Java


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

1.Cells

2.Rows

3.Columns

4.Document


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

1.Number

2.Character

3.Label

4.Date/Time


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

1.Paper

2.Margin

3.Layout

4.Orientation


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

1.Edit Chart

2.Insert Chart

3.Tools Chart

4.Format Chart


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. Data Structures and algorithms MCQ Questions
  67. Computer Communication and Networking Quiz
  68. Computer Graphics MCQ Quiz Questions and Answers
  69. Computer Basics Quiz Questions
  70. Computer Quiz Questions with Answers
  71. Computer Hardware MCQS Quiz
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!