Important Microsoft Excel Questions for SBI IBPS and other exams Part1

Important Microsoft Excel Questions for SBI IBPS and other exams Part1

1 A function inside another function is called _______

A. Nested function

B. Round function

C. Sum function

D. Text function

2 Which of the following is not an underline option in the format cells dialog box?

A. Double

B. Single Accounting

C. Double Accounting

D. Single Engineering

3 Formulas in Excel start with

A. %

B. =

C. +

D. –

4 The default header for a worksheet is

A. Username

B. Date and Time

C. Sheet tab Name

D. None

5 Which of the following is not an option of the spelling dialog box?

A. Ignore

B. Ignore all

C. Edit

D. Change

6 Which of the following methods will not enter data in a cell?

A. Pressing the Esc key

B. Pressing an arrow key

C. Pressing the tab key

D. Clicking the enter button to the formula bar

7 The cell reference for cell range of G2 to M12 is _______

A. G2.M12

B. G2;M12

C. G2:M12

D. G2-M12

8 What is the keyboard shortcut for creating a chart from the selected cell range?

A. F2

B. F4

C. F8

D. F11

9 The Software which contains rows and columns is called ______

A. Database

B. Drawing

C. Spreadsheet

D. Word processing

10 You can group noncontiguous worksheets with

A. The alt+enter key

B. The ctrl key and mouse

C. The shift key and the mouse

D. The group button on the standard toolbar

Answers

1 – A / 2 – D / 3 – B / 4 – D / 5 – C / 6 – A / 7 – C / 8 – D / 9 – C / 10 – B

For more refer to our Computer Awareness Section