Learn and practice Aptitude questions and answers with explanation for interview, competitive exam (Pariksha Corner )

Sunday, January 19, 2020

You are creating a presentation using PowerPoint 2010. You want to search all of your slides for the text "sales" to replace it with "sales report". Which of the following PowerPoint features should you use to achieve the same?

You are creating a presentation using PowerPoint 2010. You want to search all of your slides for the text "sales" to replace it with "sales report". Which of the following PowerPoint features should you use to achieve the same?
AFind and Replace
BFormat Painter
CCut and Paste
DAnimations
View Answer

You are creating a presentation using PowerPoint 2010. You want to provide a unique set of colors, fonts and effects to create a consistent look and feel across all of your slides. Which of the following PowerPoint features should you use to achieve the Same?

You are creating a presentation using PowerPoint 2010. You want to provide a unique set of colors, fonts and effects to create a consistent look and feel across all of your slides. Which of the following PowerPoint features should you use to achieve the Same?
ATheme
BWatermark
CBookmark
DWordArt
View Answer

You want to enter information for one record at a time in an MS­Access table. Which of the following object should you create?

You want to enter information for one record at a time in an MS­Access table. Which of the following object should you create?
AForms
BTables
CViews
DQuery
View Answer

You have a large volume of data in your region­wise sales worksheet. You want toquickly analyze data to make better business decisions. Which of the following MS­ Excel object will you create to present your data for easy exploration and analysis?

You have a large volume of data in your region­wise sales worksheet. You want to quickly analyze data to make better business decisions. Which of the following MS­ Excel object will you create to present your data for easy exploration and analysis?
APivot Table
BTable
CSubtotal
DSlicer
View Answer

How will you convert the selected range of cells to a table in MS­Excel 2010?

How will you convert the selected range of cells to a table in MS­Excel 2010?
ABy clicking the Format as Table command in the Styles group on the Home tab.
BBy clicking the Conditional Formatting command in the Styles group on the Home tab.
CBy clicking the Cell Styles command in the Styles group on the Home tab.
DBy clicking the Insert command in the Cells group on the Home tab.
View Answer

You have entered the information in an MS­Excel worksheet as shown in the figure. What formula will you write in cell B4 for calculating sales amount?
Note: You will need to write the required formula with cell references.

You have entered the information in an MS­Excel worksheet as shown in the figure. What formula will you write in cell B4 for calculating sales amount?
Note: You will need to write the required formula with cell references.
A =B2*B3
BB2*B3
CA2*A3
D =A2*A3
View Answer

How will you convert an existing text in Word 2010 to a table?

How will you convert an existing text in Word 2010 to a table?
ASelect the text to be converted to table. Click Insert ­> Table ­> Convert Text to Table
BSelect the text to be converted to table. Click Layout ­> Table ­> Quick Tables
CSelect the text to be converted to table. Click Insert ­> Table ­> Draw Table
DSelect the text to be converted to table. Click Design ­> Forms &Table ­> Insert Table
View Answer

Categories