Home
Current Affairs January 2024

What is the correct answer?

4

When a range is selected, how can you activate the previous cell?

A. Press the Alt key

B. Press Tab

C. Press Enter

D. None of above

Correct Answer :

D. None of above


Related Questions

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

B7:B9 indicates:

A. Cells B7 and cell B9 only

B. Cells B7 through B9

C. Cell B8 only

D. None of the above

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

You can edit a cell by

A. Clicking the formula button

B. Double clicking the cell to edit it in-place

C. Selecting Edit>Edit Cell from the menu

D. None of above

What is the correct answer?

4

The Delete key of keyboard is assigned to which command in Excel?

A. Edit >> Clear >> Contents

B. Edit >> Clear >> All

C. Edit >> Delete

D. All of 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

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

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

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and Charts

What is the correct answer?

4

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A. Logical

B. Math & Trigonometry

C. Statistical

D. Financial

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

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

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

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

How can you remove borders applied in cells?ACC

A. Choose None on Border tab of Format cells

B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)

C. Both of above

D. None of above

What is the correct answer?

4

What does COUNTA () function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

What is the correct answer?

4

You can select a single range of cells by

A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B. Pressing the Ctrl key while dragging over the desired cells

C. Pressing the Shift key and an arrow key

D. Dragging over the desired cells

What is the correct answer?

4

How can you find specific information in a list?

A. Select Tools > Finder from the menu

B. Click the Find button on the standard toolbar

C. Select Insert > Find from the menu

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

What is the correct answer?

4

Tab scroll buttons are place on Excel screen

A. towards the bottom right corner

B. towards the bottom left corner

C. towards the top right corner

D. towards the top left corner

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

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

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command on the edit menu

D. Split command on the window menu

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

Concatenation of text can be done using

A. Apostrophe ( )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

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 is not a valid data type in excel

A. Number

B. Character

C. Label

D. Date/time

What is the correct answer?

4

Multiple calculations can be made in a single formula using .......

A. Standard Formulas

B. Array Formula

C. Complex Formulas

D. Smart Formula

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

What is the short cut key to replace a data with another in sheet?

A. Ctrl + R

B. Ctrl + Shift + R

C. Ctrl + H

D. Ctrl + F

What is the correct answer?

4

Which of the following is not true regarding Conditional Formatting?

A. You can add more than one condition to check

B. You can set condition to look for Bold and apply Italics on them

C. You can apply Font, border and pattern formats that meets the specified conditions

D. You can delete any condition from Conditional Formatting dialog box if it is not requried