PassEveryTest
中文

Excel for Beginners Course 2026

This course is for people who are new to Excel or want to fill gaps before starting an office, retail or warehouse job. It covers cells and ranges, formatting, formulas and basic functions, cell references, sorting and tables, and charts, printing and sharing. Study each lesson, try its topic quiz, then take the timed final assessment. Score 80% or more to earn a certificate of completion.

  • 课程
  • 加拿大
  • 100道题
  • 核对于2026年10月13日
  • 事实核查：2026年10月13日

快速解答

这门免费课程包括约120分钟的课程、6个不限时的专题测验（共100道题），以及一次随机抽取30道题的限时期末评估。期末评估得分达到80%或以上即可下载结业证书（私人颁发，未经认证）。 已于2026年10月13日根据官方资料核对。

从课文开始Excel for Beginners Course: Lessons：阅读时间约120分钟。测试中的每道题在课文中都有讲解。

你将学到什么

  • Find your way around workbooks, worksheets, cells and ranges
  • Enter, edit and format numbers, dates, money and text
  • Write formulas with SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, ROUND and IF
  • Use relative and absolute references and fill formulas with AutoFill
  • Sort, filter and total data in an Excel table
  • Make a simple chart, print a sheet neatly and share a workbook

得分达到80%或以上即可下载证书。

你的学习计划

阅读每一课，完成对应的专题测验（不限时，有解释），然后参加限时的期末评估。每次都会抽取新的题目组合。你的进度保存在此浏览器中。

  1. 阅读课程6课，约120分钟
  2. 专题测验1：Workbooks, worksheets, cells and ranges16道题
  3. 专题测验2：Entering, editing and formatting data16道题
  4. 专题测验3：Formulas and basic functions18道题
  5. 专题测验4：Cell references and AutoFill17道题
  6. 专题测验5：Sorting, filtering and tables17道题
  7. 专题测验6：Charts, printing and sharing16道题
  8. 结业考试30道题，40分钟 · 得分达到80%或以上

专题测验1：Workbooks, worksheets, cells and ranges

  1. 第1题，共16题

    What is the name of the cell where column C meets row 4?
    显示答案

    答案: C. C4

    A cell name is the column letter followed by the row number, so column C and row 4 give C4.

  2. 第2题，共16题

    In the sheet below, which cell contains the word "Radios"?
    ABCD
    1ItemCategoryQtyUnit cost
    2Safety vestsPPE4212.50
    3Hard hatsPPE1524.00
    4FlashlightsTools818.75
    5RadiosElectronics6149.00
    6Batteries (AA)Electronics1200.85
    7GlovesPPE644.20
    8Traffic conesSite3016.40
    显示答案

    答案: A. A5

    "Radios" is in column A on row 5, so the cell is A5.

  3. 第3题，共16题

    How many worksheets does a new blank workbook have by default in current versions of Excel?
    显示答案

    答案: B. 1

    Microsoft lists the default number of sheets in a new workbook as 1. You can add more at any time.

  4. 第4题，共16题

    Which keyboard shortcut creates a new blank workbook?
    显示答案

    答案: B. Ctrl+N

    Ctrl+N opens a new blank workbook. You can also open Excel and select Blank workbook.

  5. 第5题，共16题

    How do you add a new worksheet with the mouse?
    显示答案

    答案: B. Select the + icon next to the sheet tabs

    The plus (+) icon next to the sheet tabs at the bottom adds a new worksheet.

  6. 第6题，共16题

    What is a quick way to rename a worksheet?
    显示答案

    答案: C. Double-click its sheet tab and type a name

    You can double-click a sheet tab (or right-click it and choose Rename) and type a new name.

  7. 第7题，共16题

    How many cells are in the range B2:B6?
    显示答案

    答案: B. 5

    The range runs from row 2 to row 6 in one column: rows 2, 3, 4, 5 and 6 make 5 cells.

  8. 第8题，共16题

    What does the range B15:E15 refer to?
    显示答案

    答案: C. Row 15, from column B to column E

    A colon joins the first and last cell of a range. B15:E15 is row 15, columns B through E.

  9. 第9题，共16题

    In the sheet below, the data (without the header row) is in A2:D8. How many cells is that?
    ABCD
    1ItemCategoryQtyUnit cost
    2Safety vestsPPE4212.50
    3Hard hatsPPE1524.00
    4FlashlightsTools818.75
    5RadiosElectronics6149.00
    6Batteries (AA)Electronics1200.85
    7GlovesPPE644.20
    8Traffic conesSite3016.40
    显示答案

    答案: A. 28

    The range has 4 columns (A to D) and 7 rows (2 to 8), so 4 × 7 = 28 cells.

  10. 第10题，共16题

    What does the reference 5:10 mean in a formula?
    显示答案

    答案: A. All cells in rows 5 through 10

    A reference made of two row numbers, such as 5:10, means every cell in those whole rows.

  11. 第11题，共16题

    Which of these sheet names will Excel refuse?
    显示答案

    答案: C. Week 1/2

    Sheet names can't contain the characters / \ ? * : [ or ]. The slash makes "Week 1/2" invalid.

  12. 第12题，共16题

    What is the longest name a worksheet tab can have?
    显示答案

    答案: B. 31 characters

    Excel limits sheet names to 31 characters, and a name can't be blank.

  13. 第13题，共16题

    Which sheet name can't be used, even though it has no forbidden characters?
    显示答案

    答案: A. History

    Excel reserves the name "History" for its own use, so you can't give a sheet that name.

  14. 第14题，共16题

    How many rows does one Excel worksheet have?
    显示答案

    答案: C. 1,048,576

    A worksheet has 1,048,576 rows and 16,384 columns.

  15. 第15题，共16题

    A formula contains Sales!B2:B9. What does the exclamation point (!) do?
    显示答案

    答案: A. It separates the sheet name from the cell range

    In a reference to another sheet, the ! separates the worksheet name from the cells, so Sales!B2:B9 is B2:B9 on the Sales sheet.

  16. 第16题，共16题

    You want a formula that uses cell A1 on a sheet named March Hours. Which reference is written correctly?
    显示答案

    答案: C. 'March Hours'!A1

    When a sheet name has a space, put it inside single quotation marks (apostrophes) before the exclamation point.

考前须知

  • Every Excel formula starts with an equal sign (=).
  • Excel multiplies and divides before it adds and subtracts, so =5+2*3 returns 11 but =(5+2)*3 returns 21.
  • A dollar sign makes a reference absolute: $A$1 stays the same wherever you copy the formula. Press F4 to switch reference types.
  • AVERAGE ignores empty cells and text in a range, but it includes cells that contain zero.
  • A number format changes only how a value looks. Excel calculates with the stored value, which you can see in the formula bar.
  • A table's Total Row uses SUBTOTAL, so totals skip rows hidden by a filter.
  • One worksheet has 1,048,576 rows and 16,384 columns.

常见问题

What certificate do I get, and what is it not?

If you score 80% or more on the final assessment, you can download a certificate of completion for this course. It shows that you finished a general skills course. It is not a Microsoft certification such as Microsoft Office Specialist (MOS), and it is not an accredited qualification.

Which version of Excel does this course use?

The lessons describe Excel for Microsoft 365 on Windows and Excel for the web. Most steps are the same on a Mac, but some keyboard shortcuts are different.

Do I need Excel installed to take the course?

No. You can read the lessons and answer the quizzes in your browser. To try the practical exercises, use Excel on a computer or Excel for the web, and copy the practice data into a new workbook.

How does the final assessment work?

It has 30 questions picked at random from the course's question bank, and you have 40 minutes. You get a new mix of questions each time you try.

Why does the invoice exercise use 5% GST?

It is an example only. Sales tax rates differ by province and territory. Some places charge 5% GST only, and others charge HST, such as 13% in Ontario.

这份证书是否经过认证或获得官方认可？

不是。这是一份私人颁发的结业证书，仅用于知识学习。它未获得任何政府、执照发放机构、监管机构或教育机构的认可、认证或批准，也不能替代法律要求的任何执照、资格证书或培训。

资料来源

相关测试