On This Page
This set of Office Automation Tools Multiple Choice Questions & Answers (MCQs) focuses on Office Automation Tools Set 4
Q1 | Which of the following methods will not enter data in a cell?
- pressing the esc key
- pressing an arrow key
- pressing the tab key
- clicking the enter button to the formula bar
Q2 | The cell reference for cell range of F2 to P12 is _______
- f2.p12
- f;p12
- f2:p12
- f2-p12
Q3 | What is the keyboard shortcut for creating a chart from the selected cell range?
- f2
- f4
- f8
- f11
Q4 | The Software which contains rows and columns is called ______
- database
- drawing
- spreadsheet
- word processing
Q5 | You can group non-contiguous worksheets with
- the alt+enter key
- the ctrl key and mouse
- the shift key and the mouse
- the group button on the standard toolbar
Q6 | Which of the following is not a valid Zoom percentage in Excel?
- 75
- 100
- 200
- 500
Q7 | The spelling tool is placed on ______ toolbar
- standard
- formatting
- drawing
- reviewing
Q8 | If you need a text to show vertically in a cell. How will you achieve this?
- choose vertical on text alignment in format cells dialog box
- choose 90 degrees in orientation of format cells dialog box
- choose distributed from the vertical drop down list of format cells dialog box
- choose centre across selection from horizontal combo box in format cells dialog box
Q9 | Can you set 0.5 inch left indentation for a cell in Excel?
- excel does not have indentation feature
- you can specify indentation only if you turn the rulers on
- indentation can be set from format cells dialog box
- the indentation can be specified only when printing
Q10 | You can automatically adjust the size of text in a cell if they do not fit in width by
- double clicking on the right border of column header
- from format choose columns and then auto fit selection
- from format cells dialog box mark shrink to fit check box
- all of above
Q11 | Formatting a cell in Currency, you can specify
- decimal places
- currency symbol
- both of above
- none of above
Q12 | Formatting a cell in Number format you can’t set
- decimal places
- use 1000 separator
- negative numbers
- currency symbol
Q13 | What is entered by the function =today()
- the date value for the day according to system clock
- the time value according to system clock
- today’s date as text format
- all of above
Q14 | Which function will you use to enter current time in a worksheet cell?
- today()
- 44711.89343
- 0
- 0
Q15 | Special category of Number tab in Format Cells dialog box can be used to applyformats like
- zip code
- phone number
- both of above
- none of above
Q16 | Merge cells option can be applied from
- format cells dialog box alignment tab
- formatting toolbar
- both of above
- none of above
Q17 | Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be appliedfrom
- from format >> cells
- from format >> auto format
- from table >> auto format
- all of above
Q18 | Which of the following format you can decide to apply or not in AutoFormat dialogbox?
- number format
- border format
- font format
- all of above
Q19 | How can you remove borders applied in cells?
- choose none on border tab of format cells
- open the list on border tool in formatting toolbar then choose first tool (no border)
- both of above
- none of above
Q20 | Where can you set the shedding colour for a range of cells in Excel?
- choose required colour form patterns tab of format cells dialog box
- choose required colour on fill colour tool in formatting toolbar
- choose required colour on fill colour tool in drawing toolbar
- all of above
Q21 | You can set Page Border in Excel from
- from border tab in format cells dialog box
- from border tool in formatting toolbar
- from line style tool in drawing toolbar
- you cannot set page border in excel
Q22 | When all the numbers between 0 and 100 in a range should be displayed in RedColour, apply
- use =if() function to format the required numbers red
- apply conditional formatting command on format menu
- select the cells that contain number between 0 and 100 then click red colour on text colour tool
- all of above
Q23 | You can check the conditions against __________ when applying conditionalformatting
- cell value
- formula
- both of above
- none of above
Q24 | Which of the following is not true regarding Conditional Formatting?
- you can add more than one condition to check
- you can set condition to look for bold and apply italics on them.
- you can apply font, border and pattern formats that meets the specified conditions
- you can delete any condition from conditional formatting dialog box if it is not required
Q25 | In Microsoft Excel 2007, the ----------- is used to issue commands
- quick access tool bar
- formula bar
- ribbon
- ms button