Home >> MS Excel MCQs >>

MS Excel Set 01

MS Excel Set 01

Q.1 What is maximum zoom level in MS Excel.
A. 10
B. 100
C. 300
D. 400
ANSWER: D) 400 Explanation : MS Excel provide zoom levels from 10 to 400.
Q.2 What is minimum zoom level in MS Excel.
A. 10
B. 20
C. 50
D. 100
ANSWER: A) 10 Explanation : MS Excel provide zoom levels from 10 to 400.
Q.3 Zoom level controll is provided in _____________ in MS Excel.
A. Lower Right Corner
B. Lower Left Corner
C. Top Right Corner
D. None of these.
ANSWER: A) Lower Right Corner Explanation : Zoom level control is provided in lower right corner and View tab as well.
Q.4 In MS-Excel__________ short cut key is used for hiding rows.
A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above
ANSWER: C) Ctrl+9 Explanation : There a re various keys to do this task 1. CTRL+9 is used to hide selected Rows. 2. CTRL + SHIFT + ( is also used to hide the selected rows.
Q.5 In MS-Excel __________ short cut key is used for hiding columns.
A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. CTRL+0
ANSWER: D) CTRL+0 Explanation : There a re various keys to do this task 1. CTRL+0 is used to hide selected Columns. 2. CTRL + SHIFT + ) is also used to hide the selected Columns.
Q.6 In excel columns are labeled as____________?
A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.
ANSWER: A) A, B, C, etc. Explanation : Columns a are labeld as characters in MS Excel and Rows are labeled with numbers.
Q.7 Which function calculates the largest value in a set of numbers?
A. Average
B. Count
C. MIN
D. MAX
ANSWER: D) MAX Explanation : MAX() Function is used to find the largest value in set of values in MS Excel
Q.8 What displays the content of active cell?
A. Name box
B. Row headings
C. Formula bar
D. None of these
ANSWER: C) Formula bar Explanation : Content of an active cell are shown in formula bar.
Q.9 Microsoft Excel 2019 files have a default extension of___________?
A. .xlsx
B. .xls
C. excel
D. .123
ANSWER: A) .xlsx Explanation : default extension of MS Excel files from Office 2007 to 2019 is .xlsx whereas the previous versions of ms excel files have .xls extension
Q.10 Which of the following is the latest version of MS Excel?
A. Excel 2016
B. Excel 2017
C. Excel 2019
D. Office 365
ANSWER: C) Excel 2019 Explanation : Latest Version of MS Excel is Excel 2019.
Test Your Learning

Related Posts

More MCQs