MISY 5325 Excel Midterm Ultimate Review | Comprehensive Midterm Excel Review |Que & Answ
(Excel) TRUE/FALSE:
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). ** Answ** TRUE
(Excel) TRUE...
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie
or Doughnut Chart button (INSERT tab | Charts group). ** Answ** TRUE
(Excel) TRUE/FALSE:
To use the AutoCalculate area, select the range of cells containing the numbers for a
calculation you want to verify and then press and hold or double-click the AutoCalculate
area to display the Customize Status Bar shortcut menu. ** Answ** FALSE
(Excel) TRUE/FALSE:
The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain
proof that you have the Excel 2013 skills required by employers. ** Answ** TRUE
(Excel) TRUE/FALSE:
You can clear cell contents and formatting by tapping or clicking Clear Contents on the
Clear button menu. ** Answ** TRUE
(Excel) TRUE/FALSE:
The equal sign (=) precedes a formula. ** Answ** TRUE
(Excel) TRUE/FALSE:
The most common error when entering a formula is to reference the wrong cell in the
formula. ** Answ** TRUE
(Excel) TRUE/FALSE:
An asterisk (*) following a cell reference in a formula is the arithmetic operator that
directs Excel to perform the division operation. ** Answ** FALSE
(Excel) TRUE/FALSE:
The arithmetic operator, ^, directs Excel to perform the division operation. ** Answ**
FALSE
,(Excel) TRUE/FALSE:
As in algebra, you can use brackets to override the order of operations Excel follows to
perform formula calculations. ** Answ** FALSE
(Excel) TRUE/FALSE:
If you drag the fill handle to the left or up, Excel will increment the series rather than
decrement the series. ** Answ** FALSE
(Excel) TRUE/FALSE:
The Increase Indent button indents the contents of a cell to the right by three spaces
each time you click it. ** Answ** FALSE
(Excel) TRUE/FALSE:
A requirements document includes a needs statement, source of data, summary of
calculations, and any other special requirements for a worksheet. ** Answ** TRUE
(Excel) TRUE/FALSE:
Worksheet titles and subtitles should be as wordy as possible. ** Answ** FALSE
(Excel) TRUE/FALSE:
When you tap or click the Enter box to complete an entry in a cell, the active cell moves
down to the next cell in the same column. ** Answ** FALSE
(Excel) TRUE/FALSE:
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. ** Answ** TRUE
(Excel) TRUE/FALSE:
When text is longer than the width of a column, Excel displays the overflow characters
in adjacent cells to the right as long as those adjacent cells contain no data. ** Answ**
TRUE
(Excel) TRUE/FALSE:
When entering dollar values in cells, you also must type the dollar sign ($), commas,
and any trailing zeros. ** Answ** FALSE
,(Excel) TRUE/FALSE:
You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). ** Answ** FALSE
EXCEL:
An Excel _____ allows data to be summarized and charted easily.
a. worksheet
b. workflow
c. document
d. presentation ** Answ** a. worksheet
EXCEL:
The first step in creating an effective worksheet is to make sure you _____.
a. apply font formatting
b. understand what is required
c. insert chart
d. enter the data ** Answ** b. understand what is required
EXCEL:
To enter data in a cell, you must first select the _____.
a. row
b. worksheet
c. column
d. cell ** Answ** d. cell
EXCEL:
______ is/are used to place worksheet, column, and row titles on a worksheet.
a. Color
b. Text
c. Links
d. Tabs ** Answ** b. Text
EXCEL:
Clicking the _______ box completes an entry.
a. Cancel
, b. Formula
c. Enter
d. Tab ** Answ** c. Enter
EXCEL:
The ______ feature works behind the scenes, fixing common typing or spelling
mistakes when you complete a text entry.
a. AutoComplete
b. AutoCorrect
c. AutoFormat
d. AutoTyping ** Answ** b. AutoCorrect
EXCEL:
Pressing the_____ key to complete an entry activates the adjacent cell to the right.
a. RIGHT ARROW
b. LEFT ARROW
c. UP ARROW
d. DOWN ARROW ** Answ** a. RIGHT ARROW
EXCEL:
In Excel, a number can contain the characters _______.
a. 0 1 2 3 4 5 6 7 8 9
b. + - ( ) , /
c. . $ % E e
d. all of the above ** Answ** d. all of the above
EXCEL:
The ______ is the small black square located in the lower-right corner of the heavy
border around the active cell.
a. selection handle
b. sizing handle
c. fill handle
d. copy handle ** Answ** c. fill handle
EXCEL:
The _____ button allows you to choose whether you want to copy the values from the
source area to the destination area with formatting.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller smartchoices. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.79. You're not tied to anything after your purchase.
