MS Excel Basics, Microsoft Excel

MS Excel Basics

Question: Which of the following is the correct shortcut key for creating a new sheet?
A
Shift + F11

B
CTRL + N

C
CTRL + S

D
Shift + S

Note: Not available
1. Report
Question: "You cannot enter duplicate data in primary key field." The statement is-
A
True.

B
False.

Note: Not available
1. Report
Question: The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
A
B1:G10

B
B1-G10

C
B1.G10

D
B1;G10

Note: Not available
1. Report
Question: To get a value in the cell C1 that is 90% of the number in cell C3, you enter—
A
= C3*1.9

B
.9 x C3

C
C3*90%

D
= C3*0.90

Note: Not available
1. Report
Question: 3. Which command reverses the most recent changes made to a document?
A
Revert

B
Reverse

C
Undo

D
Back

Note: Not available
1. Report
Question: Under the File , “Save As” command helps you—
A
to convert the file for a different operating system.

B
to delete the current document and create a new document with the same file name.

C
to save a file using a different file name and/or get the additional saving options.

D
None of the above

Note: Not available
1. Report

Question: Which of the following is the correct shortcut key for creating a new sheet?