Question # 1

What feature enables yo to adjust or back solve the value in a cell to reach a desired outcome in a formula.

Choose an answer

Goal seek

Scenario summary report

Forecasting

Trend line

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

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

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

What term described a back ground that appears as a grainy non smooth surface.

Choose an answer

Gradient

Pattern

Solid

Texture

What term refers to a specific set of values saved with the workbook.

Choose an answer

Range

Scenario

Trend line

What if analysis

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

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

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

Choose an answer

Edit

Insert

Format

Tools

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

When working in the page break preview you can

Choose an answer

View exactly where each page break occurs

Add or remover page breaks

Change the print area

All of above

Formatting a cell in number format you can't set.

Choose an answer

Decimal places

Currency symbol

Both of above

None of above

When yu use the fill effects in the format data series dialog box you can not.

Choose an answer

Rotate text on the chart

Select a fore ground color

Select a pattern

Select a background color

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

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

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

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

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

Choose an answer

= today()

=now()

= time()

= current time()

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

To create an interactive pivot table for the web you use a Microsoft Office web component called.

Choose an answer

HTML

Pivot Table field list

Pivot Table list

Pivot Table Report

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