MS Excel MCQs

Which of the following is not a valid option to insert a hyperlink in excel, which can link to?

1. existing file or web page
2. place in this document
3. e-mail address
4. link to home

The Function ________ in Excel is used to look up information in a table and extract the corresponding data.

1. FETCH
2. GET
3. VLOOKUP
4. LET
5. DATA

What are the shortcut keys to paste special?

1. ALT + H + V + F
2. ALT + H + V + P
3. ALT + H + V + O
4. ALT + H + V + S

What is the shortcut keyboard to edit formulas in a cell?

1. F2
2. F4
3. CTRL +1
4. CRTL + F

Which tab of the ribbon should you go to for removing gridlines on a worksheet?

1. Formulates
2. View
3. Review
4. Developer

Which of the following features cannot be found in the data ribbon?

1. What-If Analysis
2. PivotTable
3. Data Validation
4. Text to Columns

Use a _________ list to sort or fill in a user-defined order.

1. Auto Fill Options
2. Fill Series
3. Custom List
4. none

What is the function of the F4 key in a Spreadsheet

1. Change font
2. Repeat the last action
3. Choose open command
4. Open bookmark

All these MS Excel MCQs taken from the past papers of PPSC, FPSC, SPSC, KPPSC, BPSC, AJKPSC, UPSC, NTS, CSS, OTS, PMS and other competitive exams.

Read More: Computer MCQs