MS-Excel Interview Questions and Answers
Ques:- Press ______ to open the Excel formula window.
A. Shift + F3
B. Shift + F4
C. Shift + F5
D. Shift + F6
Ques:- A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______
A. Horizontal columns, vertical row
B. Horizontal table, vertical cell
C. Horizontal cell, vertical table
D. Horizontal row, vertical columns
Ques:- To displays the Find and Replace dialog box, with the Find tab selected press
A. Alt + F
B. Tab + F
C. Esc + F
D. Ctrl + F
Ques:- Press ______ to displays the format cell dialog box in MS Excel.
A. Ctrl + 1
B. Ctrl + 2
C. Ctrl + 3
D. Ctrl + 4
Ques:- Pre-defined and built in formulas in Excel are known as
A. Autosheets
B. Charts
C. Functions
D. Tables
Ques:- Press ______ to saves the active file with its current file name, location, and file format.
A. Ctrl + S
B. Alt + S
C. Ctrl + Alt + Esc
D. Alt + Tab + Esc
Ques:- Use the _____ to join, or concatenate, one or more text strings to produce a single piece of text.
A. Ampersand
B. Comma
C. Colon
D. Space
Ques:- ______ inserts a new worksheet.
A. Alt + Shift + F1
B. Alt + Shift + F2
C. Alt + Shift + F3
D. Alt + Shift + F4
Ques:- _____ creates a chart of the data in the current range.
A. Alt + F1
B. Ctrl + F1
C. Ctrl + Alt + F1
D. Esc + F1
Ques:- Press ______ to displays the Print dialog box in MS Excel.
A. Alt + P
B. Ctrl + P
C. Esc + P
D. Tab + P
Ques:- VisiCalc is a program developed by
A. Charles Hokens in 1977
B. Steve Mc Neon in 1989
C. Operah Helen in 1986
D. Dan Bricklin in 1979
Ques:- To displays the open dialog box to open or find a file, press
A. Alt + O
B. Ctrl + O
C. Esc + O
D. Tab + O
Ques:- Which of the following function used to adds the values in the function argument or the values in the all references in the argument?
A. ADD
B. SUM
C. TOTAL
D. LIST
Ques:- When a chart is placed on this, it is much larger and there is no other data on it.
A. Reference sheet
B. Primary sheet
C. Exclusive sheet
D. Chart sheet
Ques:- What are commonly be used to performs many different types of calculations?
A. Word document
B. Slides
C. Spreadsheets
D. All of these
Ques:- Which of the following term is related with legends?
A. Operator
B. Chart
C. Word art
D. Clipart
Ques:- ______ moves to the previous cell in a worksheet or the previous option in a dialog box.
A. Alt + Tab
B. Ctrl + Tab
C. Esc + Tab
D. Shift + Tab