Home >> MS Excel MCQs >>

MS Excel Set 04

MS Excel Set 04

Q.1 How many rows are in one Microsoft Excel sheet?
A. 1,048,576
B. 16,384
C. 65,536
D. None of Above

ANSWER: A) 1,048,576
Explanation : in MS Excel 2007 and above there are 1048576 Rows

Q.2 In a computer spreadsheet rows are labeled ________ ?
A. by letters
B. by cell references
C. by numbers
D. by symbols

ANSWER: C) by numbers
Explanation : In MS Excell, Rows are labeled with numbers. It starts from 1 and ends up on 1048576. You can use CTRL+Down Arrow to check last line number.

Q.3 A formula in excel starts with _________ ?
A. *sign
B. / sign
C. $ sign
D. equal sign

ANSWER:
Explanation : In MS Excel Formula and function starts with ( =) equal to Sign.

Q.4 Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?
A. Smart tip
B. Soft Tip
C. Web Tip
D. Cell Tip

ANSWER:
Explanation : when we place mouse over a cell having comments, a small box appeared which contains comments this box is called tooltip.

Q.5 In MS Excel to delete duplicate values which Tab is used?
A. Data
B. Review
C. View
D. Insert

ANSWER:
Explanation : There is a remove duplicate option in Data Tab which can be used to remove duplicate values in a sheet.

Q.6 To open an existing workbook, click the open button on the ___________ toolbar?
A. form
B. standard
C. Drawing
D. Formatting

ANSWER:
Explanation : To open an existing file, we can use open icon in standard tool bar on the other hand we also can use CTRL+ O short Key for same purpose.

Q.7 To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
A. Pivot Table Report
B. Pivot Table List
C. Pivot Table Field List
D. HTML

ANSWER:
Explanation : Pivot Table Report can be used to create an interactive Pivot Table for the web.

Q.8 Which among following is not associated with spelling dialogue box?
A. Edit
B. Ignore All
C. Ignore
D. Change

ANSWER:
Explanation : Spell and grammer check have IGNORE, IGNORE ALL, ADD TO DISCTIONARY, CHANGE CHANGE ALL option but don’t have EDIT option.

Q.9 If you press ___, the cell accepts your typing as its -contents?
A. Tab
B. Ctrl+Enter
C. Enter
D. Alt+Enter

ANSWER: C) Enter
Explanation : Enter Button is used to make the MS Excell accept its contents entered in a cell.

Q.10 The default style for new data keyed in a new workbook is ___________?
A. Comma
B. Normal
C. Currency
D. Percent

ANSWER: B) Normal
Explanation : By Default, MS Excel accepts data as NORMAL/GENERAL in each cell. Butyou can change it later

Related Posts

More MCQs