Office Automation (MS Office) – Previous Year Questions
42 questions from past HTET PGT Computer Science papers, each with the correct answer. Open any question for its explanation.
- Which function calculates the difference between two dates?
- The ? wildcard character represents :
- In Access .......... data type is used to store alphanumeric data, sentences or paragraph.
- In MS Access Index can not be defined using .......... field.
- Which Excel function determines whether a cell contains text, a number, a logical value, an array or an error?
- Which is the way to secure PowerPoint presentation?
- In PowerPoint, multiple sequential slides can be selected by clicking on first slide and then hold down .......... Key while you are clicking on last slide.
- In Excel, after .......... is on you can not change a locked item.
- In MS Word options available for vertical alignment is/are :
- In Excel, .......... refers to any cell containing static data such as numbers or text, but not formulas.
- Which Excel function counts the number of empty cells in specified range, which is its only argument?
- SUM function can be quickly entered in a cell by pressing ....... in Excel.
- In the page setup dialog box, following option(s) are available for orientation :
- What is/are the primary functions to look up the information stored in a list or table in Excel?
- .............. allows you to alter all the slides in the presentation.
- ............ is a drawing object which is usually printed as the background of text on all the pages of document.
- If data is organized in rows, which function is used to search a value ?
- .............. allows you to synthesize and analyze data from list or existing table.
- ............ command is used to duplicate the active document under different names ?
- Chart created on worksheet is called as .............. .
- A small dark square in the right hand corner of the cell is called as :
- In MS-Excel ..... option can be used to keep the desired rows and columns visible while the rest of the sheet scrolls.
- In context of MS-Word, with a ......... indent, the second and all the following lines of a paragraph are indented more than the first line of the paragraph.
- In MS-PowerPoint-2007, size of a slide can be set to A4 size using which of the following options ?
- In MS-PowerPoint function key F7 is used to ......... .
- Which of the following output is not expected from MS-excel function = RAND() ?
- In MS-Office Word, .......... option is used to navigate through structural view of document and ......... option is used to navigate long document through small pictures of each page.
- Which of the following pairs represents types of charts in MS- PowerPoint ?
- In MS-excel if ........ function key is pressed after entering a formula into a cell in place of Enter key, the result of formula is placed as value in the cell and the formula is removed from that cell.
- In MS-Office Word short cut key used to change case of selected text is :