AGBE 3200

Ace your homework & exams now with Quizwiz!

You can activate a cell by ?

All of the above

Which of these will not select all the cells in a document ?

Clicking three times with the right mouse button in the spreadsheet

How do you change column width to fit the contents ?

Double click the boundary to the right of the column heading

Which among following is not associated with spelling dialogue box ?

Edit

If you press ___, the cell accepts your typing as its contents ?

Enter

The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

C1:H10

What is shortcut to enter current date in cell in excel ?

CTRL + ;

To drag a selected range of data to another worksheet in the same workbook, use the ?

CTRL Key

Shortcut to edit the selected cell ?

F2

You can convert existing Excel worksheet data and charts to HTML document by using the ?

Internet Assistant Wizard

Which function in excel counts the numbers of characters in a cell ?

LT

What term describes explanatory text attached to a cell ?

comment

Shortcut to delete the selected column ?

ctrl + -

Which shortcut can be used to Switch between open workbooks ?

ctrl + F6

Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?

f11

A function inside another function is known as ?

Nested Function

The default style for new data keyed in a new workbook is ?

Normal

Which function calculates your monthly mortgage payment ?

PMT

The accounting style shows negative numbers in ?

Parentheses

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

Pivot Table Report

A Spreadsheet contains ?

Rows and columns

How is data organized in a spreadsheet ?

Rows and columns

VLOOKUP function used to ?

Finds related records

what term describes a background that appears as a grainy, non smooth surface ?

Gradient

To insert three columns between columns A and B you would

Select B

Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

IF

Which function is used for creating a data table

Table

How we can view a cell comment ?

position the mouse pointer over the cell

Which among following wildcard characters are recognized by excel ?

* and ?

Which of the following is not a valid Zoom percentage in Excel ?

500

With which of the following all formulas in excel starts ?

=

On an excel sheet the active cell in indicated by ?

A Blinking Border

Which types of charts can excel produce ?

Bar charts, line graphs, and pie charts

You can check the conditions against _____ when applying conditional formatting ?

Both of above (cell value & formula)

A value used in a formula that does not change is called a ?

Constant

Which function converts miles to kilometers ?

Convert

Formula palette is used to ?

Create and edit formulas containing functions

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

Data Form

3-D reference in a formula ?

Spans Worksheet

Which among following is associated with excel ?

Spreadsheet

To open an existing workbook, click the Open button on the ___ toolbar ?

Standard

Macros can be executed from the which of the following menu ?

Tools

Protection and the Protect Sheet options can be selected from ?

Tools

What function displays row data in a column or column data in a row ?

Transpose

How can we set Page Border in Excel ?

You can not set a page border in Excel


Related study sets

Which of the following statements about endotoxins is true

View Set

General Insurance - Practice Scenarios

View Set

Exámen 2 (Química Instrumental) (Chp.9)

View Set

macro topic 7 practice questions

View Set

PNSCE - Firewall 10.0: WildFire Versus Malware

View Set