Software Solutions - Excel 2003 Skill Assessment
Please provide the following Skill Assessment Report information:
Why do we ask for you email address? Because if you have problems with your password you won't be able to open the final skill assessment report, we need more than your Firstname and Lastname to give you your password and to differentiate you from others with the same Firstname and Lastname.
Skill Measurement: Insert, delete and move cells It is essential that the Excel user is able to quickly insert, delete and move the content of cells around and between worksheets. 1) To unmerge cells?
1. Right-click a cell and select Unmerge from the shortcut menu 2. Select Format>Cells and under the Alignment tab unselect Merge Cells 3. Select Format>Cells and unselect Merge Cells 4. Click the Centre icon to unmerge cells 5. Honestly don't know
Skill Measurement: Enter and edit cell content It is essential that the Excel user is able to quickly enter, edit all types of data including text, numbers and formulas into a worksheet. 2) To clear the content only in a cell, which option doesn't work:
1. Press the DELETE key 2. Edit>Clear>Contents from the menu 3. Format>Delete from the menu 4. Honestly don't know
Skill Measurement: Preview Data in other views 3) To preview how data will layout across pages you could use which view?
1. Full Screen View 2. Normal View 3. Page Break View 4. Honestly don't know
Skill Measurement: Define and modify workbook properties 4) Which option is not a workbook property?
1. Manager 2. Assistant 3. Author 4. Honestly don't know
Skill Measurement: Filter lists using AutoFilter Filtering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria you specify for a column.
5) If you had a list of Sales figures and you turn on the AutoFilter how do you filter the top 25 percent?
1. Sort in Descending order 2. Select (Custom..) 3. Select (Top 10...) 4. Honestly don't know
Skill Measurement: Organize workbook using file folders 6) To save a file in a new folder select:
1. File>Save As from the menu and click the Create New Folder icon 2. File>New>Folder from the menu and then File>Save As from the menu 3. Click the Create new folder icon and then File>Save As from the menu 4. Honestly don't know
Skill Measurement: Create new workbooks from templates To create new workbooks that already have your preferred formatting, you can base the new workbooks on a template. A template can include formatting, styles, standardised text such as page headers and row and column labels, formulas, Visual Basic for Applications macros, and custom toolbars.
7) An Excel template has what file extension?
1. .xlt 2. .xls 3. .xtp 4. Honestly don't know
Skill Measurement: Format charts and diagrams 8) To change the chart from a sheet to an object on a sheet select which menu commands?
1. Chart>Source 2. Chart>Location 3. Chart>Object 4. Insert>Object 5. Honestly don't know
Skill Measurement: Apply and modify cell formats To make text stand out, you can format all of the text in a cell or selected characters. Select the characters you want to format, and then click a button on the Formatting toolbar.
9) To rotate text 45º select ?
1. Format>Cells from the menu and the Alignment tab and set Orientation to 45º 2. Format>Cells from the menu and the Orientation tab and set Orientation to 45º 3. Format>Cell Orientation from the menu and set Orientation to 45º 4. Honestly don't know
Skill Measurement: Customize window layout 10) To freeze the first two columns and the first three rows select which cell before choosing Window>Freeze Panes?
1. C4 2. B3 3. Honestly don't know
Skill Measurement: Modify row and column formats 11) To set the width of columns B to D to 20 characters do the following?
1. You can't set columns to a specific number of characters wide 2. Select columns B to D and from the menu select Column>Format Width 3. Select columns B to D and from the menu select Format>Column Width 4. Select columns B to D and from the menu select Format>Column>Width 5. Honestly don't know
Skill Measurement: Apply and modify cell Styles A style is a collection of formats, like bold text or background shading.
12) To apply a style to cells select?
1. Excel does not have styles, Word does 2. Format>Styles and select the style from the drop-down list 3. Click the Styles icon and select the style from the drop-down list 4. Honestly don't know
Skill Measurement: Format worksheets 13) Which option is not an AutoFormat?
1. Classic 1 2. List 1 3. Elegant 1 4. Honestly don't know
Skill Measurement: Setup pages for printing 14) To set a print area do the following?
1. Select the range and from the menu select File>Print and Selection 2. Select the range from the menu select File>Print Area>Set Print Area 3. Select the range and from the menu select File>Print 4. Honestly don't know
Skill Measurement: Print data 15) To print Sheet1 and Sheet4 do the following:
1. Select Sheet1 and click the print icon, select Sheet4 and click the print icon 2. Click Sheet1 and hold the CTRL key and select Sheet 4 and click the print icon 3. Click Sheet1 and hold the SHIFT key and select Sheet 4 and click the print icon 4. Honestly don't know
Skill Measurement: Organize worksheets and modify Excel default settings A Microsoft Excel workbook is a file that contains one or more worksheets, which you can use to organise various kinds of related information. You can enter and edit data on several worksheets simultaneously and perform calculations based on data from more than one worksheet. When you create a chart, you can place the chart on the same worksheet as its related data or on a separate chart sheet. You can move from one worksheet or chart sheet to another by clicking the sheet tabs at the bottom of the workbook window. You can colour-code your sheet tabs to make them easier to recognise.
16) Which method will not insert a sheet and under what tab in Tools>Options can the default number of sheets in a workbook be set?
1. Select Insert>Worksheet from the menu and Edit tab 2. SHIFT+F11 and Edit tab 3. CTRL+N and General tab 4. Honestly don't know
Skill Measurement: Sort lists 17) In the Sort window how many columns are you able to sort by?
1. 3 2. 4 3. 5 4. Honestly don't know
Skill Measurement: Apply workbook security settings 18) To apply a password to modify click what menu commands
1. Tools>Protection 2. File>Save As 3. Insert>Protection 4. Honestly don't know
Skill Measurement: Insert and modify formulas Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result. =5+2*3
19) Which formula will not change the row reference only if it is filled or copied to another location?
1. =SUM($B$1:$B$10) 2. =SUM(B$1:B$10) 3. =SUM($B1:$B10) 4. Honestly don't know
Skill Measurement: Use statistical, date and time, financial, and logical functions Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.
20) Which function in B1 will return 10% of A1 if the value in A1 is greater than or equal to 100 else return 5%?
1. =IF(A1>=100,B1*10%,B1*5%) 2. =IF(A1>=100,A1*0.10,A1*0.05) 3. =IF(A1>=100,A1*5%,A1*10%) 4. Honestly don't know
Skill Measurement: Format and resize Graphics 21) When formatting a graphic under what tab is the setting Lock Aspect Ratio?
1. Size 2. Layout 3. Picture 4. Honestly don't know
Skill Measurement: Create, modify, position diagrams and charts based on worksheet data Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, rather than having to analyse several columns of worksheet numbers, you can see at a glance whether sales are falling or rising over quarterly periods, or how the actual sales compare to the projected sales.
22) To modify the text in a chart legend go to which menu commands:
1. Double-click the Legend 2. Chart>Chart Options and the Legend tab 3. Chart>Source Data and the Series tab 4. Honestly don't know
Skill Measurement: Insert, position and size graphics You can add graphics to your worksheets and charts to make them more visually appealing, to create eye-catching reports, or to add emphasis. For example, you can display a logo on your worksheet, create a flowchart, and use graphics in chart data markers. You can make your worksheet interactive by using graphic objects as hyperlinks or by assigning buttons to macros.
23) To add a Venn diagram to a worksheet do the following?
1. Insert>Picture>Clip Art from the menu 2. Insert>Diagram from the menu 3. Insert>Picture>AutoShapes from the menu 4. Honestly don't know
Skill Measurement: Save data in appropriate formats for different use Web pages often contain information that is perfect for analysis in Microsoft Excel. For example, you can analyse stock quotes in Excel using information that comes directly from a Web page. Depending on your needs, you can retrieve data that is refreshable (that is, you can update the data in Excel with the latest data on the Web page) or you can get data from a Web page and keep it static on the worksheet.
24) To view a spreadsheet as a web page do the following?
1. View>Web Page in the menu 2. File>Save as Web Page in the menu 3. File>Web Page Preview in the menu 4. Honestly don't know
Skill Measurement: Create and modify hyperlinks A hyperlink is a link from a document that opens another page or file when you click it. The destination is frequently another Web page, but it can also be a picture, or an e-mail address, or a program. The hyperlink itself can be text or a picture.
25) Which method will not edit a hyperlink?
1. Right-click and select Edit Hyperlink 2. Select Edit>Hyperlink from the menu 3. Select Insert>Hyperlink from the menu 4. Honestly don't know
Skill Measurement: Insert, view and edit comments A comment is a note that you attach to a cell, separate from other cell content. Comments are useful as reminders to yourself, such as noting how a complex formula works, or to provide feedback to other users.
26) To print comments in a worksheet at the end of the worksheet do the following?
1. Select File>Print Comments from the menu 2. Select File>Page Setup and under the Sheet tab select Comments drop-down list 3. Select Tools>Options and under the Print tab select Comments 4. Honestly don't know
Skill Measurement: Import data to Excel By importing data, you don't have to retype the data you want to analyze in Microsoft Excel. You can also update your Excel reports and summaries automatically from the original source database whenever the database is updated with new information.
27) To import data from an Access database select which menu commands?
1. File>Import and Export and select Import Database File 2. Data>Import and Export>New Query 3. Data>Import External Data>Import Data 4. Honestly don't know
Skill Measurement: Export data from Excel 28) To Export data to a text file what menu commands would you choose?
1. File>Save As and set Files of Type to Text File 2. Data>Export and select Text File 3. Tools>Data Analysis>Export 4. Honestly don't know
Skill Measurement: Publish and edit worksheets and workbooks 29) To publish a worksheet as HTML what menu commands would you choose?:
1. Data>Export as HTML 2. File>Web Page Preview 3. File>Save as Web Page 4. Honestly don't know
Skill Measurement: Create and edit templates 30) To open a Spreadsheet Solutions template you would?
1. Select File>Open 2. Select File>New 3. Select File>Open Template 4. Honestly don't know
Skill Measurement: Create and modify list ranges 31) To create a list do what?
1. Select Database>Create List in the menu 2. Type in the list box 3. Select Data>List>Create list in the menu 4. Honestly don't know
Skill Measurement: Data consolidation 32) When consolidating data from two or more worksheets what function is not available?
1. If 2. Sum 3. StdDev 4. Honestly don't know
Skill Measurement: Create and apply custom data formats 33) To format 1000 to $1,000.00 and -1000 to -($1,000.00) and 0 to 0.00 apply which custom number format:
1. $#,###.00;-($#,###.00);0.00 2. $#,###.00;0.00;-($#,###.00) 3. Honestly don't know
Skill Measurement: Use conditional formatting 34) How many conditions can you have in a single conditional format?
1. Three 2. Two 3. One 4. Honestly don't know
Skill Measurement: Define, modify and use named ranges A reference identifies a cell or a range of cells on a worksheet and tells Microsoft Excel where to look for the values or data you want to use in a formula. With references, you can use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas. You can also refer to cells on other sheets in the same workbook, and to other workbooks. References to cells in other workbooks are called links.
35) To change a range name range reference select which options?
1. Edit>Named Range 2. Use the Name box 3. Insert>Name>Define from the menu 4. Honestly don't know
Skill Measurement: Use lookup and reference functions 36) To find an exact match in a Vlookup or Hlookup function the last parameter in the function must be set to?
1. True 2. False 3. Left Blank 4. Honestly don't know
Skill Measurement: Customise toolbars and menus 37) Which method is not valid; to customise a toolbar button?
1. Select Tools>Customize Toolbars and Menus in the menu 2. Select View>Toolbars>Customize 3. Select Tools>Customize in the menu 4. Honestly don't know
Skill Measurement: Create, edit and run macros If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
38) To edit a macro which method is not valid?
1. Click the Visual Basic Editor icon on the Visual Basic toolbar 2. Click Tools>Macro>Macros>Record New Macro 3. Press ALT+F11 4. Honestly don't know
Skill Measurement: Trace formula precedents, dependents and errors 39) Tracing dependents or precedents is done with which toolbar?
1. Formula Tracing 2. Formula Reviewing 3. Formula Auditing 4. Honestly don't know
Skill Measurement: Change and locate invalid data 40) To circle invalid data use what toolbar?
1. Validation 2. Reviewing 3. Formula Auditing 4. Honestly don't know
Skill Measurement: Watch and evaluate formulas 41) To evaluate a formula or watch use what toolbar?
1. Validation 2. Formula Auditing 3. Reviewing 4. Honestly don't know
Skill Measurement: Use subtotals with lists and ranges Microsoft Excel can automatically calculate subtotal and grand total values in a list. When you insert automatic subtotals, Excel outlines the list so that you can display and hide the detail rows for each subtotal.
42) The subtotals commands is available from which menu?
1. Insert 2. Tools 3. Data 4. Honestly don't know
Skill Measurement: Define and apply advanced filters 43) To perform an advanced filter you need?
1. A List 2. A List and Criteria 3. A Criteria 4. Honestly don't know
Skill Measurement: Group and outline data Microsoft Excel can create an outline for your data to let you show and hide levels of detail with a single mouse click. You can click the outline symbols.
44) When grouping has been applied, groups can be expanded by?
1. Clicking the ↓ button 2. Clicking the Expand button 3. Clicking the Plus button 4. Honestly don't know
Skill Measurement: Use data validation 45) To create a drop-down arrow for each cell in a range of cells that limits the entries that a user can enter into a cell apply?
1. A combo box from the forms button 2. A validation rule where the validation criteria is a list 3. Honestly don't know
Skill Measurement: Use database functions 46) All database functions begin with the letter D for example DSUM?
1. No 2. Yes 3. Honestly don't know
Skill Measurement: Structure workbooks using XML 47) To add an XML Map to a workbook you would?
1. Click the XML Maps button on the XML Source Task Pane 2. Select File>Open XML Maps 3. Select Data>XML>XML Map from the menu 4. Honestly don't know
Skill Measurement: Create PivotTables and PivotChart Reports A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.
48) To change the layout of a PivotTable click which options on the PivotTable toolbar?
1. PivotTable and then Field Settings 2. PivotTable and then Wizard 3. PivotTable and then Table Options 4. Honestly don't know
Skill Measurement: Forecast values with what-if analysis 49) Which option is not a Trendline available in Excel?
1. Logarithmic 2. Falling Average 3. Polynomial 4. Honestly don't know
Skill Measurement: Add, show, close, edit, merge and summarize scenarios Scenarios are part of a suite of commands sometimes called what-if analysis tools. A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.
50) Can you prevent changes to a scenario?
1. False 2. True 3. Honestly don't know
Skill Measurement: Protect cells, worksheets and workbooks Microsoft Excel provides several layers of protection to control who can access and change your Excel data.
51) To complete the protecting of cells you must Protect?
1. The Sheet 2. The Workbook 3. Honestly don't know
Skill Measurement: Share workbooks 52) To share an Excel Workbook and allow changes by more than one user enable Share Workbook under the Tools menu?
1. True 2. False, this is not necessary 3. Honestly don't know
Skill Measurement: Track, accept and reject changes to workbooks
Change tracking logs details about workbook changes each time you save a workbook. You can use this history to understand what changes were made, and to accept or reject revisions. This capability is particularly useful when several users edit a workbook. It's also useful when you submit a workbook to reviewers for comments, and then want to merge input into one copy, selecting which changes and comments to keep.
53) When accepting or rejecting tracked changes what options do you have?
1. Who 2. When 3. Where 4. All of the above 5. Honestly don't know
Skill Measurement: Merge Workbooks 54) When comparing and merging workbooks you are able to merge to?
1. A New Workbook 2. A New Workbook or the Current Workbook 3. The Current Workbook 4. Honestly don't know
Skill Measurement: Advanced Filtering 55) When performing an Advanced Filter you have the options to?
1. Filter in place or copy to another location 2. Filter in place 3. Copy to another location 4. Copy to another worksheet 5. Honestly don't know
