Module 4: Excel Worksheets and Amortization

Consolidation in the context of data analysis refers to:

• the process of combining multiple data sources into a single, unified view.

• the analysis of data trends over time.

• the separation of data into distinct categories.

• the visualization of data using charts and graphs.

The WEEKDAY function is used to:

• Return the day of the week as a number

• Calculate the number of weekdays between two dates

• Determine if a date falls on a weekend

• Convert a date to a text string

A linear series in data management is:

• a sequence of data points arranged in a straight line

• a random collection of data points

• a circular arrangement of data points

• a hierarchical structure of data points

A growth series is a sequence of numbers or data points that shows the progression of growth over time. How is it used?

• To analyze trends and make predictions

• To create artistic designs

• To measure temperature changes

• To calculate distances

What is a date series and how is it applied in spreadsheets?

• A sequence of dates used for calculations and analysis in spreadsheets.

• A type of chart used to display data trends over time.

• A function to sort data alphabetically in spreadsheets.

• A tool to create pivot tables in spreadsheets.

Explain the concept of an auto fill series.

• An auto fill series is a feature that automatically fills cells with data following a specific pattern.

• An auto fill series is a tool used to manually enter data into cells one by one.

• An auto fill series is a method to delete data from a spreadsheet.

• An auto fill series is a feature that prevents data entry errors by locking cells.

The WORKDAY function is used to:

• Calculate the number of working days between two dates

• Add a specified number of workdays to a date

• Determine the day of the week for a given date

• Calculate the total number of days in a month

Define serial number in the context of data organization.

• A unique identifier assigned to individual items for tracking and identification purposes.

• A random number assigned to data entries without any specific order.

• A sequence of numbers used to perform mathematical operations.

• A code used to encrypt data for security purposes.

The TODAY function in a spreadsheet:

• Returns the current date

• Calculates the difference between two dates

• Formats a date to a specific style

• Adds a specified number of days to a date

What is meant by Normal style in document formatting?

• A standard formatting style used in documents

• A unique style for each document

• A style used only for headings

• A style used only for footnotes