100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Test Bank for The Shelly Cashman Series® Microsoft® Office 365® & Excel® Comprehensive | 2025, 1st Edition by Wilson (All Chapters included) CA$42.32   Add to cart

Exam (elaborations)

Test Bank for The Shelly Cashman Series® Microsoft® Office 365® & Excel® Comprehensive | 2025, 1st Edition by Wilson (All Chapters included)

 7 views  0 purchase
  • Course
  • The Shelly Cashman Series® Microsoft® Office 365®
  • Institution
  • The Shelly Cashman Series® Microsoft® Office 365®

Complete Test Bank for The Shelly Cashman Series® Microsoft® Office 365® & Excel® Comprehensive | 2025, 1st Edition by Rob Wilson ; ISBN13: 9780357881613.....(Full Chapters included from Chapter 1 to 11)...1. Creating a Worksheet and a Chart. 2. Formulas, Functions, and Formatting. 3. Working...

[Show more]

Preview 4 out of 1396  pages

  • October 25, 2024
  • 1396
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • The Shelly Cashman Series® Microsoft® Office 365®
  • The Shelly Cashman Series® Microsoft® Office 365®
avatar-seller
TEST BANK



The Shelly Cashman Series® Microsoft®
Office 365® & Excel® Comprehensive | 2025
1st Edition by Rob Wilson



Complete Chapters Test Bank
are included (Ch 1 to 11)



** Immediate Download
** Swift Response
** All Chapters included
** Access 365
** Excel 365
** Outlook
** Teams
** Technology for Success
** Windows 11
** Word 365

,Table of Contents are given below




1. Creating a Worksheet and a Chart.
2. Formulas, Functions, and Formatting.

3. Working with Large Worksheets, Charting, and What-If Analysis.

4. Financial Functions, Data Tables, and Amortization Schedules.
5. Working with Multiple Worksheets and Workbooks.

6. Creating, Sorting, and Querying a Table.

7. Creating Templates, Importing Data, and Working with SmartArt,

Images, and Screenshots.

8. Working with Trendlines, PivotTable Reports, PivotChart Reports, and

Slicers.
9. Formula Auditing, Data Validation, and Complex Problem Solving.

10. Data Analysis with Power Tools and Creating Macros.
11. User Interfaces, Visual Basic for Applications (VBA), and
Collaboration Features in Excel.

,Name: Class: Date:

Access 365 Module 01

1. Before you close a database, you must save any changes you made to the data.

a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct.
Incorrect Incorrect.
POINTS: 1
REFERENCES: SCAC 1-19
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: SCAC.CENG.25.1.7 - Add records to a table.
CORPORATE STANDARDS: 3654 - Save a record.
TOPICS: Shelly Cashman Series: Creating a Table Using Datasheet View
KEYWORDS: Bloom's: Understand
DATE CREATED: 5/7/2024 12:47 PM
DATE MODIFIED: 5/7/2024 12:47 PM

2. In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a
database.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct.
Incorrect Incorrect.
POINTS: 1
REFERENCES: SCAC 1-4
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: SCAC.CENG.25.1.2 - Create a database.
CORPORATE STANDARDS: 1345 - Create a blank desktop database.
TOPICS: Shelly Cashman Series: Creating a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 5/7/2024 12:47 PM
DATE MODIFIED: 5/7/2024 12:47 PM

3. To rename a form, open the form, and then use the Rename command on the Home tab.

a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct.

Page 1

, Name: Class: Date:

Access 365 Module 01

Incorrect Incorrect.
POINTS: 1
REFERENCES: SCAC 1-40
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: SCAC.CENG.25.1.15 - Explain special database operations.
CORPORATE STANDARDS: 3330 - Rename a form in the Navigation pane.
TOPICS: Shelly Cashman Series: Performing Special Database Operations
KEYWORDS: Bloom's: Apply
DATE CREATED: 5/7/2024 12:47 PM
DATE MODIFIED: 5/7/2024 12:47 PM

4. You can use the Compact and Repair Database button in the Info gallery to reduce the size of the database.

a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct.
Incorrect Incorrect.
POINTS: 1
REFERENCES: SCAC 1-39
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: SCAC.CENG.25.1.15 - Explain special database operations.
CORPORATE STANDARDS: 1237 - Compact and repair a database.
TOPICS: Shelly Cashman Series: Performing Special Database Operations
KEYWORDS: Bloom's: Understand
DATE CREATED: 5/7/2024 12:47 PM
DATE MODIFIED: 5/7/2024 12:47 PM

5. To navigate to a record in a table, switch to Table Design view.

a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct.
Incorrect Incorrect.
POINTS: 1
REFERENCES: SCAC 1-21
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: SCAC.CENG.25.1.4 - Create a table using Datasheet view.
CORPORATE STANDARDS: 2989 - Navigate to the previous record in Table Datasheet view.
Page 2

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller mizhouubcca. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for CA$42.32. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

85169 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
CA$42.32
  • (0)
  Add to cart