면접 준비, 온라인 테스트, 튜토리얼, 라이브 연습을 위한 학습 플랫폼

집중 학습 경로, 모의고사, 면접 준비 콘텐츠로 실력을 키우세요.

WithoutBook은 주제별 면접 질문, 온라인 연습 테스트, 튜토리얼, 비교 가이드를 하나의 반응형 학습 공간으로 제공합니다.

라이브러리 검색

Prepare Interview

Microsoft Excel 면접 질문과 답변

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

1
2
3
4
5
6
7
8

Ques 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.

도움이 되었나요? 예 아니요 Add Comment View Comments

Ques 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.

도움이 되었나요? 예 아니요 Add Comment View Comments

Ques 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

도움이 되었나요? 예 아니요 Add Comment View Comments

Ques 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

도움이 되었나요? 예 아니요 Add Comment View Comments

Ques 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

도움이 되었나요? 예 아니요 Add Comment View Comments

1
2
3
4
5
6
7
8

Most helpful rated by users:

Copyright © 2026, WithoutBook.