Fall Final Exam Review Part 2 Pick a
- Slides: 36
Fall Final Exam Review Part 2
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 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. • b
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 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 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 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
Excel files end with which extension? • . xls
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 column is ___. • cell
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
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 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 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 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? 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. Data d. Format • d. Format
Which function would find the smallest number in a group of cells? • MIN
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. Color d. All of the above • d. All of the above
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. SUM c. Rate b. NOW d. PMT • d. PMT
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 • b. Data
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 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. a cell range • c. functions
A group of cells is called a ___. • range
In Excel, formulas begin with a(n) ___. • Equal sign (=)
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. . ppt. doc. xls. ppo • a. . ppt
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 slide. a. an outline b. the print preview c. a miniature version d. the text • c. a miniature version
- Physics 20 final exam practice
- Ap gov review final exam review
- Chemistry fall semester exam review answers
- Physics fall semester exam review
- Us history semester 2 final exam
- English 3 fall semester exam review
- Dramatic irony def
- Us history semester exam review answers
- World history spring final exam review answers
- Spanish 1 review packet
- Pltw human body systems final exam
- Poe practice test answer key
- Ied final exam
- Principles of business final exam answer key
- Spanish 2 review packet
- Final exam study guide environmental science
- World history final exam review
- Us history semester 2 final exam
- English 11 a semester exam
- Physical science jeopardy
- Mat1033c
- Statics final review
- Zoology final exam review
- Earth science sol review
- Algebra 2 semester 2 final exam
- Hft 2401 exam 1
- Personal finance final exam review
- Spanish 2 final exam review
- Psychology final exam review
- Chapter review motion part a vocabulary review answer key
- World geography spring final review
- Web design final exam
- Sbu final exam schedule
- Itus exam
- National latin exam practice quiz
- Street law final exam
- Biology second semester final exam answers