Microsoft excel 2013 questions | Computer Science homework help

2. John wants to see the formulas he has used in his spreadsheet but he does not want to see the results of the formulas. How does he display his formulas?

A. Click Print Formulas.

Don't use plagiarized sources. Get Your Custom Essay on
Microsoft excel 2013 questions | Computer Science homework help
From as low as $5/Page
Order Essay

B. Click on Show Formulas.

C. Click Evaluate Formulas.

D. Click on Trace Precedents.

3. Which of the following ranges of cells is correctly named?

A. A5:E5

B. A5+G1

C. A5:G1

D. A/E5

4. After inputting a formula or a piece of data into a cell, what happens to the cell pointer when you press Enter?

A. It moves down one cell.

B. It moves to the next adjacent cell to the right.

C. It moves to the last cell in the column.

D. It moves up one cell.

5. Which of the following processes should Angel use to merge cells A1:D4 to create a title?

A. Highlight cells A1:D4, right-click and select Format Cells, click Number, and choose the Merge cells option.

B. Highlight cells A1:D4, click on the Home tab, and click on the Wrap text icon in the Alignment group.

C. Highlight cells A1:D4, click on the Home tab, and click on the Merge cells icon in the Styles group.

D. Highlight cells A1:D4, right-click and select Format Cells, click Alignment, and choose the Merge cells option.

6. Evan is creating a worksheet and needs to copy information in cells A2:A13 into cells B2:B13. Which of

the following is the easiest process for Evan to copy cells A2:A13 and place their information into B2:B13?

A. Highlight cells A2:A13, click on the Format tab, choose Duplicate, select cells B2:B13, and click Enter.

B. Highlight cells A2:A13, click on the Home tab, then in the Edit group, choose Copy, select cells B2:B13, and then click

Paste.

C. Highlight cells A2:A13, right-click, choose Cut, select cells B2:B13, right-click, and then click Paste.

D. Highlight cells A2:A13, right-click, choose Copy, select cells B2:B13, right-click, and then click Paste.

7. A rectangular range of cells with headings to describe the cells’ contents is referred to as a

A. bar chart.

B. sparkline.

C. table.

D. complex formula.

8. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at

the _______ to check the formula.

A. range

B. Formula bar

C. Function tab

D. Name box

9. If you’re unsure of what chart to use for a set of data, what feature does Excel include that will help you to decide?

A. All charts

B. Sparklines

C. Pivot chart

D. Recommended charts

10. Sidney works in the accounting department. His boss just assigned him a task that involves creating

budget formulas for the company’s payroll expense reports. Sidney will be using Excel spreadsheets to

calculate the company’s payroll expense reports. In Excel, what does Sidney need to consider when

creating formulas?

A. Excel performs operations based on the order of precedence.

B. Excel has limited capabilities, so it would be easier to use payroll software for this application.

C. Excel has third-party formulas you can purchase from Microsoft.

D. Excel has predefined formulas, so you don’t have to create any formulas from scratch.

11. You plan to use the Fill Down feature on a formula and you need to keep a cell reference the same. Which one of the following formats will allow you to keep the same cell reference?

A. $E19

B. $E$19

C. E$19

D. E19

12. You’ve been asked to find the largest number in a range of numbers. Which of the following could you use to find the largest number in range E11:E23?

A. =MIN(E11:E23)

B. =SUM(E11:E23)

C. =MAX(E11:E23)

D. =AVERAGE(E11:E23)

13. Which one of following is an example of a formatted number using the Currency option?

A. $7778.92

B. 7,7789.2

C. 777892

D. 7778.92%

14. Which of the following is an example of a complex formula?

A. =150*.05

B. =A1<= A14

C. SUM(A1:A14)

D. Income – Expenses

15. You’ve been asked to find the average of a range of numbers. Which of the following could you use to find the average of cells A1:A10?

A. =AVERAGE(A1:A10)

B. =MIN(A1:A10)

C. =SUM(A1:A10)

D. =MAX(A1:A10)

16. If you sort a portion of an Excel sheet and you get an error message such as #DIV/0, what is a likely cause of the error message?

A. The cell ranges are incorrect.

B. One or more cells contain absolute cell references.

C. You’re attempting to sort too many cells.

D. One or more cells contain relative cell references.

17. What category of predefined formulas in Excel contains the Boolean functions?

A. Math and Trig

B. AutoSum

C. Logical

D. Recently Used

18. A feature in Excel that allows you to graphically display in a single cell the trend across a range of cells is called a

A. pivot point.

End of exam

B. spark point.

C. sparkline.

D. pivot line.

19. The functions you tend to use regularly are listed where on the Ribbon?

A. Logical

B. Recently Used

C. Date & Time

D. Text

20. The order of precedence is very important when building formulas in Excel. Which of the following

formulas will produce 778 as the result?

A. =25*(27/9 + 5) + 309*2

B. =25*27/9 + 5 + 309*2

C. =25*((27/9 + 5) + 309*2)

D. =(25*(27/9) + 5 + 309)*2

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Confirm Eligibility