Excel Test - </> CoderMantra

Excel Questions

1 / 15

1. What dialog box allows you to change a field name in a PivotTable?

A. Field Options

B. Field Pane

C. Field Settings

D. Field Structure

2 / 15

2. Which function returns the current date?

A. Lookup

B. VLookup

C. CountIF

D. NOW

3 / 15

3. In ______ tab you will find AutoSum button.

A. Formatting tab

B. Formulas tab

C. Standard tab

D. Clipboard tab

4 / 15

4. What function displays row data in a column or column data in a row?

A. Hyperlink

B. Index

C. Transpose

D. Rows

5 / 15

5. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?

A. OR

B. AND

C. IF

D. ANDIF

6 / 15

6. IF Statement can be written to carry out an action

A. true

B. false

7 / 15

7. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?

A. Only 1

B. Only 2

C. None of 1 and 2

D. Both 1 and 2

8 / 15

8. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

A. Lookup

B. VLookup

C. NOW

D. CountIF

9 / 15

9. ____ appear at the bottom of the Excel window.

A. Title bar

B. Formula bar

C. Work sheet tabs

D. Name box

10 / 15

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

A. Edit

B. Format

C. Tools

D. All of the above

11 / 15

11. How can we provide a dynamic range in 'data Source' of pivot tables?

A. Create a Named range using Offset function

B. Base the pivot table using the Named range created in Step 1

C. Both A and B

D. None

12 / 15

12. Under which Tab, the chart options are available in MS Excel?

A. Data

B. Insert

C. Review

D. View

13 / 15

13. The NOW function calculates the difference in days between two dates.

A. true

B. false

14 / 15

14. Under which tab and in which function group will you find the option to insert a Pivot Table?

A. Under the Insert tab in the Tables group

B. Under the Formulas tab in the Data Analysis group

C. In the Data group in the Pivot Tables group

D. In the Data group in the Tables group

15 / 15

15. What is the correct syntax of IF() function?

A. =IF (logical_test, {[value_if_true]}, {[value_if_flse]})

B. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

C. =IF (logical_test: [value_if_true], [value_if_false])

D. =IF (logical_test, [value_if_true], [value_if_false])

Your score is

The average score is 43%