FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 151

Multiple Choice

Review LaterAdd Note

Review Later

In a complex formula, how does Excel determine which calculation to perform first?

A) It calculates the leftmost formulas first.
B) It calculates operations outside parentheses first.
C) It follows the order of operations.
D) It calculates functions first.

E) None of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 152

Multiple Choice

Review LaterAdd Note

Review Later

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page.To do this, what can she do after selecting the worksheet for this purpose?

A) Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
B) Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.
C) Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.
D) Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.

E) None of the above
F) B) and C)

Correct Answer

verified

Show Answer

Question 153

Multiple Choice

Review LaterAdd Note

Josh teaches sixth grade math.He created a table showing marks that his students scored on an assessment-the last column on the right displays this information.He now wants to add another column to the right showing percentage of marks that each students scored.What should he do after selecting the current last column on the right?

The Comma Style format adds a comma and a dollar sign to a cell value.

One can use the areas section (at the bottom) of the Field List to rearrange fields the way they want by dragging them between the four areas.

To copy a cell's formatting to another cell, which of the following can you use?

If Power View is enabled, one can create a new Power View report page by clicking Insert tab > Power View button.

Which of these will you click select as X in this series of clicks/entries/selections to edit relationships between Pivot tables: Power Pivot window > Design tab > Manage Relationships command > Manage Relationships dialog box > Relationship > Edit > X > Use the drop-down and list box controls on this form to select the appropriate table and field names?

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59.Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B?

Which of the following inserts a function into a cell?

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture, then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

To format a range so that all values greater than $500 appear in red, which of the following can you use?

In which of the following dialog boxes, under Subject to the Constraints, will you click the constraint that you want to change and then click Change?

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Warren creates a table listing the height and weight of students in his class.He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9, the heading "Height" in cell B3 and the height of students in cells B4 to B9, the heading "Weight" in cell C3 and the weight of students in cells C4 to C9.What formula can he use to look up the height of one of the students, Sari, whose name, height, and weight are mentioned in cells A7, B7, and C7, respectively?

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.

Which of the following statements is true about COUNT functions?

To evaluate a formula, click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated) > Close.

Which of the following will you select as X in the following series of clicks to copy a chart from Excel to Word so that it is no longer linked to Excel: In Excel: Chart > Home tab > Clipboard group > Copy button > In Word: location to paste chart > Home tab > Clipboard group > Paste > Paste Options button > X?