PassEveryTest
中文

Microsoft Office Specialist: Excel Exam Preparation：Manage data cells and ranges

不限时专题测验：关于Manage data cells and ranges的20道题，每道题作答后都有解释。每次题目和选项都会重新打乱。

  • 课程
  • 加拿大
  • 90道题
  • 核对于2026年10月13日
  • 事实核查：2026年10月13日
从课文开始Microsoft Office Specialist: Excel Exam Preparation: Lessons：阅读时间约300分钟。测试中的每道题在课文中都有讲解。

专题测验2：Manage data cells and ranges

  1. 第1题，共20题

    You need to copy the formatting of cell A1 to three different ranges, one after another. What is the best way?
    显示答案

    答案: C. Double-click Format Painter, then click each range

    Double-clicking Format Painter keeps it on until you press Esc. A single click applies it only once. Ctrl+V would paste the contents too.

  2. 第2题，共20题

    A long comment in B4 runs into the next cells. Which option shows it on several lines inside B4?
    显示答案

    答案: D. Wrap Text

    Wrap Text breaks long text onto more lines inside the same cell and makes the row taller.

  3. 第3题，共20题

    A1 contains "Report" and B1 contains "2026". You select A1:B1 and choose Merge & Center. What does the merged cell show?
    显示答案

    答案: C. Report

    When you merge cells, Excel keeps only the value in the upper-left cell and discards the others.

  4. 第4题，共20题

    Column C has formulas. You want to paste only their current results into column F, with no formulas. Which Paste Special option do you use?
    显示答案

    答案: A. Values

    Paste Special > Values pastes the displayed results without formulas or formatting.

  5. 第5题，共20题

    Your data runs down A1:A12 and you want the same data across a row instead. Which Paste Special option does this?
    显示答案

    答案: C. Transpose

    Transpose swaps rows and columns, so data in a column is pasted across a row.

  6. 第6题，共20题

    You copy D2, select B2:B5 and choose Paste Special > Multiply. What does B4 show afterwards?
    ABCD
    1ItemPriceIncrease
    2Gloves12.401.05
    3Vests38.00
    4Radios145.00
    5Lights22.60
    显示答案

    答案: B. 152.25

    Multiply multiplies each destination value by the copied value: 145.00 × 1.05 = 152.25.

  7. 第7题，共20题

    You type Mon in A2 and drag the fill handle down to A6. What appears in A6?
    显示答案

    答案: C. Fri

    Auto Fill continues a known list such as weekdays. A2 to A6 is five cells: Mon, Tue, Wed, Thu, Fri.

  8. 第8题，共20题

    You select A2:A3 and drag the fill handle down to A7. What does A7 show?
    A
    1Week
    25
    310
    4
    5
    6
    7
    显示答案

    答案: C. 30

    With two numbers selected, Auto Fill continues the step (+5): 5, 10, 15, 20, 25, 30.

  9. 第9题，共20题

    Which values can =RANDBETWEEN(1,6) return?
    显示答案

    答案: A. Any whole number from 1 to 6

    RANDBETWEEN returns a random whole number between bottom and top, and both limits are included.

  10. 第10题，共20题

    You fill 20 cells with =RANDBETWEEN(100,999) for test ID numbers. You do not want them to change again. What should you do?
    显示答案

    答案: D. Copy them and paste back as Values

    RANDBETWEEN gives a new number every time the sheet recalculates (for example when you press F9). Pasting as Values keeps the numbers fixed.

  11. 第11题，共20题

    You enter =SEQUENCE(3,1,100,10) in A2. What is in A4?
    显示答案

    答案: C. 120

    SEQUENCE(3,1,100,10) gives 3 rows starting at 100 and stepping by 10: 100, 110, 120. A4 is the third value.

  12. 第12题，共20题

    You enter =SEQUENCE(2,3) in A1. What is in A2?
    显示答案

    答案: B. 4

    SEQUENCE(2,3) fills 2 rows and 3 columns across each row first: row 1 is 1, 2, 3 and row 2 is 4, 5, 6. A2 starts row 2.

  13. 第13题，共20题

    You want to remove the bold, fill colour and borders from A1:D10 but keep the values. What do you use?
    显示答案

    答案: C. Home > Clear > Clear Formats

    Clear Formats removes formatting only. Clear Contents and Delete remove values; Clear All removes both.

  14. 第14题，共20题

    You Ctrl+click the tabs Jan, Feb and Mar, then make row 1 bold in Jan. What happens?
    显示答案

    答案: A. Row 1 becomes bold on all three sheets

    Clicking tabs with Ctrl groups the sheets ([Group] shows in the title bar). Formatting you apply then changes every grouped sheet.

  15. 第15题，共20题

    Which of these is a valid name for a named range?
    显示答案

    答案: B. Tax_Rate

    Names cannot contain spaces, cannot look like a cell reference such as B12, and must start with a letter, underscore or backslash.

  16. 第16题，共20题

    A1:C1 holds the headings Site, Guard and Hours, with data in rows 2–10. You select A1:C10 and use Formulas > Create from Selection with Top row checked. What range does the name Hours refer to?
    显示答案

    答案: D. C2:C10

    Create from Selection names each column's data using its label in the top row, so Hours refers to the data cells below that heading.

  17. 第17题，共20题

    You want Excel to highlight the 3 highest sales in B2:B30 automatically. Which built-in conditional formatting do you use?
    显示答案

    答案: A. Top/Bottom Rules > Top 10 Items (set to 3)

    Top 10 Items lets you set how many top values to highlight, such as 3.

  18. 第18题，共20题

    A sheet has several old conditional formatting rules in different places. How do you remove all of them at once?
    显示答案

    答案: C. Clear Rules > Clear Rules from Entire Sheet

    Clear Rules from Entire Sheet removes every conditional formatting rule on the sheet but keeps the data.

  19. 第19题，共20题

    Which three sparkline types does Excel offer?
    显示答案

    答案: C. Line, Column and Win/Loss

    Excel sparklines come in three types: Line, Column and Win/Loss.

  20. 第20题，共20题

    You inserted a line sparkline in F2. How do you remove it?
    显示答案

    答案: A. Clear on the Sparkline tab

    A sparkline is a tiny chart in the cell background; you remove it with Clear on the Sparkline tab.

相关测试