preview

penn foster microsoft excel Essay

Satisfactory Essays
Open Document

Student ID: 21709822 Exam: 038229RR - Microsoft Excel When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you hit Submit Exam. If you need to exit before completing the exam, click Cancel Exam. Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break, so be sure that you have seen the entire question and all the answers before choosing an answer. 1. 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 2. Which of …show more content…

A. It moves up one cell. B. It moves to the last cell in the column. C. It moves down one cell. D. It moves to the next adjacent cell to the right. 14. Keeping in mind the role the order of precedence plays in equations, what would Excel display as the result of the following equation? =(24+75)/(6*3) A. 28.2 B. 198 C. 5.5 D. 109.5 15. A rectangular range of cells with headings to describe the cells' contents is referred to as a A. complex formula. B. bar chart. C. sparkline. D. table. 16. Which of the following is a group of cells chosen to perform an action? A. Range B. Data series C. Group D. Command 17. 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. Name box B. Function tab C. range D. Formula bar 18. Which of the following is an example of a complex formula? A. =150*.05 B. Income – Expenses C. =A1<= A14 D. SUM(A1:A14) 19. To combine a range of cells into one large cell, you should highlight the cells and choose A. Decrease Indent. B. Merge Cells. C. Wrap Text. D. Increase Indent. 20. 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. One or more cells contain absolute cell references. B. You're attempting to sort too many cells. C. One or more cells contain

Get Access
Related
Get Access