Office Productivity Tools
Exam Practice Tests
Course Introduction
This course provides a comprehensive introduction to essential office productivity tools commonly used in academic, professional, and personal settings. Students will gain hands-on experience with word processing, spreadsheet, and presentation software, focusing on applications such as Microsoft Office and Google Workspace. The course covers document formatting, data analysis using spreadsheets, creating impactful presentations, managing schedules and contacts, and collaborating effectively through cloud-based platforms. By the end of the course, learners will possess the skills necessary to produce professional documents, organize information efficiently, and streamline daily tasks for maximum productivity.
Recommended Textbook
Your Office Microsoft Excel 2013 Comprehensive 1st Edition by Amy S. Kinser
Available Study Resources on Quizplus
16 Chapters
1553 Verified Questions
1553 Flashcards
Source URL: https://quizplus.com/study-set/1565 Page 2
Chapter 1: Navigate, manipulate, and Print Worksheets
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/30981
Sample Questions
Q1) The ________ view is used to show page margins,print headers and footers,and page breaks.
Answer: Page Layout
Q2) After selecting a column,pressing the shortcut key ________ will insert a new column.
Answer: Ctrl + +
Q3) To move up one row,you would use the ________ + Enter keyboard shortcut. Answer: Shift
Q4) To AutoFit the width of a column,you click Format and then click AutoFit Column Width in the ________.
A)Cells group on the VIEW tab.
B)Format group on the VIEW tab
C)Cells group on the HOME tab
D)Format group on the HOME tab
Answer: C
Q5) A comment is added to an individual cell.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting, functions, and Formulas
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30987
Sample Questions
Q1) To find the greatest numerical value in a range of cells,you would use the ________ function.
Answer: MAX
Q2) To apply the COUNT function to a selected range of cells containing numbers,you begin by clicking the ________ arrow.
Answer: AutoSum
Q3) To change a table back into a range,you click Convert to Range in the ________.
A)Tools group on the DESIGN tab
B)Styles group on the DESIGN tab
C)Tools group on the VIEW tab
D)Styles group on the VIEW tab
Answer: A
Q4) Striping uses alternating background colors of rows or columns to aid in visually tracking information.
A)True
B)False
Answer: False
Q5) The values inside a function's parentheses are called ________.
Answer: arguments
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Cell References, named Ranges, and Functions
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/30988
Sample Questions
Q1) The comparison operator for does not equal is ________.
Answer: <>
Q2) Which of the following is NOT a comparison operator symbol?
A)=
B)
C)<
D)>= Answer: B
Q3) In financial applications,the word "term" refers to the total time of a loan,usually in months or years.
A)True
B)False
Answer: True
Q4) The OR function returns TRUE if any one of its arguments is true.
A)True
B)False
Answer: True
Q5) The result of =ROUND(123.456,2)is ________.
Answer: 123.46
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Effective Charts
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30989
Sample Questions
Q1) Excel's ________ feature analyzes a selection in a worksheet and suggests chart types that best fit the selected data.
A)Chart Wizard
B)Chart Maker
C)Recommended Charts
D)Chart Styles
Q2) By clicking the Chart Elements button,you can add,move,or remove data labels.
A)True
B)False
Q3) When adding colors to a chart,more is better.
A)True
B)False
Q4) A(n)________ is a line that uses current data to display the progress or general direction of the data.
A)major gridline
B)minor gridline
C)trendline
D)axis
Q5) A(n)________ is an individual value in a data series.
Q6) A common use for ________ charts is for project management.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Complex Conditional and Retrieval Functions
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30990
Sample Questions
Q1) When a(n)________ function is nested in the logical_test argument of an IF function,both logical tests need to be evaluated as "TRUE" for the [value_if_true] argument to be returned.
Q2) The ________ function is used when the lookup_value argument checks the top row of the table_array.
A)HLOOKUP
B)VLOOKUP
C)RLOOKUP
D)TLOOKUP
Q3) Which of the following is NOT a database function?
A)DAVERAGE
B)DCOUNT
C)DMIN
D)DCALC
Q4) All of the following statements are TRUE about the IF function EXCEPT:
A)The [value_if_false] argument may be omitted from the IF function.
B)The IF function is the most common logical function.
C)The TRUE argument of the IF function is optional.
D)Cell references listed in the IF function must be capitalized.
Q5) COUNTIF and AVERAGEIF are examples of ________ statistical functions.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Analyze Data Using Tables
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30991
Sample Questions
Q1) ________ is created by users when they organize data in a meaningful context.
Q2) A ________ is a visual mechanism for quickly filtering data in a PivotTable.
A)selector
B)sifter
C)slicer
D)strainer
Q3) The SUBTOTAL function includes hidden records and only uses visible filtered records to calculate the formula.
A)True
B)False
Q4) The function_num argument of the SUBTOTAL function can only have entries from 1 to 10 or from 101 to ________.
Q5) If there are a lot of groups within a field,it is better to put those fields across the top in the columns of a PivotTable instead of along the row side.
A)True
B)False
Q6) ________ data include elements or facts that may or may not have meaning or relevance.
Q7) Pressing ________ allows you to select multiple criteria on a slicer.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Multiple Worksheets workbooks and Templates
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/30992
Sample Questions
Q1) Each of the following statements is TRUE regarding grouping worksheets EXCEPT:
A)Grouped worksheets make the entry of worksheet structural elements like titles, column headings, and row labels fast and efficient.
B)Errors made, such as misspellings or misplacement of a heading, are compounded across all grouped worksheets.
C)If you forget to ungroup worksheets, you can quickly create more work than you saved by grouping worksheets in the first place.
D)When worksheets are grouped, the Undo command is disabled.
Q2) To arrange the data in all the worksheets in identical order and location,use the consolidate by position option.
A)True
B)False
Q3) Ungrouping worksheets is accomplished by either right-clicking a grouped worksheet tab and selecting Ungroup Sheets from the shortcut menu,or by clicking the [Group] tag on the title bar.
A)True
B)False
Q4) A(n)________ named range cannot be defined in the Name box.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 8: Refine an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/30993
Sample Questions
Q1) A(n)________ appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.
A)list validation
B)Error Message
C)Input Message
D)cell validation
Q2) A ________ is formed following a system of rules where the position of information is tied to its context.
A)restrictive
B)conditional
C)codified data value
D)logical
Q3) ________ schemes are rules that combine data values in specific formats and locations to generate new data values.
Q4) ________ validation allows users to apply multiple criteria simultaneously.
A)Defined
B)Personalized
C)Custom
D)Individualized
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Organize, import, export, and Cleanse Data Sets
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/30994
Sample Questions
Q1) Data cleansing is the process of validating that the data is correct and accurate.
A)True
B)False
Q2) Some companies use Internet queries on their websites to make their data available to users.
A)True
B)False
Q3) All of the following are common formats used to import data into Excel EXCEPT ________.
A)ODBC
B)HTML
C)XML
D).accdb
Q4) ________ recognizes patterns in data as you type and automatically fills in values for text and numeric data.
Q5) Excel import file types are limited to only two types of files,HTML and XML.
A)True
B)False
Q6) With ________,tags are customized for content of a specific industry.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Data Tables, scenario Manager, and Solver
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30982
Sample Questions
Q1) For a one-variable data table,you must specify both the row input cell and column input cell from the original data set.
A)True
B)False
Q2) The iteration settings cannot be changed.
A)True
B)False
Q3) The scroll bar is a type of scenario tool because of the ability to calculate numerous outputs in other cells by referencing the target cell in formulas and functions.
A)True
B)False
Q4) Changing a binding constraint also changes the optimal solution.
A)True
B)False
Q5) The three parameters available in Solver are objective cell,variable cell,and ________.
Q6) What-if analysis tools provide definitive solutions to problems. A)True B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Loan Amortization, investment Analysis, and Asset Depreciation
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30983
Sample Questions
Q1) You would need to enter a value for the fv argument of the PMT function when you have a(n)________ payment at the end of the loan.
Q2) The ________ function calculates the number of payment periods for an investment or loan if you know the loan amount,interest rate,and payment amount.
A)NPV
B)IPMT
C)RATE
D)NPER
Q3) The NPV function can evaluate the value of an investment over time through incoming and outgoing cash flows.
A)True
B)False
Q4) A(n)________ is the ratio of the amount of money gained or lost from an investment relative to the initial amount invested.
Q5) A loan schedule that calculates the interest and principal payments is known as a(n)________ table.
Q6) ________ are the costs associated with the loan and are never deducted from the beginning balance.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Business Statistics and Regression Analysis
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30984
Sample Questions
Q1) ________ is the process of taking data from a sample of the population and making predictions about the entire population.
Q2) Calculating the range,variance,and standard deviation of a data set are all methods used to determine the ________ of a data set.
A)concentration
B)dispersion
C)standard deviation
D)central tendency
Q3) Calculating the range,variance,and kurtosis of a data set are all methods used to determine the dispersion of a data set.
A)True
B)False
Q4) The spa manager uses data such as number of soaps in a box and the number of different services the spa offers its customers.These are examples of ________.
A)probability distributions
B)discrete variables
C)continuous variables
D)populations
To view all questions and flashcards with answers, click on the resource link above.
14
Chapter 13: Excels Data Model, Power-pivot, and Power View
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/30985
Sample Questions
Q1) Digital dashboards are mechanisms that deliver business intelligence in tabular form.
A)True
B)False
Q2) ________ provide a way to graphically summarize a row or column of data in a single cell.
Q3) The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.
Q4) A ________ can be the aggregate of 2013 Profit or a monthly sales goal that every employee should meet.
A)target value
B)status threshold
C)KPI
D)base value
Q5) A typical manager engages in over 300 different tasks and decisions each day.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Q6) A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.
Chapter 14: Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/30986
Sample Questions
Q1) All of the following are ways to make VBA code easy to read EXCEPT ________.
A)Comments
B)Line breaks
C)Paragraphs
D)Indentations
Q2) It is best to group your Sub procedures together by what they do into separate modules,renaming the module appropriately to describe the kind of procedures it contains.
A)True
B)False
Q3) A(n)________ is an effective way of using VBA code to increase the interactivity of a dashboard by prompting the user for information and storing that information in a variable to be used later.
Q4) A(n)________ consists of a hierarchical collection of objects,consisting of properties,methods,and events that can be manipulated using VBA.
A)method
B)collection
C)source
D)object model
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Appendix:efficient Interaction With a Touch Screen
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30996
Sample Questions
Q1) ________ in Windows 8 is (are)better than any prior version of Windows.
A)GUI
B)Menus
C)Icons
D)Speech recognition
Q2) Windows 8 and Office 2013 have fully integrated the touch environment.
A)True
B)False
Q3) A(n)________ is a movement of the user's finger,fingers,or pen on a touch screen resulting in a particular action.
Q4) ________ switches Office into a version that makes a touch screen easy to use.
A)Windows 8
B)Touch mode
C)Gesturing
D)Flicking
Q5) Bezel gestures start and end at the edge of the screen.
A)True
B)False
Page 17
Q6) Windows 8 supports ________ recognition,which allows you to control the computer with gestures instead of mouse clicks.
To view all questions and flashcards with answers, click on the resource link above.
Page 18
Chapter 16: The Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/30995
Sample Questions
Q1) When you use computing resources of another computer over a network,you are using ________.
Q2) Each Office program has its own Help window.
A)True
B)False
Q3) Office 365 has several advantages over Office 2013,but requires payment of an annual fee.
A)True
B)False
Q4) Microsoft PowerPoint is used to create ________.
A)newsletters
B)presentations
C)documents
D)databases
Q5) Microsoft OneNote is a(n)________ program.
A)e-mail and contact
B)presentation and slide
C)planner and note-taking
D)information management
Q6) To enlarge your workspace,you can collapse the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 19