Explore topic-wise MCQs in MS Excel.

This section includes 162 Mcqs, each offering curated multiple-choice questions to sharpen your MS Excel knowledge and support exam preparation. Choose a topic below to get started.

1.

Which among the following will not set text in selected cells to italics?
A. Pressing Ctrl + I on the keyboard
B. Using the Tools Wizard Web Form menu item
C. Using the Format Cells Font menu item
D. None of the above
Answer» C. Using the Format Cells Font menu item
Discussion
2.

Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros?
A. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
B. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
C. Apply a selected background color
D. All of above
Answer» C. Apply a selected background color
Discussion
3.

Which among the following methods can not be used to enter data in a cell?
A. Pressing an arrow key
B. Pressing the tab key
C. Pressing the Esc key
D. Clicking the enter button to the formula bar
Answer» D. Clicking the enter button to the formula bar
Discussion
4.

How should you print a selected area of a worksheet if a different area needs to printed ?
A. On the file menu, point to print area, and then click set print area.
B. On the file menu, click print, and then click selection under print what
C. On the view menu, click custom views, then click add
D. All of above
Answer» C. On the view menu, click custom views, then click add
Discussion
5.

What is a function inside another function is called ?
A. Nested Function
B. Round Function
C. Sum Function
D. Text Function
Answer» B. Round Function
Discussion
6.

Which among the following is a correct order of precedence in a formula calculation?
A. Multiplication and division, exponential positive and negative value
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. None of above
Answer» E.
Discussion
7.

What kind of charts can an excel produce ?
A. Line graphs and pie charts only
B. Only line graphs
C. Bar charts, line graphs and pie charts
D. Bar charts and line graphs only
Answer» D. Bar charts and line graphs only
Discussion
8.

You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu.
A. Edit
B. Insert
C. Format
D. Tools
Answer» E.
Discussion
9.

To protect a worksheet, you can choose Protection and the Protect Sheet from the .. menu
A. Edit
B. Format
C. Tools
D. Data
Answer» D. Data
Discussion
10.

You can quickly change the appearance of your work by choosing Auto Format from the . Menu
A. Edit
B. View
C. Format
D. Tools
Answer» D. Tools
Discussion
11.

Which of the following is invalid statement?
A. Sheet tabs can be colored
B. Some picture can be applied as a background of a sheet
C. You can set the column width automatically fit the amount of text
D. The width of a row and be specified manually or fit automatically
Answer» E.
Discussion
12.

You can check the conditions against __________ when applying conditional formatting
A. Cell value
B. Formula
C. Both of above
D. None of above
Answer» D. None of above
Discussion
13.

Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set condition to look for Bold and apply Italics on them.
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if it is not requried
Answer» C. You can apply Font, border and pattern formats that meets the specified conditions
Discussion
14.

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer» C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
Discussion
15.

You can set Page Border in Excel from
A. From Border tab in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From Line Style tool in Drawing toolbar
D. You can not set page border in Excel
Answer» E.
Discussion
16.

Where can you set the shedding color for a range of cells in Excel?
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer» E.
Discussion
17.

How can you remove borders applied in cells?
A. Choose None on Border tab of Format cells
B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C. Both of above
D. None of above
Answer» D. None of above
Discussion
18.

Which of the following format you can decide to apply or not in AutoFormat dialog box?
A. Number format
B. Border format
C. Font format
D. All of above
Answer» E.
Discussion
19.

Special category of Number tab in Format Cells dialog box can be used to apply formats like
A. Zip Code
B. Phone Number
C. Both of above
D. None of above
Answer» D. None of above
Discussion
20.

Which function will you use to enter current time in a woksheet cell?
A. =today()
B. =now()
C. =time()
D. =currentTime()
Answer» C. =time()
Discussion
21.

What is entered by the function =today()
A. The date value for the day according to system clock
B. The time value according to system clock
C. Today s date as Text format
D. All of above
Answer» B. The time value according to system clock
Discussion
22.

Formatting a cell in Number format you can t set
A. Decimal Places
B. Use 1000 separator
C. Negative numbers
D. Currency Symbol
Answer» E.
Discussion
23.

Formatting a cell in Currency, you can specify
A. Decimal Places
B. Currency Symbol
C. Both of above
D. None of above
Answer» D. None of above
Discussion
24.

Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from
A. from Fromat >> Cells
B. from Format >> Autoformat
C. from Table >> Autoformat
D. All of above
Answer» C. from Table >> Autoformat
Discussion
25.

Merge cells option can be applied from
A. Format Cells dialog box Alignment Tab
B. Formatting toolbar
C. Both of above
D. None of above
Answer» B. Formatting toolbar
Discussion
26.

Which of the following is not an option in the spelling dialog box?
A. Edit
B. Ignore
C. Ignore all
D. Change
Answer» B. Ignore
Discussion
27.

Can you set 0.5 inch left indentation for a cell in Excel?
A. Excel does not have indentation feature
B. You can specify indentation only if you turn the rulers on
C. Indentation can be set from Format Cells dialog box
D. The indentation can be specified only when printing
Answer» D. The indentation can be specified only when printing
Discussion
28.

You can automatically adjust the size of text in a cell if they do not fit in width by
A. Double clicking on the right border of column header
B. From Format choose Columns and then Autofit Selection
C. From Format Cells dialog box mark Shrink to fit check box
D. All of above
Answer» D. All of above
Discussion
29.

If you need a text to show vertically in a cell. How will you achieve this?
A. Choose Vertical on Text alignment in Format Cells dialog box
B. Choose 90 Degrees in Orientation of Format Cells dialog box
C. Choose Distributed from the Vertical drop down list of Format Cells dialog box
D. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box
Answer» C. Choose Distributed from the Vertical drop down list of Format Cells dialog box
Discussion
30.

The spelling tool is placed on ______ toolbar
A. Standard
B. Formatting
C. Drawing
D. Reviewing
Answer» B. Formatting
Discussion
31.

Which of the following is not a valid Zoom percentage in Excel?
A. 10
B. 100
C. 300
D. 500
Answer» E.
Discussion
32.

Comments on a presentation can record who wrote them and when they were added. What's the automatic way in PowerPoint 2002?
A. Use online collaboration
B. Use comments
C. Use the notes page
D. All of the above
Answer» D. All of the above
Discussion
33.

Which of the following allow you to select more than one slide in a presentation?
A. Alt + Click each slide
B. Shift + drag each slide
C. Shift + Click each slide
D. Ctrl + Click each slide
Answer» D. Ctrl + Click each slide
Discussion
34.

In which format does the data appear When an Excel file is inserted in a Word document?
A. Hyperlinked
B. Placed in a word table
C. Linked
D. Embedded
Answer» C. Linked
Discussion
35.

Which of the following options in the printer dialog box would you select to print slides 5 and 12 in a presentation?
A. Slides
B. Custom shows
C. Current slide
D. All
Answer» B. Custom shows
Discussion
36.

Data can be arranged in a worksheet in a easy to understand manner using
A. auto formatting
B. applying styles
C. changing fonts
D. all of above
Answer» E.
Discussion
37.

Concatenation of text can be done using
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer» E.
Discussion
38.

A numeric value can be treated as a label value if it precedes with
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer» B. Exclamation (!)
Discussion
39.

which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
A. Workday
B. Date
C. Networkdays
D. All of the above
Answer» E.
Discussion
40.

How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32,000
D. 65,535
Answer» E.
Discussion
41.

Data marker on a chart are linked to data points in a worksheet, therefore,
A. You can automatically apply formatting to a data series
B. You can change the position of a data marker and automatically change the data point value in the worksheet
C. You can change a data print value and automatically are draw the chart
D. a and b
Answer» C. You can change a data print value and automatically are draw the chart
Discussion
42.

A typical worksheet has . Number of columns
A. 128
B. 256
C. 512
D. 1024
Answer» C. 512
Discussion
43.

Which of the following formulas will Excel Not be able to calculate?
A. =SUM(Sales)-A3
B. =SUM(A1:A5)*.5
C. =SUM(A1:A5)/(10-10)
D. =SUM(A1:A5)-10
Answer» B. =SUM(A1:A5)*.5
Discussion
44.

Which of the following formulas is not entered correctly?
A. =10+50
B. =B7*B1
C. =B7+14
D. 10+50
Answer» E.
Discussion
45.

Which symbol must all formula begin with?
A. =
B. +
C. (
D. @
Answer» B. +
Discussion
46.

In a worksheet you can select
A. The entire worksheet
B. Rows
C. Columns
D. a, b, and c
Answer» E.
Discussion
47.

to activate the previous cell in a pre-selected range, press
A. the Alt key
B. the Tab key
C. the Enter key
D. none of above
Answer» E.
Discussion
48.

When the formula bar is activated, you can see
A. The Edit Formula button
B. The Cancel button
C. The Enter button
D. All of above
Answer» E.
Discussion
49.

To drag a selected range of data to another worksheet in the same workbook, use the
A. Tab key
B. Alt key
C. Shift key
D. Ctrl key
Answer» E.
Discussion
50.

You can add an image to a template by clicking the Insert Picture From File button on the . Toolbar.
A. Standard
B. Formatting
C. Drawing
D. Picture
Answer» E.
Discussion