Desktop Applications for Business
Final Exam Questions
Course Introduction
This course introduces students to the fundamentals of developing, utilizing, and managing desktop applications in a business environment. Emphasis is placed on understanding how desktop software can enhance productivity, streamline business operations, and support decision-making processes. Students will explore a range of common business applications such as word processors, spreadsheets, presentation software, and databases. The course also covers best practices for software selection, customization, integration, data management, and security. Through hands-on projects and case studies, learners will gain practical skills in using and configuring desktop applications to meet business needs.
Recommended Textbook
Your Office Microsoft Office 2016 Volume 1 1st Edition by Amy S. Kinser
Available Study Resources on Quizplus
18 Chapters
1777 Verified Questions
1777 Flashcards
Source URL: https://quizplus.com/study-set/707 Page 2
Chapter 1: Understanding the Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13798
Sample Questions
Q1) In Windows 10,________ mode is used when every action is expected to be touch.
Answer: tablet
Q2) Windows 10 allows a user to set up different Start menus and experiences for different purposes,known as configuring multiple ________ desktops.
A) user
B) live
C) virtual
D) multitasking
Answer: C
Q3) A picture that represents a program or application in the Windows 10 Start menu is called a ________.
A) ribbon
B) snip
C) Tile
D) charm
Answer: C
Q4) In Windows 10,notifications appear in the ________.
Answer: Action Center
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Explore Windows and File Management
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13803
Sample Questions
Q1) C :\Users\username\OneDrive is an example of a(n)________.
A) AutoRecovery in progress
B) ScreenTip
C) file extension
D) file path
Answer: D
Q2) A(n)________ is a small storage device that can be easily lost.
A) USB drive
B) OneDrive
C) zip drive
D) cloud
Answer: A
Q3) Cloud computing can refer to either hardware or software.
A)True
B)False
Answer: True
Q4) A(n)________ drive is a small,portable storage device.
Answer: USB,USB flash
Q5) Office ________ can be opened by pressing F1.
Answer: Help
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Review and Modify a Document
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13793
Sample Questions
Q1) The Word ________ screen displays when Microsoft Word 2016 is opened.
A) Open
B) Beginning
C) Start
D) Navigation
Answer: C
Q2) ________ is an alignment style that spreads text evenly between the right and left margins so that lines begin on the left margin and end uniformly on the right margin.
Answer: Justified
Q3) The ________ paragraph line spacing setting in a Microsoft Word 2016 document is more commonly used in desktop publishing.
A) At Least
B) Multiple
C) Exactly
D) Double
Answer: A
Q4) A(n)________ symbol can be used to represent characters and numbers when using the Find and Replace feature.
Answer: wildcard
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Create and Edit a Document
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/13792
Sample Questions
Q1) Microsoft Office enables you to copy text from a Word document and paste it into other Office documents.
A)True
B)False
Q2) A page ________ is a line or graphic that surrounds a page.
Q3) When you change a style's formatting options,the new options are immediately applied to all text that has been formatted in that style within the current document.
A)True
B)False
Q4) When indenting the first line of paragraph from the left margin,use a hanging indent.
A)True
B)False
Q5) The default bullet in Word is a ________.
A) round, empty, black circle
B) round, filled-in, black circle
C) filled in black square
D) empty black square
Q6) Indentation is considered to be a type of ________ formatting.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Include Tables and Objects
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13791
Sample Questions
Q1) A text box can be created from scratch by using the ________ Text Box option.
Q2) The Text box and SmartArt graphics use the same ________ tab.
Q3) To center a text box horizontally on a page,click ________ on the Format tab,and then select Align Center.
A) Align Text Box
B) Align
C) Center Align
D) Align Objects
Q4) To ensure that a picture does not get skewed,on the Format tab,click the Layout Dialog Box Launcher in the Size group,and select ________ aspect ratio in order to maintain the picture's size ratio.
A) Align
B) Lock
C) Adjust
D) Set
Q5) A table ________ is the intersection of a column and a row.
A) heading
B) grid
C) cell
D) box
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Special Document Formatting and Mail Merge
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13790
Sample Questions
Q1) Mail merge options are available on the ________ tab.
A) Layout
B) References
C) Mailings
D) Review
Q2) A design element in which the first letter of a paragraph is shown as a large graphic representation of the letter is a(n)________ cap.
A) extra large
B) superscript
C) enhanced
D) drop
Q3) When you click any text on a bibliography or works cited page,a content control tab,titled ________,appears at the top of the selected list of citations.
A) Update Citations and Bibliography
B) Update Bibliography
C) Citations
D) Citations and Bibliography Page
Q4) To track changes in a document,click the Track Changes button on the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter
Worksheets
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/13802
Sample Questions
Q1) A comment is indicated by the presence of a ________ in the upper-right corner of a cell.
A) red square
B) green square
C) red triangle
D) green triangle
Q2) A file that contains one or more worksheets is a(n)________.
Q3) To move up one screen,you use the Ctrl + PgUp keyboard shortcut.
A)True
B)False
Q4) By default,________ data is left-aligned in a cell.
Q5) By default,numeric data is right-aligned in a cell.
A)True
B)False
Q6) A ________ is a grid of columns and rows in which data is entered.
A) database
B) presentation
C) document
D) worksheet
Q7) The cells on a worksheet that have been selected are a cell ________. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Formats, Functions, and Formulas
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13801
Sample Questions
Q1) Which of the following is NOT true about working with formulas?
A) In Excel, formulas always begin with an equal sign.
B) When a formula that contains cell references is copied to another cell, the cell reference will change to reflect the destination cell relative to the original cell.
C) To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert.
D) Cells that contain formulas can be treated like any other worksheet cell.
Q2) Excel presents information graphically via charts and graphs based on the tabular information in worksheets.
A)True B)False
Q3) When you filter table data,the ________ values will automatically be recalculated.
Q4) To paint a format to more than one nonadjacent cell,you can double-click Format Painter and then select nonadjacent cells.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above.
11
Chapter 9: Cell References, Named Ranges, and Functions
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13800
Sample Questions
Q1) The TRIM function returns text from which any leading,trailing,or extra spaces between words have been removed.
A)True
B)False
Q2) What is the error message when you attempt to use a cell that has been deleted as a function argument?
A) #NPV?
B) #NAME?
C) #REF!
D) #N/A
Q3) When using a text string in an argument,enclose the string in ________ so Excel will recognize it as a text string rather than a named range.
A) asterisks * *
B) brackets [ ]
C) parentheses ( )
D) quotes " "
Q4) Excel's WEEKDAY function returns a number from 1-7 or 0-6.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Effective Charts
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13799
Sample Questions
Q1) When first creating a chart,best practice dictates that you first consider and develop the basic ________ of the chart.
Q2) In Excel,there are ________ types of trendlines.
A) 5
B) 2
C) 4
D) 6
Q3) A ________ chart is similar to a column chart except the data is horizontal instead of vertical.
A) bar
B) combination
C) area
D) pie
Q4) To open the Format Chart Area task pane,right-click the chart border,and then select ________.
A) Format Properties
B) Chart Properties
C) Format Chart Area
D) Chart Formatting dialog box
Q5) You should use the ________ effect and rotation of a chart conservatively.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: The Four Main Database Objects
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/13804
Sample Questions
Q1) A column or field in an Access table is also known as a(n)________.
Q2) The Navigation Pane is located on the ________ when Access is opened.
A) top
B) bottom
C) right side
D) left side
Q3) What you learn about one relational database can be transferred to other relational databases.
A)True
B)False
Q4) Before working in a database,it is beneficial to explore the database ________.
Q5) To create objects,a(n)________ can be used to serve as a step-by-step guide.
Q6) To see how a report would look in a continuous page layout,open the report in ________.
A) Report view
B) Print Preview
C) Layout view
D) Design view
Q7) To move through the data in a table,Access provides a(n)________ at the bottom of the table.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Tables,Keys,and Relationships
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13805
Sample Questions
Q1) The ________ data type stores a maximum of 255 characters in the field.
A) Short Text
B) Long Text
C) OLE Object
D) Lookup Wizard
Q2) Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________.
A) a query
B) a report
C) a form
D) the relationship window
Q3) A phone number field would be best formatted as the ________ data type.
Q4) If you accidentally delete the wrong record,you can click Undo to restore it.
A)True
B)False
Q5) To ensure that information is entered,sorted,and displayed consistently,an input mask can be defined in a field.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Queries and Data Access
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13806
Sample Questions
Q1) Which of the following is NOT true regarding calculated fields?
A) The result of the calculated field is displayed each time you run the query.
B) A calculated field can be added to a query using the fields in the query or even fields in another table or query in the database.
C) A calculated field is stored in the table once the query is saved.
D) The calculation can use a combination of numbers and field values, which allows you flexibility in how you perform the calculation.
Q2) The ________ is a tool in Access that can help you format your calculated fields correctly.
Q3) A(n)________ field is a field used to determine the order of the records.
Q4) To search for a three-digit number that starts with "67" you would enter 67*.
A)True
B)False
Q5) The ________ contains a list of properties for fields in which you can make precise changes to each property associated with the field.
Q6) A filter is a condition you apply temporarily to a table or query.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Using Forms and Reports in Access
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/13807
Sample Questions
Q1) When navigating a main form,pressing ________ will move the cursor to the last field of the current record.
A) Home
B) End
C) Tab
D) Ctrl + Home
Q2) Form view is only for viewing data,so to make any changes to the form you need to switch to either Print Preview or Design view.
A)True
B)False
Q3) When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the main form and the second table you select becomes the ________.
A) joined form
B) co-form
C) split form
D) subform
Q4) Calculations performed on a group in a report are added to a section called the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Presentation Fundamentals
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13797
Sample Questions
Q1) During a presentation,pressing ________ will advance to the next slide.
A) Back arrow
B) Down arrow
C) F5
D) F6
Q2) A PowerPoint file with predefined layouts,theme colors,and fonts is called a(n)________.
Q3) A(n)slide ________ is displayed at the bottom of the slide and can include items such as the slide number or date.
Q4) When using Slide Sorter view,the selected slide is highlighted by ________.
A) red circles at each corner
B) an orange border
C) a red border
D) orange circles at each corner
Q5) When beginning to create a presentation,it is suggested that you use the ________ view.
A) Outline
B) Normal
C) Notes
D) Slide Show
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: Text and Graphics
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13796
Sample Questions
Q1) A PNG graphic can be substituted for a GIF and has more features than JPEG.
A)True
B)False
Q2) ________ fonts are easy to read on the screen,help to protect the eyes from strain,and reduce stress.
Q3) Typography is the the art of selecting and arranging text on a page.
A)True
B)False
Q4) A vertical guide is used to align objects vertically.
A)True
B)False
Q5) Format Painter is located in the ________ tab.
A) Editing group on the Home
B) Editing group on the Design
C) Clipboard group on the Home
D) Clipboard group on the Design
Q6) ________ fonts are considered formal,businesslike,and powerful.
Q7) An ordered list can use either bullets or numbers.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 17: Multimedia and Motion
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13795
Sample Questions
Q1) Once imported into a photo album,photographs can be rotated in 45-degree increments.
A)True
B)False
Q2) To view a slide show from the beginning,press ________.
Q3) Buttons and triggers enable the start of ________ actions.
A) motion
B) multimedia
C) transition
D) animation
Q4) There are ________ categories of transition types.
Q5) Hyperlinks give your audience a chance to interact with your presentation.
A)True
B)False
Q6) The file extension for a Windows Media video file is .wmv.
A)True
B)False
Q7) Objects that already contain animations are called triggers.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 18: Customization and Collaboration
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/13794
Sample Questions
Q1) ________ is an add-in to PowerPoint that turns PowerPoint presentations into interactive lessons.
Q2) A file with predefined layouts,theme colors and fonts,and sample content that enables you to quickly produce a professional,consistent slide show is called a(n)________.
Q3) You can modify the headers and footers of notes through the View tab,using Notes Master view.
A)True
B)False
Q4) Because PowerPoint 2016 has been optimized for widescreen monitors and tablets,the slides are generally displayed in a(n)________ ratio.
Q5) Speaker notes display in the Speaker Notes pane of the PowerPoint window. A)True
B)False
Q6) There is a difference between memorizing the presentation and memorizing the outline.
A)True
B)False
Q7) The ________ group of a company generally develop its corporate identity.
Page 21
To view all questions and flashcards with answers, click on the resource link above.