answersLogoWhite

0

📱

Microsoft Excel

Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.

9,788 Questions

How do you insert a photo in Excel when the sheet is protected?

You do not enter anything into a worksheet that is protected, unless the protection settings allow you to do so. You need to unprotect the sheet, insert the photo, then protect the sheet again. If the protection is locked with a password, then you need to contact the spreadsheet author to get the password. There are many ways to remove the password from an Excel workbook, but I will not discuss that topic here.

What are the definitions of alignment left right centered and justified?

LEFT - Align all text even at the left margin, while letting it remain ragged on the right.

RIGHT - Align all text even at the right margin, while letting it remain ragged on the left.

CENTER - Align all text to center between the left and right margins, while letting it remain ragged on the left and right.

JUSTIFIED (FULL) - Align all text at both left and right margins, so each side is aligned straight on both sides. The computer will calculate spacing between words to ensure there are the appropriate number of spaces to reach both margins.

How do you calculate tiles quantity?

in a square/rectangular room, count the tiles across and the tiles along then multiply.

Difference between what if analysis and goal seeking analysis?

A what if analysis is used to check what happens when different values are entered into a situation, like changing the prices for items, or how much of an item is ordered or different rates of exchange for a currency. Using it, business people can see what happens if they were to do different things in their business and it can help make the best choices.

Goal Seek allows you to find a specific value that will make a calculation give a particular result. At a very simple thing it could be like find what value you need to add to 10 to get the total 14. Obviously that will be 4, but in some spreadsheets you will be looking to find a value that is not so simple to work out. Goal Seek will help.

What are counta's parametres?

Its parameters can be either a range of cells, a list of individual cells, or even values, which can be numbers text and even blank:

=COUNTA(A4,A6,B6,C15)

=COUNTA(B2:B25)

=COUNTA(1,"A",,,,"Do",2,128)

What is a radar chart?

A radar chart, also known as a spider or web chart, is a graphical representation used to display multivariate data in the form of a two-dimensional chart. It consists of a series of axes emanating from a central point, each representing a different variable or category. Data points are plotted on these axes, and lines connect them to form a polygon, allowing for easy comparison of multiple variables across different entities. Radar charts are often used in performance analysis, sports statistics, and market research to visualize strengths and weaknesses.

The order in which calculations are performed in a formula is called the?

The order in which calculations are performed in a formula is called the order of operations.

What kind of chart is similar to a line chart?

An Area chart. It fills the space below the line until the next line or x-axis with a solid fill colour.

Why would a personal budget only need one worksheet?

A personal budget is likely to have very few entries compared to the budget of a large organisation. A user setting up a personal budget could choose to use different worksheets for different aspects of their budget, but it is probably simpler for them to put it on one worksheet.

What happens in the Overtype mode in Excel?

If there is something in the cell, it will be overwritten by what is being typed in.

In Excel What is the preferred method for removing Sparklines?

You can use the Clear option in the Sparkline tools. You can also just press the Delete key on the cell.

Insert missing letter FKILV?

The missing letter in the word "FKILV" is O. The word should be FKILOV.

What is a formula that can perform more than one calculation at a time?

Many formulas can perform more than one calculation at a time. A simple example for Excel is =SUM(A1:A12,B14:B23,D6:D32) .

How do you change column width in Excel?

Use AUTOFIT, which finds the widest value in a column and sets the width to that. It is found in the Format menu, under Column. It can also be done by putting the mouse between the column headings for two columns until you get a double-headed arrow, and then double clicking.

What is a leader line in Excel?

Excel does not use leader lines, because it does not use tabs. You would find leader lines in MS Word.

What is used in Excel to make it stand out from the rest?

Lots of things can be used in Excel to make something stand out from the rest. You can change the colors, increase the font size, use a different font, put borders around things, bold them, underline them, italicize them and more.

There is also an Autoformat feature which allows you to apply pre-designed styles to your spreadsheet.

However, for the Crossword Puzzle Challenge, your answer is "bold".

What tab do you click on to insert a table?

On versions of Word prior to the introduction of ribbons, there is a Table menu and on that you will find the Insert sub-menu from which you can insert a table.

When would you use a power function and when would you use a exponential function?

Both of these functions are found to represent physical events in nature. A common form of the power function would be the parabola (power of 2). One example would be calculating distance traveled of an object with constant acceleration. d = V0*t + (a/2)*t².

The exponential function describes many things, such as exponential decay: like the voltage change in a capacitor & radioactive element decay. Also exponential growth (such as compound interest growth).

What does to chart a course mean?

It means to plan an activity or a trip.

Reducing or enlarging the display of a worksheet?

Use VIEW, or hold down the control key and rool the mouse wheel.