雅虎香港 搜尋

登入

搜尋結果

  1. spreadsheetplanet.com › square-number-in-excelHow to Square a Number in Excel (2 Simple Methods) - ...

    Learn three easy and quick ways to find the square of a number in Excel using formulas, operators or functions. See examples, steps and screenshots for each method.

  2. exceltrick.com › how-to › square-a-number-in-excelHow to Square a Number in Excel (5 Quick & Easy Ways)

    2023年11月8日 · Learn five easy ways to square a number in Excel using formulas and functions. See examples, syntax and tips for each method with screenshots and explanations.

    • Mehwish Javaid

  3. 影片

    查看全部

  4. trumpexcel.com › square-number-excelHow to Square a Number in Excel (3 Easy Ways)

    Learn three easy ways to calculate the square of a number in Excel using the POWER function, the caret operator, or simple multiplication. See examples, formulas, and tips for different scenarios.

  5. support.microsoft.com › en-us › officeSquare a number - Microsoft Support

    • Overview
    • Square a number in its own cell
    • Square a number in a different cell
    • Need more help?
    • GeneratedCaptionsTabForHeroSec

    You can square a number in Excel with the power function, which is represented by the carat ^ symbol. Use the formula =N^2, in which N is either a number or the value of the cell you want to square. This formula can be used multiple times throughout a worksheet.

    在「support.microsoft.com」查看更多資訊

    Follow these steps:

    1.Click inside a cell on your worksheet.

    2.Type =N^2 into the cell, where N is the number you want to square. For example, to insert the square of 5 into cell A1, type =5^2 into the cell.

    3.Press Enter to see the result.

    在「support.microsoft.com」查看更多資訊

    Follow these steps:

    1.Click inside a cell and type the number that you want to square.

    2.Select another empty cell in the worksheet.

    3.Type =N^2 into the empty cell, in which N is a cell reference that contains the numeric value you want to square. For example, to display the square of the value in cell A1 into cell B1, type =A1^2 into cell B1.

    在「support.microsoft.com」查看更多資訊

    You can always ask an expert in the Excel Tech Community or get support in Communities.

    在「support.microsoft.com」查看更多資訊

    Learn how to square a number in Excel with the power function, which is represented by the carat ^ symbol. Follow the steps to square a number in its own cell or in a different cell.

    在「support.microsoft.com」查看更多資訊

  6. www.howtoexcel.org › square-numbers9 Ways to Square a Number in Microsoft Excel

    2024年9月10日 · Learn how to square a number in Excel using different methods, such as multiplication operator, carat operator, POWER function, and more. See examples, formulas, and steps for each method.

    • square in excel1
    • square in excel2
    • square in excel3
    • square in excel4

  7. www.excel-university.com › how-to-square-a-number-in-excelHow to Square a Number in Excel

    2023年1月10日 · Learn four easy ways to square a number in Excel, using operators, functions or formulas. Whether you have a single number or a range of cells, you can quickly get the squared result with Excel's tools and functions.

  8. learnexcel.io › square-excelHow to Square on Excel - Learn Excel

    2023年5月20日 · Learn how to square numbers on Excel using a simple formula, a built-in function, or the Autofill feature. Follow the steps and examples to perform arithmetic calculations and check your answers.

  1. square in excel 相關

    廣告
  2. welkin.com.hk/course/excel

    由Functions 到 Excel VBA - 全方位Excel及 Power BI應用課程

    不走冤枉路，踏實學好Excel。Excel 技能能助你在商業環境下盡展所長，工作更快更好完成. 學習全面 Excel 技能能讓你的生產力迅速爆發，在高度競爭的環境下給你額外的競爭優勢，佔盡先機