- Chapter 5 exam exploring microsoft office excel 2013 serial#
- Chapter 5 exam exploring microsoft office excel 2013 update#
Chapter 5 exam exploring microsoft office excel 2013 update#
Use the word menu bar and toolbars AnswerĮxplanation : When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. When you insert an excel file into a word document.
Which of following is Not one of Excel’s what-if function?Įxplanation : Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.ĩ. This causes the formula to use its result in the calculation, which can create errors.Ĩ. A formula that either directly or indirectly depends on itselfĮxplanation : A circular reference occurs when a formula directly or indirectly refers to its own cell. It is designed for the 1997 and earlier versions of Excel.ī. The Internet Assistant helps you convert your spreadsheet data to HTML format. You can convert existing excel worksheet data an charts to an HTML document by usingĮxplanation : The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. It can precede the column reference, the row reference or both.Ħ. In the formula, which symbol specifies the fixed columns or rows?Įxplanation : The absolute cell reference in excel is a cell address that contains a dollar sign ($). What is the short cut key to highlight the entire column?Įxplanation : Ctrl + Space Bar is the short cut key to highlight the entire column.ĥ. COUNTA function does not count empty cells.Ĥ. On the Home tab, in the Alignment group, click Wrap Text.Įxplanation : COUNTA function counts cells containing any type of information, including error values. We can format the cell so the text wraps automatically, or enter a manual line break.
Chapter 5 exam exploring microsoft office excel 2013 serial#
How do you display current date only in MS Excel?Įxplanation : DATE – returns the serial date value for a dateĮxplanation : Microsoft Excel can wrap text so it appears on multiple lines in a cell. MS Excel Objective Questions and Answersġ. Answer Different types of Objective Questions on Micro Soft Excel and revise the complete concept in a quick way. Utilize these Excel MCQ Questions with Answers as a part of your preparation for exams such as UPSC, SSC, IBPS and score maximum grades in exams. We have outlined all the Important Multiple Choice Questions on Excel for your comfort after ample research. If you are in search of MCQ on MS Excel across the web you have arrived at the right page.