Question # 1

If you need a text to show vertically in a cell .how will you achieve this.

Choose an answer

Choose vertical on text alignment in format cells dialog box

Choose 90 degrees in orientation of format cells dialog box

Choose distributed from the vertical drop down list of format cells dialog box

Choose center Across selection from horizontal combo box in format cells dialog box

Which is following is not an option in the spelling dialog box.

Choose an answer

Edit

Ignore

Ignore all

Change

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

Choose an answer

= today()

=now()

= time()

= current time()

To copy cell contents using drag and drop press the.

Choose an answer

End key

Shift key

Esc key

None 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.

You can quickly change the appearance of your work by choosing Auto format from the Menu.

Choose an answer

Edit

Format

View

Tools

Which of the following describes how to select all the cells in a single column.

Choose an answer

Right click on column and select pick from list

Use data text to columns menu item

Left click on the gray column title button

Pressing Ctrl + A on the keyboard

How are data organized in a spread sheet.

Choose an answer

Lines and spaces

Layers and planes

Rows and columns

Height and width

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

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

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

None of above

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

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

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

When working in the page break preview you can.

Choose an answer

View exactly where each page break occurs.

Add or remove page breaks

Change the print area

All of above

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

What is the keyboard shortcut for creating a chart from the selected cells.

Choose an answer

F3

F6

F11

F7

Which of the following methods cannot be used to edit the content of cell.

Choose an answer

Pressing the Alt key

Clicking the formula bar

Pressing F2

Double clicking the cell

To protect a worksheet, you can choose protection and the protect sheet from the menu.

Choose an answer

Edit

Tools

Data

Format

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

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