Office Productivity Tools
Exam Preparation Guide
Course Introduction
Office Productivity Tools is a practical course designed to introduce students to the essential software applications widely used in todays professional environments. The course covers word processing, spreadsheet management, presentation design, email communication, and database basics, typically focusing on software such as Microsoft Office or Google Workspace. Emphasis is placed on developing competencies in creating well-formatted documents, analyzing data, automating repetitive tasks, collaborating online, and organizing work efficiently. By the end of the course, students will have gained hands-on experience and practical skills that enhance their efficiency and productivity in academic, business, and personal contexts.
Recommended Textbook
New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition by June Jamrich Parsons
Available Study Resources on Quizplus
13 Chapters
1319 Verified Questions
1319 Flashcards
Source URL: https://quizplus.com/study-set/1082 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21371
Sample Questions
Q1) A common business practice is to include a worksheet named \(\underline { \text { Documentation } }\) that contains a description of the workbook,the name of the person who prepared the workbook,and the date it was created._________________________
A)True
B)False
Answer: True
Q2) Shows the contents of the worksheet
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template
Answer: H
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21372
Sample Questions
Q1) One way to align text over several columns or rows is to ____________________,or combine,several cells into one cell.
Answer: merge
Q2) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
Answer: formatting
Q3) To set a page break in Excel,select the _____.
A)first cell below the row where you want to insert a page break
B)first cell above the row where you want to insert a page break
C)row above where you want to insert a page break
D)row below where you want to insert a page break
Answer: A
Q4) Information that prints on each page,like a company name or logo,may be set as a
A)print setup
B)copied text
C)text header
D)print title
Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Calculating Data With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21373
Sample Questions
Q1) A Statistical function that calculates the middle value of a collection of numbers
A)NOW
B)error value
C)COUNTA
D)<
E)MEDIAN
F)Mon, Tues, Wed, Thurs, Fri
G)F4
H)absolute
I)nested
J)mixed
Answer: E
Q2) One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.
A)goal seek
B)gunction
C)search
D)what-if analysis
Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21374
Sample Questions
Q1) Each slice in a pie chart represents a single value from a data series.
A)True
B)False
Q2) Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.
Q3) \(\underline { \text { Interest } }\) is the amount added to the principal by the lender._________________________
A)True
B)False
Q4) Each value from a data series is represented by a ________.
Q5) Placing a chart in a ____ displays only the chart and no worksheet cells.
A)new worksheet
B)tabbed view
C)graph display
D)chart sheet
Q6) A ____________ displays data values as columns with the height of each column based on the data value.
Q7) You can add ___________________ to identify smaller intervals between the major tick marks.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Working With Excel Tables, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21375
Sample Questions
Q1) A data ____ table describes the fields you plan to maintain in a table.
A)structure
B)definition
C)map
D)linked
Q2) Which of the following is true about Excel tables (as opposed to structured ranges of data)?
A)You cannot format quickly using a table style.
B)You cannot enter a formula in one table cell that is automatically copied to all other cells in that table column.
C)You cannot add new rows and columns that automatically expand the range.
D)You cannot freeze the top row of the worksheet.
Q3) In addition to displaying subtotals,the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.
A)headers
B)outlines
C)shadows
D)defines
Q4) The second sort field in a sort is called the ____________________ field.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21376
Sample Questions
Q1) If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.
A)anchor
B)source
C)link
D)index
Q2) A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.
Q3) To select adjacent worksheets,you use the ____ key.
A)Shift
B)Alt
C)Ctrl
D)F1
Q4) When two files are linked together,the ____________________ file receives the information.
Q5) All template files have the .xlts file extension.
A)True
B)False
Q6) ____________________ appear whenever you place the pointer over a hyperlink.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21377
Sample Questions
Q1) After a year of work,Ted is taking coursework to become a VBA programmer.He is working on developing an application that contains macros.Which should his option be in the Trust Center?
A)Enable all trusted macros
B)Enable all macros
C)Disable all macros except digitally signed macros
D)Disable a macro with notification
Q2) Which of the following is an example of a valid defined name Juan can provide to you?
A) .FY2010
B)F-Y2010
C)FY2010
D)FiscalYear2010
Q3) Validation rules come into play only during data entry.
A)True
B)False
Q4) List three advantages to using defined names instead of cell references.
Q5) Describe the four macro security settings.
Q6) What are the steps for creating a validation rule?
To view all questions and flashcards with answers, click on the resource link above. Page 9
Q7) A digital ____________________ is typically issued by a certificate authority.
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21378
Sample Questions
Q1) For one service recognition program,you need to calculate the length of service in complete months.What is the correct formula?
A)=DATEDIF(C2, $AE$2, "m")
B)=DATEDIF($AE$2, C2, "month")
C)=DATEDIF($AE$2, C2, "mth")
D)=DATEDIF(C2, $AE$2, "mon")
Q2) You can edit existing conditional formatting _____ from the Conditional Formatting Rules Manager dialog box.
A)themes
B)objects
C)tables
D)rules
Q3) The \(\underline {\text { VLOOKUP } }\) function searches vertically down the first column of the lookup table for the value you entered,and then retrieves the corresponding value from another column of the table._________________________
A)True
B)False
Q4) What are the guidelines to keep in mind when creating fields in an Excel table?
Q5) Discuss strategies for checking formulas for matching parentheses.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21379
Sample Questions
Q1) The major advantage of the payback period is that it takes into account the time value of money.
A)True
B)False
Q2) With ____________________ the asset loses value by equal amounts each year until it reaches the salvage value at the end of its useful life.
Q3) To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.
A)add
B)subtract
C)multiply
D)divide
Q4) The item marked 2 in the accompanying figure is the _______ value.
A)sum
B)declining balance
C)initial asset
D)salvage
Q5) Describe the steps to interpolate a series of values between starting and ending values.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What If Analyses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21380
Sample Questions
Q1) If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.
A)FALSE
B)NO
C)1
D)0
Q2) The ____________________ input cell is the cell on which values placed in the first column of the data table are based.
Q3) How many different types of reports can Solver create? What are the characteristics of these report types,and which is the most useful?
Q4) To perform a what-if analysis with more than two input cells,you _______.
A)hide all references
B)use only exchange values
C)apply additional constraints
D)create scenarios
Q5) Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.
Q6) What are the steps to create a one-variable data table?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/21381
Sample Questions
Q1) A _______ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column.
A)space
B)comma
C)tab
D)dash
Q2) In XML,the rules about which elements are required and which are not are stored in a document called the _______.
A)schema
B)dictionary
C)index
D)glossary
Q3) One of the advantages of using XML as a data source is that it allows you to attach,or _______,elements to specific cells in the workbook.
A)map
B)bind
C)insert
D)pin
To view all questions and flashcards with answers, click on the resource link above.
13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/21382
Sample Questions
Q1) Rebecca would like to review track changes.In a shared workbook,all edits are stored in a tracking log for 30 days.On the REVIEW tab,she will _______.
A)click the Track Changes button in the Changes group, and then click Highlight Changes.
B)click the Track Changes button in the Language group, and then click Highlight Changes.
C)click the Track Changes button in the Comments group, and then click Highlight Changes.
D)click the Track Changes button in the Proofing group, and then click Highlight Changes.
Q2) The following condition must be met to merge two or more workbooks:
A)The copies must originate from different shared files.
B)The copies cannot have different filenames.
C)The Track Changes feature must be turned off for all copies.
D)The copies must either have the same password or not be password-protected.
Q3) The different versions of the workbook can be ____________________ so that the changes in the copies can be compared and conflicting edits can be resolved.
Q4) Data ____________________ can be databases,text files,or other Excel workbooks.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21370
Sample Questions
Q1) Windows 8 stores compressed files in a special type of folder called a(n)____.
A)extraction
B)USB drive
C)lockbox
D)archive
Q2) Boxes D,E,and F in the accompanying figure point to items in the ____________________ pane.
Q3) temporary storage area for files and information
A)backslash
B)Large icons
C)Clipboard
D)root directory
E)SkyDrive
F)extension
G)folder
H)archive
I)Details
J)library
Q4) A duplicate copy of important files is known as a(n)____________________.
Q5) What are the text's three main guidelines for creating folders?
To view all questions and flashcards with answers, click on the resource link above. Page 15