面向面试准备、在线测试、教程与实战练习的学习平台

通过聚焦学习路径、模拟测试和面试实战内容持续提升技能。

WithoutBook 将分主题面试题、在线练习测试、教程和对比指南整合到一个响应式学习空间中。

搜索资源库

面试准备

Microsoft Excel 面试题与答案

Test your skills through the online practice test: Microsoft Excel Quiz Online Practice Test

1
2
3
4
5
6
7
8

问题 21. What filter will you use, if you want more than two conditions or if you want to analyse the list using database function?

You will use Advanced Criteria Filter, to analyse the list or if more than two conditions should be tested.

这有帮助吗？是否添加评论查看评论

问题 22. To move to the previous worksheet and to next sheet, what keys will you press?

To move to the previous worksheet you will use the keys Ctrl+PgUp, and to move to the next sheet you will use keys Ctrl+PgDown.

这有帮助吗？是否添加评论查看评论

问题 23. How do I put password to protect my entire Spreadsheet so data cannot be changed?

1. Click Tools
2. Scroll down to Protection, then Protect Sheet
3. Enter a password, Click OK
4. Re-enter password,
Click OK

这有帮助吗？是否添加评论查看评论

问题 24. What is Freeze Panes and how do I do it?

1. Row - Select the row below where you want the split to appear
2. Column - Select the column to the right of where you want the split to appear
3. Go to the Menu Bar
4. Click Windows
and then click Freeze Panes

这有帮助吗？是否添加评论查看评论

问题 25. How do I Format data in MS Excel?

1. Must Always highlight the data before formatting
2. Click Format
3. Then go to Cells

这有帮助吗？是否添加评论查看评论

1
2
3
4
5
6
7
8

用户评价最有帮助的内容：