Manage Question

Topics Question Option 1 Option 2 Option 3 Option 4 Answer Operation
MS EXCEL Press ______ to open the Excel formula window. Shift + F3 Shift + F2 Shift + F5 Shift + F7 A
MS EXCEL ______ inserts a new worksheet. Alt + Shift + F1 Alt + Shift + F2 Alt + Shift + F3 Alt + Shift + F4 A
MS EXCEL ___ operator, combines multiple references into one
reference.		 Ampersand Space Comma Colon C
MS EXCEL Which of the following is an active cell in excel? Cell address Range Formula Current cell D
MS EXCEL The fill series dialog box in Excel has ____ sections. 1 2 3 4 D
MS EXCEL In ______ tab you will find AutoSum button. Formatting tab Formulas tab Standard tab Clipboard tab B
MS EXCEL The extension name of Ms Excel is .PPTX .DOCX .XLSX .MDB C
MS EXCEL Which of the following characteristics is used to compute
dynamically the results from Excel data?		 Chart Formula and Function Table Diagram B
MS EXCEL Forms that are used to organise business data into rows and
columns are called		 Spreadsheets Business forms Registers Transaction sheet A
MS EXCEL In a spreadsheet program, the ___ contains related
worksheets and documents.		 Cell Formula Column Workbook D
MS EXCEL # VALUE! Refers to ___ Font value Error in value Subscript of the number value Addition of value B
MS EXCEL ____ sign is used to create an absolute cell reference. $ @ % & A
MS EXCEL When we can create a chart on a separate sheet in the same
workbook, it is called a		 Chart sheet Embedded chart View sheet View chart A
MS EXCEL Which Excel feature enables predefined layouts to selected
tables in the worksheet?		 Autograph Autoformat Header and Footer Spelling and Grammar B
MS EXCEL Press ____ to close the window of MS Excel. Esc Ctrl + Alt + C Alt + F4 Ctrl+W C
MS EXCEL ____ was the first spreadsheet on a microcomputer. VisiCalc Excel Lotus 1-2-3 StarCalc A
MS EXCEL How many rows are there in old version of MS Excel? 65536 65538 65534 65539 A
MS EXCEL When you enter text in a cell in Excel. It also appears in
the		 Status bar Formula bar Row heading Name box B
MS EXCEL In A3 cell edit = A1 + A2 refers to Addition of A1 and A3 will display in A2 Addition of A1 and A2 will display in A3 Addition of A1 and A2 will not display in A3 Addition of A2 and A3 will display in A1 B
MS EXCEL To select the entire column, press Tab + C Tab + E Alt + Space Ctrl + Space D
MS EXCEL ___ is the intersection of a row with a column. Cell Rows Columns All of these A
MS EXCEL The result of a formula in a cell is the Displayed value Range Value Label C
MS EXCEL Workbook is a collection of Worksheets Page set-up Buttons Diagrams A
MS EXCEL ____ is a powerful tool used to create and format
spreadsheets.		 Adobe Photoshop CS Mozilla Firefox Microsoft Office PowerPoint Microsoft Office Excel D
MS EXCEL Another name for a pre-programmed formula in Excel is Cell Graph Function Range C
MS EXCEL What are the basic rectangular building blocks of a
spreadsheet?		 Cells Zoom slider Help button All of these A
MS EXCEL ____ appear at the bottom of the Excel window. Title bar Formula bar Work sheet tabs Name box C
MS EXCEL What is the maximum number of rows in excel 2007 worksheet 1028176 1048576 1045876 None of these B
MS EXCEL Which of the following format you can decide or not in Auto
format dialog box		 Number format Border format Font format All of the above D
MS EXCEL An Excel is ---------------- program Spreadsheet Document Presentation None of these A
MS WORD The default tab stop position is.................. 1" 0.7" 0.5" None of these C
MS WORD In MS-Word text or logos that appear behind the text is
known as		 Subdocuments Watermark Bookmark None of these B
MS WORD Which of the following is not a font style Bold Italic Regular Superscript D
MS WORD Which file starts with MS Word? Winword.exe Word.exe Msword.exe Word356.exe A
MS WORD Select all the text in MS Word document by Ctrl+A Ctrl+C Ctrl+D Ctrl+P A
MS WORD Which bar shows the current position as far as the text
goes?		 Title bar Menu bar Scroll bar Status bar D
MS WORD Which enables us to send the same letter to different
people?		 Macros Template Mail Merge None of these C
MS WORD Mail merge option is available in.......................... Insert View Mailings Home C
MS WORD The short cut key of print is.................... Alt+P Shift+P Ctrl+P None of these C
MS WORD Page Borders is available in........................ Page Layout View Insert Home A
MS WORD If you type a word that is not in word dictionary , a
............................................. Wavy underline
appears below the word		 Green Blue Red Yellow C
MS WORD The extension of ms-word is
..................................		 .Txt .Dotx .Docx None C
MS WORD The shortcut of spelling and grammar correction
is...................................		 F12 F11 Ctrl+F7 F7 D
MS WORD The default tab stop position is
..................................		 1" 2" 1.15" 0.5" D
MS WORD The shortcut for save as is
.....................................		 Ctrl+v Ctrl+S Alt+S Alt+Ctrl+S B
MS WORD The total number of column we can insert in a table
is.......................................		 63 32767 16384 None A
MS WORD The term "word processor" allows
for..................................		 All Editing Formatting Printing A
MS WORD To close the active file without existing the application
press....................................		 Ctrl+C Ctrl+V Alt+W Ctrl+W D
MS WORD The default font Size in Ms-Word Is
usually..........................................		 12 11 14 10 B
MS WORD The default font style in Ms Word is
usually......................		 Arial Tahoma Callibri Times New Roman C
MS WORD User can use _____ commands to search for and correct words
in a document.		 Copy and Paste Find and Replace Header and Footer Print and Print preview B
MS WORD The process of making changes to an existing document is
referred to as ____ it.		 Editing Changing Creating Modifying A
MS WORD Which is not a page size in MS Word document? Letter A3 A4 Z100 D
MS WORD What is used to measure and line up objects in the document? Ruler Gridlines Document Map Thumbnails A
MS WORD In MS word we insert Text Box Table Page Number All of these D
MS WORD Which of the following option may be used to change
page-size and margins?		 Data Tools View Page Setup D
MS WORD To specify margins in word, the user has to select Page
Setup option from which menu?		 Page Layout Insert File View C
MS WORD To align right the selected text, the shortcut key is Ctrl+E Ctrl+R Ctrl+J Ctrl+L B
MS WORD What is a set of unified design elements that provides a
look for your document by using color, fonts and graphics?		 Highlight Format painter Line spacing Theme D
MS WORD Which of the following options is used to display
information such a title, page number of the document?		 Auto Correct Header and Footer Thesaurus Insert Table B
MS WORD Go to end of a document, press _____ End Home Back Space Enter A
MS WORD To move data from one part of the document to another,
following is used.		 Cut and Delete Cut and Paste Copy and Paste Copy and Undo B
MS WORD _____ are advanced features that can speed up editing or
formatting you may perform often in a word document.		 Comment Track Change Ribbon Macros D
MS WORD To cut the selected text, these keys should be pressed Ctrl+C Ctrl+V Delete Ctrl+X D
MS WORD The shortcut key to open a new file in MS Word is Ctrl+N Alt+N Ctrl+P Ctrl+V A
MS WORD What is the overall term for creating, editing, formatting,
storing, retrieving and printing a text document?		 Database Management Web design Spreadsheet design Word processing D
MS WORD Insert a ___ to illustrate and compare data. Chart Hyperlink Header Footer A
MS WORD Go to beginning of a document. press Home End Page Up None of these A
MS WORD The ____ is a customizable toolbar that contains commands
that you may want to use.		 Quick access toolbar Title bar View option toolbar Ribbon A
MS WORD The bar at the top of the window that bears the name of the
window is known as		 Title Bar Menu Bar Status Bar Clipboard A
MS WORD The document can be zoom maximum upto 100% 200% 400% 500% D
MS WORD Zoom in and out button is available on Scroll Bar Pagelayout Tab Home Tab View Option Toolbar D
MS WORD Microsoft Office Word creates a ____ for you when you press
ENTER or the SPACEBAR after you type the address of an
existing Web page.		 Hyperlink Header Chart Footer A
MS WORD Press ____ to open the help window in MS word document. F1 F2 F5 F12 A
MS WORD Which of the following software is used for making resume? MS Excel Ms Word Java None of these B
MS WORD The ___ works with the standard Copy and Paste Office Clipboard Paragraph dialog box View Tab None of these A
MS WORD Which is not an edition of MS Word? 2003 2007 2010 2020 D
MS WORD ____ cannot be used to work in MS Office. Light Pen Mouse Joystick Scanner C
MS WORD Which is not in MS word? Bold Font Color Font Magic Tool D
MS WORD Microsoft word is ____ software. System Application Programming Compiler B
© METHOD MEDIA COMPUTER ACADEMY PRIVATE LIMITED.
Design & Develop by MethodMedia