Welcome to your Microsoft Excel Assessment First Name Last Name Company Email 1. What are the sections of a Ribbon tab called? Commands Groups Dialog Boxes Dropdowns 2. Select the correct formula to enter in cell B6 that would total sales for all quarters for the year 2011. =B2:B3:B4:B5 =B2:B5 =SUM(B2:B5) =TOTAL(B2:B5) 3. Which key(s) CANNOT be used to navigate in an Excel Worksheet? The arrow keys Tab and Enter Insert and Delete Page Up and Page Down 4. How can you save a file while working on it? Ctrl-S Click the File Tab, then Save Click the Save button in the Quick Access Toolbar All of the above 5. Which mouse technique lets us edit existing content in a cell? Single-click Double-click Right-click Drag 6. Which is the easiest way to call up Help related to the operation you are currently doing? The F1 key The help button in the Help tab on the Ribbon Typing in the Search space None of the above 7. Which item comes LAST in the order of operations in the "Sales with Tax" formula? Multiplication Addition Exponents Parentheses 8. Which symbol indicates a range of cells in a function formula? Comma Colon Semi-colon Forward slash 9. Where do the dollar signs go in an absolute reference? Before both the column and row reference Before the column reference Before the row reference None of the above 10. How can we auto-fit the column width or row height? Drag the column or row divider Double-click the column or row divider Single-click the column or row divider None of the above 11. If we want to use Find/Replace on an entire worksheet, how many cells should we select? The first row The first column All Any one cell 12. What kind of words can the Spell Check correct? Proper names Common Names Verbs Words in its dictionary 13. Under which Ribbon tab do we find the Formatting controls? File Home Page Layout View 14. Which number format uses a dollar sign? Accounting Currency A & B None of the Above 15. Which feature allow us to combine cells, e.g. for titles? Merge and Center Text Wrap Increase/Decrease Indent Rotate Text Up/Down 16. Which theme-related item can we NOT easily create or edit? Colors Fonts Effects Themes 17. How many basic conditional formatting choices are there? Two Three Four Five 18. Which is the file type/extension for an Excel template? .xls xltx .xlsx .xlsm 19. In the Page Setup dialog, which tab allows us to set up the Print Titles? Sheet Header/Footer Margins Page 20. How many kinds of items can we insert in a custom header or footer, aside from text? Seven Eight Nine Ten 21. How many worksheets can a saved Excel workbook have? 64 255 1024 Limited only by available space in memory 22. Which feature lets us keep the top and left sides of the sheet visible for labeling purposes? Arrange Windows Split Freeze Panes Workspaces 23. Which tab in the Advanced Properties dialog allows us to enter our own data? General Summary Statistics Contents Time's up