Exam (elaborations)
D100 Questions.
- Module
- D100 Intro to Spreadsheets
- Institution
- D100 Intro To Spreadsheets
Exam of 8 pages for the course D100 Intro to Spreadsheets at D100 Intro to Spreadsheets (D100 Questions.)
[Show more]
Seller
Follow
Content preview
D100 QuestionsWhat advances in technology have become increasingly important for managers in their
decision-making?
a. Technology readiness
b. Battery technology
c. Mobile computing technology
d. Technology Management - ANS-c. Mobile computing technology
Mobile computing technology is an important technological advancement related to
Excel's increasing importance to managers' decision-making.
Which Excel features can be found in the File menu tab?
a. Options for formatting print settings
b. Options for working with Excel windows
c. Options for opening and saving workbook files
d. Options for formatting cells - ANS-c. Options for opening and saving workbook files
The File menu tab opens settings for opening, sharing, and saving a workbook file.
What is a collection of cells arranged in columns and rows?
a. A worksheet
b. A spreadsheet file
c. A workbook
d. A menu tab - ANS-a. A worksheet
A worksheet is a collection of cells arranged in columns and rows. Many worksheets
come together to form a workbook.
When it appears as the first character in a cell, which character signals to Excel that the
contents of the cell should be treated as a calculation?
a. The equals character (=)
b. The multiplication character (*)
c. The division character (/)
d. The exponent character (^) - ANS-a. The equals character (=)
The equals sign is the first character in a cell. Without the equals sign, Excel would not
recognize the cell's contents as a calculation.
, The result of a function changes as the values in the other cells referenced by that
function change in what kind of function?
a. Dynamic
b. Simple
c. Static
d. Complex - ANS-a. Dynamic
A dynamic function changes when the values in the cells it references change.
Which Excel feature(s) are used to reuse a formula from one cell to another?
a. Freeze Panes
b. Copy and Paste
c. Repeat Headers
d. Sort and Filter - ANS-b. Copy and Paste
Copy and Paste allow you to transfer a formula into another cell.
A spreadsheet template __________.
a. is static and resistant to changes in the worksheet
b. may only be used by the person who created it
c. must be rebuilt every time a person uses it
d. can be used repeatedly with changing inputs - ANS-d. can be used repeatedly with
changing inputs
A spreadsheet template is very versatile.
Which arithmetic operator is evaluated first in an Excel arithmetic expression?
a. Parentheses
b. Exponents
c. Addition and Subtraction
d. Multiplication and Division - ANS-a. Parentheses
Parentheses are the first part of an arithmetic expression that must be evaluated.
Excel would evaluate the expression =25-15/5*2+7 to the value of?
a. 26
b. 11
c. 8
d. 18 - ANS-a. 26
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 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 denicetho. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.16. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79650 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now