Information Systems Fundamentals
Exam Materials
Course Introduction
Information Systems Fundamentals introduces students to the foundational concepts and components of information systems used in businesses and organizations today. The course covers the role of information technology in supporting business operations, decision-making, and competitive advantage. Topics include hardware, software, data management, networking, system development processes, and the ethical and security considerations related to information systems. Through practical examples and case studies, students will gain an understanding of how information systems integrate with organizational objectives and how technology influences business strategies and processes.
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) A key or feature that can be turned on or off is known as a(n)________ command.
Answer: toggle
Q2) 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.
Q3) When dragging a group of tiles on the Windows 8 Start screen,a light gray vertical bar displays to indicate where the new group will be located.
A)True
B)False Answer: True
Q4) The Notification area of Windows 8 is displayed in the bottom-left corner of the Start screen.
A)True
B)False Answer: False
Q5) The Replace button is located on the ________ tab in Office 2013. Answer: Home
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) To precisely position an object,you can work within these horizontal and vertical green lines.
A)Alignment guides
B)Sizing handles
C)Live Layout
D)Layout Options
Answer: A
Q2) Use the ________ option to quickly change the capitalization of document text. Answer: Change Case
Q3) 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
Q4) ________ spacing makes it clear where one paragraph ends and another begins. Answer: Paragraph
Q5) Styles can be created and applied from the Styles group on the ________ tab. Answer: Home
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 4: Word: Document Productivity: Working With
Tables and Mail Merge
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39849
Sample Questions
Q1) By default,text within a cell is oriented from right to left.
A)True
B)False
Q2) When you insert a table,rows and columns are identically sized;however,when you ________ a table,you can create rows and columns of varying heights and widths.
Q3) After merge fields have been inserted in a main document,how are they set apart from other text?
Q4) The intersection of a column and row in a Word table is a(n)________.
Q5) After a table structure is created,you can enter all of the following in a cell EXCEPT: A)characters.
B)numbers.
C)a header. D)graphics.
Q6) By default,text is oriented horizontally in a cell.Provide an example of when you might want to change the text direction?
Q7) Arranging data alphabetically in a table is referred to as ________.
Page 5
Q8) A(n)________ is a numbered item of text,positioned above or below a table,figure,or object.
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) Word Web App includes two views--Editing view and ________ view.
Q4) How can you tell whether it is appropriate to use a footnote or an in-text citation?
A)Research papers require in-text citations,whereas all other document types require the use of footnotes.
B)Legal documents require in-text citations;all other document types require footnotes.
C)The writing style in use often gives preference to footnotes or in-text citations.
D)All academic disciplines require footnotes;businesses prefer the use of in-text citations.
Q5) How would you determine whether to use footnotes or endnotes in a paper?
Page 6
Q6) The ________ writing style originated as a subset of Chicago.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Word: Desktop Publishing and Graphic Design:
Creating a Newsletter, working With Graphics, and Linking Objects
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39851
Sample Questions
Q1) The purpose of using lists in a newsletter is to:
A)organize information by emphasizing important topics.
B)add personality to a newsletter.
C)emphasize the top portion of a newsletter.
D)stick to one font family or size.
Q2) Word 2013 can open and edit PDF files.
A)True
B)False
Q3) Of the following options,________ is NOT part of a style in Word.
A)tabs
B)indents
C)margins
D)line spacing
Q4) Use a Section Break to force paragraph text to start at the top of the next column.
A)True
B)False
Page 7
Q5) SmartArt diagrams can be used to illustrate a list,but NOT a process.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 8
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) Which of the following statements about the Create from file feature in Word is TRUE?
A)The file does not have to be open to be inserted into a document.
B)Only a portion of the file can be inserted into the open document.
C)The Create from file option is available by clicking the Review tab,then the Object arrow.
D)You do not have to place the cursor where you want the closed file to be inserted because a dialog box will pop up and ask you for the desired location.
Q2) When you save a template,it will automatically save as a Word document.
A)True
B)False
Q3) Theme colors can be accessed from both the Design and Home tabs.
A)True
B)False
Q4) Thumbnails are an alternative to ________ in the Navigation Pane.
A)pages
B)headings
C)subdocuments
D)AutoText
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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 commands to create a form are available on the ________ tab.
A)Insert
B)Review
C)Developer
D)Home
Q2) 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.
Q3) The ________ form control enables a user to select from a list of choices,but also allows the user to modify the choices in the list.
A)drop-down list
B)combo
C)combo box
D)rich text
Q4) A form ________ is a document that includes layout,structure,and formatting.
Q5) A signature ________ allows individuals and organizations to distribute and collect signatures,and then process forms or documents electronically without the need to print and fax.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) Ctrl+A
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
Q2) Click Online Videos in the ________ group to insert an online video clip onto a Web page.
A)Media
B)Insert
C)Apps for Office
D)Illustrations
Q3) WWW stands for ________.
Q4) A hyperlink to another document takes you only to the top of the new page.
A)True
B)False
Q5) Themes include a color background.
A)True
B)False
Q6) Why would you want to customize the Ribbon? Page 11
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) Both .pptx and .ppsx are PowerPoint 2013 file extensions.
A)True
B)False
Q2) Which of the following is TRUE about transitions and animations?
A)The more transitions you can include on a slide,the better the presentation.
B)Very slow transitions are calming and work well for all types of audiences.
C)When transitions are part of a slide,you cannot delete just one transition;all transitions must be deleted.
D)Too many transitions and animation styles can be distracting for audiences.
Q3) 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?
Q4) All PowerPoint views are available on the status bar.
A)True
B)False
Q5) Clicking ________,and then the Options button will allow you to set the Proofing options in PowerPoint 2013.
Q6) The ________ tab allows you to include a media object in your presentation.
Q8) Name three things you should NEVER do during a presentation. Page 13
Q7) Name three necessary steps you should take prior to planning 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) As in other Microsoft Office programs,the Cut,Copy,and Paste commands are on the ________ tab.
Q2) Which of the following is FALSE about sections in PowerPoint?
A)They help you group meaningful slides together.
B)You can change section names.
C)Slide sections can be created in Slide Show view.
D)Slide sections can be collapsed.
Q3) It is only possible to promote text to a higher level prior to entering the text.
A)True
B)False
Q4) Sections in PowerPoint 2013 cannot be named.
A)True
B)False
Q5) Files cannot be transferred from different platforms,such as Macintosh and Windows.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Q6) The Health and Fitness Sample and Wedding photo Album Sample are examples of ________ in PowerPoint 2013.
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) You can ________ or move an object around its axis.
Q2) What is a quick,easy way to flip an object?
A)Double-click a side sizing handle.
B)Right-click a side sizing handle and select Flip.
C)Triple-click the image.
D)Drag one of the side sizing handles over the opposite side.
Q3) WordArt styles cannot be changed without retyping the text.
A)True
B)False
Q4) What is a gradient fill a blend of?
A)Two or more colors
B)Two or more images
C)Only two shapes merged together
D)Two or more Quick Styles
Q5) Which of the following is TRUE about the SmartArt diagram galleries?
A)There are two: colors and special effects.
B)There are three: colors,effects,and fill.
C)There are two: colors and shapes.
D)There are two: layout and colors.
Q6) Name three text effects available in WordArt. 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) Both bitmap and vector images are created using mathematical statements. A)True
B)False
Q2) As you are removing areas of a background that you want to discard,you can press the ________ key to see what the picture currently looks like.
A)Ctrl
B)Shift
C)F3
D)Esc
Q3) 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
Q4) The intensity of the colors in an image on a PowerPoint slide is referred to as ________.
Q5) Why might file compression be important?
Q6) ________ is spoken commentary that can accompany a PowerPoint presentation.
Q7) When might it be advantageous to use narration in a presentation?
Q8) To begin to record audio for a presentation,click the ________ tab. Page 18
To view all questions and flashcards with answers, click on the resource link above.
Page 19
Chapter 14: Power: Infographics: Creating Text Charts, tables,
and Graphs
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39859
Sample Questions
Q1) The first column of a table is known as the ________.
Q2) Click the Chart Elements arrow in the Current Selection group on the ________ tab to choose individual chart elements.
Q3) A(n)________,often printed on vinyl or cloth,is different than a poster primarily in the medium upon which it is printed.
Q4) A(n)________ is a chart that displays a relationship between two sets of numbers plotted as data points with coordinates on a grid.
Q5) Simply pasting an object ________ the copied object into the application.
Q6) The ________ of a pie chart could be Rent,Food,Tuition,and Transportation.
Q7) Which of the following is NOT a button in the Shape Styles group on the Chart Tools Format tab?
A)Shape Fill
B)Shape Border
C)Shape Outline
D)Shape Effects
Q8) Column ________ are used to identify the contents of the columns of a table.
A)True B)False Page 20
Q9) Data increments on a chart's Y-axis can be manually changed.
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 15: Power: Interactivity and Advanced Animation: Engaging the Audience
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39860
Sample Questions
Q1) Describe the four types of animation that can be added to objects on slides.
Q2) A hyperlink can be activated in ________ views.
A)Reading and Normal
B)Normal and Slide Sorter
C)Slide Show and Normal
D)Slide Show and Reading
Q3) A(n)________ animation type draws attention to an object that is already located on a slide.
Q4) Text can be used as a trigger on a slide.
A)True
B)False
Q5) How does a hyperlink attached to text appear in comparison with other typed text on the slide?
A)Underlined
B)Bolded and italics
C)A different color and underlined
D)A different color and bolded
To view all questions and flashcards with answers, click on the resource link above. Page 22
Q6) Adding ________,the ability to branch nonsequentially to a different part of a presentation,helps involve the audience and capture their interest.
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) After you've selected text on a slide that you want to hyperlink to another slide,click the ________ tab to access the Hyperlink button.
A)File
B)Home
C)Insert
D)Design
Q2) While in Slide Show view,if you want to reveal a hidden slide and you are aware of the slide number:
A)press F3 and choose the title from the list.
B)type the slide number and press Enter to display it.
C)type the slide number and press H to display it.
D)press F12.
Q3) A footer is always located at the bottom of the page or a slide.
A)True
B)False
Q4) ________ fonts are scalable fonts supported by Windows.
Q5) When in Slide Sorter view,how would you know that hidden slides are included?
Page 23
Q6) Press ________ during a presentation to reveal a hidden slide.
Q7) A(n)________ pages printout is typically used by the presenter.
Q8) Click the ________ tab to create a custom slide show in a presentation.
To view all questions and flashcards with answers, click on the resource link above.
Page 24
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) What does it mean to flatten a PowerPoint file?
Q2) Which of the following PowerPoint features deactivates most PowerPoint tools and converts a presentation to read-only?
A)Compatibility Checker
B)Mark as Final
C)Accessibility Checker
D)Document Inspector
Q3) When a reviewer returns a presentation to you,determine which changes you'd like to keep and which you'd like to reject based on ________ in the presentation.
A)markups
B)accessibility
C)reviews
D)metadata
Q4) Where does the Document Properties panel appear when in Normal view?
A)Above the selected slide
B)In a separate dialog box
C)Below the selected slide
Page 25
D)In a panel to the right of the selected slide
Q5) How would you set multiple document properties in a file?
To view all questions and flashcards with answers, click on the resource link above. Page 26
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) Which of the following is NOT a number format available in the Number group on the Home tab?
A)Comma Style
B)Percent Style
C)Accounting Number Format
D)Date Format
Q2) The fill handle:
A)is a red bolded circle at the bottom-right of an active cell.
B)helps carry over the fill in an active cell to another range.
C)is the same action as pressing the Enter key.
D)is a small green square at the bottom-right corner of a cell.
Q3) Default margins on an Excel 2013 worksheet are .75" top and bottom.
A)True
B)False
Q4) When you hide a column or row,the data is not deleted,it is just hidden.
A)True
B)False
Q5) The ________ Toolbar allows a user to quickly save,undo,and redo or repeat commands in Excel 2013.
Page 27
Q6) ________ refers to how data are positioned in cells.
To view all questions and flashcards with answers, click on the resource link above. Page 28
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) To simplify entering ranges in formulas you can use:
A)range names.
B)a cell's relative location.
C)both an absolute and a relative cell reference.
D)a cell's absolute location.
Q2) Describe a circular reference.Provide an example.
Q3) The lookup value:
A)is the argument in a function that identifies which lookup table column from which to return a value.
B)looks in a horizontal table where the first row contains the values.
C)is a reference to a cell containing a value to look up.
D)is a range containing a lookup table.
Q4) The PMT function calculates the breakpoint of the lowest value for a specific category.
A)True
B)False
Q5) The ________ function totals the values in two or more cells and displays the result in the cell containing the function.
Q7) How does a nested function work? Provide an example. Page 29
Q6) How are an input area on a worksheet and absolute cell references related?
To view all questions and flashcards with answers, click on the resource link above.
Page 30
Chapter 20: Excel : Charts: Depicting Data Visually
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39865
Sample Questions
Q1) Before you create a chart,you should delete any blank rows or columns in the primary data set from which you will create a chart.
A)True
B)False
Q2) ________ are small white-filled squares that display when a chart is selected.
Q3) The purpose of a sparkline is to present a complex chart on a full chart sheet.
A)True
B)False
Q4) 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
Q5) Sizing handles display as small,black-filled circles to resize a chart.
A)True
B)False
Q6) The ________ of a chart is a key that identifies each data series of the chart.
Q7) What does a chart filter do?
Page 31
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) If the automatic page breaks occur in undesirable locations,you can adjust the page breaks.
A)True
B)False
Q2) Filtering:
A)helps to remove duplicate data in a dataset.
B)displays data in chronological order.
C)is the process of displaying only records that meet special conditions.
D)arranges dates in alphabetical order.
Q3) The calculations on a total row in a table use the ________ function.
Q4) You can only apply one filter to a large dataset in Excel 2013.
A)True
B)False
Q5) Which of the following is NOT a Table Style option?
A)Subtotal Row
B)Filter Button
C)First Column
D)Banded Rows
Page 32
Q6) How can you identify the difference between automatic page breaks on a worksheet and manual page breaks?
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 22: Excel: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) 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)
Q2) Which tool is best suited for use with PivotTables when the data is based on multiple tables?
A)PivotCharts
B)Slicers
C)Sorting
D)Filters
Q3) Which of the following options is the best tool when using a PivotTable that contains more data than you currently need?
A)Sorting
B)Removing a value field
C)Filtering
D)Refreshing the data
To view all questions and flashcards with answers, click on the resource link above. Page 34
Chapter 23: Excel : What-If Analysis
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39868
Sample Questions
Q1) Substitution values can be manually entered.
A)True
B)False
Q2) Which of the following tools is an add-in?
A)Goal Seek
B)Scenario Manager
C)Solver
D)One-variable data table
Q3) Which of the following tools is best suited for comparing the effects of two variables on a formula?
A)Solver
B)Goal Seek
C)Two-variable data table
D)One-variable data table
Q4) When creating substitution values using the Series dialog box,what is the last number used in the substitution values?
A)Stop value
B)Step value
C)Integer
D)Constraint
To view all questions and flashcards with answers, click on the resource link above. Page 35
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 database functions is best suited to add total salaries from a database that are higher than $30,000?
A)DMIN
B)DSUM
C)DMAX
D)DCOUNTA
Q2) Returns the value or the reference to a value within a range based on X and Y coordinates.
A)DSUM
B)INDEX
C)IPMT
D)PPMT
Q3) Which of the following functions will return the principal payment of a loan?
A)CUMPRINC
B)PMT
C)PPMT
D)IPMT
Q4) What is the difference between advanced filtering and database functions?
Q5) The ________ function should be used to calculate the interest paid on the first payment of a mortgage.
To view all questions and flashcards with answers, click on the resource link above. Page 36
Chapter 25: Excel: Statistical Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39870
Sample Questions
Q1) The ________ function determines how often a set of numbers appears within a dataset.
Q2) Which of the following functions will exclude quartiles 0 and 4 in its calculations?
A)QUARTILE.INC
B)QUARTILE.EXC
C)QUARTILE
D)PERCENTILE.EXC
Q3) The ________ function is best suited to determine the number of high school students under the age of 16.
Q4) The .EXC descriptor in PERCENTRANK.EXC stands for:
A)inclusive.
B)increment.
C)expert.
D)exclusive.
Q5) The ________ is an Excel add-in that offers powerful tools for statistical analysis.
Q6) A ________ is a visual display of tabulated frequencies.
Q7) The ________ of a sample is the summation of the squared deviations divided by the amount of the sample (n - 1).
To view all questions and flashcards with answers, click on the resource link above. Page 37
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) When information is chosen as the error style using data validation,the user will be able to input the incorrect data.
A)True
B)False
Q2) Which of the following is true when synchronize scrolling is enabled?
A)Side by side worksheets will scroll at the same rate
B)Side by side worksheets will scroll at a different rate
C)Side by side worksheets will not scroll
D)Side by side worksheets are locked
Q3) If defined by the user,an optional ________ appears when the mouse pointer hovers over a hyperlink.
Q4) The #DIV/0! error indicates a misspelled word in Excel.
A)True
B)False
Q5) Which of the following functions does not contain a syntax error?
A)=avg(B1:B9)
B)=AVERAG(B1:B9)
C)=AVERAGE(B1;B9)
D)=AVERAGE(B1:B9)
Q6) ________ is/are not supported when worksheets are grouped.
Page 38
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) Which of the following functions does not manipulate text?
A)CONCATENATE
B)PROPER
C)UPPER
D)INDEX
Q2) This file type uses commas to separate data into columns.
A)jpeg
B)pdf
C)csv
D)tab-delimited
Q3) XML documents can be imported into Excel.
A)True
B)False
Q4) The ________ function will convert all characters in a text string to lowercase.
Q5) Which of the following is a required element of XML?
A)Tag
B)Title
C)Link
D)Anchor
Q6) Text can be converted into separated columns using the ________ Wizard.
To view all questions and flashcards with answers, click on the resource link above. Page 39
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 default file format for Excel 2013 files is ________.
Q2) Excel customization options can be located in the ________ area.
Q3) What are the benefits of sharing a workbook?
Q4) ________ is the process by which two or more individuals work together to achieve an outcome or goal by using software technology and features in Excel.
Q5) Metadata is attached to each Excel workbook.
A)True
B)False
Q6) Which of the following scenarios would trigger the Resolve Conflicts dialog box in a shared workbook?
A)Two users attempt to change the same cell at the same time
B)Two users open the same file at the same time
C)Two users attempt to save the same file at the same time
D)Network error
Q7) A workbook marked as final cannot be password protected.
A)True
B)False
Q8) What are the benefits of customizing Excel?
Q9) The Share Workbook command is located on the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 40
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) A ________ is a collection of formats that include coordinating colors,fonts,and special effects to provide a stylish appearance.
Q2) Which of the following is the file extension for a Personal Macro Workbook?
A).xls
B).xlxs
C).xltm
D).xlsb
Q3) All templates should contain instructions.
A)True
B)False
Q4) The macro recorder can append a previously recorded macro.
A)True
B)False
Q5) Which of the following is not true about locked cells?
A)Locked cells can be edited
B)All cells are locked by default
C)A password is required to unlock the cells
D)A locked cell is indicated by a padlock icon in the Format menu
Q6) The file extension for an Excel Macro-Enabled Workbook is ________.
Q7) The VBA editor can be access using the keystroke combination ________.
To view all questions and flashcards with answers, click on the resource link above. Page 41
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) What is a foreign key? Provide an example.
Q2) What does a custom Web app enable you to do?
A)Create databases through Access' Web app.
B)Create relational tables that can be distributed through the Web.
C)Create a database and share with others through the Web.
D)Share and distribute database files without the need for Access to be installed on every computer.
Q3) When forming relationships in a relational database,the ________ from one table must be joined to the foreign key of another table.
Q4) What are the three methods for creating a new database?
Q5) Filter by Form uses the AND and OR logical operators.
A)True
B)False
Q6) When you ________,you ensure that data entered into a related table first exists in the primary table.
A)create a foreign key
B)create a primary key
C)filter by selection
D)enforce referential integrity
To view all questions and flashcards with answers, click on the resource link above. Page 42
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) Which of the following is FALSE about CamelCase notation?
A)Use uppercase letters to distinguish the first letter of each new word.
B)Field name can be up to 64 characters.
C)Field names should include spaces when the name is more than one word.
D)Field names can include letters and numbers.
Q2) You can set a(n)________ to create a label more readable than a field.
Q3) The Is Null expression is used to find blank fields.
A)True
B)False
Q4) When designing a database,an important guideline is to store data in their largest parts.
A)True
B)False
Q5) ________ is the value used to describe a blank field in an Access table.
Q6) A text field may contain numbers,text,and special characters.
A)True
B)False
Q8) The ________ Wizard guides you through the query design process in Access. Page 43
Q7) A(n)________ produces a value from an expression or function that uses one or more fields in a database.
To view all questions and flashcards with answers, click on the resource link above. Page 44
Chapter 32: Access: Customize,analyze,and Summarize
Query Data: Creating and Using Queries to Make Decisions
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/39877
Sample Questions
Q1) A(n)________ contains an additional row in the query design grid and displays aggregate data when the query is run.
Q2) According to the order of operations,multiplication and addition are evaluated before Division and subtraction.
A)True
B)False
Q3) Consider the following equation: 3 * (6 + 5)- 4 / 2.Which operation would be calculated FIRST according the order of operations?
A)3 * 6
B)4 / 2
C)6 + 5
D)5 - 4
Q4) A(n)________ is used to change settings such as formatting and captions.
A)dialog box
B)parameter list
C)property sheet
D)argument menu
Q5) * is the symbol for ________.
Q6) The ________ aggregate functions return the item with the lowest value.
To view all questions and flashcards with answers, click on the resource link above. Page 45
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 ________ source is also referred to as the data source.
Q2) Report view allows a report to be viewed onscreen in a continuous page layout.
A)True
B)False
Q3) Print Preview is used to see exactly what the report will look like when it is printed.
A)True
B)False
Q4) When the form tool is used to create a form with related tables,Access automatically adds a(n)________ to the main form
Q5) A theme can be applied to a single form or to all the forms in a database.
A)True
B)False
Q6) Which form view would be used to perform advanced layout adjustments?
A)Design
B)Layout
C)Form
D)Detail
Q7) The ________ asks a series of questions and then uses the answers to generate a customized report.
To view all questions and flashcards with answers, click on the resource link above.
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) Assuming a hire date of February 15,2017,which of the following date part functions would return the number of days since the beginning of the current year?
A)DatePart("yyyy",[HireDate])
B)DatePart("y",[HireDate])
C)DatePart ("q",{HireDate])
D)DarePart("w",[HireDate])
Q2) ________ enable you to execute programming tasks whenever data in a table is changed.
Q3) Which data validation property specifies a value that is automatically entered into a field?
A)Default value
B)Validation rule
C)Input mask
D)Required
Q4) ________ function checks to see if a field does not contain a value.
A)IsNull
B)IsNotNull
C)IIF
D)Math
To view all questions and flashcards with answers, click on the resource link above.
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) Where do the column headings display in a crosstab query?
A)Along the top of a crosstab query
B)Along the left side of a crosstab query
C)Along the right side of a crosstab query
D)Along the bottom of a crosstab query
Q2) If you would like to add data from an Excel spreadsheet to an existing Access table,you might use a(n)________ query.
Q3) What does the type of data displayed in a crosstab query depend on?
A)Which aggregate function used when the query was created
B)The intersection of columns and rows
C)What the query was based on
D)The grouping of the data
Q4) An action query can be used to add,edit,or delete data in a database.
A)True
B)False
Q5) While reviewing a table,you find that the same customer was added to the customers table twice,you decide to run a(n)________ query to determine if there are any other records added multiple times.
Q6) What are the four types of action queries?
Q7) What is the purpose of a crosstab query? Page 48
To view all questions and flashcards with answers, click on the resource link above. Page 49
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 generally refers to decorative elements such as the title of a report?
A)Unbound control
B)Bound control
C)Calculated control
D)Text box
Q2) If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.
Q3) After inserting a line into a form or report,you can modify the color,thickness and line type.
A)True
B)False
Q4) Which sections display on forms and reports by default?
A)Detail and form/report header and footer
B)Detail and form/report page header and footer
C)Form/report page header and footer
D)Form/report header and footer
Q5) Changes to a subform are easier to make in Layout view.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 50
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 adding a file to an attachment field,the file is actually copied into the database itself.
A)True
B)False
Q2) The objects you select to export from Access to Word should have which of the following types of layout?
A)Tabular
B)Stepped
C)Block
D)Outline
Q3) The ________ file format is considered an alternative to PDF.
A)XPS
B)DOCX
C)XLS
D)RTF
Q4) If you want to export specific records in a table to Excel,you can either filter the table or create a query for the needed records.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 51
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) A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.
A)transitive dependencies
B)composite keys
C)non-key fields
D)functional dependencies
Q2) What is the difference between first,second,and third normal form?
Q3) The Database Splitter is not identified by name on the Access Ribbon.
A)True
B)False
Q4) You cannot create an ACCDE file unless you have enabled the content in the database.
A)True
B)False
Q5) Name two situations that violate 1NF.
Q6) The formal process of deciding which fields should be grouped together into which fields is called ________.
Q8) A(n)________ database contains only the tables of a database. Page 52
Q7) A(n)________ is a primary key that is made up of two or more fields.
Q9) What is the main reason for splitting a database?
To view all questions and flashcards with answers, click on the resource link above.
Page 53