Business Technology Essentials
Final Exam Questions
Course Introduction
Business Technology Essentials provides an introduction to the fundamental concepts and tools that enable the effective use of technology in todays business environment. This course covers key topics such as information systems, digital collaboration, cybersecurity basics, data management, cloud computing, and emerging technologies. Students will explore how technological innovations impact business operations, decision-making, and strategy, while gaining practical skills with commonly used software applications and business platforms. By the end of the course, learners will understand how to leverage technology to solve business problems, improve efficiency, and create competitive advantage in a rapidly evolving digital landscape.
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) When you close a document in Office 2013,what happens to the application?
A)It automatically remains open for a minimum of 10 additional minutes.
B)It also closes with the document.
C)If you close two of more documents simultaneously,the application closes;if only one document is closed,the application remains open.
D)The application remains open.
Answer: D
Q2) 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
Q3) Describe tiles.
Answer: Tiles are colorful block images available on the Windows 8 Start screen.When you click a tile,you will be taken to a program,file,folder,or other Windows 8 app.Tiles include the name of the app or program.
Q4) The ________ key on the keyboard accesses Help in Office 2013. Answer: F1
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) The default paragraph alignment is right.
A)True
B)False Answer: False
Q2) Which of the following is NOT considered an object?
A)Border
B)Picture
C)Screenshot
D)WordArt
Answer: A
Q3) As you move an object,the Layout Options feature enables you to watch text flow around it.
A)True
B)False Answer: False
Q4) Monospaced fonts are often used in tables of columnar data.
A)True
B)False
Answer: True
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Word: Document Productivity: Working With
Tables and Mail Merge
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39849
Sample Questions
Q1) 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.
Q2) Which of the following is TRUE about captions?
A)When a caption is created,it is formatted in Title style.
B)If you delete a table with a caption,all remaining tables with captions are automatically renumbered.
C)As you add captions,each caption is shown in sequence.
D)All captions must begin with the word Table.
Q3) During the mail merge process,you can create a data source.
A)True
B)False
Q4) Rows in a Word table are numbered 1,2,3,and so on.
A)True
B)False
Q5) The line style around each table or cell is called a(n)________.
Q6) Mail ________ combines data from a main document and a data source.
Q7) The first row in a data source is called the ________ row.
Q9) Completing a mail merge in Word begins with clicking the ________ tab. Page 5
Q8) Use the ________ dialog box to select an option to center a table horizontally.
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) An index and a table of contents are terms that refer to the same thing.
A)True
B)False
Q2) Why might you want to mark a comment as done?
Q3) Because style manuals vary with respect to rules,you should choose the one with which you are most comfortable when writing a research paper.
A)True
B)False
Q4) To give credit to a source you used in the preparation of a research paper,you should include a parenthetical citation.
A)True
B)False
Q5) Most English classes use the MLA style manual.
A)True
B)False
Q6) When you quote or paraphrase another person or publication,you must reference the source in a(n)________.
7
Q7) The ________ dialog box enables you to specify footnote or endnote settings other than those indicated by default.
To view all questions and flashcards with answers, click on the resource link above.
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39851
Sample Questions
Q1) Masthead is the use of light-colored text on a dark-colored background.
A)True
B)False
Q2) The ________ of an object or shape can be described as the interior space of the object.
Q3) You can add three-dimensional effects to an WordArt object.
A)True
B)False
Q4) A(n)________ is a geometric or nongeometric object such as a rectangle,star,or arrow.
Q5) When you embed a worksheet in a Word document,:
A)an error message displays.
B)the formulas become values .
C)the formulas remain as formulas.
D)the cells with formulas display as blank cells in the Word document.
Q6) ________ breaks a single object into numerous individual objects.
Q7) A sidebar is usually set in larger type,often in a different font or italics,and may be offset with borders at the top,bottom,or on the sides. Page 8
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) Word color themes can be modified and saved with a new name.
A)True
B)False
Q2) A(n)________ is a small picture of a page in a document.
Q3) ________ is a small graphical image.
A)Thumbnail
B)Document theme
C)Subdocument
D)Template
Q4) Which of the following is NOT a part of theme colors?
A)Accent colors
B)Page color
C)Hyperlink colors
D)Text and background colors
Q5) When you open a new blank document in Word,you use the ________ template.
Q6) Word 2013 does NOT provide any predefined building blocks,so users must create their own building blocks.
A)True
B)False
Q7) Describe the three elements in a document theme. Page 10
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Word: Document Automation:
Forms,macros,and Security
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39853
Sample Questions
Q1) ________ is NOT a type of editing restriction in Word.
A)Filling in Forms
B)Format
C)Track Changes
D)Comments
Q2) 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.
Q3) In a form template,pressing the ________ key moves a user from one field to the next.
A)Enter
B)Shift
C)Tab
D)Alt
Q4) Describe the steps to create a macro.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Q5) ________ form fields can be used when users will open the file in Word 2003 or earlier versions.
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) Saving Web pages using the Single File Web Page format will reduce the file size and Word editing options.
A)True
B)False
Q2) All the following are options on the Share feature on the File tab EXCEPT:
A)Present Offline.
B)Invite People.
C)Email.
D)Post to Blog.
Q3) The command to insert an online photo into a document is located in the Illustrations group of the Insert tab.
A)True
B)False
Q4) Why would you want to customize the Ribbon?
Q5) The Present Online feature is new in Word 2013.What is the purpose of this feature and how do you access it?
Q6) The ________ zoom feature will enlarge the inserted online image on a Web page.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Q7) Microsoft's ________ is a virtual storage location that utilizes the cloud integration technology.
Chapter 10: Power: Introduction to Powerpoint: Creating a Basic Presentation
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39855
Sample Questions
Q1) Of the following,which is NOT a method to advance through a slide show?
A)Press the Spacebar
B)Press Page Down
C)Press P
D)Press Enter
Q2) Which of the following is NOT considered a step in checking spelling and incorrect word usage in a PowerPoint slide show?
A)Use the Editing feature.
B)Read the slide content after you enter it.
C)Use the Spelling feature.
D)Ask a friend or colleague to review it.
Q3) What key combination inserts an indent within the cell of a table in PowerPoint 2013?
A)Shift+Tab
B)Alt+Tab
C)Ctrl+right arrow
D)Ctrl+Tab
Q4) The Normal view is the default view in PowerPoint 2013.
A)True
B)False
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) Why is it helpful to collapse the view of an outline in an Outline View presentation?
Q2) A hierarchy of organized text with main points and subpoints is called a(n)________.
Q3) What is the default name of a new section?
A)Untitled Section
B)Section1
C)Section Rename
D)Section panel
Q4) How do you move a slide in collapsed outline view?
A)Click the slide title and drag it to the new location.
B)Position the pointer over a slide icon until it turns to a four-headed arrow and then drag it.
C)Position the pointer over the slide number until it turns into a four-headed arrow and then drag it.
D)Click the slide number and drag it to the new location.
Q5) What sort of effects can be found in the Effects Gallery?
Q6) Click the ________ tab to print a presentation in Outline view.
Q7) What are two options for printing an outline?
Q8) In design,empty space on a slide is known as ________ space. Page 15
To view all questions and flashcards with answers, click on the resource link above.
Page 16
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) Explain the difference between WordArt and SmartArt?
Q2) A(n)________ is a set of intersecting lines,similar to graph paper.
Q3) Which of the following is NOT a modification element of WordArt?
A)Text Fill
B)Text Outline
C)Text Animation
D)Text Effects
Q4) A(n)________ SmartArt diagram shows a proportional relationship with the largest component on the top or the bottom.
Q5) A(n)________ is a shape that has a line,is often filled with text,and is often used in cartooning.
Q6) Use the ________ feature to create an equal space between shapes.
A)Distribute
B)Align
C)Rotate
D)Grid
Q7) ________ graphics are created using geometrical formulas and can be easily edited and layered.
Q8) The Shapes gallery can be accessed from the ________ tab. Page 17
Q9) Explain how PowerPoint's SmartArt feature can help in creating a presentation.
To view all questions and flashcards with answers, click on the resource link above. Page 18
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) Which of the following is NOT a typical way to add audio to a PowerPoint presentation?
A)Insert audio directly from a Web page
B)Insert audio from a file
C)Record audio
D)Insert from the Clip Art pane
Q2) The shape of a video can be edited in PowerPoint.
A)True
B)False
Q3) The ________ of a picture is the area to be kept with the Remove Background tool.
Q4) If an audio file is intended as background music but stops before you get to the last slide,use the ________ feature to play the music until the last slide.
A)Timing
B)Play Across Slides
C)Loop Until Stopped
D)With Previous or After Previous
Q5) To begin to record audio for a presentation,click the ________ tab.
Page 19
Q6) ________ is spoken commentary that can accompany a PowerPoint 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) Which of the following happens when you create a chart in PowerPoint?
A)The chart is created within PowerPoint.
B)Information is entered in Excel and linked in your presentation.
C)Excel opens with a message asking whether you want to open a new worksheet.
D)Information is entered in Excel and embedded in your presentation.
Q2) Where is the data stored for a linked object in PowerPoint?
A)In the PowerPoint file that has the linked object
B)In the source file
C)In the destination file
D)In a separate linked PowerPoint file
Q3) PowerPoint allows up to ________ rows and columns in a table.
A)25
B)50
C)75
D)250
Q4) The ________ option formats the last row of a table and displays column totals.
Q5) You can click the ________ tab to begin the process of inserting a new row or column.
Q7) How is an embedded object related to the source file? Explain. Page 20
Q6) On what is a table style applied to a table in PowerPoint based?
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) A(n)________ arrow on a motion path indicates the ending point of the path.
Q2) In order to animate text,select the text and click the ________ tab.
Q3) A(n)________ is set so when a user clicks text or an object on a slide,an image appears.
Q4) Multiple animations can be applied to objects in PowerPoint 2013.
A)True
B)False
Q5) What is the purpose of a ScreenTip in a slide?
A)To show the options available from a link
B)To show the URL of a link so a viewer can click it and link to the Web page
C)To offer PowerPoint help features
D)To offer a way for the user to determine the purpose of a hyperlink
Q6) A linear presentation progresses sequentially through slides,starting with the first slide and ending with the last slide.
A)True
B)False
Q7) From an action button,you can run a specific program or application.
A)True
B)False
Page 22
Q8) To apply a motion path,first select the object and then click the ________ tab.
To view all questions and flashcards with answers, click on the resource link above.
Page 23
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) Clicking the File tab displays the ________ view to the user.
Q2) To create a hyperlinked custom show,you can link slides from within the same presentation.
A)True
B)False
Q3) The feature that automatically changes something that you type in PowerPoint to something else is ________.
A)AutoFormat
B)Contextual spelling
C)the Spelling checker
D)AutoCorrect
Q4) If you make changes to the PowerPoint Ribbon,you can use the Reset button to restore it to the original settings.
A)True
B)False
Q5) ________ fonts are scalable fonts supported by Windows.
Q6) PowerPoint saves a master as a template with an extension of ________.
Q7) The Intersect Shapes command removes all intersected areas of two shapes.
A)True
B)False Page 24
To view all questions and flashcards with answers, click on the resource link above.
Page 25
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) ________ is used to protect the privacy of a presentation by converting a password into unreadable text.
Q2) To view the metadata of a presentation,click the ________ tab.
Q3) All PowerPoint 2013 features are fully supported when saved as an OpenDocument presentation.
A)True
B)False
Q4) ________ is the PowerPoint feature that allows you to transmit a presentation over the Internet to invited participants.
Q5) Document ________ are the attributes of a file.
Q6) ________ in PowerPoint refers to the ease with which a person with physical challenges can access,use,and understand a presentation.
Q7) 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 Page 26
To view all questions and flashcards with answers, click on the resource link above. Page 27
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) 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.
Q2) The Show Formulas button is accessible from the ________ tab.
Q3) Describe alignment in relation to Excel 2013.How is text automatically aligned,how are values automatically aligned,and how are dates automatically aligned?
Q4) The order of ________ controls the sequence in which Excel does math.
Q5) Describe three features available for headers and/or footers.
Q6) 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.
Q7) The Date number format only allows Long Date,for example,March 14,2016.
A)True
B)False
Q8) Adjust the column ________ to accommodate the widest entry in a column. Page 28
Q9) A(n)________ is a single spreadsheet.
To view all questions and flashcards with answers, click on the resource link above. Page 29
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) A relative cell ________ indicates a cell's relative location.
Q2) The AVERAGE function can be used to calculate the student class average or a quiz or exam.
A)True
B)False
Q3) You can choose to use range names in formulas that you create instead of cell references.
A)True
B)False
Q4) Excel provides three basic count functions: COUNT,COUNTA,and ________.
Q5) A circular reference:
A)is a predefined formula that performs a calculation.
B)is a rule that governs the structure and components for functions.
C)occurs when a formula directly or indirectly refers to the cell containing the formula.
D)is an input such as a cell reference or a value needed to complete a function.
Q6) Because the SUM function is a rarely used function it has no button on the Ribbon.
A)True
B)False
Page 30
To view all questions and flashcards with answers, click on the resource link above.
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) ________ are small white-filled squares that display when a chart is selected.
Q2) How can you identify sizing handles when you click a chart?
A)A Sizing Handles button displays on the Design tab.
B)A Sizing Handles button displays next to the chart.
C)They display as small,black triangles located on the corners of a selected chart.
D)They display as small,white-filled squares.
Q3) A(n)________ column chart compares groups of columns set side by side for easy display.
Q4) Describe the difference between an X-axis and a Y-axis.
Q5) Gridlines on a chart in Excel 2013 are:
A)numeric values that describe a single value on a chart.
B)lines used to depict trends and forecast future data.
C)horizontal or vertical lines that span across the chart.
D)a visual representation of numerical data.
Q6) Describe the display of horizontal axis and vertical axis titles on a chart.
Q7) When you hover the mouse pointer over a chart,Excel 2013 display a(n)________ with the name of that chart element.
Q8) Describe the three Format task panes that allows you to format with fill and border elements of a chart.
To view all questions and flashcards with answers, click on the resource link above. Page 31
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) Each ________ in an Excel table represents a record.
Q2) If the default conditional format options do not provide what you need,you can create your own rule for formatting.
A)True
B)False
Q3) A color scale:
A)highlights cells meeting specified criteria with a specified color,font,or border.
B)is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range.
C)calculates an aggregate for values in a range or database.
D)is a conditional format that displays a color based on the relative value of the cell contents.
Q4) Filtering the Last_Name field to show only records that begin with the letter P is an application of a(n)________ filter.
Q5) What are icon sets?
Q6) A(n)________ bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
Page 32
To view all questions and flashcards with answers, click on the resource link above.
Chapter 22: Excel: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) Once grouped,columns cannot be ungrouped.
A)True
B)False
Q2) To update the data in a PivotTable click ________ in the Data group.
Q3) ________ is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections.
Q4) Multiple filters can be applied to a PivotTable.
A)True
B)False
Q5) More than one function can be applied per field in a PivotTable.
A)True
B)False
Q6) From which of the following locations can you create a PivotTable?
A)Data tab
B)Quick Analysis gallery
C)Backstage
D)Formulas tab
To view all questions and flashcards with answers, click on the resource link above. Page 33
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) In order to complete a two-variable data table,a formula or reference to a formula must be entered in the top-left corner.
A)True
B)False
Q2) There is no limit to the number of scenarios that can be created with Scenario Manager.
A)True
B)False
Q3) When calculating the optimal blend of down payment and interest rate to purchase an automobile,a limit of no more than a $10,000 down payment is an example of which of the following?
A)Nonbinding constraint
B)Objective cell
C)Integer
D)Set cell
Q4) Solver constraints can be set to restrict values to integers.
A)True
B)False
Q5) ________ can be used to compare the effects of several scenarios on calculated results.
34
To view all questions and flashcards with answers, click on the resource link above.
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 end_period argument should have the value of ________ if you are calculating cumulative interest using CUMIPMT for the third payment of a loan.
Q2) 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
Q3) The ________ function is best suited when two or more logical tests are required and at least one condition must be true to return the value_if_true.
Q4) In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:
A)Value_if_true.
B)Value_if_false.
C)Logical_test.
D)Modifier.
Q5) The RATE function returns the periodic rate for an investment or loan.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 35
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 FREQUENCY function will count numbers that are outside the predetermined bins.
A)True
B)False
Q2) When using the CORREL function,a value of .00007 would indicate:
A)a weak relationship.
B)a strong relationship.
C)an inverse relationship.
D)no relationship.
Q3) The PERCENTILE.INC function includes the 0 and 100th percentile.
A)True
B)False
Q4) The ________ is the range of cells that contain the values that are being evaluated for frequency of occurrence when using the FREQUENCY function.
Q5) A CORREL value of .9 has a strong positive relationship.
A)True
B)False
Q6) The ________ function calculates the variance of a population.
Q7) ________ calculates the variance of a sample.
Q8) A ________ is a visual display of tabulated frequencies.
To view all questions and flashcards with answers, click on the resource link above. Page 36
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) Which of the following actions will open another window of the current workbook?
A)Click the Formulas tab,and then click New Window in the Manage group
B)Click the View tab,and then click New Window in the Window group
C)Click the Data tab,and then click New Window in the Manage group
D)Click the View tab,and then click New Window in the Manage group
Q2) A hyperlink cannot be used to access an e-mail address.
A)True
B)False
Q3) ''[South Bend.xlsx]Qtr3''!A1 is an example of a (n)________.
Q4) What is the proper format of an external reference to a workbook or worksheet thats name does not contains spaces;source and destination files are in the same folder.
A)''[WorkbookName]Worksheet''!Cell
B)[WorkbookName]Worksheet!Cell
C)'[WorkbookName]Worksheet'!Cell
D)Worksheet'!Cell
Q5) ________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.
Q6) What is the difference between a precedent and dependent cell?
Q7) A ________ is a file that that contains original data that you need elsewhere.
To view all questions and flashcards with answers, click on the resource link above. Page 37
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) Web queries cannot import data from Web pages that are ________.
Q2) Indentation indicates the hierarchy structure in XML.
A)True
B)False
Q3) The UPPER function will capitalize every character of a text string.
A)True
B)False
Q4) Web queries refresh data automatically.
A)True
B)False
Q5) When connections are being refreshed,Excel displays the message "Running background query" in the status bar.
A)True
B)False
Q6) A(n)________ is a data file that contains characters,such as letters,numbers,and symbols,including punctuation and spaces.
Q7) Flash Fill is located on the Ribbon.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 38
Q8) The ________ function will convert all characters in a text string to lowercase.
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) Customization of the Quick Access Toolbar can be exported.
A)True
B)False
Q2) Which feature is best suited to record edits made to a document over time?
A)Compare and merge
B)Track changes
C)Comments
D)Sharing
Q3) Which of following is the default file format for Excel 97-2003?
A).TXT
B).XLS
C).XLSX
D).XLTX
Q4) When printing,by default all comments in a worksheet are ________.
Q5) Use the ________ command to combine the shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.
Q6) ________ 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.
Q7) What are the benefits of customizing Excel?
To view all questions and flashcards with answers, click on the resource link above. Page 39
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) All templates should contain instructions.
A)True
B)False
Q2) .xlsb files do not support macros.
A)True
B)False
Q3) Which of the following formats does not support macros?
A).xlsm
B).xlsb
C).xltm
D).xlsx
Q4) Macro security can be edited in the ________.
Q5) Which of the following is not a best practice when creating a macro?
A)Practice the steps before starting
B)Determine whether absolute or relative references should be used
C)Start and stop the recording as needed
D)Ensure the macros are broad enough to apply to multiple situations
Q6) What business practices should be used when creating a macro?
Q7) What are the benefits if using templates in the workplace?
Q8) By default all cells in a workbook are ________.
To view all questions and flashcards with answers, click on the resource link above. Page 40
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) A field that is defined as a primary key in one table is defined as a(n)________ in a related table.
A)referential integrity key
B)relational database
C)foreign key
D)primary2 key
Q2) A complete set of all fields about one person or event is called a field.
A)True
B)False
Q3) The navigation buttons in Access allow you to step through a table record by record,or to quickly go to the first or last record in the table.
A)True
B)False
Q4) You can create a Web app from a Web app template from the Backstage view. A)True
B)False
Q5) The ________ utility of Access helps reduce the size of a database.
Q6) How is referential integrity helpful?
Q7) Describe how Access sorts multiple criteria in a database.
To view all questions and flashcards with answers, click on the resource link above.
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 field property type should be used to enter a predefined value into a field when most of the records will have the same value?
A)Input Mask
B)Default Value
C)Validation Rule
D)Validation Text
Q2) The ________ data type is used for fields that will be used in mathematical calculations except those involving money.
Q3) Where do you change the order of query fields to change the order of query results?
A)In the design grid of a query's Datasheet view
B)In the Criteria row of the Query Design view
C)In the Show row of the Query Design view
D)In the Relationship window of the Design view
Q4) ________ is the value used to describe a blank field in an Access table.
Q5) If you choose Append a copy of the records to the table as an option for incoming data,the data will be added to an existing table.
A)True
B)False
42
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) The default option in the total row is:
A)first.
B)group By.
C)sum.
D)expression.
Q2) To change a field's caption or the number of decimal places,you would use its ________.
Q3) Formats available on the Property Sheet vary based on the data type.
A)True
B)False
Q4) Which aggregate function would be used to find the highest value in a column?
A)MAXIMUM
B)MOST
C)HIGHEST
D)COUNT
Q5) A Total row displays the results of aggregate functions as the last row in the Datasheet view.
A)True
B)False
Q6) * is the symbol for ________. Page 43
To view all questions and flashcards with answers, click on the resource link above. Page 44
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) Which of the following is NOT a report view?
A)Design view
B)Print Preview
C)Format view
D)Layout view
Q2) The Ascending and Descending buttons are located in the ________ group on the HOME tab.
Q3) Report view allows a report to be viewed onscreen in a continuous page layout.
A)True
B)False
Q4) What type of control is used to help keep controls aligned horizontally and vertically,giving forms a uniform appearance?
A)Bounded
B)Layout
C)Unbounded
D)Calculated
Q5) To sort fields in a report,you begin by clicking Group & Sort in the Group & Sort group on the DESIGN tab.
A)True
B)False
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) 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) A(n)________ accepts two or more options in a lookup field.
A)multiple-value field
B)input mask
C)lookup list
D)required
Q3) How can you see relationships created with a Lookup Wizard?
Q4) Which of the following function checks to see if a field has no value?
A)IsNull
B)Sum
C)Average
D)IsNotNull
Q5) An Access expression that calculates lapsed time is called ________.
Q7) The ________ Wizard restricts how data is entered into a field. Page 46
Q6) If a field in a table has a ________ a drop down menu will appear in the field.
To view all questions and flashcards with answers, click on the resource link above. Page 47
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 row headings display in a crosstab query?
A)Along the left side of a crosstab query
B)Along the top of a crosstab query
C)Along the right side of a crosstab query
D)Along the bottom of a crosstab query
Q2) An append query is used to add records to an existing table.
A)True
B)False
Q3) If the destination table exists and you run the make table query,Access automatically deletes the source table.
A)True
B)False
Q4) The process of creating a make table query is very similar to which other type of query?
A)Append query
B)Delete query
C)Find duplicates query
D)Update query
Page 48
Q5) To find which customers have not yet ordered,you would run a(n)________ query.
Q6) How do appended records appear in the destination table?
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) How do you hide details in a report?
A)Click Hide details in the Grouping & Totals group on the Design tab
B)Close the detail section in Design view
C)Click Hide details in the Header/Footer Options
D)Click Hide details in Page Options
Q2) Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.
A)True
B)False
Q3) What is the group footer used for?
A)Totaling the data at the end of each group
B)Totaling the data at the end of each page
C)Totaling the data at the end of each section
D)Totaling the data at the end of the form
Q4) A(n)________ contains an expression that generates a calculated result.
A)calculated control
B)rectangle control
C)bound control
D)unbound control
Q5) What is a subform?
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) What is one of the reasons you import directly into Access from Excel?
Q2) What happens when you click a hyperlink field value while in Datasheet view?
A)Access launches the program required to display the file or Web page
B)Access adds an attachment to the table
C)Access saves the corresponding file
D)Access creates a ScreenTip that appears when you hover over the hyperlink
Q3) What happens when you double-click an attachment field in a table?
A)A dialog box opens with options
B)The attachment opens
C)The attachment is removed
D)The attachment is saved to a file
Q4) Rich Text Format (RTF)is a format that enables documents created in one software application to be opened with a different software application.
A)True
B)False
Q5) In a report,click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.
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) To start a navigation form automatically on start up,change settings in the Options window.
A)True
B)False
Q2) Which of the following is NOT a tool database administrators can use to improve the performance of a database?
A)Oracle tool
B)Database Documenter tool
C)Performance Analyzer tool
D)Table Analyzer tool
Q3) What is the purpose of a password?
Q4) What does the Database Documenter list?
Q5) A back-end database contains the queries,forms,and reports of the database.
A)True
B)False
Q6) What are four ways to keep your database application safe?
Q7) When a database has been converted to an .accde file,it can be converted back to its source format (accdb).
A)True
B)False Page 52
To view all questions and flashcards with answers, click on the resource link above. Page 53