1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Katyanochek1 [597]
3 years ago
13

What are the features of MS Excel​

Computers and Technology
1 answer:
Contact [7]3 years ago
3 0
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.
You might be interested in
What is the difference between margin and padding property?
VMariaS [17]

Answer:

Margin is applied to the outside of your element hence affecting how far your element is away from other elements.

Padding is applied to the inside of your element hence affecting how far your element's content is away from the border.

Explanation:

Hope it helps!!!

6 0
2 years ago
the php function that is executed is a connection to a database cannot be made is the____ function. die | isset| end | connect.
Pepsi [2]

The PHP function that is executed is a connection to a database that cannot be made is the die() function.

An error is an undesirable programming outcome. The mistake is a subset of the error. Error management is a vital component of any website or programme.

Error handling is a mechanism for identifying errors that a programme makes and taking appropriate corrective action. This can be done by utilising die() method.

When a programming problem occurs, the software will halt further code execution and display the appropriate error message to the user. The die() function displays a message and terminates the running of the programme.

The connect() function in PHP is one that is used to establish a connection to a database.

The end() method in PHP is used to locate the final element of the specified array. The end() function updates an array's internal pointer to refer to the final element and returns that element's value.

The isset() function examines whether a variable is set, which implies that it has to be declared and is not NULL. If the variable is present and not NULL, this function will return true; otherwise, it will return false.

To learn more about PHP click here:

brainly.com/question/29740624

#SPJ4

4 0
1 year ago
All of the following are functions of the DBMS except ________. Group of answer choices modifying the database getting the users
andreev551 [17]

Answer:

None of the above.

Explanation:

The outlined options are all functions of DBMS.

3 0
3 years ago
Design and implement an application that reads an integer value representing a year from the user. The purpose of the program is
olga55 [171]

Answer :

Written in java

import java.util.Scanner;

public class Main{

   public static void main(String[] args) {

       int year;

       Scanner scanner = new Scanner(System.in);

       System.out.print("Please enter a year\n\n");

       year = scanner.nextInt();

       while (year < 1582) {

           System.out.print("\nPlease enter a different year above 1582\n");

           year = scanner.nextInt();

       }

       if (year % 4 == 0) {

           if(year % 100 ==0 && year % 400 != 0){

                   System.out.println(year + " is not a leap year\n\n");

           }else {

               System.out.println(year + " is a leap year\n");

           }

       } else {

           System.out.println(year + " is not a leap year\n\n");

       }

   }

}

4 0
3 years ago
All conductors,buses,and connections should be considered
SashulF [63]

They should be considered as energized

6 0
4 years ago
Other questions:
  • One disadvantage of using the styles feature of a word processor is that you cannot modify existing styles. true or false
    14·1 answer
  • WILL MARK BRAINLYIST
    15·2 answers
  • Define the missing method. licenseNum is created as: (100000 * customID) + licenseYear. Sample output: Dog license: 77702014
    14·1 answer
  • Which note taking strategy has you divide a page into 3 sections for your notes, key points, and summary?
    11·1 answer
  • _______ allows you to add formatting such as shapes and colors to text.
    14·1 answer
  • Multiple Choice: We have been assigned the task of developing a software testing tool (tester) that can assess reachability of s
    11·1 answer
  • You would use the _______ conditional formatting options when analyzing a worksheet in which you want to highlight the highest o
    13·1 answer
  • You want to copy data from one cell or range to an adjacent cell or range in your spreadsheet, without using a shortcut key. Whi
    10·1 answer
  • Networks, partnerships, and joint ventures are an example of
    7·1 answer
  • 16. Your character qualities never change. (3 points)<br> A. True<br> B. False
    6·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!