# penn foster microsoft excel

Satisfactory Essays
985 Words
Grammar
Plagiarism
Writing
Score
penn foster microsoft excel
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 the following identifies the patterns used for each data series in a chart?
A. The horizontal and vertical axes
B. Data series
C. Legend
D. Data point

3. Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot table? A. When Helga created the pivot table, Excel automatically put the fields to the appropriate cells of the pivot table. There aren't two ways to set up a pivot table.
B. Helga can check the field or type in the data in the pivot table.
C. Helga can drag the fields to the four boxes in the pivot table field list or right-click a field name and choose its location from the shortcut menu.
D. Helga can slide cells to the four boxes or double-click properties to choose from a list of pivot table options.

4. 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

5. 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. Recommended charts
B. Sparklines

C. All charts
D. Pivot chart

6. Which of the following ranges of cells is correctly named?
A. A5:E5
B.

## You May Also Find These Documents Helpful

• Satisfactory Essays

(TCO 1) The three types of data that can be entered in a cell in an Excel…

• 397 Words
• 2 Pages
Satisfactory Essays
• Good Essays

The challenge in this situation is that the user wants to use a program that is new to him. I will have to explain to the user the basic functions of Excel to see if those functions match what the user wants to do.…

• 918 Words
• 4 Pages
Good Essays
• Good Essays

All of the cells have been correctly formatted for presentation and should not require any adjustment. For example, if the text requires one, two, or three significant digits in a presentation, the template has been set for that presentation in the appropriate cells.…

• 1877 Words
• 8 Pages
Good Essays
• Satisfactory Essays

To make a line break in a cell (not everything fits well within a cell)…

• 526 Words
• 3 Pages
Satisfactory Essays
• Good Essays

1. Create the pivot table and then click any cell in the pivot table on which…

• 521 Words
• 3 Pages
Good Essays
• Good Essays

The Pivot Table is two-dimensional statistical summaries of database information and can be improved by arranging the codes chronologically and sort the data…

• 565 Words
• 3 Pages
Good Essays
• Satisfactory Essays

When a response has been selected a dot will appear in the centre of the button…

• 351 Words
• 2 Pages
Satisfactory Essays
• Good Essays

by Double Click, it is very beneficial to use Pivot Tables in Excel. If you have never used Pivot tables, here is…

• 608 Words
• 3 Pages
Good Essays
• Powerful Essays

In order to enter your data and work with it in the most straightforward way it is…

• 1416 Words
• 12 Pages
Powerful Essays
• Powerful Essays

J.A. (Jim) Connell University of Montevallo Michael E. Stephens College of Business Station 6551 Montevallo, AL 35115 Elizabeth Mulig USF St. Petersburg 140 Seventh Avenue South St. Petersburg Florida 33701-5016 727-553-4154 mulig@stpt.usf.edu…

• 2074 Words
• 9 Pages
Powerful Essays
• Satisfactory Essays

4. Create a new table in Design view, using the table design shown in Figure 2-44.…

• 375 Words
• 2 Pages
Satisfactory Essays
• Good Essays

After analyzing the resulting Pivot Table, you might want to add a Pivot Chart to your analysis (as explained in the tutorials recommended…

• 288 Words
• 9 Pages
Good Essays
• Powerful Essays

assigned to individual formulas in cells. Some of these formulas can apply to ranges as well, like…

• 962 Words
• 3 Pages
Powerful Essays
• Satisfactory Essays

BASICS OF MS-EXCEL 12.1 INTRODUCTION MS-Excel 2000 is a Windows based application package. It is quite useful in entering, editing, analysis and storing of data. Arithmetic operations with numerical data such as addition, subtraction, multiplication and division can also be done with Excel. You can sort the numbers/characters according to some given criteria (like ascending, descending etc.)and solve simple financial, mathematical and statistical formulas. 12.2 OBJECTIVES…

• 3696 Words
• 15 Pages
Satisfactory Essays
• Satisfactory Essays

Figure 10 - Spreadsheet with the "show only events commencing after 15th October filter applied…

• 670 Words
• 3 Pages
Satisfactory Essays