Exam (elaborations)
MISY 5325 Excel Midterm Ultimate Revie2
- Course
- Institution
MISY 5325 Excel Midterm Ultimate Revie2
[Show more]
Content preview
MISY 5325 Excel Midterm Ultimate ReviewA ctrl key should be pressed if users want to select cells or a range of cells which are
not adjacent. - ANSWER TRUE
To properly move a chart to another worksheet, you should use the function
________ move chart - ANSWER C.
move chart
If users enter the functions correctly, the functions SUMIF and DSUM should return
the same result. - ANSWER TRUE
Which of the following of cell reference will not change when the formula was copied
and pasted in another cell? - ANSWER B. $A$1 (Absolute Reference)
Which one of the following statement is NOT true about the function Table? -
ANSWER C. Once the Table function is applied on the data, there is no way to
convert it back.
(The above statement is FALSE/NOT TRUE)
To display the formula in a worksheet, a user should press ____________ -
ANSWER C. Ctrl + Accent
The PV function is usually used to calculate the ending balance of the loan in an
amortization schedule. - ANSWER TRUE
The function Hide will allow users to hide the column, but not row. - ANSWER
FALSE
Linda deposits 200 into a bank every month. The annual interest rate is 6%. She
deposits the money for 4 years. Which one of the following is the function to
calculate the money she would have at the end of the fourth year? - ANSWER C. =
-FV(6%/12, 4*12, 200)
[with a minus - sign before the future value]
Typically, the function Autosum should not be used to find the total for a column
containing data in percentage. - ANSWER TRUE
The function Hide will allow users to hide the column, but not row. - ANSWER
FALSE
Linda deposits 200 into a bank every month. The annual interest rate is 6%. She
deposits the money for 4 years. Which one of the following is the function to
calculate the money she would have at the end of the fourth year? - ANSWER
(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). - ANSWER 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. - ANSWER
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. - ANSWER
TRUE
(Excel) TRUE/FALSE:
You can clear cell contents and formatting by tapping or clicking Clear Contents on
the Clear button menu. - ANSWER TRUE
(Excel) TRUE/FALSE:
The equal sign (=) precedes a formula. - ANSWER TRUE
(Excel) TRUE/FALSE:
The most common error when entering a formula is to reference the wrong cell in the
formula. - ANSWER 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. - ANSWER FALSE
(Excel) TRUE/FALSE:
The arithmetic operator, ^, directs Excel to perform the division operation. -
ANSWER FALSE
(Excel) TRUE/FALSE:
As in algebra, you can use brackets to override the order of operations Excel follows
to perform formula calculations. - ANSWER 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. - ANSWER 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. - ANSWER 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. - ANSWER
TRUE
(Excel) TRUE/FALSE:
Worksheet titles and subtitles should be as wordy as possible. - ANSWER 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. - ANSWER FALSE
(Excel) TRUE/FALSE:
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. - ANSWER 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. - ANSWER TRUE
(Excel) TRUE/FALSE:
When entering dollar values in cells, you also must type the dollar sign ($), commas,
and any trailing zeros. - ANSWER FALSE
(Excel) TRUE/FALSE:
You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). - ANSWER FALSE
EXCEL:
An Excel _____ allows data to be summarized and charted easily.
a. worksheet
b. workflow
c. document
d. presentation - ANSWER 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 - ANSWER 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 - ANSWER d. cell
EXCEL:
______ is/are used to place worksheet, column, and row titles on a worksheet.
a. Color
b. Text
c. Links
d. Tabs - ANSWER b. Text
EXCEL:
Clicking the _______ box completes an entry.
a. Cancel
b. Formula
c. Enter
d. Tab - ANSWER 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 - ANSWER b. AutoCorrect
EXCEL:
Pressing the_____ key to complete an entry activates the adjacent cell to the right.
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 leonardmuriithi061. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79879 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now