.png){kind=logo}
Excel Chapter 1 Quick Concepts Checks Answers Section 1: Introduction to Spreadsheets 1. What are two major advantages of using an electronic spreadsheet instead of a paper-based ledger? Using a calculator to perform calculations and entering results in a paper-based ledger can lead to greater inaccuracies than building formulas in a spreadsheet, especially when a value changes and new results are needed. In addition, it is easier to make data-entry changes in a spreadsheet over making changes in a paper ledger. 2. What visual indicators let you know which cell is the active cell? The active cell is indicated by a solid green border. In addition, the Name Box displays the active cell name, such as B15. Finally, the row and column headings have a light gray background with a thick green line for the respective row and column that contains the active cell. 3. What steps should you perform before entering data into a worksheet? (1) State the purpose of the worksheet. (2) Decide what input values and data are needed. (3) Decide what outputs are needed to achieve the purpose of the worksheet. (4) Decide how to arrange the inputs and outputs into columns and rows. 4. What are four major things you can enter into a cell? Give an example (different from those in the book) for each type. Text: Microsoft Excel Value: 1234.56 Date: January 1, 2016 Formula: =B5+C5 Section 2: Mathematics and Formulas 1. What is the order of precedence? Provide and explain two examples that use four different operators: one with parentheses and one without. The order of precedence is a set of rules that specify the sequence in which arithmetic calculations are performed.
Â
.png)