Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

184

Excel Questions

1 / 15

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

2 / 15

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

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

3 / 15

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

A. true

B. false

4 / 15

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

5 / 15

5. _____ are equations that perform calculations on values in your worksheet.

A. Functions

B. References

C. Formulas

D. Constants

6 / 15

6. Getting data from a cell located in a different worksheet is called?

A. Accessing

B. Referencing

C. Updating

D. Functioning

7 / 15

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

A. Title bar

B. Formula bar

C. Work sheet tabs

D. Name box

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 function will you use to enter current date and time in a worksheet cell?

A. =today()

B. =now()

C. =time()

D. =currentTime()

10 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

11 / 15

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

12 / 15

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

13 / 15

13. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

A. CTRL + F

B. ALT + 1

C. CTRL + SHIFT + F

D. CTRL + 1

14 / 15

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

A. WORKDAY()

B. DAY()

C. WORKDATE()

D. DAYM()

15 / 15

15. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

A. OR

B. AND

C. IF

D. ANDIF

Your score is

The average score is 42%

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