On This Page
This set of Office Automation Tools Multiple Choice Questions & Answers (MCQs) focuses on Office Automation Tools Set 5
Q1 | You can auto fit the width of column by
- double clicking on the column name on column header
- double click on the cell pointer in worksheet
- double clicking on column right border on column header
- double clicking on the column left border of column header
Q2 | Long text can be broken down into many lines within a cell. You can do this through
- wrap text in format >> cells
- justify in edit >> cells
- text wrapping in format >> cells, layout tab
- all of above
Q3 | MS Excel provides the default value for step in Fill Series dialog box
- 0
- 1
- 5
- 10
Q4 | Ctrl + D shortcut key in Excel will
- open the font dialog box
- apply double underline for the active cell
- fill down in the selection
- none of above
Q5 | The short cut key Ctrl + R is used in Excel to
- right align the content of cell
- remove the cell contents of selected cells
- fill the selection with active cells to the right
- none of above
Q6 | The command Edit >> Fill Across Worksheet is active only when
- one sheet is selected
- when many sheets are selected
- when no sheet is selected
- none of above
Q7 | Which of the following series type is not valid for Fill Series dialog box?
- linear
- growth
- auto fill
- time
Q8 | Which of the following you can paste selectively using Paste Special command?
- validation
- formats
- formulas
- all of above
Q9 | Paste Special allows some operation while you paste to new cell. Which of thefollowing operation is valid?
- square
- percentage
- goal seek
- divide
Q10 | Edit >> Delete command
- deletes the content of a cell
- deletes formats of cell
- deletes the comment of cell
- deletes selected cells
Q11 | To remove the content of selected cells you must issue ______ command
- edit >> delete
- edit >> clear >> contents
- edit >> clear >> all
- data >> delete
Q12 | The Delete key of keyboard is assigned to which command in Excel?
- edit >> clear >> contents
- edit >> clear >> all
- edit >> delete
- all of above
Q13 | If you need to remove only the formatting done in a range (numbers and formulatyped there should not be removed), you must
- from edit menu choose clear and then formats
- from edit menu choose delete
- click on remove formatting tool on standard toolbar
- double click the format painter and then press esc key in keyboard
Q14 | By default Excel provides 3 worksheets. You need only two of them, how willyou delete the third one?
- right click on sheet tab of third sheet and choose delete from the context menu
- click on sheet 3 and from edit menu choose delete
- both of above
- none of above
Q15 | Which of the following action removes a sheet from workbook?
- select the sheet, then choose edit >> delete sheet
- select the sheet then choose format >> sheet >> hide
- both of above
- none of above
Q16 | While finding and replacing some data in Excel, which of the followingstatement is valid?
- you can find and replace within the sheet or workbook
- excel does not have option to match case for find
- both are valid
- none are valid
Q17 | Which of the following is not true about Find and Replace in Excel
- you can search for bold and replace with italics
- you can decide whether to look for the whole word or not
- you can search in formula too
- you can search by rows or columns or sheets
Q18 | You can move a sheet from one workbook into new book by
- from edit menu choose move or copy sheet, mark the create a copy and click ok
- from edit menu choose move of copy then choose (move to end) and click ok
- from edit menu choose move or copy then select (new book) from to book list and click ok
- none of above
Q19 | What is the short cut key to replace a data with another in sheet?
- ctrl + r
- ctrl + shift + r
- ctrl + h
- ctrl + f
Q20 | To start Microsoft PowerPoint application
- click on start >> programs >> all programs >> microsoft powerpoint
- hit ctrl + r then type ppoint.exe and enter
- click start >> run then type power point then press enter
- all of above
Q21 | Which tab is not available on left panel when you open a presentation?
- outline
- slides
- notes
- all of above are available
Q22 | Which of the following statements is not true?
- you can type text directly into a powerpoint slide but typing in text box is more convenient.
- from insert menu choose picture and then from file to insert your images into slides.
- you can display a powerpoint presentation in normal, slide sorter or slide show view.
- you can show or hide task pane from view >> toolbars
Q23 | Which of the following section does not exist in a slide layout?
- titles
- lists
- charts
- animations
Q24 | PowerPoint presentations are widely used as
- note outlines for teachers
- project presentations by students
- communication of planning
- all of above
Q25 | _______ controls all the main slide control tasks for your presentation.
- task pane
- task bar
- control panel
- none of above