Computer Science MCQ - Set 10

Which setting you must modify to print a worksheet using letterhead?
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
The spelling dialog box can be involved by choosing spelling from ________ menu.
Which key do you press to check spelling?
To record a sequence of keystrokes and mouse actions to play back later we use:
We can save and protect the workbook by
The first cell in EXCEL worksheet is labeled as
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
What are the tabs that appear at the bottom of each workbook called?
What is represented by the small, black square in the lower-right corner of an active cell or range?
In Excel, a Data Series is defined as what?
In Excel, the Fill Color button on the Formatting toolbar is used for what?
In help menu of Excel, which of the following tabs are found?
A __________ is a grid with labeled columns and rows.
The active cell:
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
B7:B9 indicates:
The Cancel and Enter buttons appear in the:
MS-EXCEL can be used to automate
NOT, AND, OR and XOR are
In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be:
. You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
In order to perform a calculation in a spreadsheet, you need to use a:
The box on the chart that contains the name of each individual record is called the ________.
If you want all of the white cats grouped together in the database, you need to sort by ________.
You accidentally erased a record in the sheeWhat command can be used to restore it immediately?
Where a row and a column meet, what do you call that?
How do you tell one cell from another?
Give me an example of a cell address.
Which is an example of a formula?
Which is an example of a function?
What is the symbol for multiplying?
What is the symbol for dividing?
A function inside another function is called _______
Which of the following is not an underline option in the format cells dialog box?
Formulas in Excel start with
Which of the following is not an option of the spelling dialog box?
Which of the following methods will not enter data in a cell?
The cell reference for cell range of G2 to M12 is _______
What is the keyboard shortcut for creating a chart from the selected cell range?
The Software which contains rows and columns is called ______
What is the AutoComplete feature of Excel?
Which of the following is correct?
Which of the following function will return a value of 8?
How to restrict to run a macro automatically when starting Microsoft Excel?
How to remove the unwanted action from recorded macro without recording the whole macro again?
What should be add before a fraction to avoid entering it as a date?
Which of the following function will use to find the highest number in a series of number?
What does the NOW() function return?
What value will display if the formula = “$55.00″+5 is entered into a cell?
What is the shortcut key to insert current date in a cell?
 Which of the following syntax is correct regarding to SUM function in Excel?
What is the shortcut key to hide entire column?
How to specify cell range from A9 to A99 in Excel?
Selecting the Column G & H then choose Insert->ColumnWhat will happen?
How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Clear the contents by pressing “DELETE” key from a keyboard will clear 
Which of the following shortcuts can be used to insert a new line in the same cell?
What is the quickest way to select entire worksheet?
A smart tag will be removed from a cell when 
Which of the following options is appropriate to show the numbers 9779851089510 in a cell?
Which of the following is correct syntax in Excel?
Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?
If 4/6 entered in a cell without applying any formats, Excel will treat this as
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
How to fit long texts in a single cell with multiple lines?
If particular workbook have to open each time Excel started, where that workbook should be placed?
If the cell B1 contains the formula = $A$1, which of the following statements is true
Worksheet can be renamed by 
1What is the shortcut key to hide entire row?
What is the shortcut key to insert a new comment in a cell?
Which option allows you to Bold all the negative values within the selected cell range:
What is the shortcut key to insert new sheet in current workbook?
Which one is the last column header in Excel 2007?
In maximum, how many sheets can be set as default while creating new workbook? 
“New Comment” option can be found under _________ tab
In Excel, by default Numeric Values appears in
To show/hide the grid lines in Microsoft Excel 2007
What will be the result if you type =A1=B1 in cell C1?
In Excel _______ may not contain in Formula
Which tab is not available on left panel when you open a presentation?
Which of the following statements is not true?
To start Microsoft PowerPoint application
Which of the following section does not exist in a slide layout?
PowerPoint presentations are widely used as
_______ controls all the main slide control tasks for your presentation.
Which of the following cannot be toggled from View >> Toolbars?
Which of the following pane is not available in Task Pane?
A new presentation can be created from
In slide layout panel how many layouts are available for text layout by default?
Which of the following statement is false?
What lets you to create new presentation by selecting ready-made font color and graphics effects?
Which command will you use in PowerPoint if you need to change the color of different objects without changing content?
What PowerPoint feature will you use to apply motion effects to different objects of a slide?
What feature will you use to apply motion effects in between a slide exits and another enters?
The selected design template can be applied
The difference between Slide Design and Auto Content Wizard is
In which menu can you find features like Slide Design, Slide Layout etc.?
Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
How many steps are there between Start and Finish in AutoContent Wizard?
Which short cut key inserts a new slide in current presentation?
What happens if you select first and second slide and then click on New Slide button on toolbar?
Which of the following method can insert a new slide in current presentation?
Which of the following is not a part of Slide Design
What is the best way to create another copy of a slide?
From which menu you can access Picture, Test Box, Chart etc?
If you want to insert some slides from other presentation into current one choose
What are the three options available in Insert >> Picture menu?
To insert slide numbers
In a PowerPoint presentation
to insert a hyperlink in a slide
List Box and Text box
When you delete a text box object from a slide in PowerPoint Presentation
Which of the following font effect is not available in PowerPoint Font dialog box?
What happens if you edited an image inserted in PowerPoint
If you select Insert >> Picture >> From File
The effect applied to display when slides changes in slide show view is
To start slide show of a presentation
Which file format can be added to a PowerPoint show?
In Microsoft PowerPoint, two kinds of sound effects files that can be added to the presentation are
Material consisting of text and numbers is best presented as
What is a motion path?
What is a slide-title master pair?
Which of the following should you use if you want all the slides in the presentation to have the same ‘look’?
in the context of animations, what is a trigger?
If you have a PowerPoint show you created and want to send using email to another teacher you can add the show to your email message as a (an)
In order to edit a chart, you can
To exit the PowerPoint
To preview a motion path effect using the custom animation task pane, you should
You can create a new presentation by completing all of the following except
You can embed a MS-Organization Chart in a slide by
To select one hyperlink after another during a slide presentation, what do you press?