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
What is a the function of a mentor?
A mentor is someone who comes alongside you to help you through situations you haven't dealt with before, but the mentor has, or has some knowledge in how to overcome the situation.
Histogram
How do you find percentage error in Microsoft excel?
=(A1/B1)*100
then press Ctrl + Shift + % and the cell will be displayed as a percent
What makes a pictogram more compelling than a bar chart?
Because it uses pictures to communicate, therefore simple symbols can be used to communicate amongst many languages and cultures
Can a chart be saved on the same worksheet as the data or on a separate worksheet?
A chart can be saved on the same worksheet or on a separate worksheet in Excel. The easiest way to put a chart on a separate worksheet is to create your chart on the same worksheet as your data. After you create your chart, just cut and past to the worksheet where you want it to show.
It depends on what you are trying to show, but a bar chart or a line chart could present that information.
Are worksheet and spreadsheet interchangeable?
MS Excel is considered a Spreadsheet program and sheets within an Excel file are referred to as worksheets. In other words, MS Excel is a spreadsheet program that produces worksheets but not a worksheet program that produces spreadsheets.
Actually, the above is wrong. worksheet and spreadsheet are interchangable.
What does the find-and-replace feature do?
The find-and-replace feature in a word processor allows the user to search for every occurrence of a particular character, word, or phrase within a document and replace it with new text.
It is the process of arranging a group of selected cells in a row or column numerically or alphabetically, in either ascending or descending order.
xlsx
Creating Inventory controls, for another example, can control the quantity in stock, location, number of sales per day month year and calculate minimum and maximus stocks with simple formulas.
How do you insert a floating dollar sign?
Format the cell for Currency if you want the dollar sign to be immediately before the first number (floating dolar sign). Format the cell for Accounting if you want the dollar sign to stay to the left side of the cell no mater the length of the entry (fixed dollar sign).
What is the difference between manual and electronic spreadsheets?
Manual spreadsheets are made with a pencil on paper. Electronic spreadsheets are made with a program on a computer.
A document, often organized alphabetically, designed as a quick reference for experienced users.
Yes, that is true.
Insertion means that something has been inserted or the act of inserting something. The word insertion is of Latin origin.
When data in a spreadsheet programs changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
A faulty pronoun reference may be when:
- the pronoun does not have a clear antecedent (vague or hidden reference)
- the pronoun does not agree with its noun antecedent in number and gender (faulty agreement)
Examples:
Jim went with Ted to his father's store. (whose father?)
She hid the disk in her purse, but she lost it. (the disk or her purse?)
He gave his car to his brother because he was going to college. (who?)
The cooks think the steaks are too tough, so we'll have to pound them.
The police caught the crooks after they dressed up as women.
