Question # 1

You can activate a cell by

Choose an answer

Pressing the tab key

Clicking the cell

Pressing an arrow key

All of 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

Status indicators are located on the

Choose an answer

Vertical scroll bar

Horizontal scroll bar

Formula bar

Formatting tool bar

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

Choose an answer

Edit

Insert

Format

Tools

Where can you set the shedding color for a range of cells in Excel.

Choose an answer

Choose required color form patterns tab of format cells dialog box

Choose required color on fill color tool in formatting toolbar

Choose required color on fill color tool in drawing toolbar

All of above

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

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

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

When you work with large worksheets you may need to

Choose an answer

Size the worksheet to fit on the specific number of pages.

Add and remove page breaks

Specify only certain print areas

All of above

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

How are data organized in a spread sheet.

Choose an answer

Lines and spaces

Layers and planes

Rows and columns

Height and width

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

Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result.

Choose an answer

IF

AND

OR

NOT

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

Choose an answer

Edit

Format

View

Tools

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

Choose an answer

Cell value

Formula

Both of above

None of above

In a worksheet yo can select

Choose an answer

The entire worksheet

Rows

Columns

a,b and c

You can open the scenario manager dialog box by choosing scenarios from the ..............menu

Choose an answer

view

Insert

Tools

Format

The autofill feature

Choose an answer

Extends a sequential series of data

Automatically adds a range of cell values

Applies a boarder around selected cells.

None of above

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

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