Digital Literacy Exam Materials
Course Introduction
Digital Literacy introduces students to the essential skills and competencies needed to effectively navigate, evaluate, and create information using digital technologies. The course explores key concepts such as digital citizenship, online research strategies, information credibility assessment, ethical use of digital resources, and understanding privacy and security concerns in the digital world. Through practical activities and critical analysis, students will develop confidence in using a variety of digital tools and platforms for communication, collaboration, and problem-solving in academic, professional, and everyday contexts.
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) Which of the following is NOT part of the Windows 8 initial screen display?
A)User identification in the top-right corner
B)Tiles
C)The Start button
D)The Start screen
Answer: C
Q2) Which of the following is NOT part of the File Explorer interface?
A)Navigation Pane
B)Status bar
C)Content pane
D)Address bar
Answer: B
Q3) ________ is a Microsoft operating system released in 2012.
Answer: Windows 8
Q4) A(n)________ is a Windows 8 feature that allows you to share music,pictures,and libraries with other people within a home network.
Answer: Homegroup
Q5) The ________ toolbar provides a quick way to format text in Office 2013. Answer: Mini
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) Styles can be created and applied from the Styles group on the ________ tab.
Answer: Home
Q2) A section break divides a document into areas that can be formatted differently from one another.
A)True
B)False
Answer: True
Q3) Two letters,such as f and i,can be crafted together into a single character,called a ligature.
A)True
B)False
Answer: True
Q4) 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
Q5) Default tab stops are ________ aligned.
Answer: left
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) The intersection of a column and row in a Word table is a(n)________.
Q2) A(n)________ is a placeholder for variable data such as an address or salutation.
Q3) Which of the following CANNOT be used as a data source in a mail merge process?
A)A Word table
B)An Access table
C)An Excel worksheet
D)A Publisher table
Q4) A newly created table is automatically formatted in ________ style.
Q5) You can insert a basic formula such as SUM or AVERAGE in a cell,but you cannot create a unique formula.
A)True
B)False
Q6) A data source is a placeholder for variable data in the main document of a mail merge process.
A)True
B)False
Page 5
Q7) Having created a formula in a table,you later change the contents of a cell that is referenced by the formula.How can you make sure the formula reflects the change that you made?
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) What Word Web App view must you access in order to add comments to a document?
A)Print Layout
B)Editing view
C)Reading view
D)Draft
Q2) The ________ is a database of all sources created in Word on a particular computer.
Q3) Click the References tab and then click ________ to begin the process of adding a source.
Q4) Although you can present a document online,you cannot edit the document during the presentation.
A)True
B)False
Q5) You can reply to a comment within the original comment balloon.
A)True
B)False
B)False Page 6
Q6) A comment balloon will not identify you as the author. A)True
Q7) As you mark entries for inclusion in an index,they are coded with a(n)________.
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) A drop cap is formatted in a font size larger than the body text.
A)True
B)False
Q2) WordArt can be used to create ________ text to add interest to the text.
A)pull quote
B)decorative
C)straight
D)cursive
Q3) Word 2013 can open and edit PDF files.
A)True
B)False
Q4) Shading is especially useful in a newsletter:
A)to provide predefined styles for characters and/or paragraphs.
B)to help organize information by emphasizing important topics.
C)to represent a process or a hierarchy chart.
D)in the absence of clip art or other graphics.
Q6) ________ is the process of stacking objects on one another. Page 8
Q5) The ________ is a frame-like area that helps you keep various parts of a drawing together while you arrange them.
Q7) ________ breaks a single object into numerous individual objects.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39852
Sample Questions
Q1) If you have a report that you update on a(n)________ basis,that is contained in a very structured and detailed table,you should consider making it into a template.
A)rare
B)case-by-case
C)regular
D)infrequent
Q2) What is a building block? Does Word provides a predefined list of building blocks? If yes,where can you find this list?
Q3) Of the following choices,the ________ file extension is NOT a Word template.
A).dot
B).dotx
C).docx
D).dotm
Q4) Thumbnails are an alternative to ________ in the Navigation Pane.
A)pages
B)headings
C)subdocuments
D)AutoText
Q5) The Combine command is located on the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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 process of creating a macro is called ________ macro.
Q2) The ________ in Microsoft Office helps protect users from unsafe macros.
A)Trust Center
B)Protect Document button
C)NewMacros project
D)Check for Issues button
Q3) Which of the following statements about running a macro is TRUE?
A)A macro can be run from the Review tab.
B)A macro can be run from the NewMacros dialog box.
C)Running a macro is faster than manually choosing each command.
D)Running a macro is the same as recording a macro.
Q4) When you apply formatting restrictions,users CANNOT change the content in a document.
A)True
B)False
Q5) The macro commands are located on two tabs: the Developer tab and the View tab.
A)True
B)False
Q6) ________ form fields can be used when users will open the file in Word 2003 or earlier versions.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) Which of the following statements about inserting online videos into a Web page is FALSE?
A)You do not have to leave your open document to go to another window.
B)You will see a live preview.
C)The online video is embedded into the Web page.
D)You can view the video directly within the context of the document itself.
Q3) WWW stands for ________.
Q4) Ctrl+O
A)display the Open dialog box of the Web browser
B)move from one open Web page to another
C)temporarily display the menu
D)select all the text
E)to open a link
Page 13
Q5) Microsoft's ________ is a virtual storage location that utilizes the cloud integration technology.
To view all questions and flashcards with answers, click on the resource link above.
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 small,miniature graphic of a slide that appears in the Slides tab.
Q2) A typical storyboard includes sections for all of the following EXCEPT:
A)the title slide.
B)the introduction of the topic.
C)the development of the topics.
D)animations.
Q3) Name two ways in which adding animation can benefit your presentation?
Q4) Name three necessary steps you should take prior to planning your presentation.
Q5) PowerPoint 2013 includes a Thesaurus feature.
A)True
B)False
Q6) A(n)________ is movement that occurs between slides and how one slide replaces another.
Q7) The default PowerPoint window contains the ________ and ________ pane.
A)Thumbnails;Slides
B)Add-Ins;Outline
C)Slides;View
D)Slides;Slide Show
Q8) What is the purpose of using a table in a presentation? Page 14
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) The collapsed outline view allows an easy way to move slides.
A)True
B)False
Q2) Which of the following is FALSE about slide masters?
A)Slide masters control the layout,background design,and color combinations for handouts,notes pages,and slides.
B)Slide masters give the presentation a consistent appearance.
C)To function,slide masters must be imported to the presentation.
D)There are several types of masters.
Q3) Which of the following should primarily be avoided?
A)Bullet text of 28 pt or higher
B)Underlining text
C)Creating a focal point on slides
D)Title text 36 pt or higher
Q4) Which of the following is FALSE about PowerPoint 2013 templates?
A)All templates are pre-installed on the computer.
B)An Internet connection is not needed to search for templates.
C)Template searches can be filtered to narrow down results.
D)Widescreen templates are available.
Page 16
Q5) What are two options for printing an outline?
To view all questions and flashcards with answers, click on the resource link above.
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) When you click the Shapes button and start to drag the mouse pointer to position the shape,the mouse arrow changes to a:
A)four-headed arrow.
B)double-headed arrow.
C)cross-hair pointer.
D)plus sign.
Q2) Shadows,gradients,and 3-D effects are part of the ________ gallery.
A)WordArt Text Effects
B)SmartArt Quick Styles
C)WordArt Quick Styles
D)Shapes Quick Styles
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) A clip art image that has been broken apart into individual pieces has been
To view all questions and flashcards with answers, click on the resource link above. Page 17
Q5) ________ uses special effects applied to the text itself,not to the shape surrounding the text.
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) When you embed a video in a presentation,the file size of the presentation is smaller than if you would have linked the video.
A)True
B)False
Q2) Artistic effects for images use the Live Preview feature.
A)True
B)False
Q3) Which of the following video file formats compresses audio and video and requires minimal amount of storage?
A)Windows Media Video file
B)Windows Media file
C)Movie file
D)Adobe Flash Media file
Q4) Both bitmap and vector images are created using mathematical statements.
A)True
B)False
Q5) ________ can be used to mark a location in a video to make it easier to advance to a specific location.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Q6) ________ is spoken commentary that can accompany a PowerPoint presentation.
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) Should data in a table be as simple as possible or very complex? Explain.
Q2) Which of the following buttons is part of the Table Tools Design tab?
A)Table Row Height
B)Merge Cells
C)Distribute Columns
D)Draw Table
Q3) What does ##### represent in a cell in Excel?
A)The cell contains a formula that has not yet displayed.
B)That cell is linked to a PowerPoint slide.
C)There is an error in the cell.
D)The cell is not wide enough to display the data.
Q4) You can click the ________ tab to begin the process of inserting a new row or column.
Q5) By default,how are the measurements or increments on a chart's Y-axis determined?
A)Every other number in the worksheet is included
B)Manually by the user
C)By the data you enter in the worksheet
D)Every number in the worksheet is included
Q6) The ________ option formats the last row of a table and displays column totals. 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) An interactive presentation could enable the viewer to view slide 1,then choose from three different slides,then click a hyperlink to jump between two different slides,ending with the final slide.
A)True
B)False
Q2) Which of the following is NOT a timing option setting available for a slide object?
A)Set the animation to repeat unlimited times
B)Set the animation to rewind
C)Determine how an animation is triggered
D)Set the method for starting an animation
Q3) Click the ________ tab to begin the processing of adding a hyperlink to a slide.
Q4) If you create a picture link in a presentation,which of the following is NOT important?
A)Save the picture to the same folder as the presentation.
B)If you change the picture,save it as the same file name in the same location.
C)Use the Link to File PowerPoint option.
D)Use all lower-case letters in the file name.
Q5) The ________ animation in PowerPoint controls how an object comes onto a slide.
To view all questions and flashcards with answers, click on the resource link above. Page 21
Q6) A(n)________ tag indicates that an animation starts with the previous animation.
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) ________ control the layouts,background designs,and color combinations for handouts,notes pages,and slides of a presentation.
A)Custom shows
B)Placeholders
C)UI customization files
D)Masters
Q2) One feature of the AutoCorrect dialog box is the AutoFit title text to placeholder feature.
A)True
B)False
Q3) Changing the theme colors on the slide master affects the full presentation.
A)True
B)False
Q4) All new tabs and groups can be renamed,but the names cannot include a space.
A)True
B)False
Q5) PowerPoint's ________ feature allows you to locate and open a file that has been automatically saved if your system suddenly shuts down.
Q6) A(n)________ pages printout is typically used by the presenter.
To view all questions and flashcards with answers, click on the resource link above. Page 22
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) When merging and comparing presentations,when does the Revisions pane open?
A)As soon as you click the Review tab
B)Immediately after you open the original presentation
C)After you click Compare on the Review tab
D)After you click Merge on the Review tab
Q3) To view the metadata of a presentation,click the ________ tab.
Q4) The ________ app is used to store,share,and access files and folders.
A)SkyDrive
B)Collaboration
C)Windows Live
D)Encryption
Q5) The Document ________ can search for hidden or personal data.
Q6) To log in to SkyDrive,you need a Microsoft account and password.
A)True
B)False
Q7) ________ is the PowerPoint feature that allows you to transmit a presentation over the Internet to invited participants. Page 23
IRM stands for ________ management.
Q9) A comment or saved annotation is only visible if you have ________ active.
To view all questions and flashcards with answers, click on the resource link above.
Page 24
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 number that represents a quantity or amount is called a(n)________.
Q2) Use horizontal alignment to move data in a cell closer to the top or bottom of the cell.
A)True
B)False
Q3) A cell address:
A)identifies the active cell and worksheet.
B)identifies a cell by a column letter and a row number.
C)contains a column letter,a row number,and a worksheet tab name.
D)identifies a worksheet by its column letter and row number.
Q4) Merge & Center is not a good tool for creating titles of headings in Excel. A)True
B)False
Q5) The ________ format includes an optional dollar sign placed immediately to the left of a number.
Q6) The Page Setup dialog box contains additional options not found on the Excel Ribbon.
A)True
B)False
Q7) How would you print multiple worksheets? Page 25
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) The ________ function finds the midpoint value of a list.
Q2) For a straightforward,basic mathematical expression,it is best to use:
A)the arithmetic mean or average of values.
B)a formula like =C16*C17.
C)a function such as =SUM(B4:C4).
D)a nested formula inside of a function.
Q3) What does the TODAY function do?
A)Evaluates the day of the week,the date,and the time that the function was entered
B)Displays the current date and time
C)Displays the current date
D)Displays any day that the user enters
Q4) The logical test:
A)is the lowest value for a specific category or series in a lookup table.
B)evaluates true or false.
C)contains another function embedded inside one or more of its arguments.
D)contains data for the basis of the lookup and data to be retrieved.
Q5) What are the rules for creating range names?
To view all questions and flashcards with answers, click on the resource link above. Page 27
Q6) The PMT function uses ________ required arguments and up to two optional arguments.
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) A(n)________ is a worksheet that contains only a chart.
Q2) A pie chart:
A)shows a relationship between two variables.
B)separates one or more pie slices from the rest of the pie chart.
C)emphasizes magnitude of changes over time by filling in the space between lines with a color.
D)shows each data point in proportion to the whole data series as a slice in a circular pie.
Q3) A column chart is most effective with four to eight categories that display.
A)True
B)False
Q4) Where does a sparkline display?
A)In a single cell
B)On a separate worksheet from the data
C)In a range below the data
D)Always to the right of the data
Q5) The ________ of a chart is the region containing the graphical representation of the values in a data series.
Q6) A(n)________ column chart compares groups of columns set side by side for easy display.
Page 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) A page break:
A)indicates which worksheet is set to print.
B)is the sequence in which pages print.
C)indicates where data starts on a new printed page.
D)stops the printer from printing.
Q2) A(n)________ defines the range of data from a worksheet to print.
Q3) In addition to sorting and filtering cells by content,you can sort and/or filter by ________ formatting.
Q4) If the default conditional format options do not provide what you need,you can create your own rule for formatting.
A)True
B)False
Q5) Sorting arranges records in a table by:
A)using filter arrows.
B)the row number.
C)the value in field(s)within a table.
D)permanently removing extraneous data.
Q6) Default column headings of a table are Column1,Column2,and so on.
A)True
B)False
Page 29
To view all questions and flashcards with answers, click on the resource link above.
Page 30
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) A(n)________ is an association between two related tables where both tables contain a related field of data,such as IDs.
Q2) When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).
Q3) PowerPivot in an Excel add-in.
A)True
B)False
Q4) Filters can only be applied to PivotTables one at a time.
A)True
B)False
Q5) When setting custom calculation options in a PivotTable,what does Running Total calculate?
A)Displays each value as a percentage of the grand total
B)Displays each value as a percentage of the respective column
Total.The values in each column total 100%
C)Displays values as running totals
D)Displays values as: (value for the item)/ (value for the parent Item on rows)
Q6) PivotTables can be created from the ________ gallery.
Page 31
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) Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula?
A)Goal Seek
B)Solver
C)Scenario Manager
D)One-variable data table
Q2) ________ is an Excel add-in.
A)Goal Seek
B)Scenario Manager
C)One-variable data table
D)Solver
Q3) In order to complete a two-variable data table,which of the following must be included in the table?
A)Formula
B)Constraint
C)Absolute reference
D)Integer
Q4) ________ scenarios can be created within Scenario Manager.
Q5) All what-if analysis tools are located in the ________ tab.
Q6) The ________ replaces the original input value of a variable in a data table.
To view all questions and flashcards with answers, click on the resource link above. Page 32
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 MATCH function match_type must be set to 0 when matching words.
A)True
B)False
Q2) What is the difference between advanced filtering and database functions?
Q3) If the criteria of an advanced filter is blank no records will be returned.
A)True
B)False
Q4) Excel permits ________ IF statements in one formula.
Q5) The first argument of any database function is ________.
Q6) When using Advanced Filtering < > is the equivalent of:
A)equal to.
B)not equal to.
C)greater than.
D)less than.
Q7) If there are four possible outcomes,how many logical tests are required? A)4 B)3 C)2 D)1
33
Q8) The ________ function returns a user defined message if an error is detected.
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) Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?
A)STDEVA
B)STDEV.P
C)STDEV.S
D)STDEVPA
Q2) Which of the following tools is not included in the Analysis ToolPak?
A)Anova: Single Factor
B)Correlation
C)Rank Average
D)Covariance
Q3) When active,where does the Analysis ToolPak appear?
A)Data tab
B)Formulas tab
C)View tab
D)Insert tab
Q4) STDEV.S calculates the standard deviation of a sample.
A)True
B)False
Q5) ________ determines how two data sets from a sample vary simultaneously.
To view all questions and flashcards with answers, click on the resource link above. Page 34
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) Conditional formatting can be applied to a set of grouped worksheets.
A)True
B)False
Q2) All of the following could produce a #NAME? error with the exception of which one?
A)Misspelled word
B)Invalid range name
C)Invalid arguments in a function
D)Invalid function name
Q3) ________ is a logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error.
Q4) A hyperlink cannot be used to access an e-mail address.
A)True
B)False
Q5) To remove a hyperlink,right-click it,and then select Link Options.
A)True
B)False
Q6) ________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.
Page 35
To view all questions and flashcards with answers, click on the resource link above.
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 importing an Access database table,Excel:
A)imports the data as text.
B)formats the data in default table style.
C)imports the data in delimited format.
D)imports the data in CSV format.
Q2) You ________ data when you import data from an external source without maintaining a link to the original data.
Q3) XML stands for ________ Markup Language.
Q4) Flash Fill can often perform the same tasks as the PROPER function.
A)True
B)False
Q5) The maximum number of text strings supported by the CONCATENATE function is 255.
A)True
B)False
Q6) Which of the following are settings that control how imported data in cells connect to their source data?
A)Import settings
B)Connection properties
C)Link settings
D)Data range properties
To view all questions and flashcards with answers, click on the resource link above. Page 36
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) The Quick Access Toolbar can be customized.
A)True
B)False
Q2) Which of the following areas is not checked by the Accessibility Checker?
A)Table headers
B)Alt text
C)Merged cells
D)Print area
Q3) Hidden comments do not print.
A)True
B)False
Q4) Where is the Accessibility Checker located?
A)Data tab
B)Review tab
C)Backstage
D)Insert tab
Q5) In order to track changes,a workbook must be ________.
Q6) The Share Workbook command is located on the ________.
Q7) ________ is the maximum number of users that can access a shared file at once.
Q8) Once a workbook is ________ it is read-only.
To view all questions and flashcards with answers, click on the resource link above. Page 37
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) Macros can be edited in the ________.
Q2) Once created a custom function cannot be edited.
A)True
B)False
Q3) What is the default folder for Personal Macro Workbooks in Windows 8?
A)c : \Users\Username\documents
B)c : \Users\Username\AppData\Roaming\Microsoft\Excel\XLStart
C)c : \Users\Username\AppData\Roaming\XLStart
D)c : \Users\Username\Excel
Q4) What is the default file extension for a template?
A).xls
B).xlsx
C).xltx
D).xlm
Q5) By default,the Developer tab is ________.
Q6) Where are Trust Center options located?
A)Data tab
B)Backstage
C)Insert tab
D)Formulas tab
38
To view all questions and flashcards with answers, click on the resource link above.
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) ________ view is a grid containing fields and records.
Q2) Both Access and Excel contain tools that can be used to extract and analyze information.
A)True
B)False
Q3) Access can sort records by more than one field.
A)True
B)False
Q4) A(n)________ is the smallest data element of a table.
Q5) The ________ displays the number of the current record as well as the total number of records in a table.
Q6) ________ sorts a list of numeric data from highest to lowest.
Q7) Which of the following is an object that adds functionality to a database and is written using VBA?
A)Macro
B)Module
C)Query
D)Report
Q8) A(n)________ is a collection of fields that describe something,such as a person,place,event,or idea. Page 39
To view all questions and flashcards with answers, click on the resource link above.
Page 40
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) Why should you strive to avoid data redundancy in a database?
Q2) Storing the date of birth of clinic patients should be a ________ field.
A)constant
B)numeric
C)text
D)calculated
Q3) What are the three ways to run a query?
Q4) Which of the following is FALSE about changes in multitable queries?
A)Deleting a join line affects all relationships in all tables of the database.
B)Join lines can be deleted in a query with no impact on the relationships.
C)When you add two tables to a query,join lines appear automatically.
D)The Relationship window displays join lines.
Q5) Using a field that contains a year of birth and a field that contains the current year to determine the age of a person listed in a database is called ________.
Q6) Which of the following statements is TRUE about how Access and Excel share data?
A)Access can import data from Excel,but cannot export data to Excel.
B)Access can export data to Excel,but cannot import data from Excel.
C)Access can import data from Excel,and export data to Excel.
D)Access cannot import data from Excel and cannot export data to Excel.
To view all questions and flashcards with answers, click on the resource link above. Page 41
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 Pmt function is BEST suited to determine:
A)the rate of interest on a car loan.
B)the due date of a car loan.
C)the monthly payment on a car loan.
D)the average payment of a car loan.
Q2) Function arguments are enclosed in ________.
Q3) In terms of creating a calculated field in a query,define the term expression and give two examples of expression elements.
Q4) Which of the following is NOT a total row option?
A)Pmt
B)Avg
C)Count
D)Where
Q5) A(n)________ contains an additional row in the query design grid and displays aggregate data when the query is run.
Q6) When creating a calculated field,field names are enclosed in ________.
Q7) The MAXIMUM aggregate function can work with Short Text data.
A)True
B)False
Q8) To create complicated expressions,you would use the ________ tool. Page 42
To view all questions and flashcards with answers, click on the resource link above. Page 43
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 width of a field in a report can be changed in either Report or Design views.
A)True
B)False
Q2) When working with forms,the Remove Layout option only appears in ________ view.
A)Design
B)Layout
C)Form
D)Control
Q3) The table or query that supplies the underlying data for a form or report is called the ________ or data source.
Q4) The Arrange tab displays in both Layout and ________ views.
Q5) When creating a report,________ asks a series of questions and uses the answers to generate a customized report.
A)the Report Wizard
B)a Blank Report
C)Report Design
D)Report
Q7) A(n)________ layout displays fields horizontally across a form. Page 44
Q6) Text boxes,buttons,and boxes are examples of form ________.
To view all questions and flashcards with answers, click on the resource link above. Page 45
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) ________ enable you to execute programming tasks whenever data in a table is changed.
Q2) What data validation method is designed to restrict the data values entered into a field?
A)Validation rule
B)Validation text
C)Input mask
D)Lookup list
Q3) When a report has been created and used in Access,it can be formatted and laid out differently than the original design.
A)True
B)False
Q4) Which fields in a table are required fields by definition?
A)A field with a primary key
B)A field with a default value
C)A field with a lookup List
D)A field with an input mask
Q5) Validation rules prevent invalid data from being entered into a field.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 46
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) Which query identifies multiple instances of the same information in a table?
A)Find duplicates
B)Crosstab
C)Append
D)Make table
Q2) Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.
A)True
B)False
Q3) An action query can be used to add,edit,or delete data in a database.
A)True
B)False
Q4) What is the best way to check an update query before running it?
Q5) Duplicate values in a table can prevent you from:
A)enforcing referential integrity.
B)adding additional records.
C)having an accurate database.
D)running an append query.
Q6) What is the purpose of a crosstab query?
Q7) A ________ query makes it easy to correct errors or add values to blank fields. Page 47
To view all questions and flashcards with answers, click on the resource link above. Page 48
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 appears once at the bottom of each page in a form or report?
A)Form or Report Page Footer
B)Form or Report Footer
C)Form or Report Page Header
D)Form or Report Header
Q2) Which of the following appears once at the top of each page in a form or report?
A)Form or Report Page Header
B)Form or Report Page Footer
C)Form or Report Header
D)Form or Report Footer
Q3) Unbound controls are controls that are tied to specific fields.
A)True
B)False
Q4) The ________ appears after adding a grouping to a form or report.
A)Group Header
B)Group Footer
C)Page Header
D)Page Footer
Q5) What is a subform?
To view all questions and flashcards with answers, click on the resource link above. Page 49
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) When you export an object from Access to Word,Access creates a file in the PDF format.
A)True
B)False
Q2) What is the major difference between a linked file and an imported file?
Q3) When exporting from Access to Word,you are not able to analyze the data in Word.
A)True
B)False
Q4) What does Access do when you link a table to another Access database?
A)Creates a new table called a linked table
B)Makes a table in the new database with all the data
C)Imports the table as a text file
D)Imports the table as an Excel spreadsheet
Q5) ________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.
Q6) Once a hyperlink has been added to a table,it cannot be edited.
A)True
B)False
50
Q7) Why would you want to export an Access report to a PDF?
Q8) When there is a file in the ________ field a paperclip appears in the field.
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) The Performance Analyzer Tool creates a report that contains detailed information for each selected object.
A)True
B)False
Q2) A ________ is a combination of the date and time that is encrypted as part of the digital signature.
A)timestamp
B)certificate
C)navigation
D)password
Q3) What is the main reason to split an Access database?
A)Improve development and maintenance
B)To confirm the primary key of each table
C)Controls how the tables are linked
D)To decide which fields go to which tables
Q4) Any field that is not part of the primary key is called a(n)________.
Q5) The formal process of deciding which fields should be grouped together into which fields is called ________.
Q6) What are the three Performance Analyzer result types?
Q7) A(n)________ is a primary key that is made up of two or more fields. Page 52
To view all questions and flashcards with answers, click on the resource link above. Page 53