Which of the following is not a valid option to insert a hyperlink in excel, which can link to?
- existing file or web page
- place in this document
- e-mail address
- link to home
The Function ________ in Excel is used to look up information in a table and extract the corresponding data.
- FETCH
- GET
- VLOOKUP
- LET
- DATA
What are the shortcut keys to paste special?
- ALT + H + V + F
- ALT + H + V + P
- ALT + H + V + O
- ALT + H + V + S
What is the shortcut keyboard to edit formulas in a cell?
- F2
- F4
- CTRL +1
- CRTL + F
Which tab of the ribbon should you go to for removing gridlines on a worksheet?
- Formulates
- View
- Review
- Developer
Which of the following features cannot be found in the data ribbon?
- What-If Analysis
- PivotTable
- Data Validation
- Text to Columns
You are said to collect numerical data from different sources and perform different computations on it, which of the following you would use?
- Word
- PowerPoint
- Excel
- Frontpage
Use a _________ list to sort or fill in a user-defined order.
- Auto Fill Options
- Fill Series
- Custom List
- none
What is the function of the F4 key in a Spreadsheet
- Change font
- Repeat the last action
- Choose open command
- 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
