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