Comprehensive Spreadsheets Exam Questions With Verified Answers
2 views 0 purchase
Course
Spreadsheets
Institution
Spreadsheets
Comprehensive Spreadsheets Exam
Questions With Verified Answers
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
- answerT
You can use the DELETE key to clear cell contents - answerT
To print worksheet contents across the length of a page, you ca...
Comprehensive Spreadsheets Exam
Questions With Verified Answers
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
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 Brainbarter. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
