MCQ Bank
In MS Excel, what menu we should select to create chart?
- A) Go to Insert <Choose Any Chart
- B) Go to Data < Choose Any Chart
- C) Go to File < Choose Any Chart
- D) Go to Home < Choose Any Chart
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
Worksheet of MS Excel is divided into
- A) Figure
- B) Objects
- C) Facts and figures
- D) Rows and columns
Columns of MS Excel are represented by
- A) Alphabets
- B) Marks
- C) Names
- D) Numbers
To copy data in MS Excel
- A) press Ctrl+D
- B) press Ctrl+Y
- C) press Alt+C
- D) press Ctrl+C
To edit existing data in a cell without having to retype it all, you should _____.
- A) double-click the cell
- B) hold SHIFT down while clicking the cell
- C) click in the menu bar
- D) click in the task bar
The function library in Microsoft Excel is available under _________ tab.
- A) Home
- B) Formulas
- C) Insert
- D) Data
The Pivot table option can be found under ___________ tab
- A) Data
- B) Home
- C) Review
- D) Insert
Which one is not a relational operator in the given options?
- A) <=
- B) =
- C) <>
- D) ()
Relative reference is useful when we need to apply _______ type of calculations.
- A) Same
- B) Complex
- C) Simple
- D) Mathematical
Which of following bar shows the content of cell of MS Excel sheet?
- A) Content bar
- B) Name bar
- C) Formula bar
- D) Menu bar
How many worksheets an MS excel document contains by default?
- A) 1 worksheet
- B) 10 worksheet
- C) 3 worksheet
- D) 2 worksheet
To remove the contents of several cells at once, you can _____.
- A) select the cells and choose Edit | Clear... | Contents
- B) Press Esc button
- C) select the cells and drag the fill handle back up over them
- D) select the cells and press DELETE.
Rows of MS Excel are represented by
- A) Names
- B) Alphabets
- C) Numbers
- D) Marks
In MS Excel data can be sorted as following
- A) Select the date, you need to sort. Go to Data < sort
- B) Select the data, you need to sort. Go to Edit < sort
- C) Select the data, you need to sort. Go to File < sort
- D) None of Given
_______ displays the Help task pane in MS Excel.
- A) F4
- B) F3
- C) F1
- D) F2
Columns of MS Excel are represented by
- A) Alphabets
- B) Marks
- C) Names
- D) Numbers
By default there are ...... sheet(s) in MS Excel
- A) 4
- B) 3
- C) 2
- D) 1
You can enter different types of data in spreadsheet like
- A) Numeric Data
- B) Symbols
- C) All of Given
- D) Letters
Rows of MS Excel are represented by
- A) Alphabets
- B) Marks
- C) Names
- D) Numbers