What are the features of MS Excel​

Answers

Answer 1
Then here are the excel features that you need to get a hold of:

Learn to use shortcuts. Once you are able to live without the mouse, you get the speed that counts. There are two types of shortcuts - one where you press a set of keys sequentially - like Alt>H>O>I to adjust column width. And the second where you simultaneously press a combination of keys - like Ctrl+Shift+L for applying filters or Ctrl+1 for the format numbers dialog box. It takes repetition to get the speed but once you are there, you get an edge.
Learn excel functions and apply them to build formulas. Start with easy ones like SUM, COUNT, SUMIF, COUNTIF, IF etc, then move to VLOOKUP, SUMIFS, COUNTIFS, HLOOKUP, INDEX, MATCH, then move to building nested complex formulas like IF inside an IF, VLOOKUP with HLOOKUP, INDEX+MATCH and so on.
Learn about data analysis and data aggregation. This includes tools like Pivot table, solver, goal seek, data tables, descriptive statistics, regression.
Learn about conditional formatting. Style and colour your spreadsheets.

Related Questions

A broadcast network is one in which a transmission from any one attached station is received by all other attached stations over a shared medium. Examples are a bus-technology local area network, such as Ethernet, and a wireless radio network. Discuss the need or lack of need for a network layer (OSI layer 3) in a broadcast network.

Answers

Answer:

In a broadcast network such as radio network for example a walkie talkie, the broadcasted transmission is received equally by all receivers indiscriminately which may lead to dissemination of classified information to an unauthorized receiver, therefore, the network layer is required is needed to ensure proper routing of the information

Similarly, when the all the broadcasters in one location are each trying to send messages to different receivers at another given location, there would be potential for network congestion and it would be difficult to send information through the network

When there is need for priority service the presence of a network layer is needed in the network

However, when the above functions performed by the network layer is not required, then, the network layer can be excluded, such as the communication between layers 4 - 7 of the OSI model

Explanation:

Pls help me!! I will give 35 points and mark brainliest !!!

Answers

Answer:I don’t see anything I’m so confused

Explanation:

why we have to inspect the tools and equipment?​

Answers

Answer:

The purpose of an inspection is to identify whether work equipment can be operated, adjusted and maintained safely, with any deterioration detected and remedied before it results in a health and safety risk.

Explanation:

hopefully this Helps!

Which is an example of a variable name written in camelcase?

Song Name
songName
song Name
SongNAME

Answers

Answer: songName

-DoggyMan5

a computer programmer draws a before writing a comouter program​

Answers

Answer:

Draws a flow chart

window is to pane as book is to​

Answers

Answer:

is to pages

Explanation:

Answer:

A window is made up of panes, and a book is made up of pages. The answer is not (choice a) because a novel is a type of book. The answer is not (choice b) because glass has no relationship to a book. (Choice c) is incorrect because a cover is only one part of a book; a book is not made up of covers.

is to the page

Explanation:

Once a table has been inserted into a message, how can a user add new rows or columns? Check all that apply. Place the cursor inside the table and press Enter. Place the cursor on the last cell and press the Tab key. Click the plus sign over a column or next to a row. Click the Insert tab, click Tables, and select a new table. Right-click for the insert options menu at the insertion point

Answers

Answer: A and E

A. Place the cursor on the last cell and press the Tab key.

B. Right-click for the insert options menu at the insertion point.

Explanation: Just took the test!

Place the cursor on the last cell and press the Tab key. Right-click for the insert options menu at the insertion point. The correct options are B and E.

What is cursor?

On a computer display screen, a cursor indicates the location where a user can type text. It's also referred to as a "caret."

The Latin word "cursorem," which meaning "runner," is where the word "cursor" originates.

A figure resembling an arrow shows on the computer screen as the mouse pointer. It is employed to identify the various screen icons.

It is capable of sweeping the screen. However, as you type on a computer, a blinking line known as the cursor appears.

The user can add extra rows or columns by placing the cursor in the last cell and pressing the Tab key after inserting a table into a message. At the insertion point, right-click to display the insert options menu.

Thus, the correct options are B and E.

For more details regarding cursor, visit:

https://brainly.com/question/30355731

#SPJ6

PLEASE ILL GIVE BRAINLIEST IMMEDIATELY
Web Directories use a search engine to gather websites, but then those websites are evaluated, selected and saved to their Internet Library by _______________________________. *
Artificial Intelligence (AI).
UniversICTy of Wisconsin professors.
human editors.
specialists from the Federal Government.

Answers

Answer:

AI

Explanation:

The answer is Artificial intelligence.

1. What does VolP stand for? *
O a. Video on Internal Pride
O b. Voice on Inside Platform
c. Voice over Internet Protocol
O d. Video on Internet Pipes

Answers

Answer : c

Explanation:
Answer choice c is correct

A _______ is a website specially designed to allow visitors to use their browser to add, edit, or delete the site's content.

Answers

Answer:

"Wiki" Blog Webcast Microblog

so technically just wiki

Explanation:

A Wiki Blog Webcast Microblog is a website specially designed to allow visitors to use their browser to add, edit, or delete the site's content.

Answer:

A wiki is a website specially designed to allow visitors to use their browser to add, edit, or delete the site's content.

Explanation:

Write a 10 sentence paragraph about george washington and abraham lincoln and no plagiarism

Answers

10 sentence paragraph about George Washington and Abraham Lincoln and no playgiarism

Answer:

Hands down, no argument, no opinion, when you think of the U.S Presidential candidates you often think of our first founder, George Washington, and our 16th founder, Abraham Lincoln.

Lincoln was born on February 12, 1809. Although being called the Illinoisan President, he was born in Kentucky on a farm in Sinking Spring. A little after his birth, him and his parents - Thomas and Nancy Lincoln - moved to Illinois to live out the rest of their days. He was only 52 years old when he became a Presidential elect, and had 4 kids; William Wallace Lincoln, Tad Lincoln, Robert Todd Lincoln, and Edward Baker Lincoln. Soon, he would die to John Wilkes Booth on April 14th, 1865 at 7:22 am.

George Washington was born on February 22, 1732. He is nationally known for being the first of the Founding Fathers, and the first President elect of the United States. He was President of the U.S 1789-97, but unfortunately died at the age of 67 to a disease named Epiglottitis. Before he died, he had two children; John Parke Custis, and Martha "Patsy" Parke Custis.

3. The Shell mode is best for small programs and for the beginners. true and false ​

Answers

Answer:

Shell mode is just for basic programs like addition, multiplication etc , whereas to run programs u need interactive mode

Explanation:

Providing access to all of Python's built-in functions and any installed modules, command history, and auto-completion, the interactive console offers the opportunity to explore Python and the ability to paste code into programming files when you are readyIf you are in the standard Python shell, you can click "File" then choose "New" or simply hit "Ctrl + N" on your keyboard to open a blank script in which you can write your code. You can then press "Ctrl + S" to save it. After writing your code, you can run it by clicking "Run" then "Run Module" or simply press F5.

Bitmap images produce a _________ images

Answers

I DONT KNOW WHAT YOU MEAN

favorite color should it be stored why?or why not?

Answers

Answer:

Explanation:

green

Favorite color should not be stored as there is no need to keep it.

What is Color?

Color is known to be a kind of visual appeal or view property gotten from the spectrum of light working together with the photoreceptor cells of the human eyes.

Therefore, Favorite color should not be stored as there is no need to keep it but one can buy items using one's  Favorite color .

Learn more about color  from

https://brainly.com/question/911645

#SPJ2

differentiate between brown out and power surge as used in a computer

Answers

Answer:

A surge in electrical power means that there is an unexpected increase in the amount of voltage provided. This can be a small increase or a larger increase known as a spike. A spike is a short transient in voltage that can be due to a short circuit, tripped circuit breaker, power outage, or lightning strike.

A sag is an unexpected decrease in the amount of voltage provided. Typically, sags are limited in time and in the decrease in voltage. However, when voltage reduces further, a brownout could ensue. During a brownout the voltage drops to such an extent that it typically causes the lights to dim and causes computers to shut off.

A blackout is when a total loss of power for a prolonged period occurs. Another problem associated with blackouts is the spike that can occur when power is restored. In the New York area, it is common to have an increased amount of tech support calls during July; this is attributed to lightning storms! Quite often this is due to improper protection.

Explanation:

                                                                                                                       

I Hope it helped you

Are you familiar with measuring using a ruler? When have you ever used a ruler to measure, and who taught you how to use the ruler? How confident are you in your ability to measure things using a ruler? Please help me answer this question

Answers

Answer:

I have used a ruler many times to meausre various things such as paper, my height, etc. I was taught how to use a ruler in elementary school. I am pretty confident in using a ruler because I have used one for a majority of my life.

Explanation:

Why can't this app have people ask riddles.

Answers

I don’t know why it doesn’t have that

Because this is an app for school. Even though, I always post riddles on it anyway

You are opening a store, and having a working website is an important part of your project plan. The company that started creating your website went out of business before completing the job.

What components of your project plan will be affected?

Budget and time
Ethics and piracy
Ideas and creativity
Policies and procedures











HELP ASAP

Answers

Answer:

I think it might be Budget and time. :)

illl give brainliest plzzzzzzzzzz

Answers

The one paste symbol name is : paste settings

it consist of 'paste special' and 'set default paste if im not wrong'

I will mark brainliest


Which of the following is a positive effect of modern computing?


polarized views

randomized ordering

specialized limitations

customized products

Answers

Answer:

specialized limitations

Explanation:

beacause the others is an application product

What role has social media played in the GameStop story? Why do some observers see what is happening on Reddit as “skirting the line of market manipulation”?

Answers

I honestly don’t know sorry

A ______ is a group of slides designed and formatted for a specific purpose. These include themes as well as content.

Answers

Answer:

Slideshow

Explanation: :)

I have tried many times to find a gaming setup for $4k. I have tried many websites but they are not working for my liking. Any other suggestions?

Answers

I would try going to pcpartpicker.com and build your pc from there, and after you’ve done that take your remaining budget to find whatever else you need for your setup

How does a hyperlink function in an Outlook message? When the hyperlink is selected, a web page opens inside the message. When the hyperlink is selected, a web page opens in the default browser. When the message is opened, the hyperlink automatically opens a web page. When the message is opened, a web page displays in a special preview window.

Answers

Answer:

When the hyperlink is selected, a web page opens in the default browser.

Explanation:

HTML is an acronym for hypertext markup language and it is a standard programming language which is used for designing, developing and creating web pages.

Generally, all HTML documents are divided into two (2) main parts; body and head. The head contains information such as version of HTML, title of a page, metadata, link to custom favicons and CSS etc. The body of the HTML document contains the contents or informations of a web page to be displayed.

A hyperlink can be defined as an element in a HTML document that provides a direct access or link to another document, page, location, and image.

Basically, a hyperlink links to the same page or image in a HTML document or another HTML document. The texts contained in a hyperlink is usually highlighted and only activated by a click.

In Microsoft Outlook, when a hyperlink is selected, a web page opens in the default browser.

Answer:

B. When the hyperlink is selected, a web page opens in the default browser.

Explanation:

Zybook C++ 3.21 answer

Answers

Answer:

6.49

Explanation:

Help give crown and points

Answers

Answer:

what should i do

please tell

i need the answers. i don’t get this

Answers

Run,lazy,turtles,slow,wandering, jump,45,weird,pigs, cows, cousins, pale,rude,candles

There are many answers for this but this is what first came to my mind

Hope this helps

PLS HELP ASAP BRAINLIEST. Respecting yourself and others, educating yourself and connecting with others, and protecting yourself and others are all aspects of being a good _________, ____________ (2words). enter the answer

Answers

Answer:

Respecting yourself and others, educating yourself and connecting with others, and protecting yourself and others are all aspects of being a good human being

what is a computer ? what are the uses of computer​

Answers

Answer:

computer is an electronic device for storing and processing data, typically in binary form, according to instructions given to it in variable programs.

the uses of Computer is alot

from entertainment to work station

to programmers to make a program

it all depends on how we want to use it

some might use it as both entertainment and workstation too. and the fact that computers can stores and sorted many different files for example writing a 1000 page book can be a hard time to save the space in the physical world but much easier on the digital world(inside the computer)

A computer can be defined as an electronic device which accepts data, processes data and brings out information known as results.

The uses of a computer systemBusiness: A computer can be used to perform business transactions online. It is used by both sellers and buyers to market and purchase product respectively.

Entertainment: A computer can be used to play music, watch movies and play games.

Prepare documents: The computer is used to type and edit different forms of documents like word, PDF and Excel.

Save information: A computer is used to save information for future use and reference.

Therefore, a computer has the ability to store, retrieve and process information.

Learn more about computer:

https://brainly.com/question/474553

#SPJ5

write query to get the max and min salary of job_id 101​

Answers

Answer:

SELECT  MAX(salary), MIN(salary) FROM salaries WHERE job_id=101

Explanation:

Assumptions were made on the column and table names...

Other Questions
The graph below shows the population of a group of rabbits in arestricted area studied over a period of 5 years.Which statement might explain why the population levels off asshown in the graph? A silver nitrate solution contains 14.77 g of primary standard AGNO3 ( Molecular weight 169.87) in 1.00 L. What volume of this solution will be needed to react with 0.2631 g of NaCl ( Molecular weight 58.44) ? please help me its due today! 20 points + Brainliest. Help please!In an adiabatic process, the pressure on an ideal gas is increased to 14 times its initial value. The initial volume is 78 L. What is the final volume? Let = 1.67.A. 16 LB. 22 LC. 8.1 LD. 10 L 1. What happened at the battle of marathon?2. What happened at the battle of Thermopylae Pass?3. What happened at the battle of Salamis Strait4. What happened at the battle of Plataea? How do humans have a negative impact on the environment ?? Harding Company is in the process of purchasing several large pieces of equipment from Danning Machine Corporation. Several financing alternatives have been offered by Danning: (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. Pay $1,000,000 in cash immediately. 2. Pay $420,000 immediately and the remainder in 10 annual installments of $80,000, with the first installment due in one year. 3. Make 10 annual installments of $135,000 with the first payment due immediately. 4. Make one lump-sum payment of $1,500,000 five years from date of purchase. Required: Determine the best alternative for Harding, assuming that Harding can borrow funds at an 8% interest rate. (Round your final answers to nearest whole dollar amount.) Triangle RST is translated 2 units left and then reflected over the y-axis. HELP QUICK PLEASEEEE!!!!!!!!!!!!!!!! What is the intersection point for y=-3/2x-7 and y=5/6x+7!!!! 6. A camping tent is shown to the right. How much material would be needed to make the tent shown? (Use the formula S = Ph + 2B to solve). A. 144 centimeters squared B. 168 centimeters squared C. 181 centimeters squared D. 204 centimeters squared how the relationship between photosynthesis and cellular respiration prove that the Laws of Conservation of Mass and Energy exists in living systems? According to Newtons second law of motion, what is force equal to? In figure AB and CD bisect each other at O. State the 3 pairs of equal parts in AOC and BOD. Is AOC BOD? Give reasons please help me What did you do last summer? Mention five activities you have done. One regular verb in er, one regular verb in ir, one regular verb in re and two irregular verbs must be used.ex.) L't pass, j'ai travaill dans un bureau. J'ai t secrtaire. J'ai rpondu au tlphone. J'ai obi mon patron. J'ai fait beaucoup de travail!which says: last summer I worked in an office. I was a secretary. I answered the phone. I obeyed my boss. I did a lot of work! She was the first African American woman (and American woman in general) towin three Olympic gold medals. She ran Track for the U.S. in the Olympics inAustralia in 1956 and the Olympics in Rome in 1960. On top of all that, she wasdiagnosed with polio as a child, so it is even more incredible to see her amazingaccomplishments as an adult. Who is she? A 0.15kg baseball is pushed with a 100N force. What will its acceleration be? An acquiring company issues 500,000 shares of $6 par value common stock to acquire 100% of the voting common stock of an investee company in a transaction that qualifies as a business combination. The market value of the acquiring company's common stock is $30 per share. Direct legal and consulting fees incurred pursuant to the combination are $200,000. Direct registration and issuance costs for the acquiring company's common stock are $50,000. The transaction did not result in goodwill recognition or bargain gain recognition. What is the total amount of net assets recognized as a result of this business combination how can earth support sustain life Carter and his children went into a bakery where they sell cupcakes for $3 each andcookies for $0.50 each. Carter has $35 to spend and must buy a minimum of 15cupcakes and cookies altogether. If x represents the number of cupcakes purchasedand y represents the number of cookies purchased, write and solve a system ofinequalities graphically and determine one possible solution. (I need 2 inequalitys) help, please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!