Archives
978-0132840163 Access Chapter 1 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) To rename a table, you can 1) A) open Windows Explorer. B) click the Database Tools tab on the Ribbon. C) right–click […]
978-0132840163 Access Chapter 1 Part 2
37) The part of the Access window that groups the commands for performing related database tasks on tabs is the ________. 37) Answer: Ribbon Explanation: 38) The table or tables from which a query gets its data are referred to […]
978-0132840163 Access Chapter 2 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) To locate records in which a field is left blank, what should be used as the criteria for that field? 1) A) […]
978-0132840163 Access Chapter 2 Part 2
37) In a calculated field, existing field names are enclosed in square ________. 37) Answer: brackets Explanation: 38) If you intend to use sorted query results in a report, the sort order should be specified in ________ view. 38) Answer: […]
978-0132840163 Access Chapter 3 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) To view report data while making changes to a report, use 1) A) Datasheet view. B) Layout view. C) Form view. D) […]
978-0132840163 Access Chapter 3 Part 2
32) A(n) ________ inserts the page number when a report is displayed in Print Preview or is printed. 32) Answer: page number control Explanation: 33) The actual typing of information into the records is known as ________ entry. 33) Answer: […]
978-0132840163 Common Features Chap1 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Whenever a window contains information that is not in view, a(n) ________ will display so the user can bring the information into […]
978-0132840163 Common Features Chap1 Part 2
43) Match the following terms to their meanings: I. Contextual tabs A. by default displays the Save, Undo, and Redo commands II. Groups B. only display when they apply to the chosen object III. Quick Access Toolbar C. set of […]
978-0132840163 Excel Chap 1 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) In an Excel chart, a ________ is made up of related data points. 1) A) data marker B) pie slice C) column […]
978-0132840163 Excel Chap 1 Part 2
47) Match the following terms to their meanings: I. Underlying formula A. data displayed in the cell II. Displayed value B. formula displayed in the Formula Bar III. Underlying value C. constant displayed in the Formula Bar IV. Number format […]
978-0132840163 Excel Chap 2 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) A predefined formula is called a 1) A) function. B) filter. C) data bar. D) criteria. Answer: A Explanation: A) B) C) […]
978-0132840163 Excel Chap 2 Part 2
48) Bold type, fill color, and font color are examples of ________ that can be applied to the contents of a cell. 48) Answer: formats Explanation: 49) Match the following terms to their meanings: I. Drag and drop A. locate […]
978-0132840163 Excel Chap 3 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) The percentage rate of increase is calculated by using this formula: ________. 1) A) base/amount of increase B) base * amount of […]
978-0132840163 Excel Chap 3 Part 2
34) The ________ is the percent by which one number increases over another during a specified time frame. 34) A) percentage rate of decrease B) percentage rate of increase C) percent for new value D) base Answer: B Explanation: A) […]
978-0132840163 Integrated Pro Chap 1 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) When a program window is minimized, you still see its ________ displayed on the taskbar. 1) A) icon B) crest C) table […]
978-0132840163 Integrated Pro Chap 1 Part 2
34) Clicking the ________ of a SmartArt graphic selects the entire object, not just a part of the object. 34) Answer: border Explanation: 35) If you have data in an Excel spreadsheet that you wish to manage independently from the […]
978-0132840163 PPT Chap 1 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) ________ are printouts that show the slide image on the top of the page and the notes that have been created on […]
978-0132840163 PPT Chap 1 Part 2
36) Left, right, centered, and justified are examples of 36) A) styles. B) text alignments. C) formats. D) themes. Answer: B Explanation: A) B) C) D) SHORT ANSWER. Write the word or phrase that best completes each statement or answers […]
978-0132840163 PPT Chap 2 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) An object that allows you to position text anywhere on the slide is called a 1) A) text box. B) clip. C) […]
978-0132840163 PPT Chap 2 Part 2
32) The ________ provides predefined combinations of fill colors and line colors that can applied to shapes. 32) A) SmartArt Styles gallery B) Text Styles gallery C) Geometric Styles gallery D) Shape Styles gallery Answer: D Explanation: A) B) C) […]
978-0132840163 PPT Chap 3 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) A chart that is created in PowerPoint is stored as ________ that is incorporated into the PowerPoint file. 1) A) a Word […]
978-0132840163 PPT Chap 3 Part 2
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 35) Match the following terms to their meanings: I. Recolor gallery A. to shrink a video file II. Trim B. displays grayscale, sepia, washout, […]
978-0132840163 Word Chap 1 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) The formatting mark that represents a tab is a(n): 1) A) series of oval dots B) arrow C) long bracket D) long […]
978-0132840163 Word Chap 1 Part 2
33) Match the following terms to their meanings. I. Center alignment A. text is centered between the left and right margins II. Left alignment B. both left and right margins are even III. Right alignment C. the default paragraph alignment […]
978-0132840163 Word Chap 2 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) In a letter, the name and address of the person receiving the letter is known as the 1) A) salutation. B) complimentary […]
978-0132840163 Word Chap 2 Part 2
32) Match the following terms to their meanings. I. Table A. an arrangement of information organized into rows and columns II. Wordwrap B. additional Ribbon tabs present when working in a table III. Design and Layout C. intersection of a […]
978-0132840163 Word Chap 3 Part 1
Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Which of the following is represented by a bent arrow indicator? 1) A) page break B) continuous break C) column break D) […]
978-0132840163 Word Chap 3 Part 2
29) Match the following terms to their meanings: I. Align Left A. text in the paragraph aligns at the right margin and the left margin is uneven II. Center B. text in the paragraph aligns at the left and right […]