Home
Current Affairs January 2024

What is the correct answer?

4

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

A. Right click on Sheet Tab of third sheet and choose Delete from the context menu

B. Click on Sheet 3 and from Edit menu choose Delete

C. Both of above

D. None of above

Correct Answer :

A. Right click on Sheet Tab of third sheet and choose Delete from the context menu


Related Questions

What is the correct answer?

4

While Finding and Replacing some data in Excel, which of the following statement is valid?

A. You can Find and Replace within the sheet or workbook

B. Excel does not have option to match case for find

C. Both are valid

D. None are valid

What is the correct answer?

4

Which of the cell pointer indicates you that you can make selection?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above

What is the correct answer?

4

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

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

B. Widen the columns

C. Select the cells containing the title text plus the range over which the title text is to be enfettered

D. Format the cells with the comma style

What is the correct answer?

4

You can activate a cell by

A. Pressing the Tab key

B. Clicking the cell

C. Pressing an arrow key

D. All of the above

What is the correct answer?

4

In Excel, a Data Series is defined as what?

A. A type of chart

B. A cell reference

C. A collection of related data

D. A division of results

What is the correct answer?

4

Which of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1

What is the correct answer?

4

Microsoft Excel is a powerful ...........

A. Word processing package

B. Spreadsheet package

C. Communication S/W Package

D. DBMS package

What is the correct answer?

4

You can auto fit the width of column by

A. double clicking on the column name on column header

B. Double click on the cell pointer in worksheet

C. Double clicking on column right border on column header

D. Double clicking on the column left border of column header

What is the correct answer?

4

An Excel Workbook is a collection of .......

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and Charts

What is the correct answer?

4

A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

What is the correct answer?

4

Which button do you click to add up a series of numbers?

A. The autosum button

B. The Formula button

C. The quicktotal button

D. The total button

What is the correct answer?

4

Which of the following options is not located in the Page Setup dialog box?

A. Page Break Preview

B. Page Orientation

C. Margins

D. Headers and Footers

What is the correct answer?

4

A worksheet can have a maximum of …. Number of rows

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

Which of the following is not an example of a value?

A. 350

B. May 10, 2001

C. 0.57

D. Serial Number 50771

What is the correct answer?

4

How can you show or hide the gridlines in Excel Worksheet?

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

B. Click Gridline tool on Forms toolbar

C. Both of above

D. None of above

What is the correct answer?

4

What is represented by the small, black square in the lower-right corner of an active cell or range?

A. Copy handle

B. Fill handle

C. Insert handle

D. Border

What is the correct answer?

4

You can enter which types of data into worksheet cells?

A. Labels, values, and formulas

B. Labels and values but not formulas

C. Values and formulas but not labels

D. Formulas only

What is the correct answer?

4

Which of the cell pointer indicates that you can fill series?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above

What is the correct answer?

4

The short cut key Ctrl + R is used in Excel to

A. Right align the content of cell

B. Remove the cell contents of selected cells

C. Fill the selection with active cells to the right

D. None of above

What is the correct answer?

4

Which of the following option is not available in Paste Special dialog box?

A. Add

B. Subtract

C. Divide

D. SQRT

What is the correct answer?

4

Which of the following is not information you can specify using the solver?

A. Input cells

B. Constraints

C. Target cell

D. Changing cells

What is the correct answer?

4

What do you mean by a Workspace?

A. Group of Columns

B. Group of Worksheets

C. Group of Rows

D. Group of Workbooks

What is the correct answer?

4

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

A. Option buttons

B. List boxes

C. Text boxes

D. Combo boxes

What is the correct answer?

4

The Cancel and Enter buttons appear in the:

A. Title bar

B. Formula bar

C. Menu bar

D. Sheet tabs

What is the correct answer?

4

An excel workbook is a collection of

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and charts

What is the correct answer?

4

The chart wizard term data series refers to

A. A chart legend

B. A collection of chart data markers

C. A set of values you plot in a chart

D. A data label

What is the correct answer?

4

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

A. work sheet

B. chart sheet

C. module sheet

D. data sheet

What is the correct answer?

4

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

A. ROUND ( )

B. FACT ( )

C. MOD ( )

D. DIV ( )

What is the correct answer?

4

When a label is too long to fit within a worksheet cell, you typically must

A. Shorten the label

B. Increase the column width

C. Decrease the column width

D. Adjust the row height

What is the correct answer?

4

In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. &