Microsoft Excel

Microsoft Excel

Question: Which of following is Not one of Excel’s what-if function?
A
Goal seek

B
Solver

C
Scenario manager

D
Auto Outline

Note: Not available
1. Report
Question: You can check the conditions against __________ when applying conditional formatting
A
Cell value

B
Formula

C
Both of above

D
None of above

Note: Not available
1. Report
Question: When a range is selected, how can you activate the previous cell?
A
Press the Alt key

B
Press Tab

C
Press Enter

D
None of above

Note: Not available
1. Report
Question: You can set Page Border in Excel from
A
From Border tab in Format Cells dialog box

B
From Border tool in Formatting toolbar

C
From Line Style tool in Drawing toolbar

D
You cannot set page border in Excel

Note: Not available
1. Report
Question: How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A
F8

B
F9

C
F10

D
F11

Note: Not available
1. Report
Question: Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?
A
Work sheet

B
Chart sheet

C
Macro sheet

D
Data sheet

Note: Not available
1. Report
Question: Long text can be broken down into many lines within a cell. You can do this through
A
Wrap Text in Format > Cells

B
Justify in Edit > Cells

C
Text Wrapping in Format > Cells

D
All of above

Note: Not available
1. Report
Question: You can select predefined table style in MS Excel by choosing -
A
Format as table from Insert tab

B
Format as table from Data tab

C
Format as table from Home tab

D
Table from Insert tab

Note: Not available
1. Report
Question: In MS Excel, if you accidentally resize a graphic by dragging a handle and but wish to cancel the changes you made, then what one should you do?
A
Drag it again for previous position

B
Ctrl+Drag for previous position

C
Click on Redo button

D
Click on Undo button

Note: Not available
1. Report
Question: In MS Access, if we set the "Required" field property to "YES" then what happens?
A
This prevents the field from being left blank.

B
Data can be deleted.

C
Data cannot be edited.

D
All of the above.

Note: Not available
1. Report

First Prev 4 5 6 7 Next Last

Question: Which of following is Not one of Excel’s what-if function?

Question: You can check the conditions against __________ when applying conditional formatting

Question: When a range is selected, how can you activate the previous cell?

Question: You can set Page Border in Excel from

Question: How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

Question: Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?

Question: Long text can be broken down into many lines within a cell. You can do this through

Question: You can select predefined table style in MS Excel by choosing -

Question: In MS Excel, if you accidentally resize a graphic by dragging a handle and but wish to cancel the changes you made, then what one should you do?

Question: In MS Access, if we set the "Required" field property to "YES" then what happens?