Fall Final Exam Review Part 2 Pick a

  • Slides: 36
Download presentation
Fall Final Exam Review Part 2

Fall Final Exam Review Part 2

Pick a question number 1 2 3 4 5 6 7 8 9 10

Pick a question number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Which of the following is true concerning a business report’s introductory pages? a. All

Which of the following is true concerning a business report’s introductory pages? a. All introductory pages should numbered using arabic numerals (1, 2, 3. . . ). b. All introductory pages should be numbered using roman numerals (i, iii. . . ). c. All introductory pages, except the title page, should numbered using arabic numerals (1, 2, 3. . . ). d. All introductory pages, except the title page, should be numbered using roman numerals (i, iii. . . ). • d. All introductory pages, except the title page, should be numbered using roman numerals (i, iii. . . ).

Which of the following was not created using Auto. Shapes? A. C. B. D.

Which of the following was not created using Auto. Shapes? A. C. B. D. • b

Which of the following dialog boxes would be most useful if you want readers

Which of the following dialog boxes would be most useful if you want readers to be able to access a Web page from within a report you are writing? a. Save As b. Record Macro c. Mail Merge d. Insert Hyperlink • d. Insert Hyperlink

Which two files are used with mail merge? a. A Web page and a

Which two files are used with mail merge? a. A Web page and a Web browser. b. A macro and a hyperlink. c. An e-mail message and a Web page. d. A data source and a main document. • d. A data source and a main document.

If you have a table with four columns, but want the title of the

If you have a table with four columns, but want the title of the table (which is in the first row) to run the entire width of the table, you could ____ the cells in the first row. a. Delete b. place a border around c. right-align d. merge

You find yourself having to perform the same six steps over and over, each

You find yourself having to perform the same six steps over and over, each time you have to create a table for a company report. Which of the following might help you? a. macro b. Mail Merge c. Track Changes d. A hyperlink a. macro

By default, a new workbook will contain how many worksheets? • three

By default, a new workbook will contain how many worksheets? • three

Excel files end with which extension? • . xls

Excel files end with which extension? • . xls

When you cut or copy data from selected cells, the data is stored temporarily

When you cut or copy data from selected cells, the data is stored temporarily on the _______. • clipboard

The name of the box formed by the intersection of a row and a

The name of the box formed by the intersection of a row and a column is ___. • cell

An entry that begins with a letter is recognized automatically as a ____. •

An entry that begins with a letter is recognized automatically as a ____. • label

To move from one worksheet to another click on the _____. • Sheet tab

To move from one worksheet to another click on the _____. • Sheet tab

Which button allows you to add up a column of numbers? A C B

Which button allows you to add up a column of numbers? A C B D • c

If you made a change to a cell and then wanted to go back

If you made a change to a cell and then wanted to go back to the previous way, which of these would you click? A C B D • c

To erase the contents of a cell ____. a. click the cell and choose

To erase the contents of a cell ____. a. click the cell and choose Edit>Delete b. choose Edit>Delete and then key in the cell reference c. choose Format>Cell and press [DELETE] d. click the cell and press [DELETE] • d. click the cell and press [DELETE]

Which tab in the Format Cells dialog box contains the option to change a

Which tab in the Format Cells dialog box contains the option to change a letter’s color? a. Patterns b. Font c. Border d. Number • b. Font

Which of the following finds the sum of cells C 3 through C 22?

Which of the following finds the sum of cells C 3 through C 22? a. =SUM(C 3: C 22) b. SUM(C 3: C 22) c. =SUMC 3: C 22 d. SUM=(C 3: C 22) • a. =SUM(C 3: C 22)

The Style command is found in the ____ menu. a. Edit b. File c.

The Style command is found in the ____ menu. a. Edit b. File c. Data d. Format • d. Format

Which function would find the smallest number in a group of cells? • MIN

Which function would find the smallest number in a group of cells? • MIN

According to the order of precedence, “ 8 + 2 * 3” is equal

According to the order of precedence, “ 8 + 2 * 3” is equal to ____. a. 30 b. 14 c. 42 d. 26 • b. 14

Which tools are used to organize a workbook? a. Hide sheets b. Rename c.

Which tools are used to organize a workbook? a. Hide sheets b. Rename c. Color d. All of the above • d. All of the above

The NOW function ____. a. immediately recalculates the Worksheet b. displays the date and

The NOW function ____. a. immediately recalculates the Worksheet b. displays the date and time c. calculates a payment d. adds up data in the selected range • b. displays the date and time

The ____ function can be used to calculate monthly payments for a loan. a.

The ____ function can be used to calculate monthly payments for a loan. a. SUM c. Rate b. NOW d. PMT • d. PMT

To which of the following can you apply a filter? a. A row b.

To which of the following can you apply a filter? a. A row b. A chart c. A function d. A cell range • d. A cell range

Which menu contains the Sort function? a. Edit b. Data c. Insert d. Format

Which menu contains the Sort function? a. Edit b. Data c. Insert d. Format • b. Data

Which function allows you to make a choice by comparing two values? a. NOW

Which function allows you to make a choice by comparing two values? a. NOW b. PMT c. IF d. Count • c. IF

When #### is displayed in a cell containing data you must ___ to see

When #### is displayed in a cell containing data you must ___ to see all of the data. a. add a number b. widen the column c. skip a cell d. add a row • b. widen the column

Preset formulas are called ___. a. a row b. a chart c. functions d.

Preset formulas are called ___. a. a row b. a chart c. functions d. a cell range • c. functions

A group of cells is called a ___. • range

A group of cells is called a ___. • range

In Excel, formulas begin with a(n) ___. • Equal sign (=)

In Excel, formulas begin with a(n) ___. • Equal sign (=)

Which of the following buttons lets you insert a text box into a worksheet?

Which of the following buttons lets you insert a text box into a worksheet? A. C. B. D. • b.

The file extension ___ is used for Power. Point documents. a. b. c. d.

The file extension ___ is used for Power. Point documents. a. b. c. d. . ppt. doc. xls. ppo • a. . ppt

The ____ shows you which slide is currently displayed. a. Status bar b. Title

The ____ shows you which slide is currently displayed. a. Status bar b. Title bar c. Menu bar d. Standard toolbar • a. Status bar

The Slides pane at the left side of the screen shows ____ of each

The Slides pane at the left side of the screen shows ____ of each slide. a. an outline b. the print preview c. a miniature version d. the text • c. a miniature version