Question # 1

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

You can set page border in Excel from

Choose an answer

From border tab in format cells dialog box

From Border tool in formatting toolbar

From line style tool in Drawing toolbar

You can not set page border in Excel

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

To active the previous cell in a pre selected range press.

Choose an answer

The Alt key

The tab key

The Enter key

None of above

Which of the following is not a basic step in creating a worksheet.

Choose an answer

Save the workbook

Modify the worksheet

Enter text and data

Copy the worksheet

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

How are data organized in a spread sheet.

Choose an answer

Lines and spaces

Layers and planes

Rows and columns

Height and width

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

In a worksheet yo can select

Choose an answer

The entire worksheet

Rows

Columns

a,b and c

You can open the sort dialog box by choosing sort from the .....menu.

Choose an answer

view

Format

Tools

Data

What is an expression that tells how the numbers in a determined set of cells are to be calculated.

Choose an answer

Formula

Field

Data

query

A data map is helpful

Choose an answer

When you have too much data to chart

To show a geographic distribution of data

To compare data points

To show changes in data over time

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

If you press ........the cell accepts your typing as the contents.

Choose an answer

Enter

Ctrl + Enter

Tab

Insert

What is a quick way to extend these numbers to a longer sequence for instance 1 through 20

Choose an answer

Select both cells and then drag the fill handle over the range you want for instance 18 more rows.

Select the range you want include both cells point to till on the edit menu, and then click down.

Copy the second cell click in the cell below it on the standard toolbar click the down arrow on the paste button and than click paste special

All above

How do you change column width to fit the contents.

Choose an answer

Single click the boundary to the left to the column heading

Double click the boundary to the right of the column heading

Press Alt and single click any ware is the column

All of above

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

Choose an answer

G1 - G10

B1 ,G10

B1:G10

B1;G10

You can print only an embedded chart by

Choose an answer

Moving the chart to a chart sheet before you print.

Formatting the chart before you print

Selecting the chart before you print

a and c

What does the VLOOKUP function do.

Choose an answer

Looks up text that contain

Checks whether text is the same in one cell as in the next

Finds related records

All of above

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