MS Excel Basics, Microsoft Excel

MS Excel Basics

Question: Each time you start the MS Excel program, by default, it displays a new blankworkbook containing _________ blank worksheets.
A
Two

B
Three

C
Four

D
Five

Note: Not available
1. Report
Question: Which of the following is not the correct error code in MS Excel ?
A
#VALUE!

B
#######

C
#REF!

D
#NAME?

Note: Not available
1. Report
Question: SUM (B3:B7) here B3 AND B7 are
A
Cell heading

B
Cell address

C
Row heading

D
Colum heading

Note: Not available
1. Report
Question: Which of the following is the correct example of relative columns and absolute row?
A
C4

B
C$4

C
SC$4

D
$C4

Note: Not available
1. Report
Question: Which one is not a Function in MS Excel?
A
SUM

B
AVG

C
MAX

D
MIN

Note: Average is exist in excel
1. Report
Question: What function displays row data in a column or column data in a row?
A
Hyperlink

B
Index

C
Transpose

Note: Not available
1. Report
Question: What is the short cut key to highlight the entire column?
A
Ctrl + C

B
Ctrl + Enter

C
Ctrl + Page Up

D
Ctrl + Space Bar

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 2 3 4 5 Next Last

Question: Each time you start the MS Excel program, by default, it displays a new blankworkbook containing _________ blank worksheets.

Question: Which of the following is not the correct error code in MS Excel ?

Question: SUM (B3:B7) here B3 AND B7 are

Question: Which of the following is the correct example of relative columns and absolute row?

Question: Which one is not a Function in MS Excel?

Question: What function displays row data in a column or column data in a row?

Question: What is the short cut key to highlight the entire column?

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?