Exam (elaborations)
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
- Course
- Institution
- Book
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
More summaries for
-
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
Seller
Follow
maxmaxwellmm254
Content preview
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAMLATEST 2024 ACTUAL EXAM
You can start Excel using the Start button on the Windows taskbar or a shortcut on
your desktop. - ANSWER: T
You can use the DELETE key to clear cell contents - ANSWER: T
To print worksheet contents across the length of a page, you can use portrait
orientation. - ANSWER: F
When you enter a value in a worksheet cell, it is automatically left-aligned. -
ANSWER: F
You can use the I-beam pointer to copy cell contents into adjacent cells. - ANSWER: F
To print a worksheet, you begin by going to Backstage view. - ANSWER: T
To fit all worksheet content on one page, you can set page scaling in Backstage view.
- ANSWER: T
You can edit cell contents in the Formula bar or in the cell itself. - ANSWER: T
To enter a typed number into a cell, you can press Tab or Backspace. - ANSWER: F
When you copy and paste a formula with absolute cell references, Excel substitutes
new references to reflect the new formula location. - ANSWER: F
To find the largest value in a cell range, use the MIN function. - ANSWER: F
The easiest way to insert the SUM function is to use the AutoSum button on the
Home tab. - ANSWER: T
You have selected a cell with a formula. Which of the following can you use to copy
that formula to an adjacent cell? - ANSWER: Fill handle
In the formula =SUM(A6:A9), which of the following best describes A6? - ANSWER:
argument
What lets you edit the contents of a cell? - ANSWER: Double-click the cell or click in
the formula bar.
Where can you see a preview of how your worksheet will look when printed,
including headers? - ANSWER: Print tab in Backstage view
, What formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? - ANSWER:
The formula =SUM(B6:B10)
To have Excel enter the lowest price from a range of prices, which of the following
would you use? - ANSWER: MIN function
What tabs lets you see exactly how your worksheet looks before printing? -
ANSWER: File
To see a preview of how a pasted value will look, which of the following would you
use? - ANSWER: Paste List arrow
Which of the following functions would you use to calculate the arithmetic mean of a
price list? - ANSWER: AVERAGE
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab
would you use? - ANSWER: Page Layout
To print more than one copy of your worksheet, which tab would you go to? -
ANSWER: File
If you discover an error immediately after you have confirmed a cell entry, what
would you use next? - ANSWER: The Undo button on the Quick Access toolbar
To select a single worksheet cell so you can work with it, which of the following
would you do? - ANSWER: Click the cell
Which of the following functions inserts the total of a range? - ANSWER: SUM
How many actions does the Undo button let you reverse? - ANSWER: 100
Which of the following would you use to create a duplicate of the selected cell when
the CTRL key is pressed? - ANSWER: Copy pointer
Which of the following lets you search for a function or select one from a category? -
ANSWER: Insert Function dialog box
Your worksheet is too wide to fit on one portrait page. What is the best way to fix
this problem? - ANSWER: Change the page orientation to landscape
What tab lets you set worksheet print options? - ANSWER: File
To print your worksheet at its actual size, which of the following would you select? -
ANSWER: No scaling
Which of the following is the temporary Windows storage area that holds selections
you copy or cut? - ANSWER: Clipboard
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 maxmaxwellmm254. 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)
82215 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now