Microsoft Excel MT Part 2 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Merged
answer
Combining two or more selected cells into one cell is called ____ cells.
question
Displays cell contents with two decimal places that align vertically
answer
What effect does the Accounting Number Format have on the selected cells?
question
Displays cell contents with two decimal places and commas as thousands separators
answer
What effect does the Comma Style format have on the selected cells?
question
CTRL+HOME
answer
Pressing the ____ keyboard shortcut key(s) selects cell A1.
question
10
answer
How many chart types does Excel offer?
question
exploded
answer
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
question
XPS Viewer
answer
You use ____ to view an XPS file.
question
AutoCalculate
answer
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
question
ESC
answer
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
question
HOME
answer
Which of the following keys moves the insertion point to the beginning of data in a cell?
question
END
answer
Which of the following keys moves the insertion point to the end of data in a cell?
question
function
answer
A ____ is a prewritten formula that is built into Excel.
question
ALT+ENTER
answer
To start a new line in a cell, press the ____ keys.
question
2Oxx
answer
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
question
>
answer
________ is NOT valid Excel arithmetic operator.
question
=23%
answer
Which of the following calculations multiplies 23 by 0.01?
question
operations
answer
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
question
Trace Error
answer
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
question
The ____ function displays the highest value in a range.
answer
MAX
