Formula Addressing : The formula can have relative addressing absolute addressing and mixed addressing. In mail merge operation which of the following might represent the main document? Thoroughly research any product advertised on the site before you decide to download and install it. A View with a margins and gutter d. By Double Click on the Format Painter Icon c. Following section consists of some important multiple choice questions mcq on microsoft excel with answers.
Since the files are owned by Microsoft Publisher so they are created to be print-ready only. Will I be able to save files online with the Office Web apps? Bold the selected text d. Ctrl + ' Insert the value of the above cell into cell currently selected. Ctrl + Tab Move between two or more open Excel files. It allows users to download mails from the mail server to the local server and enables you to read the mail even if you are offline.
Allows you to format auto text entries d. Which feature is used to replace straight quotes with smart quotes as you type? Auto fit to Column 49. Function Library : It contains a library of functions e. What is the default left margin in Word 2003 document? Because you have a different printer at school than at home b. The updated Office will be available in two separate formats: a traditional and a. A Blue wavy line under the repeated word d. The suggestion of authors is highly appreciated and I will immediately remove the provided link in my website.
None of the all 60. Which option is not available in Insert Table Auto fit behavior? Format Painter cannot be use multiple times 64. Ctrl + Shift + % Format number in percentage format. Click on the Close button on the title bar b. Clipboard : A clipboard group contains the cut, copy and paste commands. By positioning your cursor at the appropriate place and pressing the F1 key b. What should you do if you require to paste the same format in many places? Auto Format as you type d.
What is the short cut key to open Font dialog box? Ctrl + F9 Minimise current workbook. Status Bar : It displays information about the currently active worksheet. Which would you choose to save a document with a new name? In which view Headers and Footers are visible. Any standout additions in PowerPoint? Hi Robert, how are you, thanks for posting in our microsoft community, I suggest that you read this information in the link below and see if it helps you: Best Regards ——————————————————— Note: This is a non-Microsoft website. How can you make the selected character super scripted a.
How many columns can you insert in a word document in maximum? As many as your computer memory will hold d. Auto fit to Window d. Sometimes question from this category are asked as part of the computer operation general knowledge section of basic computer awareness test. None of the above 26. Alt + Shift + Enter d. Ctrl + I Italic highlighted selection.
Click Tools, Options, Save d. Uppercase on Change Case dialog box and All Caps on Fonts dialog box both converts selected text into Capital Letters. What'll you be able to do with the Office 2010 Web apps? You'll have the option of saving files online, although you will have to sign up for a to take advantage of the cloud-based storage. Which of the following command is not available in Tools menu? The Web-based version of Office 2010, called Office Web apps, will include only Word, PowerPoint, Excel, and OneNote. How can you access the font size tool on formatting toolbar? It does not matter what widow version is installed in you computer, unfortunately you will not be able to edit Files with the.
The apps will allow for multiple people to edit the same files concurrently. As many as your task bar can display 42. What is the shortcut key for Spelling Check in document? For this particular file, the map shown as a straight. The placement of commands has been tweaked to make common tasks easier to find, and -- unlike in Office 2007 -- you'll be able to customize the Ribbon to your own personal preferences by adding, deleting, and relocating menu options. By pressing Ctrl + } d. Tables : It is used to define a range of cell as a table for easy filtering and storing and create a pivote table or chart to arrange and summarise the data. Ctrl + 5 Strike through highlighted selection.
What is the shortcut key to Update Formula in a table? Both b and c 61. What is the default number of lines to drop for drop cap a. Ctrl + Shift + ; Enter the current time. A view with a structure of heading at various levels 30. What's new in Outlook in Office 2010? What is the maximum number of lines you can set for a drop cap? Previous papers, different model papers can also seen here. Click the Tools menu and choose Auto Correct Options.