Spreadsheet Management
Mock Exam
Course Introduction
Spreadsheet Management is a course designed to equip students with practical skills in using spreadsheet software for data organization, analysis, and presentation. The course covers foundational and advanced functions, including data input, formatting, formulas, and chart creation. Students learn how to manage large datasets, apply data validation, use filtering and pivot tables, and automate tasks with macros. Through hands-on activities and real-world scenarios, the course prepares students to efficiently solve business problems, perform financial analysis, and support decision-making processes using spreadsheets.
Recommended Textbook
Exploring Microsoft Excel 2013 Comprehensive 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
22 Chapters
1288 Verified Questions
1288 Flashcards
Source URL: https://quizplus.com/study-set/1852
Page 2
Chapter 1: Introduction to Access: Hands-On-Exercise
Videos
Available Study Resources on Quizplus for this Chatper
20 Verified Questions
20 Flashcards
Source URL: https://quizplus.com/quiz/37009
Sample Questions
Q1) Where are the changes to an Access table saved as soon as you move the insertion point?
A) To memory
B) To a storage location
C) To the cloud
D) To the desktop
Answer: B
Q2) A ________ key is the field in the related table that you would use to connect to the primary key in another table.
A) secondary
B) foreign
C) composite
D) merged
Answer: B
Q3) A table can only be sorted on a single field.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 3: Customize, analyze, and Summarize Query
Data: Hands-On-Exercise Videos Available Study Resources on Quizplus for this Chatper 15 Verified Questions 15 Flashcards
Source URL: https://quizplus.com/quiz/37013
Sample Questions
Q1) When a(n)________ query is run,it contains an extra row that displays aggregate data.
A) aggregate
B) totals
C) summary
D) condensed Answer: B
Q2) The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.
A) PricePerRoom
B) ListPrice
C) Beds
D) Baths
Answer: A
Q3) What is the value of =4+3*2^2?
A) 16
B) 28
C) 40
D) 196
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Creating and Using Professional Forms and Reports:
Videos
Source
https://quizplus.com/quiz/37015
Sample Questions
Q1) When Access creates a form with two record sources having a one-to-many relationship,the one record source is displayed in the main form and the many record source is display in a ________.
A) subform
B) report
C) query
D) register
Q2) Which of the following is NOT a form view?
A) Form
B) Edit
C) Layout
D) Design
Q3) You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.
A)True
B)False
Q4) A report can be saved as a PDF file so users without Access can view it.
A)True
B)False
6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Data Validation and Data Analysis:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
18 Verified Questions
18 Flashcards
Source URL: https://quizplus.com/quiz/37017
Sample Questions
Q1) If a validation rule is not met,you CANNOT continue until the data value meets the rule.
A)True
B)False
Q2) You would use the ________ function to calculate the current date.
A) Now()
B) Today()
C) Present()
D) Date()
Q3) When most people in a database reside in New York,you should make NY the ________ value for the State field.
A) data validation rule
B) default
C) lookup field
D) input mask
Q4) When creating a parameter query,the prompt is enclosed in ________.
A) parentheses ( )
B) braces { }
C) brackets [ ]
D) quotations " "
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Action and Specialized Queries:
Source URL: https://quizplus.com/quiz/37019
Sample Questions
Q1) You CANNOT edit a crosstab query.
A)True
B)False
Q2) You would use a(n)________ query to remove the records of former employees from a table.
A) erase
B) dispose
C) delete
D) exclude
Q3) You should back up your database before testing an action query.
A)True
B)False
Q4) The ________ Query Wizard would be used to compare customer records in the Customer and Order tables to determine which customers have made no purchases.
A) Find Unmatched
B) List Unmatched
C) Find Missing
D) List Missing
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced Forms and Reports:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
12 Verified Questions
12 Flashcards
Source URL: https://quizplus.com/quiz/37021
Sample Questions
Q1) Advanced controls can be used in forms but not in reports.
A)True
B)False
Q2) A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.
A)True
B)False
Q3) You can adjust the tab order to control the advancement from one field or control to the next.
A)True
B)False
Q4) Form headers or report footers are examples of form or report ________.
A) subdivisions
B) divisions
C) segments
D) sections
Q5) A text box can be converted into a combo box.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Get Connected: Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/37023
Sample Questions
Q1) When importing a text file,________ is a common file extension for files that are not fixed-length.
A) pdf
B) csv
C) docx
D) rtf
Q2) You can export an Access table or form to another Access database.
A)True
B)False
Q3) You are limited to one attachment per record.
A)True
B)False
Q4) You CANNOT export Access data to a(n)________.
A) Excel spreadsheet
B) Word document
C) Access table
D) PowerPoint presentation
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Fine-Tuning the Database: Hands-On-Exercise
Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/37025
Sample Questions
Q1) To prevent users from making changes to a database,you can save it as a(n)________ file.
A) PDF
B) ACCDE
C) RTF
D) ACCDB
Q2) You should consider using the Database Splitter tool to see if the performance of a database can be improved.
A)True
B)False
Q3) Which of the following is NOT a result of running the Performance Analyzer tool?
A) Suggestions
B) Commands
C) Recommendations
D) Ideas
Q4) A digitally signed database requires a password to open it.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Using Macros and SQL in Access:
Hands-On-Exercise
Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/37027
Sample Questions
Q1) SQL stands for Sequential Query Language.
A)True
B)False
Q2) Which of the following events is NOT a type of macro that can be created in Access?
A) stand-alone
B) data
C) embedded
D) encapsulated
Q3) A named macro can be used to send an e-mail message when a form is used to change an entry in a table.
A)True
B)False
Q4) You can use an SQL statement in place of a table or query record source.
A)True
B)False
Q5) You can only create data macros from within a table. A)True
B)False
12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: 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/37008
Sample Questions
Q1) Good database design begins with grouping data into correct tables,a practice known as ________.
Q2) A(n)________ system is a software system that offers tools needed to create,maintain,and use a database.
Q3) When forming relationships in a relational database,the ________ from one table must be joined to the foreign key of another table.
Q4) The ________ displays the number of the current record as well as the total number of records in a table.
Q5) A filter and a sort always produce the same results in an Access database. A)True
B)False
Q6) Which of the following is FALSE about the Undo feature in Access?
A) You can click Undo to reverse the most recent change to a single record.
B) You can use Undo to reverse multiple edits in Access.
C) In Access, the Undo feature works the same as it does in other Office programs.
D) You can click Undo to redo a change that you made previously.
Q7) Offer three examples of interactions that you may have had with databases (knowingly or unknowingly)within the last week.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Office Fundamentals and File Management:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/37028
Sample Questions
Q1) To delete a folder,you:
A) double-click the folder and click Delete from the menu.
B) right-click the folder and click Delete from the menu.
C) click the folder and click Delete on the Ribbon.
D) click the folder and click Delete in the Homegroup.
Q2) A file is a collection of folders.
A)True
B)False
Q3) Typing bare instead of bear is an example of a word usage error and will have a blue underline.
A)True
B)False
Q4) You can use the ________ to quickly copy formatting from one section of text to another.
A) Quick Access Toolbar
B) Ribbon
C) Clipboard
D) Format Painter
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 14: 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/37010
Sample Questions
Q1) If a user selects the ________ Related Fields option while creating a relationship,Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.
Q2) An example of a ________ field is a field for sales associates' bonus--.05 multiplied by quarterly sales.
A) multitable
B) logical
C) numeric
D) calculated
Q3) Two or more tables that contain duplicate data are an example of:
A) one-to-many relationships.
B) data redundancy.
C) many-to-many relationships.
D) data backup.
Q4) Fields can be renamed either in Design view or in Datasheet view.
A)True
B)False
Q5) ________ tables are tables that are joined from one table to another through a common field.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: 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/37012
Sample Questions
Q1) Explain what the order of operations is and why parentheses might be needed when evaluating an expression.Give a specific example of where parentheses would be need.
Q2) The arguments to a function are enclosed in:
A) brackets.
B) parentheses.
C) braces.
D) single-quotation marks.
Q3) Explain what the Expression builder is,and how it is used.
Q4) Calculated fields are created in the Datasheet view of a table.
A)True
B)False
Q5) Expression Builder inserts ________ that tell you where each argument belongs. A) rows
B) fields
C) placeholders
D) columns
Q6) It is NOT possible to add a condition to a Totals query.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: 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/37014
Sample Questions
Q1) All of the following are report creation tools EXCEPT:
A) Report Design.
B) Report Wizard.
C) Report Layout.
D) Blank Report.
Q2) Design view can be used to alter the report design while still viewing the data.
A)True
B)False
Q3) The form Layout view can be used for all of the following EXCEPT:
A) adding or removing a field.
B) changing the order of fields.
C) adding a calculated field.
D) changing the width of a field.
Q4) Labels and Text Boxes are known as controls.
A)True
B)False
Q5) ACCDB is a file type used to exchange documents independent of software applications and operating systems.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 17: 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/37016
Sample Questions
Q1) The ________ function checks if a field does not contain a value
Q2) The data validation method that causes fields to be limited to predefined list of values is a:
A) lookup list.
B) default value.
C) data macro.
D) validation text.
Q3) A parameter query prompt is enclosed in parentheses.
A)True
B)False
Q4) ________ is the first method for controlling data input in a field of a table.
A) Selecting an appropriate data type
B) Creating an appropriate default value
C) Creating an appropriate validation rule
D) Creating a data macro
Q5) What does a IsNull function do?
Q6) The ________ function returns a number rounded to a specific number of decimal places.
Q7) A(n)________ forces data entry into a table or form to conform to a specific format. Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
Chapter 18: 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/37018
Sample Questions
Q1) What is the best precaution to take prior to running an update query?
Q2) If you run a make table query again at a later time,what happens?
A) The table is replaced with the new up-to-date table.
B) The new table will show as it was when it was created.
C) All new information is lost.
D) It will select the new records from the table and delete them.
Q3) How do appended records appear in the destination table?
Q4) Action queries include update,append,make table,and delete.
A)True
B)False
Q5) To test an update query before running the query,what should you do first?
A) From Design view, click View in the Results group and click Datasheet view.
B) From Design view, click the Run button.
C) From Design view, verify that all fields are listed.
D) From Design view, click Update in the Query type group.
Q6) You should NOT rerun an action query.
A)True
B)False
Q7) You would use a(n)________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number. Page 21
To view all questions and flashcards with answers, click on the resource link above.
Page 22
Chapter 19: 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/37020
Sample Questions
Q1) When creating a form or report,you can insert an image file containing the company logo.
A)True
B)False
Q2) A(n)________ is text not tied to a specific field.
A) label
B) text box
C) calculated control
D) control box
Q3) To add emphasis to a form or report,use the Line control or the Rectangle control.
A)True
B)False
Q4) Which of the following appears once at the bottom of each page in a form or report?
A) Form or Report Page Footer
B) Form or Report Footer
C) Form or Report Page Header
D) Form or Report Header
Q5) What will cause a group to print on a separate page?
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 20: 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/37022
Sample Questions
Q1) What is the disadvantage of storing attachments in your database?
Q2) PDF documents are the preferred format when exporting from Access.
A)True
B)False
Q3) In Access,what is a reference to an external file called?
A) Attachment
B) Paperclip
C) Field
D) OLE object
Q4) ________ allows you connect to a table without having to import the table data into your database.
A) Linking
B) Copying
C) Pasting
D) Moving
Q5) What are the two most common types of text files that can be imported into Access?
Q6) Why is it easy to export Access tables to Excel?
Q7) A(n)________ data type enables you to quickly link to any file on your computer or to any Web page on the Internet. Page 24
To view all questions and flashcards with answers, click on the resource link above.
Page 25
Chapter 21: 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/37024
Sample Questions
Q1) What is the difference between first,second,and third normal form?
Q2) What are four ways to keep your database application safe?
Q3) What are the three Performance Analyzer result types?
Q4) The Performance Analyzer lists three kinds of analysis results: recommendations,suggestions,and ideas.
A)True
B)False
Q5) What are two formats Database Documenter reports can be saved in?
A) PDF or XPS
B) PDF or WPX
C) XPS or XLS
D) PDF or CSV
Q6) ________ creates a report that contains detailed information about the tables and other selected objects in your database.
A) Database Documenter
B) Performance Analyzer
C) Database Splitter
D) Oracle
26
Q7) Any field that is not part of the primary key is called a(n)________.
Q8) What is the main reason for splitting a database?
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 22: Using Macros and SQL in Access: Advanced Techniques
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/37026
Sample Questions
Q1) An SQL keyword defines the purpose and the structure of a SQL statement.
A)True
B)False
Q2) Which SQL statement sets the criteria for the rows in the results?
A) WHERE
B) SELECT
C) FROM
D) ORDER BY
Q3) To run one macro from within another,use the RunDataMacro action.
A)True
B)False
Q4) An embedded macro is a database object that you create and use independently of other controls or objects.
A)True
B)False
Q5) What are the four keywords of an SQL SELECT statement?
Q6) Most SQL statements begin with SELECT and end with a colon(:).
A)True
B)False
Q7) How do you attach a macro to an event? Page 28
To view all questions and flashcards with answers, click on the resource link above. Page 29