Business Technology
Exam Questions
Course Introduction
Business Technology explores the intersection of information technology and business practices, equipping students with the foundational knowledge to leverage digital tools in achieving organizational goals. The course covers key topics such as information systems, digital transformation, data analytics, cybersecurity, and emerging technologies, emphasizing their roles in enhancing productivity, decision-making, and competitiveness. Through case studies and practical applications, students gain insights into how technology drives innovation and efficiency in various business environments.
Recommended Textbook
Exploring Microsoft Office 2013 Volume 1 1st Edition by Mary
Available Study Resources on Quizplus
37 Chapters
3754 Verified Questions
3754 Flashcards
Source URL: https://quizplus.com/study-set/2006
2
Anne Poatsy
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 professionally-created file such as a budget offered by Microsoft Office and often downloaded from the Microsoft Web site is known as a template.
A)True
B)False
Answer: True
Q2) Printing a document is available from the ________ tab.
A)File
B)Home
C)View
D)Page Layout
Answer: A
Q3) When you move all files from a folder in one location to a folder in another location,the files are duplicated so that they are located in both the original folder location as well as the folder to which they were moved.
A)True
B)False
Answer: False
Q4) The ________ is a Windows 8 program that allows you to capture a screen display.
Answer: Snipping Tool
Page 3
To view all questions and flashcards with answers, click on the resource link above.
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 delete a tab from the ruler,right-click the tab and select Delete.
A)True
B)False
Answer: False
Q2) Which of the following is NOT a reason to display a document in Outline view?
A)To make sure headings are developed at the correct level of detail
B)To develop a summary that can be included in a PowerPoint presentation
C)To make it easier to generate a table of contents
D)To provide the most typing space possible
Answer: D
Q3) One way to resize a text box is to drag a sizing handle;another way is to select options in the:
A)Size group on the Layout tab.
B)Format group on the Layout tab.
C)Size group on the Format tab.
D)Text group on the Format tab.
Answer: C
Q4) ________ appear as you move an object,assisting with aligning it with existing text.
Answer: Alignment guides
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) Each item of information in a data source,such as title or last name,is referred to as a(n)________.
Q2) Differentiate between table alignment and alignment of text within cells.
Q3) Having selected a table style,you cannot modify it.
A)True
B)False
Q4) Text that is separated by tabs can be converted into a table.
A)True
B)False
Q5) Use AutoFit Contents to automatically adjust rows and columns to accommodate all contents.
A)True B)False
Q6) A(n)________ is a grid of rows and columns that organizes data.
Q7) This Word 2013 feature enables you to apply a group of border settings that you have identified to one or more table borders.
A)Table Styles
B)Borders Gallery
C)Border Painter
D)Border Styles
Page 5
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Word: Collaboration and Research:
Communicating and Producing Professional Papers
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39850
Sample Questions
Q1) 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) 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.
Q3) The ________ writing style originated as a subset of Chicago.
Q4) Source information in a document that is noted in a footnote is identified by a number or ________ in superscript beside the text in the document.
Q5) The default location to which Word 2013 saves documents is ________.
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) You can save disk space by inserting the link as a(n)________ instead of displaying the actual linked data,since the data are not repeated or duplicated in the destination file.
A)file
B)icon
C)object
D)image
Q2) A(n)________ is a geometric or nongeometric object such as a rectangle,star,or arrow.
Q3) A grid is distinguished by the number of ________ it contains.
A)rows
B)columns
C)horizontal lines
D)cells
Q4) A good rule of thumb is to limit a document to ________ font type(s).
A)four
B)three
C)just one
D)two
8
Q5) A(n)________ graphic can be used to represent a process or a hierarchy chart.
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) Building Blocks can be accessed from all the following tabs,EXCEPT: A)Insert.
B)Home.
C)References.
D)Design.
Q2) Under what conditions would you view two documents side by side?
Q3) All entries that you make to the Quick Parts gallery are stored in the Building Blocks ________.
Q4) When viewing a thumbnail of a page,revision marks and comments also show.
A)True
B)False
Q5) You should never delete placeholders in a template;it is only advisable to enter information in the placeholder or leave it blank.
A)True
B)False
Q6) To save an item that you have created as AutoText,click the ________ tab.
Q7) There are Word templates available to help you create a resume.
A)True
B)False
10
Q8) The Navigation Pane button is a(n)________ which will only turn on or off.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Word: Document Automation:
Forms,macros,and Security
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39853
Sample Questions
Q1) All of the following are information fields about the signer that can be added to the Signature Setup dialog box,EXCEPT the:
A)signer's address.
B)signer's name.
C)signer's title.
D)signer's e-mail address.
Q2) A ________ form control enables a user to select from a list of the 50 states.
A)check box
B)combo box
C)text
D)drop-down list
Q3) Users must add the Developer tab to the Ribbon by clicking the Insert tab.
A)True
B)False
Q4) All of the following statements about adding a digital signature to a file are true EXCEPT:
A)it remains signed until it is modified.
B)a password is automatically added.
C)the file becomes read-only.
D)it is marked as final.
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) You may replace the space in a Web folder or file name with CamelCase,hyphen,or
Q2) Are you allowed to use any pictures and videos that you downloaded from the Internet freely?
Q3) ________ and special characters are NOT allowed in bookmark names.
Q4) When you enter the Word Options dialog box and add a new tab,the new tab is automatically added:
A)below the tab that is active in the document.
B)as the last tab on the Ribbon.
C)at whatever location the user chooses.
D)as the first tab on the Ribbon.
Q5) A bookmark for the ________ of the Web page is created automatically. A)top B)center
C)bottom D)end
Q6) A hyperlink to another document takes you only to the top of the new page.
A)True
B)False
Q7) HTML stands for ________ Markup Language. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 10: Power: Introduction to Powerpoint: Creating a Basic Presentation
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39855
Sample Questions
Q1) You must create all of your own layouts within PowerPoint 2013.
A)True
B)False
Q2) When creating slides,you would normally first add content to a placeholder,and then select a layout.
A)True
B)False
Q3) Which of the following is FALSE about the Slide Show view?
A)A presentation running in Slide Show view can contain both manual and automatic slide transitions.
B)To end a slide show,press Esc.
C)The Slide Show view is used to deliver a completed presentation to an audience.
D)The Slide Show view is new to PowerPoint 2013.
Q4) Which of the following is NOT an option when clicking the Full Page Slides button?
A)Scale to Fit
B)High Quality
C)Grayscale
D)Frame
Page 15
To view all questions and flashcards with answers, click on the resource link above.
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) You can see a template prior to downloading or creating the file by viewing it in the ________ window.
Q2) The main points of a slide appear as Level 1 on the slide.
A)True
B)False
Q3) Why is it helpful to collapse the view of an outline in an Outline View presentation?
Q4) The Hide Background Graphics button is located in the ________ group.
Q5) What are two options for printing an outline?
Q6) Templates can be found in all of the following dimensions EXCEPT:
A)20:15.
B)4:3.
C)16:9.
D)widescreen.
Q7) A(n)________ controls the layouts,background designs,and color combinations for handouts,notes pages,and slides,giving the presentation a consistent appearance.
Q8) The Increase List Level and Decrease List Level is located on the ________ tab.
Q9) What sort of effects can be found in the Effects Gallery?
Q10) What are two advantages to working in Outline view for a presentation? Page 16
To view all questions and flashcards with answers, click on the resource link above.
Page 17
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) The ________ ratio is the ratio of an object's width in regard to its height.
Q3) How do you constrain the rotation of a selected object to 15° angles?
A)Hold the Ctrl key.
B)Click on the Constrain Angle button.
C)Hold the Shift key.
D)Click the object border one time for each 15° change.
Q4) What is the definition of guides,and how can they help when creating a presentation?
Q5) ________ graphics are created using geometrical formulas and can be easily edited and layered.
Q6) List,Process,and Cycle are categories of ________.
Q7) Explain how PowerPoint's SmartArt feature can help in creating a presentation.
Q8) Text that you enter into a SmartArt diagram can be entered in a(n)________ pane. Page 18
Q9) The ________ pane contains a list of all objects on a slide.
To view all questions and flashcards with answers, click on the resource link above. Page 19
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) A(n)________ is digital video compression used to compress movies and then decompress for playback.
Q2) When you choose the Captions below ALL pictures option in the Edit Photo Album dialog box,the file type appears as a caption below the picture.
A)True
B)False
Q3) The ________ tool enables you to remove portions of a picture you do not want to keep.
A)Remove Background
B)Colors
C)Crop
D)Picture
Q4) A Media Controls bar is automatically included in your presentation when you insert your own video but is not inserted when you use videos from a Web site.
A)True
B)False
Q5) When might it be advantageous to use narration in a presentation?
Page 20
Q6) Is it permissible to use anything you find on the Internet in your presentation?
To view all questions and flashcards with answers, click on the resource link above.
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) Changing a chart layout can be done manually with individual elements or with a predefined layout.
A)True
B)False
Q2) Tables can be created in Word and PowerPoint but not in Excel or Access.
A)True
B)False
Q3) Which of the following is NOT a method to eliminate a border when combining cells in a table?
A)Select cells,right-click,and select Merge Cells.
B)Select the cells and click Merge Cells.
C)Erase the border.
D)Highlight the border and press Delete.
Q4) An axis title and a legend can be individually modified in Excel.
A)True
B)False
Q5) OLE stands for ________ and embedding.
Q6) A(n)________ row formats even rows differently than odd rows.
Q8) The ________ option changes text orientation from horizontal to vertical. Page 21
Q7) A data ________ includes the data points representing a set of related values.
To view all questions and flashcards with answers, click on the resource link above.
Page 22
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) If an animation in the Animation Pane includes a tag,what displays directly to the right of the tag?
A)The full name of the animation
B)An icon that represents the type of animation effect applied
C)A green arrow indicating the start of the animation
D)A timeline
Q2) Which of the following is NOT a ready-made action button in PowerPoint?
A)End
B)Home
C)Title
D)Sound
Q3) The ________ option from the Custom Path animation feature enables you to draw any path you choose by using a pencil-like tool.
Q4) URL stands for uniform ________.
Q5) How do you animate text beyond the first bulleted-level on a slide?
A)Click the Effect Options button on the Animations tab
B)Right-click and click Animate Text
C)Right-click and click Beyond
D)Click the Animation Dialog Box Launcher
Q6) How does a ScreenTip add to a presentation? Page 23
To view all questions and flashcards with answers, click on the resource link above.
Page 24
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) What does the Customize Ribbon tab allow you to do?
Q2) To modify handout masters of a presentation,click the ________ tab.
Q3) PowerPoint allows a default of ________ undos but can be change to any number from 3 to 150.
Q4) Which of the following is TRUE about adding a new tab to the PowerPoint Ribbon?
A)When a new tab is created,one new group is automatically added to it.
B)Once a tab is added,it cannot be removed.
C)When a new tab is added,only one group,originally named New Group (Custom),can be included on the tab.
D)Three default groups-New Group1,New Group2,and New Group3-are added to the new tab.
Q5) The ________ Print view contains a check box to designate whether to print hidden slides.
Q6) The header and footer on a handout master can be changed;the date cannot.
A)True
B)False
Q7) ________ fonts are scalable fonts supported by Windows.
Page 25
Q8) Clicking the File tab displays the ________ view to the user.
Q9) What is a notes master used for and what can be specified on it?
Q10) PowerPoint saves a master as a template with an extension of ________.
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) In addition to various page layouts,the ________ Microsoft Word dialog box includes an option to paste a link between the Word document and the presentation.
Q2) The ________ Presentation file format,.odp,is an XML-based format used in both free software and proprietary software.
Q3) Which of the following document properties is entered automatically?
A)Date and time
B)Author and title
C)Author and subject
D)Title and keywords
Q4) The Microsoft SharePoint ________ is a SharePoint site where you can store and manage files that are added to the space.
Q5) A table on a slide that includes extensive formatting may display an Error category message in the Accessibility Checker.
A)True
B)False
Page 27
Q6) Differences in files using the Compare feature can be accepted or ________.
Q7) What does it mean to flatten a PowerPoint file?
Q8) ________ text describes a text-based description of an image.
To view all questions and flashcards with answers, click on the resource link above. Page 28
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) You should use cell references in formulas instead of constant values so that:
A)you can easily include letters,numbers,and spaces.
B)it is easier to debug the errors.
C)you can change the input values without changing the formulas.
D)you can control the sequence in which Excel performs arithmetic operations.
Q2) Column width:
A)is adjustable so you can display more or less characters in a column.
B)is not adjustable so keep the formulas as short as possible.
C)always switches back to default.
D)is best left unchanged unless you absolutely have to.
Q3) The&[Page]code used in a cell displays the number of pages in a workbook. A)True
B)False
Q4) The ________ of a workbook displays the file name as well as the software name.
Q5) The order of ________ controls the sequence in which Excel does math.
Q6) The ________ button on a worksheet appears as a triangle at the intersection of the row and column headings.
Page 29
Q7) Briefly describe the data type "Text." Provide one or two examples of text entries in an Excel worksheet.
Q8) When B5 is the active cell and you press Ctrl+Enter,what happens?
To view all questions and flashcards with answers, click on the resource link above.
Page 30
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 nper in a PMT function is:
A)the total number of payment periods.
B)a word or a string of characters that represent one or more cells.
C)the present value of a loan.
D)a set of range names.
Q2) A range name can contain 255 characters and must begin with a(n)________ or an underscore.
Q3) What is a lookup table used for?
A)It looks up a value and returns a related result.
B)It contains data for the basis of a lookup and the data to be retrieved.
C)It is the lowest value for a specific category or series.
D)It is a reference to a cell containing a value to look up.
Q4) An absolute cell reference:
A)causes a potential error.
B)indicates a cell's specific location and the reference does not change when you copy the formula.
C)happens only when a formula indirectly refers to the cell containing the formula.
D)contains both an absolute and a relative cell reference.
Q5) The ________ is the lowest value in a category of a lookup table.
To view all questions and flashcards with answers, click on the resource link above. Page 31
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 charts displays lines connecting data points to show trends over equal time periods?
A)Column chart
B)Bar chart
C)Line chart
D)Area chart
Q2) ________ are small white-filled squares that display when a chart is selected.
Q3) The Y-axis:
A)is text that describes a collection of data points in a chart.
B)is a vertical line that borders the plot area to provide a frame of reference for measurement.
C)compares values for one set of data.
D)is a horizontal line that borders the plot area to provide a frame of reference for measurement.
Q4) Excel includes the placeholder text Chart Title below a chart when you create the chart.
A)True
B)False
Q5) The ________ of a chart is a key that identifies each data series of the chart.
Page 32
Q6) A(n)________ is a worksheet that contains only a chart.
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) Semiselection cannot be used to create formulas in a table.
A)True
B)False
Q2) A(n)________ defines the range of data from a worksheet to print.
Q3) In a worksheet,it is possible to ________ a manual page break to a new,desired location.
Q4) Which of the following is NOT an option on the Page Layout tab?
A)Manage page breaks
B)Set the print area
C)Print titles
D)Print preview
Q5) What do banded rows and banded columns do in an Excel table?
Q6) Each ________ in an Excel table represents a record.
Q7) Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.
A)True
B)False
33
Q8) What are the areas of the New Formatting Rule dialog box that need to be selected to create a new rule?
Q9) What are the four types of sorts in Excel 2013?
To view all questions and flashcards with answers, click on the resource link above. Page 34
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) 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).
Q2) What does the Values Area of a PivotTable do?
A)Subdivides data into one or more additional categories
B)Filters the data to display results based on particular conditions you set C)Organizes and groups data into categories on the left side.Each group Name occupies a single row
D)Displays summary statistics,such as totals or averages
Q3) Multiple subtotals can be applied to one data set.
A)True B)False
Q4) What is the default summary statistic for numerical fields in a PivotTable?
A)Average B)COUNT
C)SUM D)STDEV
Q5) The default numerical field calculation for PivotTables is SUM. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 35
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) How can you determine if the Solver add-in is active?
A)Solver is an option on the Home tab
B)Solver appears on the Data tab
C)Solver is available via right-click
D)Solver appears in the Goal Seek dialog box
Q3) Comments can be added to Scenarios in which tab or dialog box?
A)Goal Seek dialog box
B)Home tab
C)View tab
D)Scenario Manager dialog box
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
Q5) Scenario summary reports are placed on/in a ________.
To view all questions and flashcards with answers, click on the resource link above. Page 36
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 ________ function is best suited when two or more logical tests are required and all conditions must be true in order to return the value_if_true.
Q2) Which of the following functions returns a value or the reference to a value within a range based on X and Y coordinates?
A)MATCH
B)INDEX
C)VLOOKUP
D)HLOOKUP
Q3) Which of the following functions does not support multiple conditions?
A)AND
B)OR
C)MATCH
D)NOT
Q4) If payments are made at the beginning of the month the type argument should be set to ________ when using the IPMT function
Q5) The ________ function should be used to calculate the interest paid on the first payment of a mortgage.
Q6) The first argument of any database function is ________.
To view all questions and flashcards with answers, click on the resource link above. Page 37
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) VAR.P is included in the Analysis ToolPak.
A)True
B)False
Q2) The ________ function is best suited to determine the number of high school students under the age of 16.
Q3) 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
Q4) What is the difference between calculating standard deviation of a population versus a sample?
Q5) Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?
A)Correlation
B)Histogram
C)Descriptive Statistics
D)ANOVA
To view all questions and flashcards with answers, click on the resource link above. Page 38
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) ________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.
Q2) ________ is the process of selecting two or more worksheets.
Q3) Which of the following is not a way to remove panes from a window that has been split?
A)Double-click the split bar
B)Drag a vertical split bar to the left or right edge of the worksheet window
C)Click Split in the Window group
D)Click Remove Split in the View tab
Q4) ________ is/are a set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas.
Q5) When is the input message displayed in a cell that contains a validation rule?
A)When the user violates a rule
B)When the cell is clicked
C)When the workbook is opened
D)When the cell is double-clicked
Q6) A hyperlink cannot be used to access an e-mail address.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 39
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) Microsoft Access data tables and ________ can be imported into Excel.
Q2) Text functions such as CONCATENATE and UPPER can be nested for more precise results.
A)True
B)False
Q3) Which of the following applications can be used to create XML documents?
A)Notepad
B)Photoshop
C)iPhoto
D)Illustrator
Q4) <!-- Created June 29 1979 --> is an XML comment.
A)True
B)False
Q5) XML documents can be imported into Excel.
A)True
B)False
Q6) Flash Fill is located on the Ribbon.
A)True
B)False
Q7) A ________ can import data from data tables on a Web page.
To view all questions and flashcards with answers, click on the resource link above. Page 40
Chapter 28: Excel : Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39873
Sample Questions
Q1) When a workbook is opened and the message "File in Use" appears,the workbook is
Q2) Where do you access the Excel Options dialog box?
A)Backstage
B)Formulas tab
C)Data tab
D)Insert tab
Q3) When active,the Document Panel displays above the current workbook.
A)True
B)False
Q4) Which of the following is not true regarding comments in an Excel workbook?
A)Comments are indicated by a black triangle
B)Comments can be edited
C)Multiple users can insert comments
D)There is no limit to the number of comments in a file
Q5) The default comment print setting is:
A)as displayed on sheet.
B)only active.
C)at end of sheet.
D)none.
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) The file extension for an Excel Macro-Enabled Workbook is ________.
Q2) Macro security can be edited in the ________.
Q3) A user can create custom cell styles.
A)True
B)False
Q4) Which of the formats below will not support sub procedures using VBA?
A).xlsm
B).xlsx
C).xlsb
D).xltm
Q5) Which of the following is not a tool to help provided a unified look and feel within a workbook?
A)Themes
B)Custom functions
C)Backgrounds
D)Styles
Q6) Templates can be located and downloaded in the templates gallery.
A)True
B)False
Q7) What are the benefits if using templates in the workplace?
To view all questions and flashcards with answers, click on the resource link above. Page 42
Chapter 30: Access : Introduction to Access: Finding Your Way
Through an Access Database
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39875
Sample Questions
Q1) Which of the following is TRUE about Access' Compact and Repair feature?
A)It fragments a fragmented relational database file.
B)It defragments a fragmented database file if needed.
C)It removes objects and stores them in a secondary file.
D)You should compact your database no more than once a week due to the time required.
Q2) Which of the following is NOT a main object type in an Access database?
A)Template
B)Query
C)Table
D)Module
Q3) Access allows you to save a database as a PDF or ________ file,which preserves the object's formatting and looks the same on most computers.
Q4) A relationship is a connection between:
A)two tables using a field that is common to both.
B)two or more database files with a common primary field.
C)two records within the same database.
D)two or more tables using a common record.
Page 43
Q5) Describe how Access sorts multiple criteria in a database.
Q6) What are the three methods for creating a new database?
To view all questions and flashcards with answers, click on the resource link above. Page 44
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) You use the ________ view to create queries.
Q2) A ________ query is a type of query that displays on records that match criteria entered in Query Design view.
A)select
B)simple
C)one-to-one
D)multitable
Q3) You can set a(n)________ to create a label more readable than a field.
Q4) The ________ Wizard guides you through the query design process in Access.
Q5) Describe how sort order in an Access table is determined.
Q6) Freezing fields disallows any user from changing the field name or any data within the field.
A)True
B)False
Q7) "The primary key of a table plays a significant role when setting relationships."
Describe why this statement is true.
Page 45
Q8) What are the three ways to run a query?
Q9) Would you want to save every query that you create? Why or why not?
Q10) A(n)________ relationship requires a table called a junction table.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 32: Access: Customize,analyze,and Summarize
Query Data: Creating and Using Queries to Make Decisions
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/39877
Sample Questions
Q1) When designing an expression for a calculated field,the name of the calculated field is followed by a(n):
A)colon.
B)exclamation point.
C)semicolon.
D)period.
Q2) Unlike Excel,Access does not contain any built-in functions.
A)True
B)False
Q3) Which of the following can be used to zoom in and see an entire calculated field expressions?
A)F2
B)Shift + F2
C)F4
D)Shift + F4
Q4) Which aggregate function would be used to find the highest value in a column?
A)MAXIMUM
B)MOST
C)HIGHEST
D)COUNT
To view all questions and flashcards with answers, click on the resource link above. Page 47
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) To apply a background image to a file,click Background in the:
A)Background group on the FORMAT tab.
B)Picture group on the FORMAT tab.
C)Background group on the DESIGN tab.
D)Picture group on the DESIGN tab.
Q2) When in Layout or Design view,which of the follow is NOT a form layout tab?
A)Design
B)Edit
C)Layout
D)Format
Q3) When viewing a report in Layout view,you see that the records are displayed in order based on the primary key field.You prefer print the records in alphabetical order by last names and then by first names.Explain how to sort the report to display records using the last name and first name fields.
Q4) The table or query that supplies underlying data to a form or report is called the:
A)information source.
B)record source.
C)data source.
D)object source.
Page 48
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) How can you see relationships created with a Lookup Wizard?
Q2) Reports can be created based on the results of a parameter query.
A)True
B)False
Q3) When using an input mask,parentheses and hyphens are automatically stored with the data.
A)True
B)False
Q4) Using the example of a hire date of October 5,2017,what would the DatePart function be for the quarter?
Q5) A ________ rule limits the type of data a user can enter into a field.
A)validation
B)lookup
C)default
D)macro
Q6) An Access function that examines a date and returns a portion of the date is:
A)DatePart function.
B)Date formatting.
C)<<interval>>.
D)<<firstweekofyear>>.
Page 49
To view all questions and flashcards with answers, click on the resource link above. Page 50
Chapter 35: Access : Action and Specialized Queries:
Moving Beyond the Select Query
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39880
Sample Questions
Q1) What is the best way to check an update query before running it?
Q2) Once records with missing data are found,what type of query can you use to add the needed information?
A)Update
B)Delete
C)Make table
D)Find duplicates
Q3) Prior to updating data in a table,you must first locate the records that need to be modified.
A)True
B)False
Q4) What is the difference between an update query and an append query?
Q5) The find unmatched query only works if two tables share a common field.
A)True
B)False
Q6) A(n)________ query provides the easiest way to move records from one table to another.
Q8) What is the purpose of a crosstab query? Page 51
Q7) A(n)________ calculates a sum,average,or other statistic and groups the results by sets of values.
To view all questions and flashcards with answers, click on the resource link above. Page 52
Chapter 36: Access: Advanced Forms and Reports: Moving Beyond the Basics
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39881
Sample Questions
Q1) After adding grouping,a ________ appears just above the Detail section in Design view,along with the name of the field by which you are grouping.
A)Group header
B)Group footer
C)Page header
D)Form header
Q2) Which view gives a designer a higher level of control when creating forms and/or reports?
A)Design view
B)Layout view
C)Datasheet view
D)Form or Report view
Q3) 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
Q4) What is the purpose of a read-only form?
Q5) How can you add emphasis to a form or report?
To view all questions and flashcards with answers, click on the resource link above. Page 53
Chapter 37: Access: Get Connected: Exchanging Data
Between Access and Other Applications
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39882
Sample Questions
Q1) PDF is a file format created by Microsoft.
A)True
B)False
Q2) 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
Q3) When you export an object from Access to Word,Access creates a file in the PDF format.
A)True
B)False
Q4) Why is it easy to export Access tables to Excel?
Q5) When you double-click on a document with a RTF file extension,which of the following programs does Windows open by default?
A)Word
B)Excel
C)Notepad
D)Wordpad
Q6) What is one of the reasons you import directly into Access from Excel? Page 54
To view all questions and flashcards with answers, click on the resource link above. Page 55
Chapter 38: Access: Fine-Tuning the Database: Analyzing and Improving Database Performance
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39883
Sample Questions
Q1) To set a password,the database has to be opened in exclusive mode.
A)True
B)False
Q2) Optimizing a database may affect the database in ways you might not consider as positive results.
A)True
B)False
Q3) A back-end database contains the queries,forms,and reports of the database. A)True
B)False
Q4) What is the main reason for splitting a database?
Q5) What is the difference between first,second,and third normal form?
Q6) Creating an Access Database Executable (ACCDE)file will remove all VBA source code from the database.
A)True B)False
Page 56
Q7) Multivalued fields are created using the Input Mask Wizard. A)True
B)False
Q8) What are the benefits of normalization?
To view all questions and flashcards with answers, click on the resource link above. Page 57