Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

175

Excel Questions

1 / 15

1. Which function returns the current date?

A. Lookup

B. VLookup

C. CountIF

D. NOW

2 / 15

2. You can select the current Column in MS-Excel Worksheet by pressing?

A. Ctrl + Space bar

B. F8 + arrow key

C. Shift + arrow key

D. Shift + Space bar

3 / 15

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

A. Average

B. Count

C. Both of These

D. Table

4 / 15

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

5 / 15

5. Excel is a program that is used to prepare a

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

6 / 15

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

A. Title bar

B. Formula bar

C. Work sheet tabs

D. Name box

7 / 15

7. Press _____ to bring up search box.

A. Shift + F3

B. Shift + F4

C. Shift + F5

D. Shift + F6

8 / 15

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

9 / 15

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

10 / 15

10. In ______ tab you will find AutoSum button.

A. Formatting tab

B. Formulas tab

C. Standard tab

D. Clipboard tab

11 / 15

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

A. 1.98

B. 1.99

C. 2

D. 1

12 / 15

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

13 / 15

13. Excel is a ____ program developed by Microsoft.

A. Spreadsheet

B. Document

C. Data management

D. All of the above

14 / 15

14. What function will result in the total number of entries in the cell range B5 to B14

A. Count

B. MAX

C. MIN

D. SUM

15 / 15

15. When you insert an Excel file into a Word document, the data are

A. Hyperlinked

B. Placed in a word table

C. Linked

D. Embedded

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