Computer Officer/Bank IT Officer Exam Preparation Materials

Multiple Choice Question (MCQ) on Working with Tables in MS-Excel

1.  While working with two or more workbooks, what can be used to switch between them?

A)           Microsoft Office Button

B)           Windows taskbar

C)           Selection pane

D)           Ribbon

 

2.  What is the default print area of a worksheet?

A)           Visible part of the worksheet

B)           Selected cells

C)           Entire worksheet

D)           Cells A1:Z26

 

3.  What is a list of information with a row of headers followed by rows of data?

A)           Document

B)           Filter

C)           List

D)           Table

 

4.  Which of these statements is not a guideline for creating a list for a table?

A)           The first row should contain descriptive labels.

B)           The data in column A should be in descending order.

C)           The header row should not have repeated labels.

D)           Data in any given column should be of the same type.

 

5.  Which of the following is the correct order for an A to Z sort?

A)           1, 3, 5, 7

B)           7, 5, 3, 1

C)           Tom, John, Adam

D)           May 1, 2007; April 1, 2007; March 1, 2007

 

6.  Which of the following is a link?

A)           $A2

B)           ?A2

C)           A2=

D)           =B2

 

7.  How is COUNTIFS different from COUNTIF?

A)           It sums two cells with multiple arguments.

B)           It counts cells with multiple criteria.

C)           It sum cells with values or labels.

D)           It counts blank and non-blank cells.

 

8.  Which option displays fill color in alternate rows in an Excel table?

A)           Banded Rows

B)           First Row

C)           Last Row

D)           Filled Rows

 

9.  Where might you see a table name?

A)           In the filename extension

B)           In Formula AutoComplete

C)           In Properties and Attributes

D)           In the header row

 

10.  What is used to save a particular arrangement of display and print settings?

A)           Filter

B)           Custom view

C)           Wildcard

D)           Print area

 

ANSWERS:

1

2

3

4

5

6

7

8

9

10

B

C

D

B

A

D

B

A

B

B

 

You are here: Home MCQs Computer Officer Exam Computer Operator Preparation Database System Multiple Choice Question (MCQ) on Working with Tables in MS-Excel