Question # 1

Which of the following format you can decide to apply or not in auto format dialog box.

Choose an answer

Number format

Border format

Font format

All of above

Each excel file is called a workbook because.

Choose an answer

It can contain text and data

It can be modified

It can contain many sheets including worksheets and chart sheets

you have to work hard to create it.

When you print preview a worksheet.

Choose an answer

The entire worksheet is displayed

The selected range is displayed

The active portion of the worksheet is displayed

a , b and c

Got function? No ? you need the insert function dialog box. How do you get it.

Choose an answer

Right click a cell and then click insert.

Click the insert menu and then click function

Type = in a cell

As of the above

Paper spreadsheets can have all the same advantages as an electronic spread sheet except which of the following.

Choose an answer

Rows and columns

Headings

Speed

None

What function displays row data in a column or column data in a row.

Choose an answer

Hyperink

Index

Transpose

Rows

Macros are 'run' or executed from the ...........menu

Choose an answer

Insert

Format

Tools

Data

Which of the following setup options can not be set in the page setup dialog box.

Choose an answer

Printer selection

Vertical or horizontal placement

Orientation

Raw and column titles

Which of the following is not a valid zoom percentage in Excel.

Choose an answer

10

100

500

300

You can check the conditions against ______ when applying conditional formating.

Choose an answer

Cell value

Formula

Both of above

None of above

You can open the Highlight changes dialog box by choosing track changes from the menu.

Choose an answer

Edit

Insert

Format

Tools

How can you remove borders applied in cells.

Choose an answer

Choose none on border tab of format cells.

Open the list on border tool in formatting toolbar then choose fist tool

Both of above

None of above

What Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed.

Choose an answer

Format Report

Pivot table

Refresh Data

Show detail

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

You can copy data or formulas

Choose an answer

With the copy paste and cut commands on the edit menu

With commands an a shortcut menu

With buttons on the standard toolbar

All of the above

When you insert an excel file into a word document the data are.

Choose an answer

Hyperlinked

Placed in a word table

Linked

Embedded

When creating a vertical page break.

Choose an answer

The active cell must be A1

The active cell can be anywhere in the worksheet.

The active cell must be in row 1

The active cell must be in column A

Pre-made sheet formats like simple classic accounting colorful can be applied from.

Choose an answer

From format >> cells

From Table >> autoformat

From format >> autoformat

All of above

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

Charts tips can

Choose an answer

Show the formatting of a data label

Show the name of a data series

Show the value of data point

B and C

Which function will you use to enter current time in a worksheet cell.

Choose an answer

= today()

=now()

= time()

= current time()

More Classes

Other Links

PPSC Computer Science Chapter 4 Microsoft Excel Online Test MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer