Home - Bank Exam - Practice Questions - MS Office Quiz - MS Excel - EXCEL MCQ

MS Office Quiz - MS Excel - EXCEL MCQ Online Exam Quiz

Important questions about MS Office Quiz - MS Excel - EXCEL MCQ. MS Office Quiz - MS Excel - EXCEL MCQ MCQ questions with answers. MS Office Quiz - MS Excel - EXCEL MCQ exam questions and answers for students and interviews.

1. In Excel 3-D reference in a formula

Options

A : Cannot be modified

B : Only appears on the summary of Worksheet

C : Limits the formatting options

D : spans worksheet

2. In MS-Excel default header for a worksheet is

Options

A : Your name

B : The date and time

C : date

D : None of these

3. In MS-Excel which of the following is not an option in the spelling dialog box

Options

A : Edit

B : Ignore

C : Ignore all

D : None of these

4. In MS-Excel you can copy cell formats from one cell to another by using the

Options

A : Backspace key

B : Default font

C : Format painter

D : None of these

5. In MS-Excel when you group worksheets

Options

A : You can enter variable data on multiple worksheets at one time

B : You can print more than one worksheet at a time

C : You can enter common data, formats, and formulas on multiple worksheets at one time

D : (B) and (C)

46. All formula in MS-Excel start with

Options

A : &percent;

B : +

C : =

D : -

47. In MS-Excel you can print

Options

A : A range of cells by range name

B : An entire worksheet

C : A single worksheet

D : All of the above

48. In MS-Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

Options

A : & (ampersand)

B : = (equal sign)

C : (space)

D : None of these

49. In MS-Excel you can create hyperlinks from the Excel workbook to

Options

A : A webpage on company internet

B : A web page on the internet

C : Other Office application documents

D : All of the above

50. In MS-Excel divide symbol is

Options

A : /

B : D

C : \

D : None of these

51. In MS-Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

Options

A : B1-G10

B : B1.G10

C : B1~G10

D : B1: G10

52. In MS-Excel to add two cells (A1 and A2) together, you use the following formula

Options

A : =A1+A2

B : =Add(A1+A2)

C : =together(A1:A2)

D : A1 plus A2

53. In MS-Excel advantage of using a spreadsheet is

Options

A : Calculations can be done automatically.

B : Changing data automatically updates calculations

C : More flexibility

D : All of the above

54. In MS-Excel intersection of a row and column is called :

Options

A : Cata

B : A field

C : A cell

D : None of these

55. There are three types of data found in a spreadsheet

Options

A : data, words, numbers

B : equations, data, numbers

C : words, numbers, labels

D : numbers formulas, labels

56. In MS-Excel to select a column the easiest method is to

Options

A : Double click any cell in the column

B : Drag from the top cell in the column to the last cell in the column

C : Click the column heading

D : None of these

57. In MS-Excel to copy cell contents using drag and drop press the

Options

A : End key

B : Shift key

C : Ctrl key

D : Esc key

58. In MS-Excel when you copy a formula

Options

A : MS-Excel erases the original copy of the formula

B : MS-Excel edits cell references in the newly copied formula

C : MS-Excel adjusts absolute cell references

D : All of these

59. In MS-Excel when you want to insert a blank imbedded excel worksheet in a word document you can

Options

A : Click the object command on the insert menu

B : Click the office links button on the standard toolbar

C : Click the create worksheet button on the formatting toolbar

D : Click the import excel command on the File menu

60. In MS-Excel which menu option can be sued to split windows into two

Options

A : Format > window

B : View > window > split

C : Window > split

D : None of these

Bank Exam - Practice Questions more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.020339012145996