Business Computing
Pre-Test Questions
Course Introduction
Business Computing explores the integration of information technology with business processes and decision-making. The course covers key concepts such as data management, office productivity software, enterprise systems, and the strategic use of information systems in organizations. Students learn how to utilize tools like spreadsheets, databases, and presentation software to solve business problems, enhance communication, and support organizational goals. Practical case studies and hands-on projects help develop skills in using digital technologies to streamline operations, analyze data, and foster innovation in a business environment.
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) ________ is the default location for saving files for Office 2013 applications.
Answer: SkyDrive
Q2) Increasing the font size while in Print Preview by using the zoom increases the actual font size of the document when printed.
A)True
B)False
Answer: False
Q3) SkyDrive can be directly accessed from the Windows 8 Start screen.
A)True
B)False
Answer: True
Q4) ________ are made up of five icons that provide functionality to the Start button in Windows 8.
Answer: Charms
Q5) Click the File tab,and then click the Exit button to close a Microsoft Office application. A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 3: Word: Document Presentation: Editing and Formatting
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39848
Sample Questions
Q1) Monospaced fonts are often used in tables of columnar data. A)True
B)False Answer: True
Q2) When you delete a section break,text that is below the former break assumes the formatting characteristics of the previous section.
A)True
B)False Answer: True
Q3) A pointer is a series of dots or hyphens that leads a reader's eye across the page to connect two columns of information.
A)True
B)False Answer: False
Q4) ________ are side-by-side vertical blocks of text. Answer: Columns
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) The first row of a table often includes text in one cell that spans the width of all other table data below.What command enables you to design the first row in that manner?
A)Distribute Horizontally
B)Align Top Center
C)Merge
D)Split
Q2) Coordinated colors,borders,and shading are available within a(n)________ that you can apply to a table.
Q3) The first row in a data source is called the ________ row.
Q4) The Word feature that provides access to predesigned tables,including calendars,tabular lists,and matrices is:
A)Draw Table.
B)Quick Tables.
C)Excel Spreadsheet.
D)Table Styles.
Q5) Press ________ at the end of a table to insert a row below the last row.
Q6) Word 2013 includes a new feature that simplifies the process of adding rows and columns.Describe the feature.
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Word: Collaboration and Research:
Communicating and Producing Professional Papers
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39850
Sample Questions
Q1) The disciplines of business,communications,and social sciences tend to prefer which writing style?
A)MLA
B)APA
C)Chicago
D)Turabian
Q2) Comments are shown in:
A)markup balloons.
B)parenthetical citations.
C)indexed entries.
D)comment balloons.
Q3) The ________ writing style originated as a subset of Chicago.
Q4) The three available Markup views are No Markup,All Markup,and ________.
Q5) Briefly explain why you might choose Simple Markup view over All Markup view when editing a shared document?
Q6) During an online presentation of a document,who is able to edit the document?
A)The presenter
B)Any attendee to which the presenter grants permission
C)Any conference attendee
D)Anyone with a Microsoft account
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 6: Word: Desktop Publishing and Graphic Design:
Creating a Newsletter, working With Graphics, and Linking Objects
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39851
Sample Questions
Q1) A(n)________ calls attention to information by displaying it in an area along the side of featured information.
Q2) A drop cap is formatted in a font size larger than the body text.
A)True
B)False
Q3) ________ is NOT an option available in the Drop Cap dialog box.
A)Number of lines to drop
B)The letter for the drop cap initial
C)The size of the drop cap initial
D)How far from the text the drop cap displays
Q4) If you click Paste Special,you can choose the ________ option from the Paste Special dialog box to create a link to the original file.
Q5) All of the following EXCEPT ________ are preset designs for column settings in Word.
A)Left
B)One
C)Two
D)Center
8
Q6) What is SmartArt,and how do you enter text in a SmartArt graphic?
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) ________ is a small graphical image.
A)Thumbnail
B)Document theme
C)Subdocument
D)Template
Q2) Of the following choices,the ________ file extension is NOT a Word template.
A).dot
B).dotx
C).docx
D).dotm
Q3) The default alignment of text for the Normal template is: A)Right.
B)Left.
C)Justify.
D)Center.
Q4) The margins of the Normal template are ________ left,right,top,and bottom.
A)1)25"
B)1)5"
C)1)00"
D)0)75"
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Word: Document Automation:
Forms,macros,and Security
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39853
Sample Questions
Q1) A combo box allows users to select from a list of choices that displays in a drop-down box,but the user can also modify the choices in the list.
A)True
B)False
Q2) In a rich text control,users can enter text or numbers and modify the format of the text.
A)True
B)False
Q3) A good password will consist of: A)symbols.
B)symbols,letters,and numbers. C)letters.
D)numbers.
Q4) The default macro setting is disable all macros with ________.
Q5) A user can enter data in a form if the fields are: A)empty. B)shaded.
C)in red. D)in bold.
Q6) A(n)________ is a set of instructions that executes a specific task. Page 11
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) Which of the following statements about the Ribbon is FALSE?
A)You cannot restore the Ribbon to its original arrangement.
B)You can customize the Ribbon to contain just the commands you want to use.
C)You are allowed to change the order of the tabs on the Ribbon.
D)You can create a new tab and a new group and put it on the Ribbon.
Q2) The Present Online feature is new in Word 2013.What is the purpose of this feature and how do you access it?
Q3) Why would you want to customize the Ribbon?
Q4) HTML stands for ________ Markup Language.
Q5) You may replace the space in a Web folder or file name with CamelCase,hyphen,or
Q6) The ________ feature in Word enables users to share their work with others via the Internet
Q7) A(n)________ is a color,design,image,or watermark behind text in a document or Web page.
Q8) When you create a new tab,a new group is automatically created with it. A)True B)False
Q9) The ________ is a network of networks that connects computers anywhere in the 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) To keep your slide content concise,you should follow the 15X15 guideline.
A)True
B)False
Q2) What happens to the background when you print a slide show in grayscale?
A)The background prints in shades of gray.
B)The background will only print in black and white;no shades will be included.
C)The background will not print.
D)An error message occurs.
Q3) The ________ tab allows you to include a media object in your presentation.
Q4) Transitions can be applied to multiple slides from the Slide Sorter view.
A)True
B)False
Q5) Which of the following is FALSE about the 7 × 7 guideline for presentations?
A)It suggests that you use no more than seven words per line.
B)You may occasionally be forced to exceed this guideline.
C)It suggests that you try to use no more than seven lines per slide.
D)It suggests that a maximum of seven transitions and seven animations should be used in a presentation.
Page 15
Q6) A(n)________ generally appears at the top of slides and offers consistent text and/or graphics on each slide.
To view all questions and flashcards with answers, click on the resource link above.
Page 16
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) It is suggested that you never work with the blank Office Theme template.
A)True
B)False
Q2) Which of the following is TRUE about how typical text looks on a slide?
A)Each subsidiary item is indented,and the font size is larger.
B)Each subsidiary item is bolded,and the font size is smaller.
C)Each subsidiary item is italicized and bolded,and the font size is smaller.
D)Each subsidiary item is indented,and the font size is smaller.
Q3) After clicking the File tab to open a template,click the ________ button.
Q4) It is possible to reuse slides from a different file when creating a presentation.
A)True
B)False
Q5) Microsoft Word 2013 outlines that can be imported into a presentation could have all of the following file extensions EXCEPT:
A).doc.
B).rtf.
C).docx.
D).wpd.
Q6) A(n)________ view displays the slide icon,the title,and the slide content.
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) Flipping an image and rotating an image are the same thing.
A)True
B)False
Q2) Some themes have shapes incorporated.
A)True
B)False
Q3) ________ uses special effects applied to the text itself,not to the shape surrounding the text.
Q4) Which of the following is FALSE about SmartArt objects?
A)Special modifications include Text Fill,Text Effects,and a Transform option.
B)A pane is provided for entering information.
C)Shapes and text are automatically resized.
D)Layouts can easily be changed.
Q5) How does an adjustment handle display when a shape is selected?
A)Just like a sizing handle but larger
B)As a green circle located at the top of the selected shape
C)As a yellow square
D)As a large blue diamond
Q7) List,Process,and Cycle are categories of ________. Page 18
Q6) The ________ Mode allows you to create the same shape multiple times.
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) Which PowerPoint correction tool can be overused to make the image appear grainy?
A)Brightness
B)Contrast
C)Sharpening
D)Softening
Q2) The ________ of a picture is the area to be removed with the Remove Background tool.
Q3) Use Shift or ________ to select more than one image to be inserted into a photo album presentation.
A)Alt
B)F1
C)Ctrl
D)PgDn
Q4) You can't discard the formatting for a video once it has been set.
A)True
B)False
Q5) Each ________ in a bitmap image contains information about the color to be displayed on a monitor.
Q6) A(n)________ provides legal protection for written and artistic work. Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
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 shape fill,outlines,and effects on a chart is similar to making changes in a SmartArt design.
A)True
B)False
Q2) To make multiple formatting changes to an element of a chart,click:
A)Format Selection on the Format tab.
B)Current Selection on the Design tab.
C)Edit Selection on the Format tab.
D)the element,and right-click and choose Edit.
Q3) PowerPoint allows up to ________ rows and columns in a table.
A)25
B)50
C)75
D)250
Q4) On what is a table style applied to a table in PowerPoint based?
Q5) On a column chart with two axes,data increments are automatically determined and included on the ________-axis.
To view all questions and flashcards with answers, click on the resource link above. Page 22
Q6) A(n)________ is a chart that displays a relationship between two sets of numbers plotted as data points with coordinates on a grid.
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) From an action button,you can run a specific program or application.
A)True
B)False
Q3) ________ create interactivity by branching to slides or other locations such as additional files on the same storage device.
Q4) An End action button moves to the end of the last bullet on the current slide.
A)True
B)False
Q5) To add multiple animations to an object,select the object and click the Insert tab. A)True
B)False
Q6) ________ can be linear,curved,or follow a predetermined shape.
Page 23
Q7) A small ________ on a motion path indicates the starting point of the path.
To view all questions and flashcards with answers, click on the resource link above.
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) How do you know whether a slide is hidden when in Slide Sorter view?
A)The slide thumbnail shows with a light orange background.
B)The slide number is bold.
C)The slide number shows behind a red stop sign image.
D)The slide number displays with a slash.
Q2) RGB,a numeric system for identifying colors is a combination of red,green,and ________ light.
Q3) Multiple custom slide shows can be linked together with hyperlinks.
A)True
B)False
Q4) The ________ is the top slide in a hierarchy of slides.
A)slide master
B)handout master
C)notes master
D)title slide
Q5) To create a hyperlinked custom show,you can link slides from within the same presentation.
A)True
B)False
Q6) The file extension assigned to a PowerPoint presentation is ________. 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) XML stands for ________ Language.
Q2) ________ is the process of two or more individuals working together to achieve an outcome or goal.
Q3) Another name for document or presentation properties is ________.
A)encryption
B)metadata
C)markups
D)annotations
Q4) Your mouse can be used as a laser pointer while displaying a PowerPoint file.
A)True
B)False
Q5) If you accept a change when using the compare and merge feature,it is not possible to reverse the action.
A)True
B)False
Q6) Personal data in a presentation can be discovered using:
A)the Document Inspector.
B)the Accessibility Checker.
C)Mark as Final. 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) An output area is defined as:
A)a region of a worksheet with formulas dependent on values from an input area.
B)a display of the range name and tab name within a workbook.
C)a range of cells containing values for variables used in formulas and functions within a worksheet.
D)the active cell on an active worksheet.
Q2) Adjust the column ________ to accommodate the widest entry in a column.
Q3) The order of precedence in Excel 2013:
A)includes letters,numbers,and spaces.
B)controls the sequence in which Excel performs arithmetic operations.
C)is a software application used to create and modify business communications.
D)includes formulas,functions,and formatting.
Q4) Excel data can be copied and pasted into a Word or PowerPoint document.
A)True
B)False
Q5) Before printing a worksheet,click the File tab and select Print to preview the worksheet.
A)True
B)False
Q6) A number that represents a quantity or amount is called a(n)________. Page 28
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) The =DATE(year,month,day)function returns a serial number for a date.
A)True
B)False
Q2) The formula =C4*D4 uses only relative cell references.
A)True
B)False
Q3) A circular reference occurs when a formula directly or indirectly refers to the cell containing the formula.
A)True
B)False
Q4) The ________ function category performs calculations such as averages and standard deviations.
Q5) A range name:
A)indicates a cell's specific location and the reference does not change when you copy the formula.
B)is a word or a string of characters that represent one or more cells.
C)indicates a cell's relative location from the cell containing the formula.
D)always begins with an equal sign (=).
Q6) Describe a circular reference.Provide an example.
Q7) The IF function in Excel 2013 has ________ arguments. Page 30
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) Axes titles are:
A)display on the X-axis by default.
B)the value or name of a data point on the X-axis.
C)not displayed by default.
D)descriptive labels that show exact values or name of a data point.
Q2) The ________ of a chart is the region containing the graphical representation of the values in a data series.
Q3) Sizing handles display as small,black-filled circles to resize a chart.
A)True
B)False
Q4) 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.
Q5) A(n)________ is a grid that contains the data source values and labels.
Q6) Axes,chart titles,and data tables are examples of chart elements.
A)True
B)False
Page 32
To view all questions and flashcards with answers, click on the resource link above.
Chapter 21: Excel: Datasets and Tables: Managing Large
Volumes of Data
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39866
Sample Questions
Q1) A(n)________ is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
Q2) In Excel 2013,you can delete conditional formatting rules that you create but you cannot edit them.
A)True
B)False
Q3) You can create a table by selecting a range,clicking the Quick Analysis button,and clicking Tables.
A)True
B)False
Q4) In Page Break Preview,the print area has a white background with a dotted blue border.
A)True B)False
Q5) Each row in an Excel table:
A)is an individual piece of data,such as a last name.
B)is the sequence in which pages print.
C)represents a Field which can contain an individual piece of data for a record. D)represents a record.
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 22: Excel: Subtotals, Pivot-tables, and
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) Which of the following is not true regarding data mining?
A)Analyzes large amounts of data
B)Uses advanced statistical techniques
C)Identifies trends
D)Exports data
Q2) Which of the following tools is best suited for maximum control when creating an outline?
A)Subtotals
B)PivotTable
C)Grouping
D)Slicers
Q3) You must sort in order to properly execute a subtotal.
A)True
B)False
Q4) Where are PivotTable formatting tools located?
A)PivotTable Tools Analysis tab
B)Data tab
C)PivotTable Tools Design tab
D)Insert tab
Q5) The default numerical field calculation for a PivotTable is ________.
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) Multiple objective cells can be used with Goal Seek.
A)True
B)False
Q2) ________ is the best what-if analysis tool to solve complex linear and nonlinear problems.
A)Goal Seek
B)Solver
C)One-variable data table
D)Scenario Manager
Q3) When saving a Solver model which of the following is not saved?
A)Objective value
B)Changing variable cells
C)Constraints
D)Set cell
Q4) Solver models can be saved and restored.
A)True
B)False
Q5) A(n)________ is a structured range that contains different values for one variable to compare how these values affect one or more calculated results.
Q6) ________ will vary one input value to reach one optimized result.
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) The CUMPRINC function requires both starting and ending evaluation dates.
A)True
B)False
Q2) Which database function should be used to count records with empty cells?
A)DCOUNT
B)DCOUNTA
C)DGET
D)DSUM
Q3) Which of the following functions will return the principal payment of a loan?
A)CUMPRINC
B)PMT
C)PPMT
D)IPMT
Q4) The database argument of any database function requires the selection of the entire table.
A)True
B)False
Q5) CUMPRINC contains six arguments.
A)True
B)False
Page 36
To view all questions and flashcards with answers, click on the resource link above.
Chapter 25: Excel: Statistical Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39870
Sample Questions
Q1) The ________ is best suited to measure the strength of the relationship between credit score and salary.
Q2) COVARIANCE.S determines how two sets of data from a sample vary simultaneously.
A)True
B)False
Q3) Which of the following functions is best suited to add numbers based on one condition?
A)SUMIFS
B)SUMIF
C)COUNTIF
D)COUNTIFS
Q4) When using the QUARTILE.INC function which quartile would include the highest value in the dataset?
A)1
B)2
C)3
D)4
Q5) The QUARTILE.EXC function excludes quartiles 0 and 4. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
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) By default automatic updates of links are disabled.
A)True
B)False
Q2) Conditional formatting can be applied to a set of grouped worksheets.
A)True
B)False
Q3) This should be used when referencing cells on another worksheet.
A)Function
B)Reference
C)Formula
D)3-D reference
Q4) The split bar gives the user the ability to view two different workbooks simultaneously.
A)True
B)False
Q5) Using a(n)________ is best suited to monitor the changes in a cell as input value update.
Q6) What are the benefits of using 3-D formulas?
Q7) The error ________ will display when a formula attempts to divide a value by zero or an empty cell.
To view all questions and flashcards with answers, click on the resource link above. Page 38
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) The UPPER function will capitalize every character of a text string.
A)True
B)False
Q2) When creating a Web query which option preserves all original formatting?
A)Rich text
B)HTML formatting
C)XML
D)Style Sheet
Q3) Web queries cannot accurately import data from Web sites that are password protected.
A)True
B)False
Q4) The LOWER function will capitalize the first letter of a text string.
A)True
B)False
Q5) A(n)________ file uses commas to separate data into columns that can be imported into Excel.
Q6) The ________ function will convert all characters in a text string to lowercase.
Q7) A ________ can import data from data tables on a Web page.
Q8) The ________ function will capitalize all characters in a text string.
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) Workbook comments can only be removed one at a time.
A)True
B)False
Q2) Which of the following is not an Excel Options category?
A)General
B)Formulas
C)Format
D)Proofing
Q3) Which dialog box allows the user to print all comments?
A)Page Setup
B)Print
C)Page Layout
D)Backstage
Q4) AutoCorrect options are located in which Excel Options category?
A)Formulas
B)Proofing
C)General
D)Advanced
Q5) The default file format for Excel 2013 files is ________.
Q6) The ________ should be used to make sure your files are backwards compatible.
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) Where are custom cell styles saved?
A)The workbook in which you created the style
B)A personal styles workbook
C)My Documents
D)A personal macro workbook
Q2) The macro recorder can append a previously recorded macro.
A)True
B)False
Q3) Which of the following cannot be modified in a custom cell style?
A)Number
B)Alignment
C)Print area
D)Fill
Q4) Recorded macros can be viewed in the ________.
Q5) The ________ function should be used to trap errors when creating templates.
Q6) Which of the following tabs contains Form Controls?
A)Insert
B)Data
C)Developer
D)Formulas
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) Describe comparison operators in Access.
Q2) What is an Access Web app?
Q3) SharePoint is an add-on program for Access.
A)True
B)False
Q4) Which of the following best describes information?
A)Information is a converted into fields and records within a table in a database.
B)Information is converted into data that can be selected and sorted for business or personal use.
C)Information is what is entered into a database.
D)Information is the finished product that is produced by a database.
Q5) An Access database can MOST accurately be described as a structured collection of:
A)tables.
B)objects. C)records.
D)modules.
To view all questions and flashcards with answers, click on the resource link above. Page 42
Q6) Relationships in a database can be graphically represented by the ________ between the tables.
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) Data redundancy may result in errors.
A)True
B)False
Q2) In most cases,it is advisable to enforce referential integrity in databases with related tables.
A)True
B)False
Q3) Why might you want to import data rather than creating a new database from scratch?
Q4) Good database design begins with the forms of the database. A)True
B)False
Q5) A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.
A)True
B)False
Q6) What is one important limitation of the Simple Query Wizard?
B)False Page 43
Q7) All Excel spreadsheets are ready to import into an Access database. A)True
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) Expression Builder inserts ________ that tell you where each argument belongs.
A)rows
B)fields
C)placeholders
D)columns
Q2) Which of the following is NOT a total row option?
A)Pmt
B)Avg
C)Count
D)Where
Q3) Which of the following is NOT a Pmt function argument?
A)rate
B)present_value
C)future_value
D)loan_payment
Q4) When creating a calculated field,field names are enclosed in ________.
Q5) A(n)________ displays the results of the aggregate functions as the last row in the Datasheet view.
Q6) To create complicated expressions,you would use the ________ tool.
Q7) Explain how the Pmt function is used and identify two of its required arguments. Page 45
To view all questions and flashcards with answers, click on the resource link above. Page 46
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) You would use a(n)________ to add data into or edit data in a table.
Q2) A subform combines two views of the same record source
A)True
B)False
Q3) When in Layout or Design view,which of the follow is NOT a form layout tab?
A)Design
B)Edit
C)Layout
D)Format
Q4) The ________ source is also referred to as the data source.
Q5) The width of a field in a report can be changed in either Report or Design views.
A)True
B)False
Q6) A(n)________ is a defined set of colors,fonts,and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.
Q7) Give two reasons why using a form is better than using a table when adding,updating,and deleting data.
47
Q8) A(n)________ layout displays fields horizontally across a form.
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) Explain the difference between a lookup list and a multiple-value list.
Q2) 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])
Q3) If a field in a table has a ________ a drop down menu will appear in the field.
Q4) An input mask forces users to conform to a specific data-entry format for a given field.
A)True
B)False
Q5) When you use the ________ operator,each criterion must be true for the compound criterion to be true.
A)Like
B)Between C)And
D)Not
Q6) What can you use to create an expression to calculate lapsed time?
To view all questions and flashcards with answers, click on the resource link above. Page 48
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) Why is it better to enter zero in a field instead of leaving the field blank?
Q2) Why should you backup your database before testing an action query?
A)Action queries change data in your database that cannot be reversed.
B)Action queries change data in your database but the changes are temporary.
C)Action queries do not make any changes to your database.
D)Action queries duplicate data in your database.
Q3) The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.
A)True
B)False
Q4) What summarizes a data source into a grid of rows and columns?
A)Crosstab query
B)Append query
C)Make table query
D)Find duplicates table
Q5) Delete,append,and update queries are all examples of a(n)________ query.
Q6) An append query selects records from one or more tables and uses then to create a new table.
A)True
B)False Page 49
To view all questions and flashcards with answers, click on the resource link above. Page 50
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) If no caption has been set for a field,the label will default to the field name.
A)True
B)False
Q2) When a form has been created as read-only,it should be renamed to indicate it is read-only.
A)True
B)False
Q3) What is the difference between a form header and a page header?
Q4) 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
Q5) What is the difference between a bound control and an unbound control?
Q6) The ________ section in a report repeats for each record in a record source.
Q7) After inserting a line into a form or report,you can modify the color,thickness and line type.
A)True
B)False Page 51
To view all questions and flashcards with answers, click on the resource link above. Page 52
Chapter 37: Access: Get Connected: Exchanging Data
Between Access and Other Applications
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39882
Sample Questions
Q1) A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.
A)hyperlink
B)software application
C)ScreenTip
D)command
Q2) When you export an object from Access to Word,Access creates a file in the PDF format.
A)True
B)False
Q3) Why should you examine the Access table in your source fie before linking it?
Q4) Why is it easy to export Access tables to Excel?
Q5) A(n)________ is the location of a Web site or Web page on the Internet.
A)URL
B)HTTP
C)HTML
D)PDF
Q6) What is the disadvantage of linking an Excel spreadsheet from Access?
Page 53
Q7) You can ________ information from Access to another file format such as Word,Excel or PDF.
To view all questions and flashcards with answers, click on the resource link above. Page 54
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) Name two situations that violate 1NF.
Q2) The ________ contains the queries,forms,and reports of the database.
A)back-end database
B)database documenter
C)front-end database
D)design tools
Q3) A(n)________ occurs when the value of one field is determined by the value of another.
A)functional dependency
B)non-key field
C)composite key
D)primary key
Q4) ________ makes the database unreadable by encrypting the database.
A)Password protect
B)Make ACCDE
C)Digital Signature
D)Encryption
Q5) ________ dependency occurs when the value of one field is determined by the value of another field.
Q6) What are the benefits of normalization? Page 55
To view all questions and flashcards with answers, click on the resource link above. Page 56