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. - ✔✔true
Excel is _____. - ✔✔all of these answers
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. - ✔✔true
Excel is _____. - ✔✔all of these answers
