Technology in the Workplace Exam Bank
Course Introduction
This course explores the transformative impact of technology on modern work environments, examining how digital tools, communication platforms, and emerging technologies such as artificial intelligence and automation are reshaping organizational structures, workflows, and employee experiences. Students will learn about the integration of technology in various industries, the benefits and challenges of digital transformation, and the ethical, social, and productivity implications for both employers and workers. The course incorporates case studies, practical applications, and discussions on future trends, equipping students with the knowledge and skills needed to adapt and thrive in technology-driven workplaces.
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) Windows 8 offers a feature to show checkboxes next to files and folder names to select in order to move,delete,or copy.
A)True
B)False
Answer: True
Q2) Describe tiles.
Answer: Tiles are colorful block images available on the Windows 8 Start screen.When you click a tile,you will be taken to a program,file,folder,or other Windows 8 app.Tiles include the name of the app or program.
Q3) Describe the function of Homegroup in Windows 8.
Answer: Homegroup is a Windows 8 feature that enables you to share resources on a home network.Music,pictures,videos,and libraries can easily be shared in a home network through a Homegroup.It is password protected.
Q4) When you use the Find and Replace feature in Office 2013 you can narrow the search to only find whole words.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 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) Explain how a linked style includes elements of both character and paragraph formatting.
Answer: A linked style can include elements of both character and paragraph formatting because the formats applied by a linked style are dependent upon the text selected.With no text selected,both paragraph and character formats are applied.However,if text is selected,only character formatting is applied.
Q2) Having selected text,you will see the ________ which is conveniently located near the selection and contains some of the most commonly used formatting options. Answer: Mini Toolbar
Q3) Which of the following is NOT considered an object?
A)Border
B)Picture
C)Screenshot
D)WordArt
Answer: A
Q4) You can modify a tab to include a(n)________,which is a set of dots or dashes that leads a reader's eye across the page.
Answer: leader
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) Which of the following is TRUE about captions?
A)When a caption is created,it is formatted in Title style.
B)If you delete a table with a caption,all remaining tables with captions are automatically renumbered.
C)As you add captions,each caption is shown in sequence.
D)All captions must begin with the word Table.
Q2) By default,text in a cell is oriented ________,so that it reads from left to right.
Q3) A formula can contain more than one mathematical ________,such as + and -.
Q4) A number in the second column of the third row of a Word table is considered to be in cell:
A)B3.
B)C2.
C)2C.
D)3B.
Q5) Use the ________ dialog box to select an option to center a table horizontally.
Q6) How would you decide whether to use a formula or a function in a Word table?
Q7) Combining cells,such as when you create a single cell to accommodate a table header,means to ________ a cell.
Q8) Press ________ at the end of a table to insert a row below the last row. Page 5
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) As the conference leader of an online presentation,you can make the document available for download.
A)True
B)False
Q2) A possible problem with sharing a document with a View and Edit link is that:
A)the link requires that the recipient has a social network account before he/she can access the document.
B)the link is typically very long and unwieldy,with no way to shorten it.
C)anyone can share the link with others,opening the document for editing by those to whom you did not intend to grant permission.
D)A recipient cannot use the link unless he/she has Microsoft Word installed on a personal computer.
Q3) A comment balloon will not identify you as the author.
A)True B)False
Q4) A table of contents created by Word is considered a field.
A)True
B)False
Q5) How would you determine whether to use footnotes or endnotes in a paper?
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) When you click the frame border of a drawing canvas and click the Delete button,the canvas and all of its contents will be removed.
A)True
B)False
Q2) It is highly recommended that you use three or more font types in a newsletter.
A)True
B)False
Q3) When you link a worksheet to a Word document,:
A)the formulas remain as formulas.
B)the formulas automatically become values.
C)the cells with formulas display as blank cells in the Word document.
D)an error message displays.
Q4) The WordArt object can be rotated in any direction.
A)True
B)False
Q5) If you embed an Excel worksheet into a Word document,you can make changes to the source file and they will be reflected in the Word document.
A)True
B)False Page 8
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Themes
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39852
Sample Questions
Q1) Word 2013 does NOT provide any predefined building blocks,so users must create their own building blocks.
A)True
B)False
Q2) Describe the three elements in a document theme.
Q3) A(n)________ is a partially completed document that contains preformatted text and/or graphics.
Q4) When you open a new blank document in Word,you use the ________ template.
Q5) A ________ displays your skills,accomplishments,job history,or other employment information.
A)curriculum vitae
B)building block
C)template
D)placeholder
Q6) Under what conditions would you view two documents side by side?
Q7) When you press Ctrl+G in Word,the ________ dialog box opens.
A)Go To Bookmark
B)Go To tab on the Ribbon
C)Go To tab of the Bookmark
D)Go To tab of the Find and Replace 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) A digital ________ is an attachment to a file that guarantees authenticity of that file.
Q2) ________ is NOT a type of editing restriction in Word.
A)Filling in Forms
B)Format
C)Track Changes
D)Comments
Q3) ________ must be installed to add users in the Add Users dialog box.
A)IRM
B)Digital certificate
C)Digital signature
D)VBA
Q4) You set ________ to prevent users from changing the content of a document.
A)IRM
B)editing restrictions
C)user exceptions
D)formatting restrictions
Q5) To disallow other users from making any changes to a document,click the File tab,and click ________.
Q6) What is the difference between the rich text control and the plain text control? Page 12
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) When you are creating bookmarks in a Web page document,it is important to always create a bookmark at the top of the page.
A)True
B)False
Q2) Click the ________ command in the Blog Post tab to upload your blog to the Internet.
Q3) A ________ can be a way for current or future journalists and authors to share their work.
A)Web server
B)background
C)Web page
D)blog
Q4) Microsoft Expression is a:
A)Word add-in for Web page design.
B)Microsoft's Web page name.
C)Web page template for Word.
D)Web page design tool.
Q5) A file that stores your blog postings includes a(n)________ to the path where pictures are stored.
Q6) The ________ zoom feature will enlarge the inserted online image on a Web page. Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
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 FALSE about the 7 × 7 guideline for presentations?
A)It suggests that you use no more than seven words per line.
B)You may occasionally be forced to exceed this guideline.
C)It suggests that you try to use no more than seven lines per slide.
D)It suggests that a maximum of seven transitions and seven animations should be used in a presentation.
Q3) Name two ways in which adding animation can benefit your presentation?
Q4) Choosing the layout for a slide is done by clicking the ________ arrow on the ________ tab.
A)New Layout;Home
B)New Slide;Home
C)New Slide;Insert
D)Slide;Design
Q5) A(n)________ is a variation of the theme you have chosen.
Q6) Name three necessary steps you should take prior to planning your presentation. Page 16
To view all questions and flashcards with answers, click on the resource link above.
Page 17
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) The Hide Background Graphics button is located in the ________ group.
Q2) It is possible to reuse slides from a different file when creating a presentation.
A)True
B)False
Q3) What is the advantage to working with a blank Office Theme template when you are working on the content of a presentation?
Q4) Which of the following is TRUE about background shapes and graphics?
A)Shapes and graphics can be hidden on all background themes.
B)Intense background styles can be changed and hidden;subtle ones cannot.
C)Backgrounds cannot be changed by the user.
D)Background shapes and graphics can be hidden on ALL slides but not on one individual slide.
Q5) A(n)________ view displays the slide icon,the title,and the slide content.
Q6) To search for templates,your computer must be connected to the Internet.
A)True
B)False
Q7) What are two advantages to working in Outline view for a presentation?
Page 18
Q8) What happens to the formatting when you insert a slide from one presentation into another?
To view all questions and flashcards with answers, click on the resource link above.
Page 19
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) Name three text effects available in WordArt.
Q2) With some objects,it is necessary to ungroup them multiple times.
A)True
B)False
Q3) 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
Q4) The WordArt Quick Style feature is located on the ________ tab.
Q5) Define ungrouping and explain why it might be used.
Q6) Which of the following is FALSE about line shapes in PowerPoint 2013?
A)Width of a line is measured in points.
B)A vertical inch contains 100 centimeters.
C)A shape can have an outline entirely removed.
D)Weight line choices range from 1/4 pt to 6 pt.
Page 20
Q7) If you apply a shape effect to a shape,it can later be immediately changed to a different shape effect.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 21
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) Why would you want to use bookmarks in a video presentation?
Q2) Which of the following is NOT part of the Media Controls bar?
A)Edit Video
B)Play/Pause
C)Mute/Unmute
D)Move Back 0.25 Seconds
Q3) Artistic effects for images use the Live Preview feature.
A)True
B)False
Q4) Which of the following is NOT available as part of the Album Layout section of the Photo Album dialog box?
A)Rotate photos
B)Layout for the album pages
C)Frame shapes
D)Apply a theme
Q5) The ________ of a photo refers to the difference between the darkest and the lightest areas of the image.
Q7) What happens to previously applied artistic effects when you apply a new artistic effect? Page 22
Q6) ________ is spoken commentary that can accompany a PowerPoint presentation.
To view all questions and flashcards with answers, click on the resource link above.
Page 23
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) A(n)________ refers to a visual display of information-posters,banners,or SmartArt diagrams.
Q2) When you copy and paste an object into PowerPoint,it is ________.
A)linked
B)embedded
C)removed from the original location and pasted into the new location
D)cut from the original application and pasted to the clipboard
Q3) A(n)________ object is a representation of data stored in a source file and can be changed in the original source application.
Q4) Column widths can be adjusted by dragging the column border to widen or narrow the column.
A)True
B)False
Q5) Changing measurements to larger increments in a chart can exaggerate the data peaks and valleys displayed in the chart.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 24
Q6) Click the Chart Elements arrow in the Current Selection group on the ________ tab to choose individual chart elements.
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) Click the ________ tab to begin the processing of adding a hyperlink to a slide.
Q2) How do you reshape a motion path?
Q3) What is the first step in setting up a trigger on a slide?
A)Click Trigger on the Animations tab.
B)Select the object that will serve as the trigger.
C)Choose the animation for the trigger.
D)Create a motion path for the trigger.
Q4) All EXCEPT ________ can turn a linear presentation into a non-linear presentation.
A)interactivity
B)action buttons
C)animation
D)hyperlinks
Q5) A linear presentation progresses sequentially through slides,starting with the first slide and ending with the last slide.
A)True
B)False
Q6) The 7× ________ guideline is a general PowerPoint rule.
Q8) How does a ScreenTip add to a presentation? Page 25
Q7) A(n)________ path like a circle only has one starting point and no ending point.
To view all questions and flashcards with answers, click on the resource link above. Page 26
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) Describe what a handout master would be used for and what the handout master controls.
Q2) If you make changes to the PowerPoint Ribbon,you can use the Reset button to restore it to the original settings.
A)True
B)False
Q3) Click the Page Layout tab to access the broad range of PowerPoint options that can be customized.
A)True
B)False
Q4) What is a notes master used for and what can be specified on it?
Q5) The ________ Ribbon feature in the PowerPoint Options dialog box allows you to personalize a tab on the Ribbon.
Q6) What do the language options allow you to change?
Q7) Red used in a presentation tends to gain attention and stimulate people into making decisions.
A)True
B)False
Q8) ________ fonts are scalable fonts supported by Windows. Page 27
To view all questions and flashcards with answers, click on the resource link above. Page 28
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) When you access the Restrict Permission feature,point to Restrict Access,and click
Connect Digital Rights Management Servers and get templates,what is the default?
A)Unrestricted Access
B)Restricted Access
C)Manage Credentials
D)Service Sign-Up
Q2) A text-based description for an image is:
A)alternative text.
B)encrypted text.
C)metadata.
D)XML.
Q3) A Mark as Final designation for a file is permanent.
A)True
B)False
Q4) To view the metadata of a presentation,click the ________ tab.
Q5) How would you set multiple document properties in a file?
Q6) What does it mean to flatten a PowerPoint file?
Q7) The Microsoft SharePoint ________ is a SharePoint site where you can store and Page 29
manage files that are added to the space.
To view all questions and flashcards with answers, click on the resource link above. Page 30
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) An output area is defined as:
A)a region of a worksheet with formulas dependent on values from an input area.
B)a display of the range name and tab name within a workbook.
C)a range of cells containing values for variables used in formulas and functions within a worksheet.
D)the active cell on an active worksheet.
Q2) The ________ feature on in Page Setup displays a list to set or clear a print area on a worksheet.
Q3) Use the ________ to select a range by clicking in it and typing a range address,and then pressing Enter.
Q4) AutoComplete:
A)adds all numbers in the row automatically.
B)searches for and displays any other similar label in the current column when you begin typing.
C)adds numbers within a column automatically.
D)searches for and displays any other similar label in the current row when you begin typing.
Q5) The ________ of a workbook displays the file name as well as the software name.
Q6) A(n)________ is a single spreadsheet.
To view all questions and flashcards with answers, click on the resource link above. Page 31
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) One benefit of using range names is that if you copy the formula,you do not have to make the cell reference absolute in the formula.
A)True
B)False
Q2) What is Quick Analysis in Excel 2013?
Q3) The =DATE(year,month,day)function returns a serial number for a date.
A)True
B)False
Q4) Argument names that display in ________ are required;others are optional.
A)italic
B)all caps
C)red
D)bold
Q5) A(n)________ cell reference provides a permanent reference to a specific cell.
Q6) The IF function only evaluates a condition if the condition is true.
A)True
B)False
Q7) What is the F4 key used for in Excel 2013?
Q8) The ________ function category performs calculations such as averages and standard deviations. Page 32
To view all questions and flashcards with answers, click on the resource link above. Page 33
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) Which of the following is NOT a style that affects the look of a data series?
A)Flat
B)Stacked
C)3-D
D)Beveled
Q2) A(n)________ is a key that identifies the color,gradient,picture,texture,or pattern of each data series in a chart.
A)label
B)trendline
C)legend
D)axis
Q3) Which of the following is NOT controlled by choosing a chart style?
A)Color of the chart area
B)Sparklines
C)Plot area
D)Data series
Q4) A column chart is most effective with four to eight categories that display.
A)True
B)False
Q5) ________ are small white-filled squares that display when a chart is selected.
Page 34
To view all questions and flashcards with answers, click on the resource link above.
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) A(n)________ is a space for an individual piece of data within a record,such as a street name.
Q2) What do banded rows and banded columns do in an Excel table?
Q3) ________ displays alternate fill colors for even and odd rows to help distinguish fields.
A)Filtered rows
B)Banded columns
C)First/Last columns
D)Banded rows
Q4) The ________ Table Style option applies a different format to the first column of a table so that the row headings stand out.
Q5) Top/Bottom Rules:
A)is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
B)moves data from the top of the workbook to the bottom for analysis.
C)highlight cells meeting specified criteria with a specified color,font,or border.
D)format cells based upon their value in relation to the value of other cells.
Page 35
Q6) The calculations on a total row in a table use the ________ function.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 22: Excel: Subtotals, Pivot-tables, and
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) Which of the following tools is best suited for data mining and summarizing data?
A)Subtotal
B)PivotTable
C)Column chart
D)Data table
Q2) Once a slicer is inserted into a worksheet which of the following actions cannot be performed?
A)Move the slicer
B)Append the slicer
C)Filter data
D)Remove a filter
Q3) When editing a PivotTable where are values field settings edited?
A)PivotTable Design tab
B)Data tab
C)PivotTable Fields task pane
D)Formulas tab
Q4) A(n)________ is a powerful,interactive data-mining feature that enables you to summarize and analyze data,especially helpful when working with large datasets.
To view all questions and flashcards with answers, click on the resource link above. Page 36
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) Goal Seek is an Excel add-in.
A)True
B)False
Q2) Where is the check box to activate Solver located?
A)Data tab
B)View tab
C)Add-Ins tab
D)Add-Ins dialog box
Q3) What is the difference between a one-variable and two-variable data table?
Q4) Solver can solve linear and nonlinear problems.
A)True
B)False
Q5) ________ has the ability to generate Answer Reports.
A)Goal Seek
B)One-variable data table
C)Solver
D)Two-variable data table
Q6) ________ will vary one input value to reach one optimized result.
Q7) ________ specify the restrictions or limitations imposed on a spreadsheet model as Solver determines the optimum value of the objective cell.
To view all questions and flashcards with answers, click on the resource link above. Page 37
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 of the following functions will return the principal payment of a loan?
A)CUMPRINC
B)PMT
C)PPMT
D)IPMT
Q2) Which of the following is the best choice to lookup values when VLOOKUP and HLOOKUP are not possible?
A)LOOKUP
B)DGET
C)MATCH and INDEX
D)SUM
Q3) Which of the following functions requires all arguments to be true in order to return the value if true?
A)AND
B)OR
C)NOT
D)IT
Q4) What is the benefit of using MATCH nested with INDEX over lookup functions such as VLOOKUP?
Q5) ________ will return the total interest paid within a time range on a loan.
Page 38
To view all questions and flashcards with answers, click on the resource link above.
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) When created using the Analysis ToolPak,histograms cannot be deleted.
A)True
B)False
Q2) Two or more conditions can be used with the SUMIFS function.
A)True
B)False
Q3) What is the difference between COVARIANCE and ANOVA?
Q4) This function is best suited to determine ranks within a data set based on percentile.
A)RANK.EQ
B)PERCENTRANK.INC
C)RANK.AVG
D)PERCENTILE
Q5) Which function is best suited to determine how the data set is spread around the mean?
A)COVARIANCE
B)CORREL
C)STDEV.P
D)VARA
Q6) ________ determines how two data sets from a sample vary simultaneously.
Page 39
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 is the proper format of an external reference to a workbook or worksheet thats name does not contains spaces;source and destination files are in the same folder.
A)''[WorkbookName]Worksheet''!Cell
B)[WorkbookName]Worksheet!Cell
C)'[WorkbookName]Worksheet'!Cell
D)Worksheet'!Cell
Q2) 3-D formulas automatically update when data is added.
A)True
B)False
Q3) What is indicated by red arrows when tracing precedents?
A)Cells that cause errors
B)Cells with validation rules
C)Cells with no errors
D)Cells with comments
Q4) A hyperlink cannot be used to access an e-mail address.
A)True
B)False
Q5) In the formula =C3*C5 in which the results are displayed in cell C6,________ is the dependent cell.
To view all questions and flashcards with answers, click on the resource link above. Page 40
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) When using XML,the ________ contains the name of an element preceded by a slash.
Q2) Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?
A)UPPER
B)CONCATENATE
C)LOWER
D)SUBSTITUTE
Q3) ________ is the process of inserting external data created or stored in another format into the current application.
Q4) A(n)________ is a special character that designates the end of a line and separates data for the next line or row.
Q5) The UPPER function will capitalize every character of a text string. A)True B)False
Q6) Tab-delimited files use tabs to separate data into columns. A)True
B)False
Q7) The ________ function will capitalize all characters in a text string.
Q8) The ________ function will replace an older text string with new text.
To view all questions and flashcards with answers, click on the resource link above. Page 41
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) Which dialog box allows the user to print all comments?
A)Page Setup
B)Print
C)Page Layout
D)Backstage
Q2) Where is the Accessibility Checker located?
A)Data tab
B)Review tab
C)Backstage
D)Insert tab
Q3) When workbooks are shared users can see changes made by others.
A)True
B)False
Q4) Excel cannot export .CSV files.
A)True
B)False
Q5) ________ is the maximum number of users that can access a shared file at once.
Q6) An Internet connection is not required to send an Excel workbook via e-mail.
A)True
B)False
Page 42
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) Which of the following is the proper beginning for a sub procedure named "Test"?
A)Sub ()
B)Sub (Test)
C)(Test)
D)Sub Test()
Q2) The Themes gallery is located on the ________ tab.
Q3) By default all cells are locked.
A)True
B)False
Q4) Where are Trust Center options located?
A)Data tab
B)Backstage
C)Insert tab
D)Formulas tab
Q5) What is the default reference type when recording a macro?
A)Absolute
B)Relative
C)Mixed
D)Normalitive
Q6) Macro security can be edited in the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 43
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) Describe how Access sorts multiple criteria in a database.
Q2) Objects that are part of an Access database are available from the ________ within Access.
Q3) Of the following,which is NOT a main object type in an Access database?
A)Report
B)Form
C)Macro
D)Record
Q4) A template is a predefined database that can be used to jumpstart the creation of a database.
A)True
B)False
Q5) Backing up a database rearranges the data and objects in a database to decrease its file size,thereby making more space available on your disk and letting you open and close the database more quickly.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 44
Q6) A primary key may use a(n)________ data type--a generated primary key that is automatically incremented each time a record is added.
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) In a query,which of the following statements is TRUE regarding delimiters in the criterion of a field?
A)Text data types must be enclosed in pound signs.
B)Number data types that use plain digits require no delimiter.
C)Date/Time data types must be enclosed in quotations.
D)Number data types must be enclosed in single quotes.
Q2) Would you want to save every query that you create? Why or why not?
Q3) Which of the following is NOT a guideline for adding fields to a database table?
A)Consider the future use of the database.
B)Store data in their smallest parts.
C)Design to accommodate date arithmetic.
D)Link tables using foreign keys
Q4) A relationship cannot be established between two tables unless a primary key has been set in the first table.
A)True
B)False
Q5) The data type of a field determines the type of operations that can be performed on that field.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 45
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) When using the Pmt function,principal is another term for the ________ of a loan.
A)rate
B)duration
C)future value
D)present value
Q2) A(n)________ is the data used by a function to produce a result.
A)control
B)parameter
C)constraint
D)argument
Q3) A constant is a value that remains the same in an expression.
A)True
B)False
Q4) The SUM aggregate function can work with Date/Time data.
A)True
B)False
Q5) Explain what the order of operations is and why parentheses might be needed when evaluating an expression.Give a specific example of where parentheses would be need.
To view all questions and flashcards with answers, click on the resource link above. Page 46
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) The form Layout view can be used for all of the following EXCEPT:
A)adding or removing a field.
B)changing the order of fields.
C)adding a calculated field.
D)changing the width of a field.
Q2) A subform combines two views of the same record source
A)True
B)False
Q3) ________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.
Q4) ________ view allows alteration of the report design while viewing the data.
A)Report
B)Output
C)Layout
D)Design
Q5) Referencing the image above,this form contains a: A)miniform.
B)subform.
C)macroform.
D)split form.
To view all questions and flashcards with answers, click on the resource link above. Page 47
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) A(n)________ sets the property of a field to force data entry.
A)required
B)input mask
C)default value
D)data macro
Q2) A field with a number of repeated values may be better suited as what kind of field?
A)Lookup field
B)Validation text field
C)Input mask
D)Data macro
Q3) A(n)________ property sets the property of a field to force data entry.
Q4) If you want to see records with a field within a certain date range,you could use the Between operator.
A)True
B)False
Q5) What is the purpose of adding an input mask to a field?
Q6) Reports can be created based on the results of a parameter query.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 48
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 remove the duplicate records found in a table,you would run a(n)________ query.
Q2) A find duplicates query compares records in two related tables and displays the values found in one table but not the other.
A)True
B)False
Q3) Why should you backup your database before testing an action query?
A)Action queries change data in your database that cannot be reversed.
B)Action queries change data in your database but the changes are temporary.
C)Action queries do not make any changes to your database.
D)Action queries duplicate data in your database.
Q4) You can use Undo when running an update or delete query.
A)True
B)False
Q5) A(n)________ query provides the easiest way to move records from one table to another.
Q6) Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.
A)True
B)False Page 49
To view all questions and flashcards with answers, click on the resource link above. Page 50
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) Which of the following is NOT a correct way to Add a calculated control to a form or report?
A)Use the Expression Builder
B)Create a formula in an unbound control
C)Create a formula beginning with the equal sign (=)in a text box
D)Create a formula in a bound control
Q2) In a form or report,a(n)________ is a control that is not tied to a specific field.
Q3) After inserting a line into a form or report,you can modify the color,thickness and line type.
A)True
B)False
Q4) How do you switch on or off sections of a report or form?
A)Right-click a blank area
B)Go to the property sheet
C)Hide the detail section
D)Grey out a section
Q5) A(n)________ is a control in a form or report is not attached to any specific field in a table or query.
Q6) List the five default sections of a report.
To view all questions and flashcards with answers, click on the resource link above. Page 51
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) How do you insert blank lines above a table after exporting it from Access into Word?
A)Click immediately before the first value in the first cell of the table and press Enter to add an additional line.
B)You will have to cut the table and add a blank line,then paste the table back at the new cursor position.
C)You cannot add additional lines above the table.
D)Additional lines will appear below the table by default.
Q2) In Access,what is a reference to an external file called?
A)Attachment
B)Paperclip
C)Field
D)OLE object
Q3) Linking and importing produce the same result in Access.
A)True
B)False
Q4) When you export a table from Access,the table must be closed for the export to complete.
A)True
B)False
52
To view all questions and flashcards with answers, click on the resource link above.
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) In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.
Q2) A(n)________ occurs when the value of one field is determined by the value of another.
A)functional dependency
B)non-key field
C)composite key
D)primary key
Q3) ________ provides a brief description of a potential problem and its possible solution.
A)Analysis Notes
B)Analyzer report
C)Documenter report
D)Preview report
Q4) The ________ evaluates a database and makes recommendations for optimizing the database.
A)Performance Analyzer
B)Database Documenter
C)Table Analyzer
D)Database Splitter
To view all questions and flashcards with answers, click on the resource link above. Page 53