Home - Bank Exam - Practice Questions - MS Office Quiz - MS Excel - Advanced MS-EXCEL

MS Office Quiz - MS Excel - Advanced MS-EXCEL Online Exam Quiz

Important questions about MS Office Quiz - MS Excel - Advanced MS-EXCEL. MS Office Quiz - MS Excel - Advanced MS-EXCEL MCQ questions with answers. MS Office Quiz - MS Excel - Advanced MS-EXCEL exam questions and answers for students and interviews.

1. In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013

Options

A : Workday

B : Date

C : Network day

D : Weekday

2. In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore

Options

A : You can automatically apply formatting to a data series

B : You can change the position of a data marker and that automatically changes the data point value in the worksheet

C : You can change a data point value and automatically that is drawn in the chart

D : Both (b) & (c)

3. MS-Excel uses the . . . . Function when creating a data table

Options

A : Average

B : Count

C : Both (a) & (b)

D : Table

4. In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013

Options

A : Workday

B : Date

C : Network day

D : Weekday

5. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu

Options

A : Edit

B : Format

C : Tools

D : All of the above

6. In MS-Excel you can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.

Options

A : Edit

B : Insert

C : Tools

D : None of these

7. In MS-Excel 3-D reference in a formula

Options

A : Cannot be modified

B : Only appears on summary worksheets

C : Both (a) & (b)

D : Spans worksheets

8. What MS-Excel feature can you use if you want to work with one record at a time?

Options

A : AutoComplete

B : Auto Filter

C : Data Form

D : All of the above

9. In MS-Excel what chart object is a horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

Options

A : Category axis

B : Data marker

C : Both (a) & (b)

D : Gridline

10. In MS-Excel value used in a formula that does not change is called a

Options

A : Cell address

B : Constant

C : Function

D : None of these

11. In MS-Excel which elements of the worksheet can be protected from accidental modification?

Options

A : Contents

B : Objects

C : Scenarios

D : All of the above

12. In MS-Excel comments can be added to cells using

Options

A : Edit > Comments

B : Insert > Comments

C : File > Comments

D : None of these

13. In MS-Excel how can you delete a record?

Options

A : Delete the column from the worksheet

B : Select Data > Form from the menu to open the Data Form dialog box, find the record and click the Delete button

C : Select Data > Delete Record from the menu

D : None of these

14. In MS-Excel which of the following is an absolute cell reference?

Options

A : !A!1

B : $A$1

C : #a#1

D : None of these

15. In MS-Excel Documentation should include

Options

A : Destination and users of the output data

B : Source of input data

C : Information on the purpose of the workbook

D : All of the above

16. In MS-Excel chart wizard term data series refers to

Options

A : A chart legend

B : A collection of chart data markers

C : A set of values you plot in a chart

D : None of these

17. In MS-Excel Chart wizard term data categories refer to

Options

A : A chart plot area

B : A horizontal axis

C : The organization of individual values with a chart's data series

D : All of these

18. In MS-Excel how can you find specific information in a list?

Options

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

19. In MS-Excel when integrating MS-Word and MS-Excel, MS-Word is usually the

Options

A : Server

B : Destination

C : Client

D : Both (A) and (C)

20. In MS-Excel Comments put in cells are called

Options

A : Smart tip

B : Cell tip

C : Web tip

D : None of these

Bank Exam - Practice Questions more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.020348072052002