CS test 1

CS test 1 - CS 285 Test 1 Quiz 1 1. List three advantages...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 285 Test 1 Quiz 1 1. List three advantages of using Excel worksheets. Enter data quickly and accurately Recalculate data easily Perform what if analysis Change the appearance of data Create charts Share information Build on previous work 2. Explain the steps you would follow to save your Case01_Username_1 workbook as Case01_Username_2. Save As, Change the one to a 2 3. Explain the purpose of the: a. Name Box – shows the cell reference or name of the active cell b. Formula bar – enter or edit data in the active cell c. Sheet tab(s) – i dentifies sheets on a workbook and lets you switch between sheets tabs are located below the worksheet grid d. Office button – new, open, save, save as, print, etc are located e. Quick Access toolbar – customize toolbar that includes buttons for common office commands such as saving a file and undoing an action 4. Write the formula that will total the values in cells B2:B16. Use the SUM function and use cell references in the formula. =SUM(B2:B16) 5. What is AutoSum? Button located in the Home Tab (Add, Subtract, Etc) 6. Name 4 of the AutoSum options. Average, Sum, Min, Max 7. Excel 2007 files have the extension is .xlsx 8. Explain how to edit a cell’s contents (formula, value, or text). Double click, formula bar, or press F2 for edit mode 9. Explain how to increase the width of column B so that each entry automatically fits in the column. Double click at the top of the column 10. In the following formula, what are the function arguments? = Average (A1:A5) 11. Write the formula (as you would enter it into a cell) that will multiply the value in cell C6 by the value in cell D6. =C6*D6 12. Write the formula (as you would enter it into a cell) that will add the values in cells E6:E10. Use the SUM function. =SUM(E6:E10) 13. Write the formula (as you would enter it into a cell) that will multiply the total branch bonus (in cell B3) by 85%. =B3*85% 14. Write the formula (as you would enter it into a cell) that will divide the value in cell B4 by the value in cell B5. =B4/B5 15. Use the REVIEW on the Ribbon to use the Spelling Checker. 16. How would you insert a new worksheet into your Case 1 file? -Add new worksheet at the bottom of the page 17. Explain how to rename a worksheet. –Right click the sheet at the bottom and rename 18. Explain how to delete Sheet 3. Right click the sheet at the bottom and click delete
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

CS test 1 - CS 285 Test 1 Quiz 1 1. List three advantages...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online