Objective Questions on Ms Power Point in Ms Office set-2

Objective Questions on Ms Power Point in Ms Office set-2

1) A chart can be put as a part of the presentation using

A. Chart From Insert Menu

B. Picture and Choose Chart From Insert Menu

C. Chart From Tools Menu

D. Chart From Format Menu


2) Which of the following can you used to add times to the slide in a presentation?

A. Slide show menu

B. Rehearse timing button

C. Slide transaction button

D. All of the above


3) Which of the following provides a printed copy of your presentation?

A. Outlines

B. Speaker notes

C. Audience handouts

D. All of the above


4) Which shortcut key on the keyboard can be used to view slide show.

A. F1

B. F2

C. F5

D. F10


5) In order to edit a chart, you can

A. Triple Click the chart object

B. Click and drag the chart object

C. Double Click the chart object

D. Click the above


6) Which of the following is not an option when printing handouts?

A. Six slides per page

B. Five slides per page

C. Three slides per page

D. Two slides per page


7) Which option can be used to create a new slide show with the current slides but presented in a different order.

A. Rehearsal

B. Custom Slide Show

C. Slide Show Setup

D. Slide Show View


8) Which file format can be added to a power point show?

A. jpg

B. gif

C. wav

D. All of the above


9) Which of the following provides a means of printing out feature notes with a miniature slide on a printed page?

A. Slides with animation

B. Outline view

C. Notes page view

D. Audience handout


10) Slide show options available to the presenter include all of the following except

A. Transitions Command

B. Speaker Notes Command

C. Meeting Minder Command

D. Navigation Command

11) In Microsoft Power Point two kind of sound effects files that can be added to the presentation are

A. .wav files and .mid files

B. .wav files and .gif files

C. .wav files and .jpg files

D. .jpg files and .gif files


12) What are symbols used to identify items in a list?

A. Icons

B. Markders

C. Bullets

D. Graphics


13) Which of the following will not advance the slides in slide show view?

A. The Esc key

B. The Spacebar

C. The Enter key

D. Delete key


14) In the context of animations, what is a trigger?

A. An action button that advances to the next slide

B. An item on the slide that performs an action when clicked

C. The name of motion path

D. None of the above


15) The view that displays the slides of a presentation as miniature representations of the slides is called

A. Slide show

B. Slide sorter view

C. Notes page view

D. Outline view


16) Special effects used to introduction slides in a presentation are called

A. Effects

B. Custom Animation

C. Transitions

D. Present Animations


17) How can you quickly reinstate a deleted footer placeholder in master view?

A. Create a new slide master

B. Re-apply the footer placeholder

C. Re-apply the slide layout

D. None of the above


18) Which of the following should you do to bring a bullet back to a previous level?

A. Press the shift+tab keys

B. Press the shift key

C. Press the enter key

D. Press the tab key


19) Which of the following views is the best view to use when setting transaction effects for all slides in a presentation?

A. Slide sorter view

B. Notes Pages Views

C. Slide View

D. Outline View


20) Which of the following presentation elements can you modify using the slide master?

A. Slide comments

B. Slide transactions

C. Speaker note font and color

D. All of the above

Answers:

1) B. Picture and Choose Chart From Insert Menu
2) B. Rehearse timing button
3) C. Audience handouts
4) C. F5
5) C. Double Click the chart object
6) B. Five slides per page 
7) C. Slide Show Setup
8) D. All of the above
9) D. Audience handout
10) A. Transitions Command
11) A. .wav files and .mid files
12) C. Bullets
13) A. The Esc key
14) B. An item on the slide that performs an action when clicked
15) B. Slide sorter view
16)  C. Transitions
17) B. Re-apply the footer placeholder
18) A. Press the shift+tab keys
19) A. Slide sorter view
20) B. Slide transactions

Related Posts:

• Solved MCQ on Ms PowerPoint in Ms Office set-1
• Solved MCQ on Microsoft Excel in Ms Office set-1 
• Objective Questions on Ms Excel in Ms Office set-2 
• MCQ Questions on Microsoft Excel in Ms Office set-3 
• MCQ on Microsoft Excel in Ms Office with Answer set-4 
• Objective Questions on Microsoft Excel with Answer set-5
• Microsoft Word MCQ Questions with Answer set-5 
• Microsoft Word Objective Questions with Answers set-6 
• MCQ Questions and Answers on Ms Word set-7 
• Interview Questions on Microsoft Word set-8 
• Solved Interview Questions on Ms Word set-9 
• Objective Questions on Microsoft Word set-10

For More Multiple Choice Questions(MCQ's): Click Here

Solved MCQ on Ms PowerPoint in Ms Office set-1

Solved MCQ on Ms PowerPoint in Ms Office set-1

1) Which of the following toolbars provide different options in various master views?

A. Common Task Toolbar

B. Drawing Toolbar

C. Formatting Toolbar

D. Standard Toolbar


2) Which of the following allow you to select more than one slides in slide sorter view?

A. Alt+Click on each slide

B. Shift+Drag each slide

C. Shift+Click on each slide

D. Ctrl+Click each slide


3) The handout master contains placeholders for all of the following except

A. Slide number

B. Title

C. Footer

D. Header


4) Which of the following is the default page setup orientation for slide in Power Point?

A. Vertical

B. Landscape

C. Portrait

D. Tail


5) The boxes that are displayed to indicated that the text, pictures or objects are placed in it called ..

A. Placeholder

B. Auto text

C. Text Box

D. Word Art


6) Which of the following features should you use when typing in the notes text box?

A. Slide shows

B. Insert

C. Slide master

D. Zoom


7) Which of the following provides a means of printing our features notes with a miniature slide in printed page ?

A. Slides with animation

B. Outline view

C. Notes page

D. Audience handout


8) The slide that is used to introduce a topic and set the tone for the presentation is called the

A. Table Slide

B. Graph Slide

C. Bullet Slide

D. Title Slide


9) Which of the following bypass the print dialog box when printing individual slides of an entire presentation?

A. File, Print Preview

B. The Print button

C. File, Print

D. Ctrl+P


10) You can create a new presentation by completing all of the following except

A. Clicking the new button on the standard toolbar

B. Clicking File, New

C. Clicking on File, Open

D. Pressing CTRL+N


11) The power point view that display only text is

A. Slide show

B. Slide sorter view

C. Notes page view

D. Outline view


12) Which of the following toolbars provides different options in various master views?

A. Common tasks toolbar

B. Drawing toolbar

C. Formatting toolbar

D. Standard toolbar


13) Presentation designs regulate the formatting and layout for the slide and are commonly called

A. Design plates

B. Templates

C. Placeholders

D. Blueprints


14) Which of the following should you use if you want all the slides in the presentation to have the same look?

A. The slide, layout option

B. Outline View

C. Add a slide option

D. A presentation design template


15) Which of the following is the default page setup orientation for notes pages, outlines and handouts?

A. Vertical

B. Landscape

C. Portrait

D. None of the above


16) Animation schemes can be applied to in the presentation

A. All slides

B. Select Slides

C. Current Slide

D. All of the above


17) Which command bring you to the first slide in your presentation?

A. Next slide button

B. Page up

C. Ctrl+Home

D. Ctrl+End


18) Which of the following is the default page setup orientation for slides in Power Point?

A. Vertical

B. Landscape

C. Portrait

D. None of the above


19) To insert a new slide in the current presentation, we can choose

A. Ctrl+M

B. Ctrl+N

C. Ctrl+O

D. Ctrl+F


20) Material consisting of text and number is best presented as

A. A table slide

B. A bullet slide

C. A title slide

D. All of the above

Answers:

1) A. Common Task Toolbar
2) C. Shift+Click on each slide
3) B. Title
4) B. Landscape
5) A. Placeholder
6) D. Zoom
7) D. Audience handout
8) D. Title Slide
9) B. The Print button
10) C. Clicking on File, Open
11) D. Outline view
12) A. Common tasks toolbar
13) B. Templates
14) D. A presentation design template
15) C. Portrait
16) A. All slides
17) C. Ctrl+Home
18) B. Landscape
19) A. Ctrl+M
20) A. A table slide

Related Posts:

• Solved MCQ on Microsoft Excel in Ms Office set-1 
• Objective Questions on Ms Excel in Ms Office set-2 
• MCQ Questions on Microsoft Excel in Ms Office set-3 
• MCQ on Microsoft Excel in Ms Office with Answer set-4 
• Objective Questions on Microsoft Excel with Answer set-5
• Microsoft Word MCQ Questions with Answer set-5 
• Microsoft Word Objective Questions with Answers set-6 
• MCQ Questions and Answers on Ms Word set-7 
• Interview Questions on Microsoft Word set-8 
• Solved Interview Questions on Ms Word set-9 
• Objective Questions on Microsoft Word set-10

For More Multiple Choice Questions(MCQ's): Click Here

Interview Questions on Microsoft Excel with Answer set-6

Interview Questions on Microsoft Excel with Answer set-6

1) When you insert an excel file into a word document. The data are

A. Hyper-linked place in a word table

B. Linked

C. Embedded

D. Use the word menu bar and toolbars


2) All worksheet formula

A. Manipulate values

B. Manipulate labels

C. Return a formula result

D. Use the addition operator


3) Which of the following is available in Formula Auditing?

A. Trace Precedents

B. Trace Dependents

C. Trace Error

D. All


4) Concatenation of text can be done using ..

A. Apostrophe(')

B. Exclamation(!)

C. Hash(#)

D. Ampersand(&)


5) You can enter which types of data into worksheet cells?

A. Labels, values and formulas

B. Labels and values but not formulas

C. Values and formulas but not labels

D. Formulas only


6) Which of the following is NOT in sheet

A. Tab Color

B. Rename

C. Hide

D. All


7) Data can be arranged in a worksheet in an easy to understand manner using ..

A. Auto Formatting

B. Applying styles

C. Changing fonts

D. All of the above


8) A circular reference is

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous


9) Which of the following is used to copy the contents and formats of the bottom cell or cells of a selected range into the cells to the right.

A. Fill Left

B. Fill Up

C. Fill Right

D. Fill Down


10) Which area in an Excel windows allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar


11) When a label is too long to fit withing a worksheet cell, you typically must

A. Shorten the label

B. Increase the column width

C. Decrease the column width

D. Adjust the row height


12) A group of related data points plotted in a chart that originates from rows or columns on a single worksheet.

A. Data Label

B. Data Marker

C. Data Series

D. Legend


13) Name box locate on ..

A. Left size of formula bar

B. Right side of formula bar

C. Center of formula bar

D. None of the above


14) The ChartWizard term data categories refers to

A. A chart plot area

B. A horizontal axis

C. The organization of individual values with a chart's data series

D. The data range that supplies chart data


15) A box that identifies the patterns or colors assigned to the data series ..

A. Data Label

B. Data Marker

C. Data Series

D. Legend


16) You can not link excel worksheet data to a word document.

A. With the right drag method

B. With a hyperlink

C. With the copy and paste special commands

D. With the copy and paste button on the standard toolbar


17) Excel uniquely identifies cells within a worksheet with

A. Cell names

B. Column numbers and row numbers

C. Column letters and row numbers

D. Cell locator's coordinates


18) A bar, area or slice or other symbols in a chart that represents a single data point or value.

A. Data Label

B. Data Marker

C. Data Series

D. Legend


19) Which of the following methods cannot be used to entry data in a cell?

A. Pressing an arrow key

B. Pressing the tab key

C. Pressing the Esc key

D. Clicking on the formula bar


20) You want to view the progress of the stock market on a regular daily basis.

A. Pie chart

B. Row chart

C. Line chart

D. Column chart

Answers:

1) B. Linked
2) C. Return a formula result
3) D. All
4) D. Ampersand(&)
5) A. Labels, values and formulas
6) D. All
7) D. All of the above
8) C. A formula that either directly or indirectly depends on itself
9) B. Fill Up
10) C. Formula bar
11) B. Increase the column width
12) C. Data Series
13) A. Left size of formula bar
14) B. A horizontal axis
15) D. Legend
16) D. With the copy and paste button on the standard toolbar
17) C. Column letters and row numbers
18) B. Data Marker
19) A. Pressing an arrow key
20) C. Line chart

Related Posts:

• Solved MCQ on Microsoft Excel in Ms Office set-1 
• Objective Questions on Ms Excel in Ms Office set-2 
• MCQ Questions on Microsoft Excel in Ms Office set-3 
• MCQ on Microsoft Excel in Ms Office with Answer set-4 
• Objective Questions on Microsoft Excel with Answer set-5
• Microsoft Word MCQ Questions with Answer set-5 
• Microsoft Word Objective Questions with Answers set-6 
• MCQ Questions and Answers on Ms Word set-7 
• Interview Questions on Microsoft Word set-8 
• Solved Interview Questions on Ms Word set-9 
• Objective Questions on Microsoft Word set-10

For More Multiple Choice Questions(MCQ's): Click Here

Objective Questions on Microsoft Excel with Answer set-5

Objective Questions on Microsoft Excel with Answer set-5

1) Getting data from a cell located in a different sheet is called

A. Accessing

B. Referencing

C. Updating

D. Functioning


2) The default header for a worksheet is

A. Your name

B. The date and time

C. None

D. The sheet tab name


3) Excel worksheet cells work very similarly to what common element of the windows graphical user interface.

A. Option buttons

B. List boxes

C. Text boxes

D. Combo boxes


4) Which element of a worksheet can be protected from accidental modification.

A. Contents

B. Objects

C. Scenarios

D. All of the above


5) You can zoom a worksheet

A. With the zoom command on the view menu

B. With the mouse pointer in print preview

C. With the zoom button on the print preview toolbar

D. All of the above


6) If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

A. Press the Erase key

B. Press the Esc key

C. Press Enter button

D. Press the Edit Formula button


7) Which of the following not a valid data type in Excel ..

A. Number

B. Character

C. Label

D. Date/Time


8) Which of the following set-up option can not be set in the page set-up dialog box?

A. Printer selection

B. Vertical or horizontal placement

C. Orientation

D. Row and column titles


9) Text formulas

A. Replace cell references

B. Return ASCII Value of characters

C. Concatenate and manipulate text

D. Show formula error values


10) A numeric valued can be treated as a label value if it processes with ...

A. Apostrophe(')

B. Exclamation(!)

C. Hash(#)

D. Tilde(~)


11) When you print preview a worksheet

A. The entire worksheet is displayed

B. The select range is displayed

C. The active portion of the worksheet is displayed

D. All of the above


12) Excel Probably considers the cell entry January 1, 2015 to be a

A. A label

B. A Value

C. A formula

D. A text string


13) You can use drag and drop to embed excel worksheet data in a word document ...

A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

B. By dragging a range of excel data to the word button on the taskbar

C. While pressing the shift key

D. None of the above


14) When creating a vertical page break

A. The active cell must be A1

B. The active cell can be anywhere in the worksheet

C. The active cell must be in row

D. The active cell must be in column A


15) The ChartWizard term data series refers to

A. A chart legend

B. A collection of chart data markers

C. A set of values you plot in chart

D. A data label


16) When you link data maintained in an excel workbook to word document .

A. The word document cannot be edit

B. The word document contain a reference to the original source application.

C. The word document must contain a hyperlink

D. The word document contains a copy of the actual data


17) Grid lines

A. May be turned off for display but turned on for printing

B. May be turned on or off for display and printing

C. None of the above

D. Both A and B


18) To create a formula you can use

A. Values but not cell reference

B. Cell references but not values

C. Values or cell references although not both at the same

D. Values and cell references


19) To edit in an embedded excel worksheet object in a word documents

A. Use the excel menu bar and toolbars inside the word application

B. Edit the hyperlink

C. Edit the data in a excel source application

D. Use the word menu bar and toolbars


20) The chart wizard

A. Can place a chart on a new chart sheet or on sheet in the workbook

B. Can only place a chart on a new black worksheet

C. Can only be used to created embedded chart

D. Can only place a chart on a new chart sheet

Answers:

1) B. Referencing
2) C. None
3) C. Text boxes
4) D. All of the above
5) D. All of the above
6) B. Press the Esc key
7) C. Label
8) A. Printer selection
9) C. Concatenate and manipulate text
10) A. Apostrophe(')
11) D. All of the above
12) B. A Value
13) D. None of the above
14) C. The active cell must be in row
15) B. A collection of chart data markers
16) B. The word document contain a reference to the original source application.
17) D. Both A and B
18) D. Values and cell references
19) A. Use the excel menu bar and toolbars inside the word application
20) B. Can only place a chart on a new black worksheet

Related Posts:

• Solved MCQ on Microsoft Excel in Ms Office set-1 
• Objective Questions on Ms Excel in Ms Office set-2 
• MCQ Questions on Microsoft Excel in Ms Office set-3 
• MCQ on Microsoft Excel in Ms Office with Answer set-4
• Microsoft Word MCQ Questions with Answer set-5 
• Microsoft Word Objective Questions with Answers set-6 
• MCQ Questions and Answers on Ms Word set-7 
• Interview Questions on Microsoft Word set-8 
• Solved Interview Questions on Ms Word set-9 
• Objective Questions on Microsoft Word set-10

For More Multiple Choice Questions(MCQ's): Click Here

MCQ on Microsoft Excel in Ms Office with Answer set-4

MCQ on Microsoft Excel in Ms Office with Answer set-4

1) A cell contain up to ..

A. 56400 character

B. 32000 character

C. 45000 character

D. None of the above


2) To hold down column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command in the edit menu

D. Split command on the window menu


3) You want to track the progress of the stock market on a daily basis which type of chart should you use?

A. Pie chart

B. Row chart

C. Line chart

D. Column chart


4) When a formatted number does not fit in a cell, number signs

A. ###

B. #Div/0!

C. #div@

D. All of the above


5) It is acceptable to let long text flow into adjacent cell on a worksheet when

A. Data will be entered in the adjacent cells

B. No data will be entered in the adjacent cells

C. There is no suitable abbreviation for the text

D. There is not time to format the text


6) Which is used to perform what if analysis?

A. Solver

B. Goal seek

C. Scenario Manager

D. All of the above


7) To editing the formula

A. Double click on active cell

B. Press F2

C. Click on formula bar

D. All of the above


8) Which of the following in NOT information you can specify using the solver?

A. Input cells

B. Constraints

C. Traget cell

D. Changing cell


9) To insert three columns between columns d and e you would

A. Select column d

B. Select column e

C. Select column e, f and g

D. Select column c, d and e


10) What symbol is used before a number to make it a label?

A. *

B. =

C. _

D. '

11) Weight refers to

A. The print density of characters

B. The height of the printed characters

C. Upright or slanted shape

D. The design and appearance of characters


12) Which of the following is NOT one of Excel's what if functions?

A. Goal seek

B. Solver

C. Scenario Manager

D. Auto Outline


13) How many character can be typed in a single cell in excel?

A. 256

B. 254

C. 33000

D. 65536


14) When you work with large worksheets, you may need to

A. size the worksheet to fit a specific number of pages

B. Add and remove page breaks

C. Specify only certain print areas

D. All of the above


15) A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets


16) Comments put in cells are called ..

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip


17) When working in page break preview, you can ..

A. View exactly where each page break occurs

B. Change the print area

C. Add or remove page breaks

D. All of the above


18) When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell reference in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesn't adjust relative cell reference


19) We can insert comment ..

A. Comment from insert menu

B. Comment from tools menu

C. Comment from view menu

D. All of the above


20) Which of the following in not an option in the spelling dialog box?

A. Edit

B. Ignore

C. Ignore all

D. Change

Answers:

1) D. None of the above
2) B. Freeze panes command on the window menu
3) C. Line chart
4) A. ###
5) B. No data will be entered in the adjacent cells
6) D. All of the above
7) D. All of the above
8) A. Input cells
9) C. Select column e, f and g
10) D. '
11) A. The print density of characters
12) D. Auto Outline
13) D. 65536
14) D. All of the above
15) C. A group of cells
16) B. Cell Tip
17) D. All of the above
18) B. Excel edits cell reference in the newly copied formula
19) A. Comment from insert menu
20) A. Edit

Related Posts:

• Solved MCQ on Microsoft Excel in Ms Office set-1 
• Objective Questions on Ms Excel in Ms Office set-2 
• MCQ Questions on Microsoft Excel in Ms Office set-3
• Microsoft Word MCQ Questions with Answer set-5 
• Microsoft Word Objective Questions with Answers set-6 
• MCQ Questions and Answers on Ms Word set-7 
• Interview Questions on Microsoft Word set-8 
• Solved Interview Questions on Ms Word set-9 
• Objective Questions on Microsoft Word set-10

For More Multiple Choice Questions(MCQ's): Click Here

MCQ Questions on Microsoft Excel in Ms Office set-3

MCQ Questions on Microsoft Excel in Ms Office set-3

1) You can hyper-links from an Excel Workbook to

A. A web page on company Internet

B. A web page on the Internet

C. Other office application documents

D. All of the above


2) To activate the previous cell in a preselected range, press

A. The alt key

B. The tab key

C. The enter key

D. None of the above


3) Using the F11 short cut key to crate a chart on a chart sheet creates

A. A default chart

B. A 2-dimentional column chart

C. A 2-dimentional bar chart

D. A 3-dimentional line chart


4) 3-D reference in a formula ..

A. Can not be modified

B. Only appears on summary worksheet

C. Limits the formatting options

D. Spans worksheets


5) You can select single range of cell by

A. Clicking the upper left cell in a group of cells and then pressing the shift key while clicking the lower right cell in a group of cells.

B. Pressing the Ctrl key while dragging over the desired cells

C. Press the shift key and arrows key

D. Dragging over the desired cells


6) When you group worksheets

A. You can enter variable data on multiple worksheets at one time

B. You can print more than one worksheet at a time

C. You can enter common data, formats, and formulas on multiple worksheet at one time

D. Both B and C


7) In which short cut key used to switch between sheet to sheet

A. Ctrl+S

B. Ctrl+Page down

C. Ctrl+Page up

D. Both B and C


8) Rounding errors can occurs

A. When you use multiplication, division or exponentiation in a formula.

B. Because excel uses hidden decimal places in computation

C. When you use addition and subtraction in a formula

D. When you show the results of formula with different decimal places than the calculated results.


9) A 3-d reference in a formula

A. Cannot be modified

B. Only appears on summary worksheets

C. Limits the formatting options

D. Spans worksheets


10) The number of Rows are one worksheet is ...

A. 36500

B. 65536

C. 256

D. 64536

11) The auto calculate feature

A. Can only add values in a range of cells

B. Provides a quick way to view the results of a arithmetic operation on a range of cells

C. Automatically Creates formulas and adds them to a worksheet

D. Both A and C


12) Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A. Press Ctrl+Home

B. Press Home

C. Press Shift+Home

D. Press Alt + Home


13) The moving toolbar are also called ..

A. Long Toolbars

B. Active Toolbar

C. Floating Toolbar

D. All of the above


14) Which of the following is a correct order of precedence in formula calculation?

A. Multiplication and division, exponentiation, positive and negative values

B. Multiplication and division, positive and negative values, addition and subtraction

C. Addition and subtraction, positive and negative values, exponentiation

D. None of the above


15) Which button do you click to add up a series of numbers?

A. The auto sum button

B. The formula button

C. The quick total button

D. The total button


16) What are the major application area of electronic spread sheet's

A. Financial Modelling

B. Basic spreadsheet calculation

C. Scientific data processing

D. All of the above


17) In a Worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All


18) The paste special command lets you copy and paste

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula


19) The number of data format in excel is

A. Four type

B. Five Type

C. Two types

D. Six types


20) To view cell comment

A. Click the edit comment command on the insert menu

B. Click the display comment command on the window menu

C. Position the mouse pointer over the cell

D. Click the comment command on the view menu

Answers:

1) D. All of the above
2) D. None of the above
3) B. A 2-dimentional column chart
4) D. Spans worksheets
5) D. Dragging over the desired cells
6) D. Both B and C
7) D. Both B and C
8) A. When you use multiplication, division or exponentiation in a formula.
9) D. Spans worksheets
10) B. 65536
11) B. Provides a quick way to view the results of a arithmetic operation on a range of cells
12) A. Press Ctrl+Home
13) C. Floating Toolbar
14) D. None of the above
15) A. The auto sum button
16) D. All of the above
17) D. All
18) D. The resulting values of a formula instead of the actual formula
19) A. Four type
20) C. Position the mouse pointer over the cell

Related Posts:

• Solved MCQ on Microsoft Excel in Ms Office set-1 
• Objective Questions on Ms Excel in Ms Office set-2
• Solved MCQ Questions on Microsoft Word set-3 
• MCQ Questions on Ms Word with Answer set-4 
• Microsoft Word MCQ Questions with Answer set-5 
• Microsoft Word Objective Questions with Answers set-6 
• MCQ Questions and Answers on Ms Word set-7 
• Interview Questions on Microsoft Word set-8 
• Solved Interview Questions on Ms Word set-9 
• Objective Questions on Microsoft Word set-10

For More Multiple Choice Questions(MCQ's): Click Here