Microsoft Excel Basics and Functions Guide
Translated by
ScribdTranslationsMicrosoft Excel Basics and Functions Guide
Translated by
ScribdTranslationsanswer key
01 - What is Microsoft Excel?
a file manager.
b) An electronic spreadsheet.
c) A figure cataloger
an electronic dictionary.
02 - Where can we apply Excel?
To create budgets, payment scheduling, simulate tax forms
of income, expenses of
supermarkets, etc.
03 - What does the freeze Panels option do?
She locks the cell above and to the left of the on position.
where the cursor is located, as if it were frames of
spreadsheet.
04 - What is a cell?
a) An Excel function.
b) A unit of the spreadsheet in which data is entered and stored.
c) It is the name given to a set of numbers.
It is the name given to a workbook.
05 - If we copy the formula = AVERAGE (B2:B9) that is in cell D11 and
We will paste it in cell F15. What will happen?
The formula will be modified to = AVERAGE(D6:D13) in
Cell F15.
06 - How can we allow typing in some cells and protect others
against typing in the same spreadsheet?
Selecting the cells where typing will be allowed, triggering the cells command
from the format menu, unchecking the locked checkbox and activating
the protect sheet command from the tools menu.
07 - What does the IF Function do?
Returns the value if a condition that you specify evaluates as true and another
value will be evaluated as false.
08 - What is a selected cell?
It is the one in which the selector is found, but with more emphasis.
09 - How to add more pages to a spreadsheet?
Just right-click on the tab of the page and choose the
Insert Spreadsheet command and press the Ok button.
11 - Dragging the edge on the right side of a column header in an Excel spreadsheet,
a Change shall be provoked:
a) of the column name
b) Of the column number
c) Of the column width
from the height of the column
Both in width and in height.
13 - Mark the option that presents only Excel functions:
a) Average, Now, Det, Sen
b) Soma, Mínimo, Média, SE
c) Sum, Maximum, Ceiling, Total
d) Pgto, Mínimo, Soma, Dobro
14 - These are valid functions in Excel, except
a) Minimum
b) Ipgto
c) Somase
d) Statistics
e) [Link]
Common questions
Powered by AIThe Freeze Panels option in Microsoft Excel is used to lock rows and columns so that they remain visible while scrolling through the rest of the worksheet. It specifically locks the cells above and to the left of the cursor's position, similar to creating frames for the spreadsheet .
Understanding and utilizing only valid functions in Excel is crucial because invalid functions can lead to errors, misinterpretations, and inaccuracies in data analysis. Using invalid functions may result in undefined behaviors or calculation errors, which can compromise data integrity and decision-making .
To add more pages to an existing Excel spreadsheet, one should right-click the current sheet’s tab, choose the Insert Spreadsheet command, and press OK. This is useful for organizing data across multiple sheets, maintaining clarity, and handling complex datasets .
In Microsoft Excel, a 'cell' is defined as a unit of the spreadsheet where data is entered and stored. It serves as the fundamental building block of the spreadsheet, crucial for organizing and managing data .
The IF function in Excel can greatly enhance decision-making processes by allowing conditional evaluations. It can return specified values based on whether certain conditions evaluate to true or false, enabling users to implement logical tests and automate responses based on varying criteria within a spreadsheet .
Dragging the edge of a column header in an Excel spreadsheet changes the column's width. This feature allows for adjusting the visual layout of data, helping accommodate content size or improve readability without affecting the column's name or number .
Valid Excel functions are those recognized by the software to perform specific calculations or data operations. Functions not recognized by Excel, such as 'Ipgto,' are considered invalid. Excel requires functions to have correct syntax and proper usage to be valid .
Microsoft Excel is primarily an electronic spreadsheet tool used for organizing, analyzing, and storing data. It is typically applied to tasks such as creating budgets, payment scheduling, and simulating tax forms related to income and expenses, such as those from supermarkets .
When a formula is copied to another cell in Excel, the references in the formula adjust relative to the new location. For example, if the formula =AVERAGE(B2:B9) is copied from cell D11 to F15, it changes to =AVERAGE(D6:D13), indicating a shift relative to the new cell's position .
To allow typing in certain cells while protecting others in an Excel spreadsheet, first select the cells where typing is permitted. Then, go to the format menu, choose the cells command and uncheck the 'locked' checkbox. Finally, activate the protect sheet command found in the tools menu to enforce the protection .