Fundamentals of Office Software
Exam Solutions
Course Introduction
This course offers a comprehensive introduction to essential office software applications commonly used in both academic and professional environments. Students will gain practical skills in word processing, spreadsheet management, presentation design, and basic database handling. Emphasis is placed on creating, formatting, and editing documents, analyzing and visualizing data, delivering effective presentations, and utilizing collaborative tools. Through hands-on exercises and real-world scenarios, students will develop proficiency with popular office software suites, preparing them for efficient digital communication and productivity in the workplace.
Recommended Textbook
New Perspectives Microsoft Office 365 and Office 2016 Introductory 1st Edition by Patrick Carey
Available Study Resources on Quizplus
18 Chapters
1311 Verified Questions
1311 Flashcards
Source URL: https://quizplus.com/study-set/1430
Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28362
Sample Questions
Q1) Which Access feature provides information about Access commands and features and instructions about how to use them?
A)Query Wizard
B)Access Help
C)Form Wizard
D)Report Wizard
Answer: B
Q2) Each row in an Access table datasheet displays which of the following?
A)a query
B)a record
C)a field
D)a data type
Answer: B
Q3) A database or a relational database is a collection of related tables._________________________
A)True
B)False
Answer: True
Q4) The default ____________________ provided by Access is the ID field.
Answer: primary key
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Building a Database and Defining Table
Relationships
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28363
Sample Questions
Q1) A record in a table that is related to a primary table but has no matching record established with the primary table.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity
Answer: G
Q2) The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.
Answer: Single
Q3) Field name display in database objects such as datasheets,forms,and reports is determined by the ____________________ property.
Answer: Caption
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Maintaining and Querying a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28364
Sample Questions
Q1) Hiding a field in Datasheet view removes the field from the current table.____________________
A)True
B)False
Answer: False
Q2) A query based on more than one table is a(n)____query.
A)multiple
B)advanced
C)relationship
D)multitable Answer: D
Q3) Which aggregate function would be used to calculate the lowest field value for the selected records?
A)Average
B)Minimum
C)Maximum
D)Count Answer: B
Q4) The default name for a new Access query is ____________________. Answer: Query1
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Creating Forms and Reports
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28365
Sample Questions
Q1) To design a form using the Form Wizard,begin by clicking on the ____ tab on the Access Ribbon.
A)HOME
B)CREATE
C)FILE
D)EDIT
Q2) Data in a form may only be modified in ____ view.
A)Form
B)Layout
C)Design
D)Datasheet
Q3) Data in a form created from the primary table is contained in the ____.
A)subform
B)subdatasheet
C)main datasheet
D)main form
Q4) The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.
Q5) A report formatted in _____________________ is wider than it is tall.
Q6) A report layout may be changed using options on the ____________________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Introduction to Cloud Computing and Office 365
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/28366
Sample Questions
Q1) Office 365 are versions of all of the following EXCEPT ____.
A)Access
B)OneNote
C)Excel
D)PowerPoint
Q2) If you want to perform a task that is not available in Office Online,open the file in the full version of the application._________________________
A)True
B)False
Q3) ____ is a collection of limited versions of Microsoft Office programs.
A)Office 365
B)Sky App
C)Office Online
D)Web App
Q4) Describe the differences between Office 365 and Office Online.
Q5) ____________________ is an online storage and file sharing service from Microsoft.
Q6) When you use a public computer,you will be required to enter the password associated with your ____________________ account to access files you have saved on OneDrive.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Essential Computer Concepts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28367
Sample Questions
Q1) The pointing device most likely to be found on a notebook computer is a(n)____.
A)touchpad
B)optical mouse
C)trackball
D)RF mouse
Q2) Operating environments provide a textual user interface (TUI)that acts as a liaison between the user and all of the computer's hardware and software.
A)True
B)False
Q3) ____ are instructions to a computer on how to process data.
A)Mods
B)Commands
C)Requests
D)Data exchanges
Q4) Trojan horses,spyware,and worms are all forms of ____.
A)viruses
B)malware
C)phishing
D)pharming
Q5) Most PCs use ____________________ SDRAM.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28368
Sample Questions
Q1) A(n)____________________ of the original range is placed in the new location without removing the original range from the worksheet.
Q2) ____ makes it easier to enter repetitive text in cells.
A)Editing mode
B)AutoFit
C)AutoComplete
D)AutoFill
Q3) A group of worksheet cells
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template
Q4) A(n)____________________ is a named operation that replaces the arithmetic expression in a formula.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28369
Sample Questions
Q1) Information that prints on each page,like a company name or logo,may be set as a
A)print setup
B)copied text
C)text header
D)print title
Q2) Formatting changes only the appearance of data-it does not affect the data itself._________________________
A)True
B)False
Q3) Because Antoinette is familiar with conditional formatting,she can use the _____,which provides access to the most common tools for data analysis and formatting.
A)Quick Tool Bar
B)Quick Analysis Tool
C)Quick Formatting Bar
D)Conditional Analysis Tool
Q4) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28370
Sample Questions
Q1) Which function counts how many cells in a range contain numbers,where value1,value2,and so forth are text,numbers,or cell references?
A)SUM
B)COUNT
C)COUNTA
D)AUTOSUM
Q2) The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1._________________________
A)True
B)False
Q3) The numbers,text,or cell references used by the function to return a value are called ____.
A)expressions
B)arguments
C)data
D)values
Q4) Optional arguments are always placed first in the argument list._______________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28371
Sample Questions
Q1) Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.
Q2) Each value from a data series is represented by a ________.
Q3) The ____ is the only one of the following charts to compare relative values from different categories to the whole.
A)pie
B)column
C)line
D)area
Q4) The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.
Q5) In pie charts,it's best to make the slice colors as similar as possible.___________
A)True
B)False
Q6) An _______ chart takes up less space than a chart sheet.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Internet Basics and Information Literacy
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28372
Sample Questions
Q1) Failure to cite the source of material that you use is called ____.
A)plagiarism
B)libel
C)right-warding
D)platonism
Q2) Because they are the most effective way to locate information on the web,the Address bar in Microsoft Edge provides access to a(n)____________________.
Q3) A(n)____________________ is a unique string of letters/numbers that make a web address easier to remember.
Q4) The APA and MLA citation schemes both call for citing all of the following EXCEPT ____.
A)the author's last name, if known
B)the day, month, and year the page was published
C)the webpage and website titles
D)the day, month, and year you viewed the page
Q5) Claiming someone else's work as your own is an ethical and a legal violation.
A)True
B)False
Q6) MLA stands for ____________________ Association.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Managing Your Files
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28373
Sample Questions
Q1) Sorting files means listing them in ascending order or descending order by a file detail._________________________
A)True
B)False
Q2) All of the following are methods for creating a new folder EXCEPT ____.
A)using the New folder button in the New group on the Home tab
B)double-clicking an existing folder and clicking "New" on the pop-up window
C)using the New folder button on the Quick Access Toolbar
D)right-clicking to display a shortcut menu that includes the New command
Q3) File Explorer uses backslashes to separate locations in a file path.
A)True
B)False
Q4) An example of sorting in ascending order is ____.
A)Z to A
B)9 to 0
C)latest to earliest date
D)A to Z
Q5) In the path "Computer Removable Disk (G:) Wizard Widgets Stock Staff·jpg" the name of the file is ____________________ .
Q6) What are the text's three main guidelines for creating folders?
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Creating a Presentation
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28374
Sample Questions
Q1) PowerPoint files consist of what looks like pages in a document.Ethan correctly calls these buttons ____.
A)slides
B)groups
C)ribbons
D)banners
Q2) When you print ____,the presentation is printed with one or more slides on each piece of paper.
A)Full Page Slides
B)Notes Pages
C)Outline
D)Handouts
Q3) The ____ ratio is the ratio of an object's height to its width.
A)image
B)pixel
C)aspect
D)proportion
Q4) A second-level item in a list is sometimes called a subitem.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Adding Media and Special Effects
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28375
Sample Questions
Q1) If a video is too long,or if there are parts you don't want to show during the slide show,you can ____ it.
A)clip
B)cut
C)crop
D)trim
Q2) The default transition is for one slide to disappear and the next slide to immediately appear on the screen.
A)True
B)False
Q3) The Info screen in Backstage view contains a(n)____ Media button as well as the Compress Media button.
A)Maximize
B)Minimize
C)Optimize
D)Recycle
Q4) If you need to use a custom theme frequently,you can store this file so that it appears in the Themes gallery on the DESIGN tab.Please describe how you go about saving a theme so that it appears in your Themes gallery.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28376
Sample Questions
Q1) To correct an error marked by either the spelling or grammar checker,you can right-click the error,and then select the correct replacement on the _______ menu.
A)file
B)pop-up
C)insert
D)shortcut
Q2) Line spacing is the amount of space that appears between lines of text within a paragraph.____________________
A)True
B)False
Q3) Discuss the use of color and special effects in formal documents.
Q4) In the _______ group on the HOME tab,you use the Line and Paragraph Spacing button to adjust paragraph and line spacing.
A)File
B)Fonts
C)Insert
D)Paragraph
Q5) The ____________________ allow you to change the way the document is displayed.
Q6) ____________________ orientation is the default orientation for Word documents.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28377
Sample Questions
Q1) If you press the ____ keys,the insertion point moves to the beginning of the document.
A)Ctrl+Home
B)Ctrl+End
C)Shift+Home
D)Shift+End
Q2) Word inserts page number fields below the bottom margin,in the area known as the footer,or above the top margin._________________________
A)True
B)False
Q3) Charlotte has added a citation to the documents on which she is working.In the process of her doing so,Word has added the source that she introduced to a ____ of sources,which is now available to any document created using the same user account on that computer.
A)Index
B)Master List
C)Roster
D)Glossary
Q4) By default,the ____________________ theme is applied in each new Word document.
18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Creating Tables and a Multipage Report
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28378
Sample Questions
Q1) There are default tab stops every one inch on the horizontal ruler._________________________
A)True
B)False
Q2) All of the following are options in the Delete menu EXCEPT ____.
A)Delete Cells
B)Delete Columns
C)Delete All
D)Delete Table
Q3) The outline of a cell turns orange when it is highlighted.
A)True
B)False
Q4) A main advantage to tab stops and tables is that when you edit data,____.
A)it saves automatically
B)the alignment remains intact
C)Word uses AutoComplete to anticipate your entries
D)Word automatically tabs data with the correct spacing
Q5) ____________________ appear at the end of a section or,in case of a document without sections,at the end of the document.
Page 19
Q6) There are ____________________ major types of tab stops.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 18: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28379
Sample Questions
Q1) A _______ file is a type of vector graphics file created specifically for Windows.
A).bmp
B).wmf
C)" ·jpg"
D)·png
Q2) A text box is considered a(n)shape._________________________
A)True
B)False
Q3) When Santo is formatting the text in his WordArt text box,he discovers that by default the text box is formatted with _______ text wrapping.
A)Tight
B)Behind Text
C)Through
D)Top and Bottom
Q4) Which of the text wrapping settings flows around the exact outline of an object?
A)Tight
B)Square
C)Through
D)Top and Bottom
To view all questions and flashcards with answers, click on the resource link above. Page 20