OM COMPUTER CLASSES (28210103)

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

MICROSOFT EXCEL QUIZ

50% COMPULSORY & GET E-CERTIFICATE

Email *

FULL NAME (As Per Certificate) *

CONTACT *

STATE *

CITY *

INSTITUTION NAME *

EXCEL QUIZ START

In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013 *

5 points

Workday

Weekday

Networkday

Date

MS-Excel uses the . . . . Function when creating a data table *

5 points

Average

Count

Table

Tab

In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu *

5 points

Tools

Format

Edit

All of the above

In MS-Excel 3-D reference in a formula *

5 points

Spans worksheets

Cannot be modified

Only appears on summary worksheets

Both (a) & (b)

What MS-Excel feature can you use if you want to work with one record at a time? *

5 points

Auto Complete

Auto Filter

Data Form

All of the above

In MS-Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values? *

5 points

Category axis

Data marker

Both (a) & (b)

Gridline

In MS-Excel value used in a formula that does not change is called a *

5 points

Cell address

Constant

Function

None of these

In MS-Excel which elements of worksheet can be protected from accidental modification? *

5 points

Contents

Objects

Scenarios

All of above

In MS-Excel comments can be added to cells using *

5 points

Edit > Comments

Insert > Comments

File > Comments

None of these

In MS-Excel how can you delete a record? *

5 points

Delete the column from the worksheet

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

Select Data > Delete Record from the menu

None of these

In MS-Excel which of the following is an absolute cell reference? *

5 points

!A!1

$A$1

#a#1

None of these

In MS-Excel Documentation should include *

5 points

Destination and users of the output data

Source of input data

Information on the purpose of the workbook

All of the above

In MS-Excel chart wizard term data series refers to *

5 points

A chart legend

A collection of chart data markers

A set of values you plot in a chart

None of these

In MS-Excel Chart wizard term data categories refers to *

5 points

A horizontal axis

The organization of individual values with a chart's data series

A chart plot area

All of these

In MS-Excel two common wildcard characters that MS-Excel recognizes are *

5 points

* and ?

< and >

^ and /

None of these

In MS-Excel how can you find specific information in a list? *

5 points

Select Tools > Finder from the menu

Click the Find button on the standard toolbar

Select lnsert > Find from the menu

Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

In MS-Excel when integrating MS-Word and MS-Excel, MS-Word is usually the *

5 points

Server

Destination

Client

Both (A) and (C)

In MS-Excel which is used to perform what if analysis? *

5 points

Solver

Goal seek

Scenario Manager

All of above

In MS-Excel Book1 is an example of how . . . are numbered and named during each work session *

5 points

Active cell

Formula bar

Menu bar

Name box

In MS-Excel the view that puts a blue a blue line around each page that would be printed is the *

5 points

Print Preview

Normal View

Page Break Preview

None of these

Send me a copy of my responses.

Submit

Clear form

Never submit passwords through Google Forms.

reCAPTCHA

Privacy Terms

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms