Microsoft Excel

Relative Cell Reference

Excel adjusts the cell references and copies a formula relative to the answer cell.

Absolute Cell Reference

denoted with $ preceding each col/row refernece

Default Reference Type in Excel

Relative references

For test practice what each formula will do

What are functions in Excel, and why are they useful?

They can replace long or complicated formulas, making calculations easier and more efficient.

What types of functions can you find under the Financial category?

you can find functions related to interest calculations, monthly payments, and other financial operations.

What does the AutoSum feature allow you to do?

The AutoSum feature allows you to quickly sum a range of cells without creating a lengthy formula, making it easier to calculate totals.

What is a cell range, and how is it represented?

A cell range is represented by two different cell references separated by a colon (e.g., D3:D12) and includes all cells between those two references.

What is the purpose of number formats in Excel?

Number formats tell Excel exactly what type of data you are using, helping it to display and interpret the data correctly.

What is the default number format for every cell in an Excel spreadsheet?

the default number format is called the general format.

How can you modify the display of a date in Excel?

by selecting a different number format, such as the long date option.

What mistake can occur when entering percentages in Excel?

If you enter just a number like 8 and then apply percentage formatting, Excel may interpret it as 800% instead of 8%.

Does changing the number format in Excel affect the actual value of the data?

No, changing the number format only affects how the data is displayed; the actual value remains the same as shown in the formula bar.

What techniques can be applied for acquiring data in MS Excel?

importing data

from external sources,

using data entry forms

, and web scraping.

What are the key methods for storing data in MS Excel?

Data can be stored in tables, named ranges, and structured worksheets.

How can quantitative data be validated in Excel? ufe

Using data validation tools, formulas, and error-checking features.

What security requirements should be followed when handling data in Excel?

Enabling file protection, use passwords and limit accesibily

What are some sources from which Excel can acquire qualitative data?

Survey results, interview transcripts, and open-ended questionnaire responses.

How can Excel help analyze designs against criteria? CPD

conditional formatting, pivot tables, and data analysis tools.

How can Excel improve accessibility in data analysis? aad

accessibility checker, adding alt text, and designing clear spreadsheets.

What is an example of using Excel to enhance functionality in data management?

Implementing macros to automate repetitive tasks.

How does Excel support usability in data handling?

user-friendly data entry forms.

What is the importance of aesthetics in Excel design?

Clear formatting, color coding, and structured layouts improve readability.

How can Excel be used to compare designs against set criteria?

Using scoring models with weighted criteria in formulas.

What are the risks of poor data validation in Excel? EIM

Errors in decision-making, inaccurate reports, and misinterpretation of data.

Why is it important to use appropriate technical terms in Excel?

Ensures clarity and accuracy in documentation and data interpretation.

What role does Excel play in data-driven decision-making? hvg

Helps analyze trends, visualize data, and generate reports for insights. hvg

How does Excel handle both qualitative and quantitative data? CPT

Through features like charts, pivot tables, and text analysis functions.

What Excel feature allows for analyzing large datasets efficiently?

PivotTables help summarize and analyze large volumes of data.

What are key formatting techniques to improve data presentation in Excel?

Conditional formatting, cell styles, and proper alignment for clarity.

Cell comments

provide additional information about cell content. You can do this by adding a comment which is hidden from view until selected.

Sparklines

Sparklines are mini cell charts that help visualise table data.