Question

1. In the lowe left corner of the Excel 2010 window. What does blue square icon in the status bar ( outlined in red) indicates?

a. It means that sheets is in ready mode

b. it means that current shape fill color is blue

c. It's the stop button for the macro that is currently being recorded.

d. It means that the current workbook is open in protected mode

e. It means that Excel is currently refreshing local data from the external data sources.

2. Excel backstage allows you to do many workbook related activities such as opening, savings, setting permissions, printing and sharing. Which of the following is not a tab available in the backstage?

a. print

b. share

c. help

d. Info

e. Permissions

3. Bellow top right corner of the Excel 2010 window, what is the purpose of the small button ( outilned in red) that appears right above the vertical scrollbar?

a. It splits the window vertically

b. It locks the verical scrollbar

c. It hides the vertical scroolbar

d. It freezes the panes around the current cell.

e. It enables synchronous scrolling

4. What value will be returned by formula bellow?

=SUM (IF FREQUENCY A1:A9, A1:A9) > 0, 1))

NAMES: A1=33 , B3=48, B6=48, B8=25, B9=33

a. 3

b. 9

c.8

d. #Value

e.#Name

5. The figure bellow shows the excel's name box (A1). Which of the following common functions can Name Box help you with?

Select all answers that apply

a. Show the selected cell address when only one cell is selected

b. show the selected range address when multiple cells are selected.

c. Show the selection size in R x C format during the selection

d. Show a drop-down list of the available defined names

e. Select the corresponding range when a defined name is selecetd from the drop-down list

6. Excel 2010 allows you to apply 3D Format and surface material to both chart are and individual series. Which of the following materials are available in the list of the standard materials in Excel 2010?

Select all answers that apply

a. Plastic

b. wood

c. Matte

d. Charcoal

e. Metal

Answer 1

Answer 1
********
c. It's the stop button for the macro that is currently being recorded.

see screenshot

Answer 2
*********
c. help
e. Permissions

Answer 3
*********
c. It hides the vertical scrolbar

Answer 4
*********
d. #Value

if you have any doubt then please ask me without any hesitation in the comment section below , if you like my answer then please thumbs up for the answer , before giving thumbs down please discuss the question it may possible that we may understand the question different way and we can edit and change the answers if you argue, thanks :)