Home
Current Affairs January 2024

What is the correct answer?

4

The spelling dialog box can be involved by choosing spelling from ________ menu.

A. insert

B. file

C. tools

D. view

Correct Answer :

C. tools


Related Questions

What is the correct answer?

4

Tab scrolling button

A. Allow you to view a different worksheet

B. Allow you to view additional worksheet rows down

C. Allow you to view additional worksheet columns to the right

D. Allow you to view additional sheets tabs

What is the correct answer?

4

To copy cell contents using drag and drop press the

A. End key

B. Shift key

C. Ctrl key

D. Esc key

What is the correct answer?

4

You can convert existing excel worksheet data an charts to an HTML document by using

A. FTP wizard

B. Internet assistant wizard

C. Intranet wizard

D. Import wizard

What is the correct answer?

4

Concatenation of text can be done using

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

What is the correct answer?

4

How do you insert a row?

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

B. Select the row heading where you want to insert the new row and select Edit >Row from the menu

C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

D. All of the above

What is the correct answer?

4

To select an entire column in MS-EXCEL, press?

A. CTRL + C

B. CTRL + Arrow key

C. CTRL + S

D. None of the above

What is the correct answer?

4

Getting data from a cell located in a different sheet is called ......

A. Accessing

B. Referencing

C. Updating

D. Functioning

What is the correct answer?

4

When you want to insert a blank imbedded excel object in a word document you can

A. Click the object command on the insert menu

B. Click the office links button on the standard toolbar

C. Click the create worksheet button on the formatting toolbar

D. Click the import excel command on the file menu

What is the correct answer?

4

Which of the following is not a term of MS-Excel?

A. Cells

B. Rows

C. Columns

D. Document

What is the correct answer?

4

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

A. Pie chart

B. Row chart

C. Line chart

D. Column chart

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

What is the correct answer?

4

Which elements of worksheet can be protected from accidental modification

A. Contents

B. Objects

C. Scenarios

D. All of above

What is the correct answer?

4

You cannot link excel worksheet data to a word document

A. With the right drag method

B. With a hyperlink

C. With the copy and paste special commands

D. With the copy and paste buttons on the standard toolbar

What is the correct answer?

4

When the formula bar is active, you can see

A. The edit formula button

B. The cancel button

C. The enter button

D. All of the above

What is the correct answer?

4

How do you delete a column?

A. Select the column heading you want to delete and select the Delete Row button on the standard toolbar

B. Select the column heading you want to delete and select Insert Delete from the menu

C. Select the row heading you want to delete and select Edit>Delete from the menu

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

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

Which of the following is not a valid data type in Excel?

A. Number

B. Character

C. Label

D. Date/Time

What is the correct answer?

4

Right clicking something in Excel:

A. Deletes the object

B. Nothing the right mouse button is there for left handed people

C. Opens a shortcut menu listing everything you can do to the object

D. Selects the object

What is the correct answer?

4

Which of the following is not a worksheet design criterion?

A. Efficiency

B. Aditibility

C. Description

D. Clarity

What is the correct answer?

4

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

What is the correct answer?

4

When you insert an excel file into a word document. The data are

A. Hyperlinked placed in a word table

B. Linked

C. Embedded

D. Use the word menu bar and toolbars

What is the correct answer?

4

The Chart wizard term data categories refers to;

A. A chart plot area

B. A horizontal axis

C. The organization of individual values with a charts data series

D. The data range that supply chart data

What is the correct answer?

4

The autofill feature

A. extends a sequential series of data

B. automatically adds range of cell values

C. applies a boarder around the selected cells

D. none of the above

What is the correct answer?

4

Which menu option can be sued to split windows into two

A. Format > window

B. View > window > split

C. Window > split

D. View > split

What is the correct answer?

4

How do you rearrange the data in ascending or descending order?

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

What is the correct answer?

4

How many characters can be typed in a single cell in Excel?

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

Comments can be added to cells using

A. Edit > Comments

B. Insert > Comments

C. File > Comments

D. View > Comments

What is the correct answer?

4

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

What is the correct answer?

4

Concatenation of text can be done using

A. Apostrophe ( )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

What is the correct answer?

4

Text formulas:

A. Replace cell references

B. Return ASCII values of characters

C. Concatenate and manipulate text

D. Show formula error value