Ans: False This question is based upon the figure shown bellow The figure shows an Excel worksheet. It will close and save this particular worksheet of the workbook. The turnover values for each year also need to be sent separately in an Excel file. It contains all open standard modules and class modules in a Microsoft Access database. She is asked to use hyphens to allow words in the article to break between two lines. Start mode Question 26: Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data? The candidate of Exam 77-882:Excel 2010 should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level and should be familiar Office Excel 2010 and must know how to use at least 80% of the features and capabilities of Microsoft Office Word 2010.
Version control and tracking is supported by PowerPivot. Ans: Patterns Question 39: No data is deleted when an outline is hidden or removed. It will select the whole sheet, having the same effect as that of Ctrl+A. In the Macro name box, click on the macro that you want to assign. You can even create your own list.
The indexed property for the primary key and the foreign key fields should be set to Yes. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. The digital signature has expired. Ans: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell You have created a worksheet which consists of confidential data. Now you want that your team members should be able to see the report remotely on a web browser, and edit the report, as desired. The package is also suitable for Kenexa Prove It Excel 2010 - power users. Memorizing a couple of essential shortcut key combinations could save you time and frustration and could even assist you in using different versions of Excel as most shortcut keys have not changed in the last decade! False Question 118: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat.
A name can contain up to 255 characters c. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. Take an exam to see how well you know some Excel basics. What can Microsoft Excel be used for? The core-level Microsoft Office Excel 2010 user should be able to navigate Microsoft Office Excel 2010 software at the feature and functional level. In the Macro name box, click on the macro that you want to assign.
My top and bottom margins are too small. D Question 105: Which of the following charts shows numerical values on the vertical value axis and textual groupings or categories on the horizontal axis? You are creating a new formatting rule which will be used to format a PivotTable report. Q 24 State whether following statement regarding images in Microsoft Excel 2010 is true or false: Microsoft Excel 2010 supports 3D rotation of images. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires. Default Value For what reason s can a digital signature or certificate be regarded as invalid? Ans: 3 new rows will be inserted after row 9 A smart tag will be removed from a cell when……………….
All of the above are true Question 34: Which of the following is not true regarding naming a cell?. Enable Referential Integrity must be False if Allow Multiple Values is set to True for a lookup. My top and bottom margins are too small. Which method will help you do this? What is one problem that might be causing this behavior? Ans: Returns the serial number of the current date and time Ques: You start Microsoft Excel and you do not want it to automatically run a macro upon starting. How would you assign a macro to a graphic? The results of this quiz will be used to determine course placement for each team member based on total score achieved. You could have a worksheet for each month, or each location, or each person. Scoping by corresponding field Ans: c.
Or do you need Excel Practice Tests online? This quiz is designed to provide an of members' of cometency in features and functions of 2010. Excel for Beginners to Advanced Excel Training. It restricts the e-mail content from being copied by using third-party screen-capture programs. All of the above Question 27: Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location? Sometimes you need to change the case of words to upper or lower case or remove extra spaces or characters. Tables with maximum number of rows and columns was added to the document. Ans: Its adds up the values in the selected cells You have entered test in a cell which is too big for the cell.
Name of an order by element is not valid. Grid format Suppose you want to apply a calculated field on a TextBox control to concatenate the values of the firstName and lastName fields, with a space between them. It can also be used to. It enables you to reduce coding errors and easily incorporate more complex logic to create robust applications. Version control and tracking is supported by PowerPivot. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations. Knowing how to format charts using the Design, Layout and Format tabs to change colors, labels and scale makes you an Excel Chart Wizard! The red triangles signify that the cell is a hidden cell.
Both b and c Qu: If you want to create a citation and fill in the source information later, you should: oDesk Microsoft Excel 2010 Skill Test Answers a. By modifying the display of chart axes Ans: c. The data being imported into PowerPivot can be filtered before the import. Use the Autofill handle to add that quantity for the other items. Which of the following is correct regarding Crosstab queries? Working offline allows you to work on SharePoint data locally. How can Josh achieve this in Microsoft Word 2010? The Subtotal dialog box is displayed.
It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires. Ans: Select the cells, open the Window menu and click on Hide Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months? An unlimited number of columns can be returned. What will happen when this particular area is selected? Add a bottom border to cell D4. Excel Keyboard Shortcuts streamline tasks that you frequently perform in Excel by allowing you to quickly access specific functions. Ans: Patterns This chart is the default chart Ans: Column Chart Which of the following displays the contents of the active cell? In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header.