Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

179

Excel Questions

1 / 15

1. What is the keyboard shortcut to switch between open Excel windows?

A. CTRL + TAB

B. ALT + TAB

C. CTRL + ALT + TAB

D. None of the above

2 / 15

2. Which function is used to create a date with year, month, and day?

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

3 / 15

3. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

A. CountIF

B. NOW

C. Lookup

D. VLookup

4 / 15

4. Which bar show the used formula of selected active cell?

A. Formula bar

B. Ribbon

C. Menu bar

D. Scroll bar

5 / 15

5. The total number of columns in a worksheet?

A. 26

B. 256

C. 12,834

D. 16,384

6 / 15

6. Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?

A. Workbook Statistics

B. Statistics

C. Excel Statistics

D. Workbook Analysis

7 / 15

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

8 / 15

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

A. Average

B. Count

C. Both of These

D. Table

9 / 15

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

A. WORKDAY()

B. DAY()

C. WORKDATE()

D. DAYM()

10 / 15

10. You can select the current row in MS-Excel Worksheet by pressing?

A. Ctrl + Space bar

B. F8 + arrow key

C. Shift + arrow key

D. Shift + Space bar

11 / 15

11. What is the collection of worksheets called?

A. Ledger

B. Book

C. Testbook

D. Workbook

12 / 15

12. What is the first step for creating a Pivot Table?

A. Clicking on the Insert Tab and inserting a Pivot Table

B. Create or select data that needs to be analyzed

C. Deciding on which fields (column and row labels) to use to analyze the data

D. None of the above

13 / 15

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

14 / 15

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

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

15 / 15

15. The ____ function is used to convert to text in a number format in MS Excel.

A. CONVERT()

B. TEXT()

C. NUM()

D. CONVERTTEXT()

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