INF_101_INFORMATICA

Excel and Power point questionnaire.

1. What is Excel?
2. Stories and Evolution of Spreadsheets?
3. What is a Row?
4. What is a Column?
5. How Many Rows And Columns Does Excel Have?
6. What is a spreadsheet?
7. What is a cell?
8. What is a range?
9. What is a cell address?
10. What is a disjoint range?
11. What is the context menu?
12. What is a relative reference?
13. What is an absolute reference?
14. Mention and define Excel toolbars.
15. Mention and define the statistical functions and the Database functions.

Power point questionnaire

1. What is a slide?
2. What is a PowerPoint view?
3. How can presentations be distributed?
4. Within animations, what is an interval? And for examples:
5. What is a portable presentation?
6. What is an animation effect and what types of animations can be applied?
7. Within animations, what is a motion path?
8. What is a pattern?
9. What are the rules?
 10. What is a slide design?
11. What is an animation trigger?
12. What is a control?
13. What is a color scheme?
14. What is a design template?
15. What is a custom presentation?
16. What is an OLE object?
17. What is a digital signature?
18. What is a digital certificate?
19. What is Rehearsal Intervals for?
20. What is a presentation packaged for?
21. What is a slide master?

Excel questionnaire
1. What is Excel?
Excel is an application developed by Microsoft and is part of the Microsoft Office
productivity software suite. It is a spreadsheet software, which means that it is primarily
used to perform tasks related to numerical data processing and analysis, as well as
creating graphs and tables.
Excel spreadsheets are organized into rows and columns, forming a grid where you can
enter data and perform different types of mathematical, statistical and financial
calculations. This allows for a wide range of tasks to be carried out, such as budgeting,
data analysis, inventory records, accounting, and other functions related to the
management of numerical information.
Excel offers a wide variety of predefined functions and formulas that make it easy to
perform complex calculations and arithmetic operations. It also allows the creation of
graphs and dynamic tables, which enables a clearer and more understandable
visualization of the data.
In addition, Excel is used in various fields, such as businesses, organizations,
education, research and in everyday tasks, due to its flexibility and usefulness in
managing data effectively and efficiently.

2. Stories and Evolution of Spreadsheets?

Spreadsheets have an interesting history and evolution that goes back decades. Below
is a summary of its evolution:
1. 1960s: The first spreadsheets were developed in the 1960s by IBM for internal use.
However, they were not widely known or used outside of programmer and data scientist
circles.
2. 1970s: In 1978, Dan Bricklin and Bob Frankston created the first commercially
successful spreadsheet called "VisiCalc" for the Apple II computer. VisiCalc allowed
users to perform complex calculations more quickly and easily, making it a success and
contributing significantly to the popularization of spreadsheets.
3. 1980s: The 1980s witnessed the explosion of spreadsheet use in business and
education. Competition increased, and several popular spreadsheets emerged,
including Lotus 1-2-3 and Quattro Pro, which rivaled VisiCalc. These programs
introduced additional features such as graphics and macros.
4. 1990s: In 1993, Microsoft launched Excel as part of its Microsoft Office productivity
suite. Excel has become one of the most popular and widely used spreadsheets in the
world, and remains a fundamental tool in the business environment.
5. 2000s: In this decade, spreadsheets evolved to include more advanced features and
greater data handling capabilities. More complex functions, interactive graphics and
data analysis tools were introduced. In addition, spreadsheets became increasingly
integrated with other applications and online services.
6. Present: Today, spreadsheets continue to be widely used in various industries and
fields. In addition to Excel, there are cloud-based spreadsheets and other online
applications that allow for real-time collaboration and access from different devices.
In short, spreadsheets have undergone a significant evolution from their beginnings to
the present day, and have gone from being tools exclusively for data experts to being
commonly used and essential tools in the business and educational world.

3. What is a Row? in Excel

A row in Excel is a horizontal series of cells in the spreadsheet.

4. What is a Column?
A column in Excel is a vertical series of cells in the spreadsheet. Each column is
identified by a letter at the top of the sheet, starting from the letter "A" and continuing to
the right of the alphabet.
Like rows, cells within a column can contain different types of information, such as
numbers, text, dates, formulas, etc.
5. How Many Rows And Columns Does Excel Have?
The number of rows and columns in Excel depends on the specific version you are
using. Until Excel 2003, the maximum number of rows was 65,536 and the maximum
number of columns was 256.
Starting with Excel 2007 and later versions (Excel 2010, Excel 2013, Excel 2016, Excel
2019, and Excel in Microsoft 365), there has been a significant change in the program's
capabilities. Excel now supports a much larger number of rows and columns.
In modern versions of Excel:
- The maximum number of rows is 1,048,576.
- The maximum number of columns is 16,384.
This means that Excel currently has a spreadsheet with a grid of over one million rows
and over sixteen thousand columns, providing ample capacity to handle large data sets
and perform complex analysis.

6. What is a spreadsheet?
A spreadsheet is a type of digital document that is used to perform tasks related to the
processing and analysis of numerical data, as well as to organize information in a
structured manner. It is designed in the form of a grid composed of rows and columns,
where each intersection of row and column is called a "cell". Each cell can contain
different types of data, such as numbers, text, dates, formulas, among others.
Spreadsheets are widely used in various areas such as business, accounting,
education, research, financial planning, inventory tracking and many other fields. Some
of the main features of a spreadsheet are:
1. **Data Entry**: Users can enter data into spreadsheet cells, allowing them to create
tables with specific information.
2. **Formulas and functions**: Spreadsheets allow you to perform mathematical
calculations and complex operations through the use of predefined formulas and
functions.
3. **Charts and pivot tables**: It is possible to create graphs and pivot tables from the
data entered, making it easier to view and analyze the information.
4. **Automation**: Spreadsheets allow for the automation of tasks through the use of
macros and scripts, which speeds up work and reduces errors.
5. **Data Analysis**: Data analysis functions in spreadsheets help you draw important
statistics, trends, and conclusions from your data.
6. **Organization and filtering**: Data can be efficiently organized and filtered to find
specific information within large data sets.
Microsoft Excel is one of the most popular and widely used spreadsheet programs, but
there are also other alternatives, such as Google Sheets, LibreOffice Calc and Apple
Numbers, among others. Spreadsheets are powerful tools for data management and
manipulation, which makes them indispensable in the professional and academic fields.

7. What is a cell?
In Excel, a cell is the basic unit of a worksheet. It is the rectangular space in which data
can be entered, displayed and manipulated. Each cell has a unique reference that
identifies it within the spreadsheet and is located at a specific intersection of a row and
a column.
A cell can contain different types of information, such as numbers, text, dates, formulas,
or functions. When you enter a value into a cell, that value is displayed inside the cell
and can be used to perform calculations, data analysis, and other operations.
A cell's location is identified by a combination of a column letter and a row number. For
example, the cell at the intersection of column B and row 3 is identified as B3. Each cell
in the spreadsheet has a unique address that allows its contents to be accessed and
manipulated.
Cells are the basis for organizing and presenting information in a spreadsheet. You can
select individual cells, groups of cells (ranges), apply formatting, enter data, perform
calculations, and create charts and pivot tables from the data contained in the cells.
Cells are fundamental to the functioning and usefulness of Excel, allowing you to
organize and analyze data efficiently and effectively.

8. What is a range?
In Excel, a range is a group or set of contiguous cells selected in a worksheet. The
range can be either horizontal (a row of cells) or vertical (a column of cells), or a
combination of both.
For example, if you select a range of cells from cell A1 to cell A5, you would be creating
a vertical range that includes five cells in column A. Similarly, if you select a range from
cell B2 to cell E2, you would be creating a horizontal range that includes four cells in
row 2.
It is also possible to select a larger range, including multiple rows and columns at the
same time. For example, if you select a range from cell C3 to cell E6, you would be
creating a rectangular range that includes all cells from C3 to E6, forming a block of 3
rows and 3 columns.
Ranges are fundamental in Excel, as they allow you to apply operations, formulas,
formatting, and other actions to a specific set of cells together and efficiently. They are
also useful for performing calculations on organized data and for creating charts and
pivot tables based on a group of selected cells. The ability to work with ranges is
essential to taking full advantage of Excel's features and tools in data analysis and
processing.

9. What is a cell address?

A cell address is a way to identify a specific cell within a spreadsheet in Excel or other
spreadsheet applications. It consists of a combination of a column letter and a row
number that indicate the exact location of the cell in the spreadsheet grid.
In Excel's cell referencing system, columns are labeled with letters from A to Z, then
from AA to ZZ, and so on. Rows are numbered from 1 onwards. So the cell in the top
left corner of the spreadsheet is called A1, the next cell to the right is B1, and so on.
Some examples of cell addresses are:
- A1: The cell in the upper left corner of the spreadsheet.
- C3: The cell in the third row and the third column.
- F10: The cell in the tenth row and sixth column.
Cell addresses are essential for working with data in Excel, as they allow you to select,
reference, and perform operations on specific cells and ranges. They are also used in
formulas and functions to perform calculations based on data located in different cells.
Cell addresses make it easier to navigate and manipulate information in your
spreadsheet and are essential to taking full advantage of Excel's capabilities.

10. What is a disjoint range?

A disjoint range (also known as a non-contiguous range or non-adjacent range) is a set
of selected cells or areas that are not continuously connected in a worksheet. In other
words, a disjoint range is composed of two or more areas or groups of cells that are not
physically adjacent to each other.
To select a disjoint range in Excel, you must perform a non-continuous selection, that is,
select a group of cells and then hold down the "Ctrl" key (or "Cmd" on a Mac) while you
select additional areas that you want to include in the range. These areas can be in
different parts of the spreadsheet and do not need to be directly connected.
For example, to select a disjoint range, you could do the following:
1. Select the range A1:A5 (cells from A1 to A5).
2. Hold down the "Ctrl" key (or "Cmd" on Mac).
3. Select the range C1:C5 (cells C1 through C5) while holding down the "Ctrl" (or
"Cmd") key.
By doing this, you will have created a disjoint range that includes cells A1:A5 and
C1:C5.
Disjoint ranges are useful when you want to apply the same action or format to multiple
non-contiguous areas of your worksheet. For example, you can select a disjoint range
to apply specific formatting to different parts of the worksheet or to perform operations
on different sections of data. It's a useful feature that makes it easier to work with
complex spreadsheets and gives you greater flexibility in manipulating data in Excel.

11. What is the context menu?

Context menu, also known as pop-up menu or right-click menu, is a drop-down menu
that appears on the screen when you right-click on a specific item, such as a file, folder,
icon, or selected area in an application or operating system.
This type of menu provides quick access to various options and actions related to the
selected item. The content of the context menu may vary depending on the context in
which it is opened and the application being used.
In the case of Excel, the context menu is very useful for performing various quick
actions on cells, ranges, or specific elements of the spreadsheet. When you right-click
on a cell or range of cells, Excel's context menu offers options such as copy, cut, paste,
insert, delete, change formatting, apply formulas, and many other functions relevant to
data handling and work in the spreadsheet.
The context menu is a common feature in many applications and operating systems,
and provides a quick and convenient way to access relevant functions and options
depending on the context you are working in. It is a powerful tool to improve efficiency
and user experience when using different programs and platforms.

12. What is a relative reference?

In Excel, a relative reference is a type of cell reference used in formulas that
automatically adjusts when you copy or fill the formula to other cells. When you use a
relative reference in a formula, the cell references remain relative to the position of the
cell that contains the formula, meaning that the references change relative to the new
position of the formula.
Relative referencing is distinguished by not having dollar signs ($) in front of the column
letters and row numbers in the reference. For example:
- If you have the formula in cell B2: `=A2+B1`, and you copy it down one row (into cell
B3), the formula will automatically adjust the references to the cell immediately above it
(i.e. `A3` and `B2`).
- If you copy the same formula to the right (into cell C2), the references will
automatically adjust to the cell immediately to the left (i.e. `B2` and `C1`).
This makes it easier to copy and fill formulas into different cells, as Excel automatically
adjusts the references to calculate values based on the relative position of the formula
in relation to the referenced cells.
In short, a relative reference is a form of cell reference that automatically changes
based on the new position of the formula in the worksheet, allowing you to perform
repetitive calculations and operations efficiently and dynamically.

13. What is an absolute reference?

In Excel, an absolute reference is a type of cell reference used in formulas that remains
constant when you copy or fill the formula to other cells. Unlike relative reference which
adjusts automatically, absolute reference remains fixed and does not change its position
relative to the cells it references.
Absolute reference is distinguished by having dollar signs ($) in front of the column
letters and row numbers in the reference. For example:
- If you have the formula in cell B2: `=$A$2 + $B$1`, and you copy it down one row (into
cell B3), the formula will keep the same references to cells `A2` and `B1`, without
adjusting them.
- If you copy the same formula to the right (in cell C2), the references will also remain
unchanged (`$A$2` and `$B$1`).
Using absolute references is useful when you need to perform calculations based on
fixed or constant values that should not change when you copy the formula. For
example, when calculating taxes or applying a conversion factor, where the values used
in the formula must be kept constant.
To create an absolute reference in Excel, you can press the "F4" key after selecting a
cell reference in the formula bar, or simply manually add dollar signs before the column
letters and row numbers in the reference.
In short, an absolute reference is a form of cell reference that remains unchanged when
you copy or fill the formula into different cells, allowing you to set constant values in
specific calculations and operations in Excel.

14. Mention and define Excel toolbars.

In previous versions of Excel, toolbars were used to quickly access various functions
and commands. However, starting with Excel 2007, Microsoft introduced the Ribbon,
which replaced the traditional toolbars. Below I mention the main toolbars that were
used in previous versions and their definitions:
1. **Standard Toolbar**: This bar contains buttons to perform common actions, such as
saving a file, copy, paste, undo, among others.
2. **Format toolbar**: This bar contains tools for formatting cells, such as changing the
font, size, color, and style of text, aligning content, applying borders and backgrounds,
etc.
3. **Drawing toolbar**: This bar provides access to tools for creating and editing graphic
objects and drawings, such as shapes, lines, text boxes, images, and so on.
4. **Formula toolbar**: In this bar you can write and edit mathematical formulas and
functions to perform calculations in cells.
5. **Table Toolbar**: This toolbar allows you to create, format, and edit tables in Excel.
It is important to mention that although toolbars are no longer as prominent in newer
versions of Excel, the functionality they provided is still present in the Ribbon and Quick
Access Panel, allowing you to access Excel's various tools and commands in an
intuitive and efficient manner.

15. Mention and define the statistical functions and the Database functions.

**Statistical functions in Excel:**

1. **SUM**: This function sums the numeric values in a specified range of cells. For
example, "=SUM(A1:A5)" adds the values in cells A1, A2, A3, A4, and A5.
2. **AVERAGE**: Calculates the arithmetic average of a range of cells containing
numbers. For example, "=AVERAGE(A1:A5)" returns the average of the values in cells
A1 through A5.
3. **COUNT**: Counts the number of cells in a range that contain numeric values. For
example, "=COUNT(A1:A5)" counts how many cells have numeric values in the range
A1 to A5.
4. **MAX (MAX)**: Returns the largest value in a range of cells that contains numbers.
For example, "=MAX(A1:A5)" returns the largest number in cells A1 through A5.
5. **MIN (MIN)**: Returns the smallest value in a range of cells that contains numbers.
For example, "=MIN(A1:A5)" returns the smallest number in cells A1 through A5.
6. **MEDIAN**: Calculates the median of a range of cells containing numbers. The
median is the middle value in an ordered set of data. For example, "=MEDIAN(A1:A5)"
returns the median of the values in cells A1 through A5.

**Database Functions in Excel:**

1. **DAVERAGE**: Calculates the average of the values in a range of a database that
meet certain criteria. This function requires a database range, a field to apply the criteria
to, and a criterion that the rows to consider meet.
2. **DCOUNT**: Counts the cells that contain numbers in a specific field of a database
that meet certain criteria. Like the DASVERAGE function, this function also requires a
database range, a field to apply the criteria to, and the search criteria.
3. **DSUM**: Sums the values in a specific field of a database that meet certain criteria.
Like the previous functions, it also requires a database range, a field to apply the criteria
to, and the search criteria.
These Database functions are useful for performing more advanced calculations and
analysis on large data sets organized in tables. They allow criteria to be applied to
extract specific data and perform statistical operations on them.

Power point questionnaire

PowerPoint Quiz

1. **What is a slide?**
A slide is an individual page in a PowerPoint presentation. Each slide can contain text,
images, charts, tables, shapes, and other multimedia elements. Slides are used to
organize and present information in a clear and visually appealing manner.
2. **What is a PowerPoint view?**
PowerPoint offers different views to work and view a presentation:
- Normal View: Displays the current slide with the notes area and slide thumbnails.
- Slide Sorter view: Displays all slides in thumbnail form for easy organization.
- Slide Show View: Displays the presentation in full screen for audience viewing.
- Master View: Allows you to edit the slide master, which affects all slides in the
presentation.

3. **How can presentations be distributed?**

PowerPoint presentations can be distributed in a variety of ways:
- Sending the PowerPoint file (.pptx) by email or messaging.
- Sharing it on online platforms or cloud storage services.
- Exporting it as a PDF file to share with users who do not have PowerPoint.
- Presenting it live during a meeting or conference.

4. **Within animations, what is an interval? And examples:**

A gap in PowerPoint animations is the time between the start of one animation and
the start of the next. It is the time that is set for each effect or animated transition
between slides or elements of a slide. For example, an interval of 1 second means that
the effect will complete in 1 second before the next effect starts.

5. **What is a portable presentation?**

A portable presentation, also known as a PPS file or slide show, is a version of a
PowerPoint presentation that can be played directly in the PowerPoint viewer without
opening the full program. This format is used to share the presentation without the
recipients making any changes to the content.

6. **What is an animation effect and what types of animations can be applied?**

An animation effect in PowerPoint is a transition or motion applied to an element, such
as text, an image, or a shape, to highlight or enhance its appearance during the
presentation. Some examples of animation effects include fades, slides, spins, and
more.
7. **Within animations, what is a motion path?**
A motion path is a type of animation effect that allows you to animate an object along
a predefined path. You can adjust the path by dragging its control points to customize
the path the object will follow during the animation.

8. **What is a pattern?**
A master slide in PowerPoint is a master slide that defines the layout, formatting, and
style for all slides in a presentation. When you edit the master, your changes will
automatically be applied to all slides in the presentation that use that master.

9. **What are the rules?**

Rulers in PowerPoint are horizontal and vertical lines that appear in Normal view and
help you align and position elements on your slides. They allow you to measure the
distance from the margins of the slide and facilitate the precise layout and alignment of
objects on the slide.

10. **What is a slide design?**

A PowerPoint slide layout is a pre-designed template that determines the appearance
and formatting of the slides in a presentation. Slide layouts contain predefined color
schemes, font types, background styles, and placements for titles, text, images, and
other elements. Using a slide layout makes it easy to create professional, visually
coherent presentations.

11. **What is an animation trigger?**

An animation trigger in PowerPoint is an object or element that is set to start an
animation or transition on the slide when a specific action occurs. For example, clicking
on a button or image can trigger an animation to display additional text or an image.

12. **What is a control?**

A control in PowerPoint refers to interactive elements that can be added to a
presentation to enhance the user experience during a presentation. Some examples of
controls are buttons, check boxes, drop-down lists, and scroll bars. Controls are
commonly used in interactive presentations or forms to capture audience responses or
actions.

13. **What is a color scheme?**

A color scheme in PowerPoint refers to a predefined set of colors that are applied to the
presentation to establish a coherent and harmonious color scheme. By using a color
scheme, you ensure that presentation elements such as text, backgrounds, and shapes
look visually pleasing and coordinated.

14. **What is a design template?**

A PowerPoint design template is a file that contains a set of preset slides with specific
layouts and styles. Design templates serve as a foundation for creating new
presentations more quickly and easily by providing a predetermined structure and
format for your slides.

15. **What is a custom presentation?**

A custom PowerPoint presentation refers to a sequence of slides selected specifically
for a particular audience or event. Instead of displaying all the slides in the presentation,
a custom presentation allows the presenter to choose specific slides to tailor the
presentation to the needs and interest of the audience.

16. **What is an OLE object?**

OLE (Object Linking and Embedding) is a Microsoft technology that allows users to
insert and manipulate objects or data from other applications within Office documents,
such as PowerPoint. An OLE object can be an Excel spreadsheet, a chart, a Word
document, or any other type of content from other applications embedded in a
PowerPoint slide.

17. **What is a digital signature?**

A digital signature is a cryptographic mechanism used to guarantee the authenticity and
integrity of a document or electronic message. In the context of PowerPoint, a digital
signature can be added to a presentation to verify that the content has not been altered
since the signature was added and that the author is who they claim to be.
18. **What is a digital certificate?**
A digital certificate is an electronic file that contains information about the identity of an
entity (such as a person, organization, or website) and its public key. Digital certificates
are used to establish authenticity and security in online connections and
communications, such as digital signature and data encryption.

19. **What is the purpose of Rehearsing Intervals?**

Rehearsal Timing is a feature in PowerPoint that allows the presenter to practice the
presentation in real time, seeing how the slides and animations will be displayed as they
progress through them. This allows the presenter to familiarize themselves with the flow
of the presentation and ensure that everything is working as expected before presenting
to an audience.

20. **What is a presentation packaged for?**

Packaging a PowerPoint presentation means collecting all associated elements (such
as images, audio or video files, fonts, and links) into a folder or compressed file. This
makes it easy to move or send the entire presentation, ensuring that all necessary
resources are included and

avoiding broken link issues when moving the presentation to another computer.

21. **What is a slide master?**

A slide master in PowerPoint is a master slide that defines the layout, formatting, and
style for all the slides in a presentation. When you edit the master, your changes will
automatically be applied to all slides in the presentation that use that master.