Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

179

Excel Questions

1 / 15

1. Which function is used to get a date n working days in the future or past?

A. WORKDAY()

B. DAY()

C. WORKDATE()

D. DAYM()

2 / 15

2. What is the correct value of the function? =ROUND (1.9867,2)

A. 1.98

B. 1.99

C. 2

D. 1

3 / 15

3. 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])

4 / 15

4. 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

5 / 15

5. Which of the following is an example of text in a spreadsheet?

A. 2763

B. Sales 1994 1995

C. =A1+A2+A3

D. .=sum (A1+A2+A3)

6 / 15

6. What is the collection of worksheets called?

A. Ledger

B. Book

C. Testbook

D. Workbook

7 / 15

7. Which feature is used to wrap extra-long text into multiple lines in MS Excel?

A. Word Wrap

B. Letter Wrap

C. Text Wrap

D. Wrap Text

8 / 15

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

A. Hyperlink

B. Index

C. Transpose

D. Rows

9 / 15

9. An array is a systematic arrangement of similar objects, usually in rows and columns.

A. true

B. false

10 / 15

10. Which function is used to get the location of text in a string in MS Excel?

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

11 / 15

11. The intersection of a column and a row in a worksheet is called ____.

A. Box

B. Cell

C. Range

D. Page Break

12 / 15

12. Which of the following is NOT a box in the PivotTable Fields List?

A. Column Labels

B. Report Filter

C. Values

D. Formulas

13 / 15

13. Which function is used to trap and handle errors?

A. IFERROR()

B. ERROR()

C. IFNA()

D. IFTRAP()

14 / 15

14. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

A. Table Styles

B. Stylish Cells

C. Format as Table

D. Cells as Table

15 / 15

15. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

A. Styling

B. Conditional Formatting

C. Compare Formatting

D. Special Formatting

Your score is

The average score is 43%

By WordPress Quiz plugin

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Shubhranshu Shekhar

Shubhranshu Shekhar is a coding instructor, mentor, and founder of VSIT Delhi with 20+ years of teaching experience (since 2004). He has guided many students who are now working in multinational companies and specializes in Full Stack Development, Python, Digital Marketing, and Data Analytics.

Related Posts