USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Katie wants to calculate the total dues collected from FBLA members. She notices the total is not being updated as she changes the data. Which option on the Formula tab would allow her to fix this problem?
|
|
AutoSum
|
|
|
Calculate Now
|
|
|
Calculation Options
|
|
|
Evaluate Formula
|
Explanation:
Detailed explanation-1: -Detailed Solution. The correct answer is SUM().
Detailed explanation-2: -We can use the fill handle to quickly copy and paste data into adjacent cells by dragging the fill handle to the cells we want to fill with the same data.
Detailed explanation-3: -Use Mark as Final to make your Word, Excel, or PowerPoint file read-only. When you mark as final, typing, editing commands, proofing marks are disabled or turned off, and the file becomes read-only, and the Status property of the document is set to Final.
Detailed explanation-4: -PivotTables are useful to consolidate multi-worksheet data. PivotTables are useful for summarizing data.
There is 1 question to complete.