Question # 1

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

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

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

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

Choose an answer

Decimal places

Currency symbol

Both of above

None 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

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

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

Which of the following methods can not be used to enter data in a cell.

Choose an answer

Pressing an arrow key

Pressing the tab key

Pressing the Esc key

Clicking the enter button to the formula bar

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.

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

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

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

Macros are 'run' or executed from the ...........menu

Choose an answer

Insert

Format

Tools

Data

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

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

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

None of above

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

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 refers to a specific set of values saved with the workbook.

Choose an answer

Range

Scenario

Trend line

What if analysis

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