MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 161 - 170 of 1111 Questions

Formatting a cell in Currency, you can specify

A Decimal Places
B Currency Symbol
C Both of above
D None of above
Correct Answer

Option C: Both of above


Discussion

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
Correct Answer

Option C: From Format Cells dialog box mark Shrink to fit check box


Discussion

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
Correct Answer

Option C: Indentation can be set from Format Cells dialog box


Discussion

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
Correct Answer

Option B: Choose 90 Degrees in Orientation of Format Cells dialog box


Discussion

The spelling tool is placed on ______ toolbar

A Standard
B Formatting
C Drawing
D Reviewing
Correct Answer

Option A: Standard


Discussion

Which of the following is not a valid Zoom percentage in Excel?

A 10
B 100
C 300
D 500
Correct Answer

Option D: 500


Discussion

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

A HTML
B Pivot Table Field List
C Pivot Table List
D Pivot Table Report
Correct Answer

Option D: Pivot Table Report


Discussion

Excel is a

A Graphic program
B None of these
C Word processor
D A spreadsheet
Correct Answer

Option D: A spreadsheet


Discussion

what term describes a background that appears as a grainy, non smooth surface

A gradient
B pattern
C solid
D texture
Correct Answer

Option A: gradient


Discussion

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

A Goal Seek
B Scenario Summary report
C Forecasting
D Trend line
Correct Answer

Option D: Trend line


Discussion



WhatsApp Support