Download Microsoft Excel Master Handout: A Comprehensive Guide and more Cheat Sheet Business in PDF only on Docsity! Name____________________________ MICROSOFT EXCEL - Master Handout 1. What is Microsoft Excel and when would it be used? -Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format -Excel is used for calculating and analyzing data 2. a) What is the default filename in Excel? Book1 b) What is the extension added to Excel files? XLSX 3. Label the Excel screen below. Draw lines and write the appropriate letter beside each line from the list below. a) Formula bar b) Active cell c) Column headings d) Row labels e) Filename f) Cell g) Column h) Row i) Status bar j) Name box k) Fill handle 4. In a spreadsheet, a) Do columns run vertically or horizontally? vertically b) Do rows run vertically or horizontally? horizontally 5. What do you call the intersection of a row and a column? A cell Page 1 of 5 Excel Master Handout 6. Which bar on your screen tells you where your cursor is located? The border highlights the location of your cursor. 7. What is the default column width size? 8.43 8. What are the next 3 columns after Z? AA, AB, AC 9. What keys move your cursor to: (same as Word Processing) a) beginning of your file quickly? Ctrl + Home b) end of your file quickly? Ctrl + End 10. What function key will allow you to go to a specified cell quickly? F5 or Ctrl + G 11. Name 5 ways to enter information into a cell. Type the content, Copy and Paste, Edit and Insert Button, Cut and Paste, or the Drop-down arrow , 12. What are the two types of cell contents? Labels and values, 13. How are labels justified once they are entered into a cell? Left aligned 14. What are the two types of value entries? Numeric data and formulas, 15. How are values justified once they are entered into a cell? Right aligned 16. What must you type to start off a formula? An equal sign (=) 17. How do you indicate the following operations in a formula? a) addition (+) b) subtraction (-) c) multiplication (*) d) Division (/) e) Exponentiation (^) 18. What does a relative reference mean in a spreadsheet? Cell references that reflect the row or column they have been copied to are called relative cell references. 19. Spreadsheets are neat because you can use formulas and then just fill in the formula for the rest of the cells. a) To fill a formula down a column, what do you select from the Edit menu? Fill Down b) To fill a formula across a row, what do you select from the Edit menu? Fill Right 20. How do you sort the alphabet in descending order? Go to formula bar Page 2 of 5
