Explore everything we offer students and teachers

Explore all of our learning and teaching solutions

Got a Kanye-sized ego? → Test it on our Ego-Meter
+
Excel 2010: Screen Symbols

Excel 2010: Screen Symbols

Objective:

To recognize the symbols used within the Excel 2010 system and define what actions they are associate with.

(more)
See More
Tutorial

What are the different screen symbols and what do they do?

Pay close attention to the different symbols that appear when using Excel 2010. They each serve a different function and can manipulate data in different ways.

Source: Marie E. Arriaga

Sample Budget Worksheet

Excel 2010 worksheet to use for practicing move data with screen symbols.

Source: Marie E. Arriaga

Practice moving data around the Excel 2010 screen

Complete the following steps using the sample Excel 2010 budget worksheet show just above this activity.

1) Use the white pointer to zoom to 120%.

2) Use the solid black arrow to widen column C to 10.00 points.

3) Use the auto fill handle to fill in the months from February to June.

4) Use the auto fill handle to copy the monthly salary amount from January through to June.

5) Use the Click-Shift-Click Method to select the expenses range from cell B7 to B11. Then use the auto fill handle to copy the amount over to columns D through G for the same rows.

6) Move the months of the year over one column to match up with the amount data in the salary row.

7) Compare your final worksheet to see if it matches the final version shown below:

Source: Marie E. Arriaga

Questions and Answers

  • Jerry
    Answer 1
    Expand
    Jerry — over 1 year ago

    ansi code for square root

    Report
    •  
      Author
      Marie E. Arriaga answered over 1 year ago

      Although this tutorial doesn't get into the square root functionality, I have been able to find a link describing the process for you. I hope it answers your question. If not, please explain a bit further and I will try to find the answer for you. Here is the link - http://spreadsheets.about.com/od/excelfunctions/qt/090620_square_root_in_Excel.htm

      Report
Accounting

Get a great return on your investment.
Our Accounting course is only $329.

Sophia's online courses help you save you money, while earning credits are also eligible for transfer to over 2,000 colleges and universities. *