0 Hours 0 Minutes 0 SecondsThis is your time remaining Excel Assessment 1Introduction2Beginner3Intermediate4Advanced5Review and Submit Please enter your name* First Name Surname Enter your assessment code* Time left 1. An Excel file is called a workbook?* False True 2. What keystrokes would you press to bring up the “Excel Help” window?* F9 F3 F1 F4 3. If you press the “Tab” key it moves one cell to the left.* True False 4. You can format text in a cell in Excel.* True False 5. Excel automatically adjusts row height to accommodate the size of data in a row.* False True 6. To add color to a row or column you click the__________* Fill color button (paint pail) Click the font color button Set a colored border 7. You can create mixed references by placing a dollar sign in front of only the column letter or only the row number.* True False 8. You can insert a row by right clicking a column heading.* True False 9. You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press___________ to paste, press____________* CTRL+A and CTRL+V CTRL+V and CTRL+X CTRL+C and CTRL+V CTRL+X and CTRL+V 10. Which function can you use to capture the contents of an open window?* Clip Art SmartArt Screenshot Icon Set 11. A SmartArt graphic provides an audible representation of information.* True False 12. “Values” can include numbers, formulas, and functions.* False True 13. The “Fill handle” is a small square in the lower-left corner of a selected cell or range of cells.* True False 14. =A7+A9 will subtract the two cells?* True False 15. The shortcut key to “undo” an action in Excel 2010 is:* CTRL+PAGE UP CTRL+HOME CTRL+Z CTRL+C 16. What is the default file extension when you save a workbook for Excel 2010?* .excel .xls .xlav .xlsx 17. When you have selected a range of cells and then you press CTRL+P. Excel will automatically print the selected range.* True False 18. Excel offers the “Spell Check” function.* True False 19. To use the Spell check function you go to the “View” tab on the ribbon.* False True 20. Excel provides the following functions to be used except:* HIGH MAX AVERAGE MIN 21. You can move a chart in a workbook from one sheet to another.* True False 22. You can add Axis titles to a chart.* False True 23. If you look at a worksheet and cannot see certain columns, it is probably because the worksheet has columns.* Deleted Hidden Unhidden 24. One method you can use to change a worksheet name is to go to the cells group on the Format tab, click Format and choose Rename Sheet.* False True 25. To delete a worksheet all you have to do is close the current workbook and it is then deleted.* True False 26. Before printing a worksheet, you should preview it and check for spelling errors. Completing these tasks before you print can save time and paper.* True False 27. You cannot copy a formula using “AutoFill”.* True False 28. You can modify the size of an image in Excel.* False True 29. When editing the “Margins” you can only edit the left and right side of the Worksheet.* False True 30. You can rename the “sheet” tabs on the bottom left corner.* True False You can click on any section above to review your answers before submitting. Once you are happy with your answers please click on the SUBMIT button below.
