Office Productivity Tools
Test Questions
Course Introduction
This course provides a comprehensive introduction to essential office productivity tools widely used in professional and academic environments. Students will develop practical skills in word processing, spreadsheets, presentation software, and basic database management. The curriculum emphasizes efficient document creation, data analysis, information management, and collaborative work through cloud-based platforms. By the end of the course, participants will be adept at employing various software applications to streamline tasks, enhance productivity, and effectively communicate and manage information in the modern workplace.
Recommended Textbook
Exploring Microsoft Office 2013 Volume 1 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
37 Chapters
3754 Verified Questions
3754 Flashcards
Source URL: https://quizplus.com/study-set/2006
Page 2
Chapter 1: Office Fundamentals and File Management
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39846
Sample Questions
Q1) Name at least four tasks that are available in Microsoft Office 2013 Backstage view. Answer: You can open saved files,create new files,print items,and save and close files.In Backstage view,you can also indicate options,preferences,and settings in the program you are using.You can also exit an application as well as identify file information,such as the author or date created.
Q2) It is most attractive and common that Word documents are printed in ________ orientation.Excel documents are most often printed in ________ orientation.
A)landscape;landscape
B)landscape;portrait
C)portrait;landscape
D)portrait;portrait
Answer: C
Q3) Printing a document is available from the ________ tab.
A)File
B)Home
C)View
D)Page Layout
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 3: Word: Document Presentation: Editing and Formatting
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39848
Sample Questions
Q1) A style can store any type of character or paragraph formatting.
A)True
B)False
Answer: True
Q2) ________ appear as you move an object,assisting with aligning it with existing text.
Answer: Alignment guides
Q3) Which of the following is TRUE about cropping?
A)Cropping reduces the size of a graphic.
B)Cropping reduces the size of a document.
C)Cropping adjusts the amount of a picture that displays.
D)When you crop a photo,the portion cropped from the photo is deleted.
Answer: C
Q4) Default tab stops are ________ aligned.
Answer: left
Q5) When you drag a center sizing handle to resize an object,both the height and width are adjusted simultaneously.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 4: Word: Document Productivity: Working With
Tables and Mail Merge
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39849
Sample Questions
Q1) By default,text within a cell is oriented from right to left.
A)True
B)False
Q2) A database ________ is a collection of related records that can be used as a mail merge data source.
Q3) You can format text in a cell just as you format text in a paragraph.
A)True
B)False
Q4) A newly created table is automatically formatted in ________ style.
Q5) Once a table is inserted and aligned,it cannot be moved.
A)True
B)False
Q6) Live Preview is not available for table styles.
A)True
B)False
Q7) After merge fields have been inserted in a main document,how are they set apart from other text?
5
Q8) Differentiate between table alignment and alignment of text within cells.
Q9) A formula can contain more than one mathematical ________,such as + and -.
Q10) ________ affects the background color or pattern of a cell,or group of cells.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Word: Collaboration and Research:
Communicating and Producing Professional Papers
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39850
Sample Questions
Q1) Simple Markup shows all changes that have been made to a document while Track Changes is on,which can result in a cluttered display.
A)True
B)False
Q2) When you click Bibliography in the Citations and Bibliography group on the References tab,you can select from Bibliography,References,or ________.
Q3) Briefly explain why you might choose Simple Markup view over All Markup view when editing a shared document?
Q4) A(n)________ is a list of headings in the order they appear in a document,along with associated page numbers.
Q5) All writing styles require a ________ indent for a bibliography or works cited page.
A)left
B)first line
C)right
D)hanging
Q6) When contents of comments are too lengthy to show in a comment balloon,you can display them completely in the ________ Pane.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39851
Sample Questions
Q1) A(n)________ is a geometric or nongeometric object such as a rectangle,star,or arrow.
Q2) When columns are used in a document,the text will flow from the bottom of one column to the top of the next column.
A)True
B)False
Q3) The ________ options allow you to fix an image's position on the page.
A)Through
B)Top and Bottom
C)Layout
D)Tight
Q4) The Read Mode is new to Word 2013.What is the purpose of Read Mode,and how would you describe the view? According to the text,why is it that you do NOT need Adobe Reader to open a PDF?
Q5) You may use a border to surround a paragraph.
A)True
B)False
Q6) A large capital letter at the beginning of a paragraph is known as a(n)________. Page 8
Q7) The ________ of an object or shape can be described as the interior space of the object.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Word: Time Saving Tools: Using Templates, multiple Documents, and Themes
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39852
Sample Questions
Q1) Deleting a subdocument from a master document also deletes the actual subdocument file permanently.
A)True
B)False
Q2) A(n)________ is a small picture of a page in a document.
Q3) The Combine command is located on the ________ tab.
Q4) All the following statements about bookmarks are true,EXCEPT that:
A)You should try to use long,descriptive names for your bookmark.
B)you may sort bookmarks according to the bookmark name or the bookmark location in the document.
C)a bookmark will help you return to a specific location quickly.
D)you can bookmark anything in Word,including headings ,charts,and pictures.
Q5) The ________ feature in Word evaluates the contents of two or more documents and displays the differences between them.
A)Track Changes
B)Compare
C)View Side by Side
D)Combine
Q6) What is a template? What is the Normal template?
Q7) Templates have ________ to allow users to type information into the document. Page 10
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Word: Document Automation:
Forms,macros,and Security
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39853
Sample Questions
Q1) The ________ Mode is a toggle;click it once to activate it and click it again to deactivate it.
Q2) Form templates are provided by Microsoft and users CANNOT create their own.
A)True
B)False
Q3) The Comments editing restriction permits users to add comments and make changes to a document.
A)True
B)False
Q4) When you change security settings for macros in Word 2013,the changes apply to all Microsoft Office programs.
A)True
B)False
Q5) ________ is known as a digital certification authority.
A)VeriSign
B)Intel
C)Selfcert.exe
D)Microsoft
Q7) The default macro setting is disable all macros with ________. Page 12
Q6) What is the difference between the rich text control and the plain text control?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 9: Word: Word and the Internet: Web Page
Creation and Enhancement, and Blogs
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/39854
Sample Questions
Q1) All of the following are options to save Web pages EXCEPT:
A)Web Page.
B)Web Page,Filtered.
C)Web Page,Template.
D)Single File Web Page.
Q2) The command to insert an online photo into a document is located in the Illustrations group of the Insert tab.
A)True
B)False
Q3) Click Online Videos in the ________ group to insert an online video clip onto a Web page.
A)Media
B)Insert
C)Apps for Office
D)Illustrations
Q4) The Ribbon can be customized by:
A)clicking the Design tab.
B)clicking the Home tab.
C)right-clicking the Ribbon.
D)right-clicking the File tab.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 10: Power: Introduction to Powerpoint: Creating a Basic Presentation
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39855
Sample Questions
Q1) Of the following,which is NOT a method to return to a previously viewed slide?
A)Press N
B)Press the left arrow
C)Press Backspace
D)Press Page Up
Q2) Which of the following is TRUE about themes in PowerPoint 2013?
A)A theme can be added from the Insert tab.
B)Widescreen themes are available.
C)A theme includes animation and transitions.
D)A theme is automatically applied to only the currently selected slide.
Q3) If you have a Title slide selected and you click on the New Slide button (not the New Slide arrow),the new slide will have a ________ layout.
A)Title and Content
B)Title Slide
C)Blank
D)Title Only
Q4) Name three necessary steps you should take prior to planning your presentation.
Q5) A written note or drawing that offers additional commentary or explanation and is written during a slide show is known as a(n)________.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 11: Power: Presentation Development: Planning and Preparing a Presentation
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/39856
Sample Questions
Q1) Which of the following files will import all of the outline text into one placeholder on one slide?
A)Outline1.docx
B)Outline2.htm
C)Outline3.rtf
D)Outline4.txt
Q2) The ________ gallery includes options such as soft glow,soft edges,and shadow.
Q3) The ________ file format retains only text without saving any formatting.
A).txt
B).htm
C).docx
D).rtf
Q4) How do you move a slide in collapsed outline view?
A)Click the slide title and drag it to the new location.
B)Position the pointer over a slide icon until it turns to a four-headed arrow and then drag it.
C)Position the pointer over the slide number until it turns into a four-headed arrow and then drag it.
D)Click the slide number and drag it to the new location.
Q5) The Hide Background Graphics button is located in the ________ group.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 12: Power: Presentation Design: Illustrations and Infographics
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/39857
Sample Questions
Q1) What is the purpose of using shapes in a presentation?
Q2) Where would you find an arrowhead in regard to PowerPoint 2013?
A)As a shape on a slide
B)At the vertex of two or more lines
C)At the corner of any selected shape
D)At the end of a line
Q3) You enter the text for a WordArt design in the Text pane.
A)True
B)False
Q4) What is the difference between a SmartArt List diagram and a SmartArt Process diagram?
A)List is for non-sequential information;Process is for steps in a process.
B)Lists are always horizontally displayed while Processes are always displayed vertically.
C)They both show a process or timeline,but Lists are vertical and Processes are horizontal.
D)Lists are always vertically displayed while Processes are always displayed horizontally.
Q5) What is the definition of guides,and how can they help when creating a presentation?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Power: Powerpoint Rich Media Tools: Enhancing
With Multimedia
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/39858
Sample Questions
Q1) Both bitmap and vector images are created using mathematical statements. A)True
B)False
Q2) Click the ________ tab to begin the process of creating a photo album presentation.
Q3) When you crop an image,the unwanted portions of the image are automatically deleted.
A)True
B)False
Q4) Why might file compression be important?
Q5) If you're unable to apply a theme for the background of a photo album,click the ________ tab and select a theme from the gallery.
A)Insert
B)Home
C)Slide Show
D)Design
Q6) ________ a picture removes unwanted external areas of an image from view.
Q7) What audio options are available from the Audio Tools Playback tab?
Q8) Is it permissible to use anything you find on the Internet in your presentation? Page 18
Q9) To begin to record audio for a presentation,click the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 14: Power: Infographics: Creating Text Charts, tables,
and Graphs
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39859
Sample Questions
Q1) It is essential to be exact in row height and column width when drawing a table in PowerPoint.
A)True
B)False
Q2) Changing shape fill,outlines,and effects on a chart is similar to making changes in a SmartArt design.
A)True
B)False
Q3) Which of the following chart elements is LEAST likely to be included in an Excel chart?
A)Chart title
B)Legend
C)Axis titles
D)Z-axis
Q4) On what is a table style applied to a table in PowerPoint based?
Q5) The ________ option formats the last row of a table and displays column totals.
Q6) On a column chart with two axes,data increments are automatically determined and included on the ________-axis.
Q7) The Page Setup button is located on the ________ tab.
Q8) Why might you want to apply a predefined layout to a chart? Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 15: Power: Interactivity and Advanced Animation: Engaging the Audience
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39860
Sample Questions
Q1) An End action button moves to the end of the last bullet on the current slide. A)True B)False
Q2) Should you use numerous animations on a typical object or slide in PowerPoint? Explain.
Q3) To add multiple animations to an object,select the object and click the Insert tab. A)True B)False
Q4) If you follow the 7 × 7 slide guideline,you will never have more text than needs to be displayed on a slide. A)True B)False
Q5) A(n)________ arrow on a motion path indicates the ending point of the path.
Q6) A hyperlink can be attached to a SmartArt object. A)True B)False
Q7) What are the animation options for SmartArt objects?
Q8) A(n)________ path like a circle only has one starting point and no ending point.
Q9) URL stands for uniform ________. Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
Chapter 16: Power: Customization: Customizing Powerpoint and
the Slide Show
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39861
Sample Questions
Q1) A(n)________ pages printout is typically used by the presenter.
Q2) Multiple custom slide shows can be linked together with hyperlinks.
A)True
B)False
Q3) Discuss printing hidden slides.
Q4) Which of the following is NOT an option available in the Customize Ribbon option of PowerPoint 2013?
A)Change the order of tabs.
B)Change the order of groups on a tab.
C)Create a new tab.
D)Create a new button .
Q5) RGB,a numeric system for identifying colors is a combination of red,green,and ________ light.
Q6) To change the colors of a new color scheme,click the ________ tab.
Q7) Orientation of handouts of slides cannot be changed. A)True
B)False
Q8) A file named decline appt.pptx is a PowerPoint template file. A)True B)False Page 24
To view all questions and flashcards with answers, click on the resource link above.
Page 25
Chapter 17: Power: Collaboration and Distribution:
Collaborating, preparing, securing, and Sharing a
Presentation
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39862
Sample Questions
Q1) IRM stands for ________ management.
Q2) Two different passwords can be set for a file.
A)True
B)False
Q3) Changes on a slide must be accepted or rejected individually;there is no way to accept or reject all changes.
A)True
B)False
Q4) Which of the following is TRUE about passwords?
A)It is best to use a word located in a standard dictionary.
B)Passwords are not case-sensitive.
C)Repeated characters signify a strong password.
D)Symbols can be included in a password.
Q5) To compare and merge presentations,start by:
A)clicking the Review tab.
B)opening both the original and the merged document.
C)opening the original presentation.
D)clicking Merge on the Review tab.
Q6) A comment or saved annotation is only visible if you have ________ active. Page 26
To view all questions and flashcards with answers, click on the resource link above.
Page 27
Chapter 18: Excel: Introduction to Excel: What Is a Spreadsheet
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39863
Sample Questions
Q1) The Print Preview feature in Excel 2013 is available:
A)on the Quick Access Toolbar.
B)on the Page Layout tab.
C)in Microsoft Office Backstage view.
D)on the View tab.
Q2) If you select cells R45:S46 and T49:V53 you have selected a(n)________ range.
Q3) Describe three features available for headers and/or footers.
Q4) Which of the following is NOT a number format available in the Number group on the Home tab?
A)Comma Style
B)Percent Style
C)Accounting Number Format
D)Date Format
Q5) Before printing a worksheet,click the File tab and select Print to preview the worksheet.
A)True
B)False
Q6) How do the Comma,Accounting,and Currency formats differ?
Q7) Use ________ to complete a sequence in a worksheet such as January,February,March,and April. Page 28
To view all questions and flashcards with answers, click on the resource link above. Page 29
Chapter 19: Excel: Formulas and Functions: Performing
Quantitative Analysis
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39864
Sample Questions
Q1) The formula =C4*D4 uses only relative cell references.
A)True
B)False
Q2) A relative cell reference:
A)indicates a cell's specific location and the reference does not change when you copy the formula to another cell or range.
B)contains both an absolute and a relative cell reference.
C)indicates a cell's relative location from the cell containing the formula;the reference changes when you copy the formula.
D)occurs when a formula directly refers to the cell containing the formula.
Q3) The nper in a PMT function is:
A)the total number of payment periods.
B)a word or a string of characters that represent one or more cells.
C)the present value of a loan.
D)a set of range names.
Q4) The TODAY function displays what is due to be done today.
A)True
B)False
Q5) The ________ function finds the midpoint value of a list.
To view all questions and flashcards with answers, click on the resource link above. Page 30
Chapter 20: Excel : Charts: Depicting Data Visually
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39865
Sample Questions
Q1) Sparklines can be created by clicking the ________ tab.
Q2) A(n)________ label is text that describes a collection of data points in a chart.
Q3) Axes,chart titles,and data tables are examples of chart elements.
A)True
B)False
Q4) A(n)________ is a grid that contains the data source values and labels.
Q5) Gridlines on a chart in Excel 2013 are:
A)numeric values that describe a single value on a chart.
B)lines used to depict trends and forecast future data.
C)horizontal or vertical lines that span across the chart.
D)a visual representation of numerical data.
Q6) A(n)________ is a key that identifies the color,gradient,picture,texture,or pattern assigned to each data series.
Q7) When you select a range of cells and hover the mouse over the selected range,what happens in Excel 2013?
Q8) ________ are small white-filled squares that display when a chart is selected.
Q9) To move a chart from one sheet to another,click the ________ tab and click Move Chart.
Q10) A(n)________ is a worksheet that contains only a chart.
To view all questions and flashcards with answers, click on the resource link above. Page 31
Chapter 21: Excel: Datasets and Tables: Managing Large
Volumes of Data
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39866
Sample Questions
Q1) Which of the following shows where automatic page breaks will occur in a worksheet?
A)By solid blue lines
B)By dotted red lines
C)By blue dashed lines
D)By solid black lines
Q2) You can sort data by one or more columns.
A)True
B)False
Q3) In Page Break Preview,the print area has a white background with a dotted blue border.
A)True
B)False
Q4) What are two built-in functionality features in tables in Excel 2013 that assist in creating formulas?
Q5) When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.
A)True
B)False
Q6) Each ________ in an Excel table represents a record. Page 32
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 22: Excel: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) Once applied,slicers cannot be removed.
A)True
B)False
Q2) A(n)________ is an interactive graphical representation of the data in a PivotTable.
Q3) PivotTables automatically refresh data.
A)True
B)False
Q4) Where are the Expand Field and Collapse Field buttons located within the PivotTable Tools tab?
A)Filter group
B)Calculations group
C)Data group
D)Active Field group
Q5) PowerPivot in an Excel add-in.
A)True
B)False
Q6) Custom slicers can be imported into other workbooks.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 34
Chapter 23: Excel : What-If Analysis
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39868
Sample Questions
Q1) A________ is a rule that Solver has to enforce to reach the objective value.
A)binding constraint
B)stop value
C)nonbinding constraint
D)step value
Q2) Solver can be set to maximize the objective cell.
A)True
B)False
Q3) What what-if analysis tool would you use to compare the impact of different interest rates on a car payment?
A)Solver
B)Goal Seek
C)One-variable data table
D)Two-variable data table
Q4) ________ has the ability to generate Answer Reports.
A)Goal Seek
B)One-variable data table
C)Solver
D)Two-variable data table
Q5) All what-if analysis tools are located in the ________ tab.
Page 35
To view all questions and flashcards with answers, click on the resource link above.
Chapter 24: Excel: Specialized Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39869
Sample Questions
Q1) Which function will return the intersection of a specific row and column?
A)VLOOKUP
B)HLOOKUP
C)INDEX
D)MATCH
Q2) Which of the following functions has the ability to copy all results to a new location?
A)DSUM
B)DMIN
C)Advanced Filter
D)IPMT
Q3) If payments are made at the beginning of the month the type argument should be set to ________ when using the IPMT function
Q4) Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?
A)PV
B)FV
C)NPV
D)IPMT
To view all questions and flashcards with answers, click on the resource link above. Page 36
Chapter 25: Excel: Statistical Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39870
Sample Questions
Q1) The SUMIF function could be used to add the total salaries of employees over the age of 25 in a dataset.
A)True
B)False
Q2) Which of the following functions will help determine the strength of a relationship between two variables?
A)VARPA
B)STDEV.P
C)CORREL
D)VAR.P
Q3) The ________ function determines how often a set of numbers appears within a dataset.
Q4) The PERCENTRANK.INC function excludes 0 and 1.
A)True
B)False
Q5) The .EXC descriptor in PERCENTRANK.EXC stands for:
A)inclusive.
B)increment.
C)expert.
D)exclusive.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 26: Excel : Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39871
Sample Questions
Q1) What happens if a user violates a validation rule and a stop style is applied?
A)The user will not be able to continue
B)The user will be able to continue
C)The user can choose to ignore the error
D)The user will be able to edit the rule
Q2) When opening a second window of the current workbook :2 will appear after the title.
A)True
B)False
Q3) Which of the following is not a formula auditing tool?
A)Trace Precedents
B)Watch Window
C)Calculation Options
D)Trace Dependents
Q4) What happens if you rename the source file of a worksheet that is used in an external reference?
A)The link will automatically update
B)A prompt to manually update the link appears
C)The linked data will appear in red text
D)The workbook will not open
To view all questions and flashcards with answers, click on the resource link above. Page 38
Chapter 27: Excel: Imports, web Queries, and Xml
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39872
Sample Questions
Q1) ________ are settings that control how imported data in cells connect to their source data.
Q2) When connections are being refreshed in a workbook the status bar displays the message running a ________ query.
Q3) Access database tables cannot be imported into Excel.
A)True
B)False
Q4) The ________ function will replace an older text string with new text.
Q5) Flash Fill can often perform the same tasks as the PROPER function.
A)True
B)False
Q6) What message is displayed in the status bar when a connection is being updated?
A)Connections updating
B)Running background query
C)Updating connections
D)Status - updated
Q7) A(n)________ is a user-defined marker that identifies the beginning or ending of a piece of data in an XML document.
Q8) What are the main components of XML?
Q9) Text can be converted into separated columns using the ________ Wizard. Page 39
To view all questions and flashcards with answers, click on the resource link above.
Page 40
Chapter 28: Excel : Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39873
Sample Questions
Q1) History worksheet
A)Not supported by change tracking
B)Location of Track Changes tools
C)When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner
D)View changes in sequence through a dialog box that enables you to accept or reject changes
E)A worksheet that lists the changes made to the workbook
Q2) What are some ways to protect a workbook?
Q3) What is the cause of the error message "File in Use"?
A)A user opens a shared workbook
B)A user opens a workbook that is not shared
C)Two users open the same unshared workbook
D)Two users open the same shared workbook
Q4) Author properties can be updated from which category in the Backstage view?
A)Account
B)Info
C)Share
D)Options
Q5) The default file format for Excel 2013 files is ________.
Page 41
To view all questions and flashcards with answers, click on the resource link above.
Chapter 29: Excel: Templates, styles, and Macros
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39874
Sample Questions
Q1) Where is the Insert Background feature located?
A)Backstage
B)Page Layout tab
C)Formulas tab
D)Insert tab
Q2) Which of the following formats is supported as a background in Excel?
A)jpeg
B)mp3
C).xls
D).mpeg4
Q3) Comments cannot be viewed in the VBA editor.
A)True
B)False
Q4) By default all cells in a workbook are ________.
Q5) The macro recorder can append a previously recorded macro.
A)True
B)False
Q6) Custom cell styles are stored in the ________ workbook.
Q7) The Themes gallery is located on the ________ tab.
Q8) Recorded macros can be viewed in the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 42
Chapter 30: Access : Introduction to Access: Finding Your Way
Through an Access Database
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39875
Sample Questions
Q1) Filter by Form uses the AND and OR logical operators.
A)True
B)False
Q2) Ryan is working in a database that organizes vendor contact information.Ryan must find vendors located in Seattle and Portland.The vendors must have offices in both cities in order to meet Ryan's requirements.He should use the Filter by Form ________ condition.
A)query
B)sort
C)OR
D)AND
Q3) Access' ________ feature creates a duplicate copy of a database.
A)Back Up Database
B)RDBMA
C)Compact and Repair
D)Relationship
Q4) The process of saving in Access is nearly the same as it is in other Microsoft Office applications.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 43
Chapter 31: Access: Tables and Queries in Relational
Databases: Designing Databases and Extracting Data
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39876
Sample Questions
Q1) If you want to modify a saved query,open the query in ________ view.
Q2) Data redundancy may result in errors.
A)True
B)False
Q3) Use the ________ tab to begin the process of importing an Excel worksheet.
Q4) Where do you change the order of query fields to change the order of query results?
A)In the design grid of a query's Datasheet view
B)In the Criteria row of the Query Design view
C)In the Show row of the Query Design view
D)In the Relationship window of the Design view
Q5) Explain the NOT logical operator and provide one example.
Q6) Referential integrity should be enforced in a database with related tables because it:
A)creates a primary key in every table of a database.
B)helps ensure invalid data is not entered into a table.
C)makes the database easier to repair.
D)helps ensure data is automatically updated.
Q7) What is one important limitation of the Simple Query Wizard?
Page 44
Q8) You use the ________ view to create queries.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 32: Access: Customize,analyze,and Summarize
Query Data: Creating and Using Queries to Make Decisions
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/39877
Sample Questions
Q1) A ________ query has an additional row displaying aggregate data.
A)digest
B)totals
C)summary
D)synopsis
Q2) When using Design view,you click Totals in the ________ group on the QUERY TOOLS DESIGN tab to display the total row.
Q3) Formats available on the Property Sheet vary based on the data type.
A)True
B)False
Q4) Which of the following is NOT a total row option?
A)Pmt
B)Avg
C)Count
D)Where
Q5) ________ is used to summarize data by values of a field.
Q6) A(n)________ is a predefined computation that performs complicated calculations.
Q8) Function arguments are separated by ________. Page 45
Q7) To create complicated expressions,you would use the ________ tool.
Q9) When creating a calculated field,field names are enclosed in ________.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 33: Access: Creating and Using Professional Forms and
Reports: Moving Beyond Tables and Queries
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/39878
Sample Questions
Q1) A(n)________ layout displays fields horizontally across a form.
Q2) ________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.
Q3) The ________ displays data horizontally across the page.
A)Stacked Layout
B)Design View
C)Tabular Layout
D)Layout
Q4) When viewing a report in Layout view,you see that the records are displayed in order based on the primary key field.You prefer print the records in alphabetical order by last names and then by first names.Explain how to sort the report to display records using the last name and first name fields.
Q5) A(n)________ is a defined set of colors,fonts,and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.
Q6) A theme can be applied to a report in either Layout or Report views.
A)True
B)False
Page 47
Q7) A(n)________ layout displays form fields in vertical columns.
Q8) You would use a(n)________ to add data into or edit data in a table.
To view all questions and flashcards with answers, click on the resource link above. Page 48
Chapter 34: Access: Data Validation and Data Analysis:
Reducing Errors and Extracting Better Information
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/39879
Sample Questions
Q1) An Access expression that calculates lapsed time is called ________.
Q2) A(n)________ accepts two or more options in a lookup field.
A)multiple-value field
B)input mask
C)lookup list
D)required
Q3) Why would you set a default value for a field?
Q4) Validation rules limit the type or range of data a user can enter into a field.
A)True
B)False
Q5) ________ functions refers to using one formula within another one.
A)Nesting
B)IIF
C)IsNull
D)Math
Q6) When using an input mask,parentheses and hyphens are automatically stored with the data.
A)True
B)False
Q7) A(n)________ property sets the property of a field to force data entry. Page 49
To view all questions and flashcards with answers, click on the resource link above. Page 50
Chapter 35: Access : Action and Specialized Queries:
Moving Beyond the Select Query
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39880
Sample Questions
Q1) To test an update query before running the query,what should you do first?
A)From Design view,click View in the Results group and click Datasheet view.
B)From Design view,click the Run button.
C)From Design view,verify that all fields are listed.
D)From Design view,click Update in the Query type group.
Q2) It is important to ensure that when you delete duplicate records,you do not delete associated records in a related table.
A)True
B)False
Q3) An append query deletes records from one or more tables and adds them to an existing table.
A)True
B)False
Q4) An append query changes the data values in one or more fields for all records that meet specific criteria.
A)True
B)False
Q5) A(n)________ query provides the easiest way to move records from one table to another.
To view all questions and flashcards with answers, click on the resource link above. Page 51
Chapter 36: Access: Advanced Forms and Reports: Moving
Beyond the Basics
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39881
Sample Questions
Q1) After inserting a line into a form or report,you can modify the color,thickness and line type.
A)True
B)False
Q2) The Tab order of a form cannot be changed.
A)True
B)False
Q3) Sum,Min,Max,and Average are examples of which kind of functions?
A)Aggregate functions
B)Constant functions
C)Control functions
D)Bound functions
Q4) A calculated control contains an expression that generates a calculated result. A)True
B)False
Q5) The three views in Access are Form or Report view,Layout view,and Design view. A)True
B)False
Q6) A(n)________ in a form or report is connected to a specific field in a table or query.
To view all questions and flashcards with answers, click on the resource link above. Page 53
Chapter 37: Access: Get Connected: Exchanging Data
Between Access and Other Applications
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39882
Sample Questions
Q1) What type of files are compressed by Access when you attach them?
A)Word and Excel files
B)Word and JPEG files
C)Excel and JPEG files
D)JPEG and other photo formats
Q2) What is the major difference between a linked file and an imported file?
Q3) What happens when you double-click an attachment field in a table?
A)A dialog box opens with options
B)The attachment opens
C)The attachment is removed
D)The attachment is saved to a file
Q4) What type of file does Access create when exporting to Word?
A)RTF
B)HTML
C)DOCX
D)JPEG
Q5) If you have data in Excel that you would like in an Access table,you can ________ the Excel worksheet into Access.
Q6) What is an imported spreadsheet?
Q7) What is the disadvantage of linking an Excel spreadsheet from Access? Page 54
To view all questions and flashcards with answers, click on the resource link above. Page 55
Chapter 38: Access: Fine-Tuning the Database: Analyzing and Improving Database Performance
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39883
Sample Questions
Q1) ________ dependency occurs when the value of one field is determined by the value of another field.
Q2) Digital certificates are electronic,encryption-based,secure stamps of authentication.
A)True
B)False
Q3) Which process guarantees that you are the only one currently using the database?
A)Open exclusive
B)Encryption
C)Password protect
D)Selfcert
Q4) ________ mode guarantees that you are the only one currently using the database.
Q5) A method to encrypt a database is to assign a password to the file.
A)True
B)False
Q6) Name two situations that violate 1NF.
Q7) A timestamp can prove that your database has or has not been modified since you applied your signature.
A)True
B)False Page 56
To view all questions and flashcards with answers, click on the resource link above. Page 57