MS Excel

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

In Excel which of the following is not a worksheet design criterion

Description

In Excel the auto calculate feature

Provides a quick way to view the result of an arithmetic operation on a range of cells

In Excel..... is a group of cells that form a rectangle on the screen

Range

In Excel you can print

(A) A range of cells by range name (B) An entire workbook (C) A single worksheet

In Excel you can create hyperlinks from the Excel workbook to

(A) A webpage on company internet (B) A web page on the internet (C) Other Office application documents

In Excel you can insert labels for

(A) All the data markers on a chart (B) A data series (C) A selected data marker

In Excel Charts tips can

(B) Show the name of a data series (C) Show the value of data point

In Excel using the F11 shortcut key to create a chart on chart sheet creates

A 2-dimensional column chart

In Excel the chart wizard

Can only place a chart on new chart sheet

Comments put in cells are called

Cell tip

In Excel Comments put in cells are called

Cell tip

In Excel which of the following is not a valid data type in excel

Character

In Excel to select a column the easiest method is to

Click the column heading

In Excel following term describes explanatory text attached to a cell

Comment

In Excel LEN function does what

Compares the content in two cells

In Excel which elements of worksheet can be protected from accidental modification

Contents, Objects and Scenarios

Which of the following is not a basic step in creating a worksheet

Copy the worksheet

In Excel which do you press to enter the current date in a cell

Ctrl + ;

In Excel to access the Go To Special feature, you can press

Ctrl + G

In Excel to name a constant, you use the ...... dialog box

Define name

In Excel how do you change column width to fit the contents

Double click the boundary to the right of the column heading

In Excel when creating a vertical page break the active cell must be in

row 1

In Excel Hyperlinks can be

stars and banners and rectangles ovals

In Excel which menu option can be sued to split windows into two

Window > split

In Excel data marker on a chart are linked to data points in a worksheet, therefore

You can change the position of a data marker and automatically change the data point value in the worksheet

Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series

File handle

In Excel name box

In Excel name box

In Excel worksheet range is a

In Excel worksheet range is a

In Excel you can edit a cell by

In Excel you can edit a cell by

In Excel the following describes how to select all the cells in a single column

Left click on the gray column title button

In Excel when you insert an excel file into a word document. The data are

Linked

In Excel accounting style shows negative numbers in

Parentheses

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

Review

In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.

Review

To copy formatting from one area in a worksheet and apply it to another area you would use:

The Format Painter button on the standard toolbar

In Excel the Paste Special command lets you copy and paste

The resulting values of a formula instead of the actual formula

In Excel when you see a cell with a red triangle in the top right corner, what does this signify

There is a comment associated with the cell

In Excel intersection of a row and column is called

cell

In Excel two common wildcard characters that Excel recognizes are

* and ?

In Excel how many characters can be typed in a single cell

65,535

In Excel you can use the drag and drop method to

(A) Copy cell contents (B) Move cell contents

What excel feature can you use if you want to work with one record at a time

Data Form

In Excel you can quickly change the appearance of your work by choosing Auto Format from the ........... Menu

Format

In Excel to move to the previous worksheet, press

In Excel you can convert existing excel worksheet data an charts to an HTML document by using? Internet assistant wizard

In Excel it is acceptable ot let long text flow into adjacent cells on a worksheet when

No data will be entered in the adjacent cells

In Excel default style for new data keyed in a new workbook is

Normal

In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet

Press Ctrl +Home

Which of the following methods cannot be used to edit the contents of a cell In Excel

Press the Alt key

Which of the following will not cut information

Pressing Ctrl + C

How do you insert a row

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

In Excel term refers to a specific set of values saved with the workbook

Scenario

In Excel how can you delete a record

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

How can you find specific information in a list

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

How can you print three copies of a workbook

Select File >Print from the menu and type 3 in the Number of copies text box

In Excel to delete and embedded object, first

Select it and then press Delete key

In Excel to delete an embedded objects, first

Select it and then press the delete key

To create a formula, you first:

Select the cell you want to place the formula into

When the formula bar is active, you can see

a. The edit formula button b. The cancel button c. The enter button

In Excel Tab scrolling button Allow you to view

additional sheets tabs

Multiple calculations can be made in a single formula using

array formula

When integrating word and excel, word is usually the

b. Destination c. Client

Files created with Lotus 1-2-3 have an extension

123

In Excel chart wizard term data series refers to

A collection of chart data markers

In Excel on an excel sheet the active cell in indicated by

A dark wide boarder

In Excel circular reference is

A formula that either directly or indirectly depends on itself

In Excel Chart wizard term data categories refers to

A horizontal axis

In Excel what does SUMIF function do

Adds up cell values based on a condition

In Excel concatenation of text can be done using

Ampersand (&)

In Excel numeric value can be treated as a label value if it precedes with

Ampersand (&)

In Excel autofill feature

Automatically adds range of cell values

In Excel you can use drag and drop to embed excel worksheet data in a word document

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key OR By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

In Excel the drag and drop method of copying or moving

Can be used between workbooks but not worksheets

In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page

Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

How do you select an entire column

Click the column heading letter

In Excel you can use the formula palette to

Create and edit formulas containing functions

In Excel to open the Format Cells dialog box, press

Ctrl + 1

In Excel you can use the format painter multiple times before you turn it off by

Double clicking the format painter button In Excel default header for a worksheet is?None

In Excel you can select a single range of cells by

Dragging over the desired cells

In Excel the following is not information you can specify using the solver

Input cells

In Excel the following is not an underline option in the format cells dialog box

Single Engineering

In Excel 3-D reference in a formula

Spans worksheets

In Excel this type of software is similar to an accountant's worksheet

Spreadsheets

In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell

Sum

In Excel when you group worksheets

You can print more than one worksheet at a time OR You can enter common data, formats, and formulas on multiple worksheets at one time

Which is used to perform what if analysis

a. Solver b. Goal seek c. Scenario Manager

Which of the following is not a way to complete a cell entry

Pressing spacebar

Which of the following methods cannot be used to enter data in a cell

Pressing the Esc key

In Excel the following setup options cannot be set in the page setup dialog box

Printer selection

In Excel getting data from a cell located in a different sheet is called

Referencing

You cannot link Excel worksheet data to a Word document

With the copy and paste buttons on the standard toolbar

You can activate a cell by

a. Pressing the Tab key b. Clicking the cell c. Pressing an arrow key

In Excel typical worksheet has .... Number of columns

256

In Excel what symbol is used before a number to make it a label

= (equal)

In Excel All macro keyboard shortcuts include the ..... key

ALT

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

Page Break Preview

How do you delete a column

Right click the column heading you want to delete and select delete from the shortcut menu

In Excel how do you insert a row

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

To center worksheet titles across a range of cells, you must

Select the cells containing the title text plus the range over which the title text is to be centered

In Excel to cancel the marquee, press

esc

In Excel if you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you press

esc button

The name box Appears to the

left of the formula bar

In Excel constant is another name for this type of data

number

There are three types of data found in a spreadsheet

numbers formulas, labels


संबंधित स्टडी सेट्स

Principles of Marketing: Ch. 1 Prep

View Set

Chapter 6: Clinical Assessment and Diagnosis

View Set

Legalism, Daoism, Buddhism and Confucianism

View Set

Chapter 11: Digestive System Diseases and Disorders

View Set

Anatomy and Physiology - Chapter 1 HW Study

View Set