Computers in the Workplace Exam Bank
Course Introduction
This course explores the essential role of computers in modern workplaces, examining how digital technologies have transformed business operations, communication, data management, and organizational productivity. Students will gain an understanding of fundamental computer concepts, software applications, and digital tools commonly used across various industries. The course also addresses topics such as computer security, ethical considerations, and the impact of emerging technologies on the future of work. By the end of the course, students will be equipped with practical skills for effectively utilizing computers to enhance workplace efficiency and adapt to evolving digital environments.
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) Of the four Microsoft Office 2013 programs,the ________ Home tab is the most unique and different than the other programs.
A)Access
B)Word
C)PowerPoint
D)Excel
Answer: A
Q2) By default,after you click the SkyDrive tile on the Windows 8 Start screen,which of the following items will NOT display?
A)Documents
B)Pictures
C)Public Shared
D)Libraries
Answer: D
Q3) The Notification area of Windows 8 is displayed in the bottom-left corner of the Start screen.
A)True
B)False
Answer: False
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) Why is it never advisable to resize a picture by dragging a center handle?
A)Doing so will move the picture.
B)Doing so will skew the picture.
C)Doing so will deselect the picture.
D)Doing so will anchor the picture to the nearest paragraph.
Answer: B
Q2) Which of the following wrap options causes text to follow the shape of the object without overlapping it?
A)Tight
B)Square
C)Through
D)Top and Bottom
Answer: A
Q3) The default paragraph alignment is right.
A)True
B)False
Answer: False
Q4) ________ are side-by-side vertical blocks of text. Answer: Columns
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) A(n)________ is a built-in formula that simplifies the task of completing basic calculations.
Q2) 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.
Q3) The Word 2013 feature that displays when you point to the edge of a column or row gridline,enabling you to insert rows or columns is called the:
A)insert control.
B)Table Select indicator.
C)argument.
D)Border Painter.
Q4) A merge field displays in the main document in what manner?
A)Underlined
B)Within double angle brackets
C)Italicized
D)Colored
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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) If a writing style requires it,a(n)________ page is the first page of a report.
Q2) The default location to which Word 2013 saves documents is ________.
Q3) An index and a table of contents are terms that refer to the same thing.
A)True
B)False
Q4) Word Web App includes two views--Editing view and ________ view.
Q5) How would you determine whether to use footnotes or endnotes in a paper?
Q6) As you mark entries for inclusion in an index,they are coded with a(n)________.
Q7) To begin the process of saving a Word document as a PDF file,click the FILE tab and then click ________.
Q8) Sources saved in the Master List are only available in the current document.
A)True
B)False
Q9) The ________ writing style originated as a subset of Chicago.
Q10) As a component of Office Web Apps,________ is a limited version of Word.
Q11) The three available Markup views are No Markup,All Markup,and ________.
Q12) To give credit to a source you used in the preparation of a research paper,you Page 6
should include a parenthetical citation.
A)True
B)False
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) ________ an object into Word allows you to edit it in Word without modifying the source.
Q2) 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?
Q3) Why do you want to use features such as WordArt and SmartArt in a newsletter?
Q4) PDF files can only be read using the Adobe Reader program.
A)True
B)False
Q5) A grid can contain columns of different widths.
A)True
B)False
Q6) All of the following EXCEPT ________ are commands available from the Rotate command in the Arrange group.
A)Flip Vertical
B)Flip Horizontal
C)Rotate Right 90 degrees
D)Rotate Right 180 degrees
Page 8
Q7) The ________ of a document offers identifying information at the top of a newsletter.
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) A(n)________ theme is a coordinating set of fonts,colors,and effects.
Q2) It is NOT possible to assign your own name to an item that you add to the Quick Part Gallery,since Word assigns its own,unique name.
A)True
B)False
Q3) What is a building block? Does Word provides a predefined list of building blocks? If yes,where can you find this list?
Q4) ________ CANNOT be modified.
A)Font effects
B)Theme effects
C)Color effects
D)A master document
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
To view all questions and flashcards with answers, click on the resource link above. Page 10
Q6) When you open a new blank document in Word,you use the ________ template.
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) If you set the ________ or No changes (Read only)restrictions,you can specify user exceptions for a document.
A)Tracked Change
B)Fillin in Forms
C)Styles
D)Comments
Q2) All of the following would be recorded in a macro if the Record Macro feature is active,EXCEPT:
A)inserting a signature line.
B)pressing F4.
C)dragging the mouse to select a word.
D)pressing Ctrl+Home.
Q3) Which of the following is NOT an editing restriction that you can set in Word?
A)Preventing users from making changes to a letterhead template.
B)Preventing users from formatting the document.
C)Restricting data entry to fields.
D)Restricting data entry to unprotected areas of a form.
Q4) The default macro setting is disable all macros with ________.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Q5) A(n)________ form control allows a user to enter text or numbers,but NOT modify the format.
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 pictures are included in a blog,they are stored:
A)together with the text of the blog as one file.
B)as a separate file that is unrelated to the blog.
C)as a placeholder in the text file.
D)as a separate file with a link in to the text file.
Q2) It is NOT a good idea to substitute spaces in folder and file names with: A)underscores.
B)CamelCase notation.
C)hyphens.
D)the %20 combination.
Q3) The ________ zoom feature will enlarge the inserted online image on a Web page.
Q4) Office 365 is available to anyone who has a(n):
A)Office 2013.
B)user subscription.
C)SkyDrive.
D)cloud integration technology.
Q5) The Present Online feature is new in Word 2013.What is the purpose of this feature and how do you access it?
Page 12
Q6) Click Online Video in the ________ group to insert an online video clip into a Web page.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) A(n)________ is a variation of the theme you have chosen.
Q2) After you have created a storyboard,it is advisable to lengthen sentences and add adverbs and adjectives to your text.
A)True
B)False
Q3) Which of the following is NOT considered a step in checking spelling and incorrect word usage in a PowerPoint slide show?
A)Use the Editing feature.
B)Read the slide content after you enter it.
C)Use the Spelling feature.
D)Ask a friend or colleague to review it.
Q4) Explain why it is important to have a backup plan for your presentation in case of equipment failure.What might be two good backup plans?
Q5) Contextual mistakes in PowerPoint 2013 are noted by:
A)a red wavy underline.
B)dark red bolded text.
C)a thick green underline.
D)blue flashing text.
Q6) Name two ways in which adding animation can benefit your presentation?
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) Sections in PowerPoint 2013 cannot be named.
A)True
B)False
Q2) A(n)________ font is a font that does not have small lines at the end of letters.
Q3) In the Fonts gallery,fonts are paired for you so you do not have to choose each individual font style.
A)True
B)False
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) Name five important Slide Show design principles.
Q6) It is not possible to drag and drop text while in the Outline view.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
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 most common modification procedure of objects?
A)Resizing
B)Rotating
C)Recoloring
D)Flipping
Q2) Which of the following is FALSE about clip art images?
A)They can be recolored.
B)They can be modified by removing pieces you do not need or want.
C)They are made from a series of combined shapes.
D)Height and width must be adjusted separately.
Q3) Which of the following is FALSE about SmartArt objects?
A)Special modifications include Text Fill,Text Effects,and a Transform option.
B)A pane is provided for entering information.
C)Shapes and text are automatically resized.
D)Layouts can easily be changed.
Q4) A(n)________ is a combination of formatting options that can easily be applied to a shape or graphic.
Q5) The ________ pane contains a list of all objects on a slide.
Q6) Explain the difference between WordArt and SmartArt?
Q7) A(n)________ SmartArt diagram shows how parts relate to a whole. Page 16
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) The ________ button in the Edit Photo Album dialog box allows you to turn an image 90 degrees each time it is clicked.
Q2) Click the ________ tab to begin the process of creating a photo album presentation.
Q3) How does the Play Across Slides check box in the Audio Options group differ from the Loop Until Stopped check box?
A)Play Across Slides lets you set the number of slides during which you wish the audio to play;the Loop Until Stopped option does not.
B)Play Across Slides lets you choose up to 10 slide for the audio to play across;the Loop Until Stopped option allows an unlimited number of slides.
C)Play Across Slides allows you to choose two or more sounds to play simultaneously;the Loop Until Stopped option only allows you to play one over and over again.
D)Play Across Slides doesn't let you choose the number of slides to play the audio;the Loop Until Stopped option does.
Q4) Name four things you can do with the tools in the Photo Album feature.
Q5) Why would you want to use bookmarks in a video presentation?
Q6) In order to play audio,what is needed on your computer?
To view all questions and flashcards with answers, click on the resource link above. Page 18
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) If you link an object,the information is stored in the destination file.
A)True
B)False
Q2) Column ________ are used to identify the contents of the columns of a table.
Q3) A(n)________ is a chart that displays a relationship between two sets of numbers plotted as data points with coordinates on a grid.
Q4) The ________ tool is used to draw a table in PowerPoint.
A)Pen
B)Marker
C)Line
D)Pencil
Q5) Column widths can be adjusted by dragging the column border to widen or narrow the column.
A)True
B)False
Q6) Data increments on a chart's Y-axis can be manually changed.
A)True
B)False
Q7) A(n)________ refers to a visual display of information-posters,banners,or SmartArt diagrams. Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
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) What is required of a trigger?
A)Animation
B)A ScreenTip
C)A URL
D)An object
Q2) An action button only initiates an action when you right-click the button and click Open.
A)True
B)False
Q3) Multiple animations can be applied to objects in PowerPoint 2013.
A)True
B)False
Q4) How does a ScreenTip add to a presentation?
Q5) A(n)________ arrow on a motion path indicates the ending point of the path.
Q6) URL stands for uniform ________.
Q7) What does a 0 tag in the Animation Pane indicate?
A)There are no animations on that slide.
B)The timing between all animations on that slide is 0 seconds.
C)The animation starts with the previous animation.
D)The timing of all animations on the slide starts with 0 seconds delay. Page 21
To view all questions and flashcards with answers, click on the resource link above.
Page 22
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) One feature of the AutoCorrect dialog box is the AutoFit title text to placeholder feature.
A)True
B)False
Q2) Click the Page Layout tab to access the broad range of PowerPoint options that can be customized.
A)True
B)False
Q3) Slides can be hidden using the ________ views.
A)Slide Show and Normal
B)Reading and Slide Show
C)Slide Sorter or Normal
D)Slide Show or Slide Sorter
Q4) Which of the following is TRUE about embedding fonts in a presentation?
A)Embedding fonts increases the file size of a presentation.
B)Embedding fonts is a new feature of PowerPoint 2013.
C)Embedding fonts ensures that your entire font set on your computer will be installed on another computer.
D)Embedding fonts in a presentation compresses the file.
Page 23
Q5) Clicking the File tab displays the ________ view to the user.
To view all questions and flashcards with answers, click on the resource link above.
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) Describe when,where,and how you would use annotations in a PowerPoint file.
Q2) ________ is used to protect the privacy of a presentation by converting a password into unreadable text.
Q3) If you receive a file with a Mark as Final designation,what can or can't you do,and what does that tell you?
Q4) To log in to SkyDrive,you need a Microsoft account and password.
A)True
B)False
Q5) The ________ app is used to store,share,and access files and folders.
A)SkyDrive
B)Collaboration
C)Windows Live
D)Encryption
Q6) A(n)________ signature is an invisible,electronic stamp attached to a certificate.
Q7) 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. Page 24
To view all questions and flashcards with answers, click on the resource link above.
Page 25
Chapter 18: Excel: Introduction to Excel:
Spreadsheet
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39863
Sample Questions
Q1) A range:
A)cannot be selected with the mouse.
B)is the numbers that fall between the smallest and largest in a formula or function.
C)is another word for the active worksheet.
D)refers to a group of adjacent or contiguous cells.
Q2) The Formula Bar:
A)displays the name of a worksheet within a workbook.
B)is located at the intersection of a column and a row.
C)identifies the address of the current cell in a worksheet.
D)displays the formula or contents of an active cell.
Q3) A border:
A)is data from another cell that is only temporarily residing in an active cell.
B)is a line that surrounds a cell or a range of cells.
C)never prints.
D)is preset and weight cannot be adjusted.
Q4) If you enter data into a worksheet and decide you want the columns and rows reversed,you can click the Paste arrow,and then click ________.
Q5) The ________ of a workbook displays the file name as well as the software name.
Q6) ________ refers to how data are positioned in cells.
To view all questions and flashcards with answers, click on the resource link above. Page 26
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) Excel displays a red arrow in the top left corner of a cell if it detects a possible error.
A)True
B)False
Q2) The IF function:
A)contains data for the basis of the lookup and data to be retrieved.
B)looks up a value and returns a related result from a lookup table.
C)evaluates a condition and returns one value if the condition is true,a different if false.
D)contains another function embedded inside one or more of its arguments.
Q3) The PMT function uses ________ required arguments and up to two optional arguments.
Q4) The SUM function:
A)identifies the midpoint value in a set of values.
B)calculates the total of values contained in two or more cells.
C)calculates the arithmetic mean or average of values in a range.
D)displays the lowest value in a range.
Q5) When might you want to use an IF function in a worksheet?
Q6) A(n)________ function occurs when one function is embedded as an argument within another function.
To view all questions and flashcards with answers, click on the resource link above. Page 27
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 type of sparkline?
A)Bar
B)Line
C)Column
D)Win/loss
Q2) Sparklines can be created by clicking the ________ tab.
Q3) Axes,chart titles,and data tables are examples of chart elements.
A)True
B)False
Q4) 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
Q5) When you hover the mouse pointer over a chart,Excel 2013 display a(n)________ with the name of that chart element.
Q6) A disadvantage of a stacked column chart is that the segments within each column do not start at the same point.
A)True
B)False
28
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) Default column headings of a table are Column1,Column2,and so on.
A)True
B)False
Q2) A Table style controls:
A)check boxes to select format actions such as Total Row.
B)check boxes to select format actions such as Header Row.
C)the fill color of the header row and rows of records.
D)the background and watermarks of a worksheet.
Q3) Which of the following is TRUE about the print area feature?
A)In Page Break Preview,the area of the worksheet that won't be printed has a dark blue background.
B)In Page Break Preview,the print area has a white background and dashed red border.
C)The print area can be cleared from the Home tab.
D)The print area defines the range of data to print.
Q4) A total row appears as the last row of a table to:
A)highlight or emphasize cells that meet certain conditions.
B)format cells based upon their value in reference to the value of other cells.
C)tag a table element as a reference in a formula.
D)display summary statistics,such as a sum.
Page 29
To view all questions and flashcards with answers, click on the resource link above.
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) Which of the following is not a calculation that can be completed with the SUBTOTAL function?
A)Average
B)Count
C)Min
D)Index
Q2) Adding ________ to a preexisting data set can help you identify which disciplines and which areas contribute the highest revenue for a company and which disciplines and areas produce the lowest revenue.
Q3) ________ is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections.
Q4) Multiple subtotals can be applied to one data set.
A)True
B)False
Q5) By default,PivotTables display aggregated data for each category.
A)True
B)False
30
To view all questions and flashcards with answers, click on the resource link above.
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) Where is the check box to activate Solver located?
A)Data tab
B)View tab
C)Add-Ins tab
D)Add-Ins dialog box
Q2) Substitution values can be manually entered.
A)True
B)False
Q3) Where is Goal Seek located in Excel?
A)Formula tab
B)Backstage
C)View tab
D)Data tab
Q4) ________ has the ability to restrict variable cells to integers.
A)Goal Seek
B)Solver
C)Scenario Manager
D)Two-variable data table
Q5) User created scenarios are stored in a(n)________.
Q6) Solver summary reports appear on/in a(n)________.
To view all questions and flashcards with answers, click on the resource link above. Page 31
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) The CUMPRINC function requires both starting and ending evaluation dates.
A)True
B)False
Q2) In order for the OR function to return a true value,one or more arguments must be true.
A)True
B)False
Q3) Which of the following functions will return the interest payment of a loan?
A)CUMPRINC
B)PMT
C)PPMT
D)IPMT
Q4) 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
Q5) The ________ function returns a user defined message if an error is detected.
Page 32
Q6) The ________ function returns the position of a value in a list.
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) How many condition arguments can be defined with the SUMIF function?
A)1
B)2
C)3
D)unlimited
Q2) Which of the following functions will rank two values evenly if there is a duplicate value present?
A)RANK.EQ
B)RANK.AVG
C)RANK
D)PERCENTILE
Q3) The ________ is the range of cells that contain the values that are being evaluated for frequency of occurrence when using the FREQUENCY function.
Q4) Which function would be best used to determine the rank of each student in a graduating high school class?
A)RANK.EQ
B)RANK.AVG
C)QUARTILE.EXC
D)QUARTILE.INC
To view all questions and flashcards with answers, click on the resource link above. Page 33
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 are the benefits of using 3-D formulas?
Q2) Images can be used as hyperlinks
A)True
B)False
Q3) NovemberFile.xlsx is an example of ________.
Q4) By default automatic updates of links are disabled.
A)True
B)False
Q5) ''[South Bend.xlsx]Qtr3''!A1 is an example of a (n)________.
Q6) When worksheets are grouped which of the following actions will not occur across all worksheets?
A)Data entry
B)Structural changes
C)Formatting
D)Conditional formatting
Q7) The split bar gives the user the ability to view two different workbooks simultaneously.
A)True
B)False
Q8) By default automatic updates of links are ________.
To view all questions and flashcards with answers, click on the resource link above. Page 34
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) 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
Q2) Access database tables cannot be imported into Excel.
A)True
B)False
Q3) Flash Fill can often perform the same tasks as the PROPER function.
A)True
B)False
Q4) What governing body created XML?
A)IEEE
B)World Wide Web Consortium
C)The Computer Science Society
D)ICANN
Q5) A ________ can import data from data tables on a Web page.
Q6) The ________ function removes extra spaces from the beginning and end of a text string.
To view all questions and flashcards with answers, click on the resource link above. Page 35
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) Users will experience difficulties using shared files on a network drive if the network is
Q2) When a file is created,customizations such as the author's name are saved as
Q3) Which of the following is not a tool to check a workbook for errors?
A)File Inspector
B)Document Inspector
C)Accessibility Checker
D)Compatibility Checker
Q4) Where is the Accessibility Checker located?
A)Data tab
B)Review tab
C)Backstage
D)Insert tab
Q5) Which feature is best suited to record edits made to a document over time?
A)Compare and merge
B)Track changes
C)Comments
D)Sharing
Q6) The Share Workbook command is located on the ________.
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 not controlled with cell style formats?
A)Font attributes
B)Print settings
C)Cell-protection settings
D)Border and fill styles
Q2) Which of the following cannot be modified in a custom cell style?
A)Number
B)Alignment
C)Print area
D)Fill
Q3) By default,the macro recorder uses ________ references.
Q4) Macros are stored in ________.
Q5) What is the password character limit in Excel?
A)325
B)255
C)355
D)100
Q6) Custom backgrounds can be applied to Excel worksheets.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 37
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) Of the following,which is NOT a main object type in an Access database?
A)Report
B)Form
C)Macro
D)Record
Q2) When you make a change to the content of a record in an Access table,when are the changes saved?
A)When you click the Save or Save As button from the File tab or the button on the Quick Access Toolbar
B)When you press F11 or click the Save button on the Quick Access Toolbar
C)When you move the insertion point to a different record
D)When you move the insertion point to a different table,form,query,or report in the database
Q3) A relational database has the ability to create relationships between two: A)forms.
B)fields.
C)files. D)tables.
Q4) A(n)________ is a number,phrase,or expression used to select records from a table.
To view all questions and flashcards with answers, click on the resource link above. Page 38
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) The ________ Wizard guides you through the query design process in Access.
Q2) Which of the following is NOT a way to create a table in Access?
A)Typing a field name in a column in Datasheet view
B)Typing a field name in a row in Design view
C)Entering table data into a new row in Datasheet view
D)Importing data from another database or application
Q3) Which of the following is TRUE about the NOT operator?
A)The NOT operator returns records meeting any of the specified criteria.
B)The NOT operator returns records meeting all of the specified criteria.
C)The NOT operator does return any records.
D)The NOT operator returns all records except those that meet the specified criteria.
Q4) Why should you strive to avoid data redundancy in a database?
Q5) If a user selects the ________ Related Fields option while creating a relationship,Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.
Q6) Linking tables using common fields is a suggested guideline for successfully adding fields to a database.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 39
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) The arguments to a function are enclosed in:
A)brackets.
B)parentheses.
C)braces.
D)single-quotation marks.
Q2) Exponents are evaluated first according to the order of operations.
A)True
B)False
Q3) The sequence which operations are performed is determined by the order of operations.
A)True
B)False
Q4) A(n)________ is a variable or constant that is needed to produce output for a function in a calculated field.
A)formula
B)argument
C)expression
D)function
To view all questions and flashcards with answers, click on the resource link above. Page 40
Q5) When using a datasheet,explain what an aggregate function is and identify an aggregate function and explain what it does.
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) ________ view allows users to make changes to the layout while viewing the data on a form.
Q2) To sort fields in a report,you begin by clicking Group & Sort in the Group & Sort group on the DESIGN tab.
A)True
B)False
Q3) 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.
Q4) Text boxes,buttons,and boxes are examples of ________,which can be used to add,edit,and display data in a form or report.
A)placeholders
B)controls
C)containers
D)records
Q5) To modify a report,the Arrange tab is displayed in both the ________ views.
A)Layout and Report
B)Layout and Design
C)Format and Design
D)Report and Design
To view all questions and flashcards with answers, click on the resource link above. Page 41
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 input mask forces users to conform to a specific data-entry format for a given field.
A)True
B)False
Q2) A(n)________ performs calculations on an entire column of data and returns a single value.
A)Aggregate function
B)data macro
C)Expression Builder
D)Round function
Q3) In the criteria of a query,Access encloses date fields with & symbols.
A)True
B)False
Q4) Which data validation method forces data entry in a field?
A)Required
B)Default value
C)Data macro
D)Validation rule
42
Q5) Explain the difference between validation rule and validation text.
Q6) A(n)________ rule limits the type of data a user can enter into a field.
To view all questions and flashcards with answers, click on the resource link above. Page 43
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) There is no way to verify that the correct records will be updated when using an update query.
A)True
B)False
Q2) What is the best precaution to take prior to running an update query?
Q3) What should be the first step taken before creating an update query?
A)Back up the database
B)Switch to Datasheet view
C)Move the records to a different table
D)Run the query
Q4) What must be present for a find unmatched query to work?
A)Two tables share a common field.
B)Two tables have no relationship.
C)All fields in the tables should be the same.
D)There is nothing necessary for the query to work properly.
Q5) If you run a make table query again at a later time,what happens?
A)The table is replaced with the new up-to-date table.
B)The new table will show as it was when it was created.
C)All new information is lost.
Page 44
D)It will select the new records from the table and delete them.
To view all questions and flashcards with answers, click on the resource link above.
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) What is the difference between a form header and a page header?
Q2) What is the group footer used for?
A)Totaling the data at the end of each group
B)Totaling the data at the end of each page
C)Totaling the data at the end of each section
D)Totaling the data at the end of the form
Q3) Which of the following displays one time at the bottom of a report?
A)Report footer
B)Report header
C)Form footer
D)Form header
Q4) What is the purpose of a read-only form?
Q5) Which view do you use to modify lines or rectangles?
A)Design view
B)Layout view
C)Datasheet view
D)Form or Report view
Q6) The three views in Access are Form or Report view,Layout view,and Design view.
A)True
B)False Page 45
To view all questions and flashcards with answers, click on the resource link above. Page 46
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) A(n)________ appears next to a linked table name in the Navigation Pane.
A)arrow
B)star
C)pound sign
D)ampersand
Q2) Access creates a temporary file on your computer each time you open an attachment file.
A)True
B)False
Q3) What happens when you click a hyperlink field value while in Datasheet view?
A)Access launches the program required to display the file or Web page
B)Access adds an attachment to the table
C)Access saves the corresponding file
D)Access creates a ScreenTip that appears when you hover over the hyperlink
Q4) XPS is a file format that displays a printed page onscreen identically on any computer platform.
A)True
B)False
Page 47
Q5) ________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.
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) How does Access handle multivalued fields?
A)Creates special invisible tables in the background
B)Appear as repeating groups in the table
C)Makes the multivalue field dependent on the primary key
D)Removes dependencies on required fields
Q2) In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.
Q3) Access 2013 incorporates encryption methods to keep databases secure.
A)True
B)False
Q4) Which of the following is NOT a tool database administrators can use to improve the performance of a database?
A)Oracle tool
B)Database Documenter tool
C)Performance Analyzer tool
D)Table Analyzer tool
Q5) A(n)________ is a primary key that is made up of two or more fields.
Q6) What is the purpose of a password?
48
Q7) Any field that is not part of the primary key is called a(n)________.
Q8) What is the difference between first,second,and third normal form?
To view all questions and flashcards with answers, click on the resource link above. Page 49