Question # 1

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

What do we call a computer program that organizes data in rows and columns of cells? You might use the type of program to keep a record of the money you keep a record of the money you earned moving lawns over the summer.

Choose an answer

Spread sheet program

Database program

Word processor program

Desktop publisher program

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

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

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

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

You can activate a cell by

Choose an answer

Pressing the tab key

Clicking the cell

Pressing an arrow key

All of above

You can add an image to a template by clicking the insert picture from file button on the toolbar

Choose an answer

Standard

Formatting

Drawing

Picture

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

A function inside another function is called a ................ function.

Choose an answer

Nested

Round

Sum

Text

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

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

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

Choose an answer

Edit

Insert

Format

Tools

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

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

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

You can edit existing Excel data by pressing the

Choose an answer

F1 key

F2 key

F3 key

F4 key

You can use the horizontal and vertical scroll bars to.

Choose an answer

Split a worksheet into two panes

View different rows and columns

Edit the contents of a cell

View different worksheets.

To copy cell contents using drag and drop press the.

Choose an answer

End key

Shift key

Esc key

None 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

Choose an answer