Excel Essential Training | 100% Correct Answers | Verified | Latest 2024 Version

In Excel, a file is a ____________. - workbook You click once a cell that has the word "cat" in it and begin typing the word "dog", and then hit Return on your keyboard. The cell - now says "dog" The most effective way to add up five different cells in a row is to _____ (after typing the equal sign into the formula bar). - use the function SUM, type an open parenthesis, and the highlight the five cells What is true of formatting cells to a particular category, such as Accounting or Currency? - This adjusts the display of your data, but not the data itself When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____. - simply complete the action. Excel maintains the formulas for you Which of the following is not type of Sparkline (mini chart)? - Scatter _____ means "exact match" when creating a VLOOKUP. - FALSE If you highlight a column and then click the Sort alphabetically button (A-Z), - only the data in the column is sorted All of the following are required to begin creating a PivotTable, except: _____. - Begin with an equal sign and open parenthesis A macro is a way to automate a sequence of steps in your work. - t