1. With which of the following all formulas in excel starts ?
- /
- *
- $
- =
Answer: Option D
2. On an excel sheet the active cell in indicated by ?
- A dotted border
- A dark wide border
- A blinking border
- By italic text
Answer: Option B
Answer: Option C
Answer: Option A
3. What term describes explanatory text attached to a cell ?
- Context
- Callout
- Comment
- Dialog
Answer: Option C
4. How we can view a cell comment ?
- position the mouse pointer over the cell
- click the comment command on the view menu
- click the edit comment commands on the Insert menu
- click the Display comment command on the window menu
Answer: Option A
5. Which of these will not select all the cells in a document ?
- Using the Edit – Select All menu
- Pressing Ctrl + A on the keyboard
- Clicking three times with the right mouse button in the spreadsheet
Answer: Option C
6. The default style for new data keyed in a new workbook is ?
- Comma
- Normal
- Currency
- Percent
Answer: Option B
7. If you press ___, the cell accepts your typing as its contents ?
- Tab
- Ctrl+Enter
- Enter
- Alt+Enter
Answer: Option C
8. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?
- F11
- F10
- F4
- F2
Answer: Option A
9. Formula palette is used to ?
- format cells containing numbers
- create and edit formulas containing functions
- entered assumptions data
- copy all cells
Answer: Option B
10. A value used in a formula that does not change is called a ?
- Constant
- Cell address
- Varaible
- Static
Answer: Option A
11. A Spreadsheet contains ?
- columns
- rows
- rows and columns
- None of above
- Answer : C
12. To open an existing workbook, click the Open button on the ___ toolbar ?
- Form
- Standard
- Drawing
- Formatting
Answer: Option B
13. Which among following is not associated with spelling dialogue box ?
- Edit
- Ignore
- Ignore All
- Change
Answer: Option A
14. what term describes a background that appears as a grainy, non smooth surface ?
- Pattern
- Gradient
- Texture
- Velvet
Answer: Option B
15. Which among following is associated with excel ?
- Graphic program
- Word Processor
- Presentation
- Spreadsheet
Answer: Option D
16. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?
- C1:10H
- C1:H10
- C1:H-10
- C1:H:10
17. You can convert existing Excel worksheet data and charts to HTML document by using the ?
- Internet Assistant Wizard
- Intranet Wizard
- Import Wizard
- Export Wizard
Answer: Option A
18. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?
- HTML
- Pivot Table Field List
- Pivot Table Report
- Pivot Table List
Answer: Option C
19. What function displays row data in a column or column data in a row ?
- Transpose
- Index
- Rows
- Hyperlinks
Answer: Option A
20. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
- NOT
- OR
- IF
- AND
Answer: Option C
21. Macros can be executed from the which of the following menu ?
- Format
- Home
- Insert
- Tools
Answer: Option D
22. Protection and the Protect Sheet options can be selected from ?
- Data
- Tools
- Edit
- Format
Answer: Option B
23. Which of the following is not a valid Zoom percentage in Excel ?
- 10
- 100
- 300
- 500
Answer: Option D
24. You can check the conditions against ____ when applying conditional formatting ?
- Cell Value
- Formula
- Both of above
- None of above
Answer: Option C
25. How can we set Page Border in Excel ?
- From Edit menu
- From Home
- You can not set page border in Excel
- From Tools menu
Answer: Option C
26. Which function calculates your monthly mortage payment ?
- PV
- NPER
- PMT
- All of above
Answer: Option C
27. Which types of charts can excel produce ?
- Line graphs and pie charts only
- Bar charts, line graphs and pie charts
- Bar charts and line graphs only
- Only line graphs
Answer: Option B
28. How is data organized in a spreadsheet ?
- Rows and columns
- Layers and planes
- Lines and spaces
- Height and width
Answer: Option A
29. VLOOKUP function used to ?
- Finds related records
- Looks up text that contain "v"
- Check if two cells are identical
- None of above
Answer: Option A
30. Gridlines may be turned off for display but turned on for printing.
- True
- False
Answer: Option A
31. How do you change column width to fit the contents ?
- Single-click the boundary to the left to the column heading
- Double click the boundary to the right of the column heading
- Press Alt and single click anywhere in the column
- All of above
Answer: Option B
32. To insert three columns between columns A and B you would
- Select column A
- Select A and B
- Select B
- All of above
Answer: Option C
33. To drag a selected range of data to another worksheet in the same workbook, use the ?
- Ctrl key
- Shift key
- Alt key
- Tab key
Answer: Option A
34. You can activate a cell by ?
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- All of above
Answer: Option D
35. A function inside another function is known as ?
- Round function
- Sandwich function
- Switch function
- Nested function
Answer: Option D
36. What excel feature can you use if you want to work with one record at a time ?
- Auto Complete
- Data Form
- Set Form
- Auto Text
Answer: Option B
37. Which function is used for creating a data table ?
- Sum
- Table
- Add
- Count
Answer: Option B
38. The accounting style shows negative numbers in ?
- Bold
- Italics
- Parentheses
- Quotes
Answer: Option C
39. 3-D reference in a formula ?
- Spans worksheets
- Can not be modified
- Only appears on summary worksheets
- Limits the formatting options
Answer: Option A
40. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.
- True
- False
Answer: Option A
41. Which among following wildcard characters are recognized by excel ?
- + and -
- ! and ^
- * and ?
- < and >
Answer: Option C
42. Which among following is divide symbol in excel ?
- /
- D
- Div
- \
Answer: Option A
43. Which function in excel counts the numbers of characters in a cell ?
- LENGHT
- LGT
- LT
- LEN
Answer: Option D
44. Which function converts miles to kilometers ?
- Change
- Covnert
- Shift
- Conv
Answer: Option B
45. What is shortcut to enter current date in cell in excel ?
- Ctrl + ;
- Alt + ;
- Shift + &
- Ctrl + $
46. Shortcut to edit the selected cell ?
- F3
- F8
- F4
- F2
Answer: Option D
47. Each excel can contain many sheets including worksheets and chart sheets.
- True
- False
Answer: Option A
48. Which shortcut can be used to Switch between open workbooks ?
- Ctrl + F2
- Ctrl + F6
- Ctrl + F8
- Ctrl + F10
Answer: Option B
49. Shortcut to delete the selected column ?
- Ctrl + -
- Alt + -
- Shift + -
- Insert + -
Answer: Option A
50. Shortcut to enter current date ?
- Home + ;
- Shift + ;
- Alt + ;
- Ctrl + ;
Answer: Option D
51. When the formula bar is activated, you can see
- The Edit Formula button
- The Cancel button
- The Enter button
- All of above
Answer: Option D
52. Style sheet formats can be applied from ?
- Table >> Autoformat
- Format >> Autoformat
- Table >> Cells
- Fromat >> Cells
Answer: Option B
53. Which function will you use to enter current time in a woksheet cell ?
- =time()
- =nowtime()
- =now()
- =currentTime()
Answer: Option C
54. Merge cells option can be applied from ?
- Formatting toolbar
- Format Cells dialog box Alignment Tab
- Both of above
- None of above
Answer: Option B
55. How many recent files you can display on File menu at maximum ?
- 3
- 7
- 9
- 15
Answer: Option C
56. The name box appears at the ?
- left of the formula bar
- right of the formula bar
- below the status bar
- below the menu bar
Answer: Option A
57. Entire worksheet can not be selected in one time.
- True
- False
Answer: Option B
58. Where are the status indicators located ?
- Horizontal Scroll
- Vertical Scroll
- Formula bar
- Address bar
Answer: Option C
59. Insert picture option is in which of the following toolbars ?
- Standard
- Formatting
- Drawing
- Picture
Answer: Option D
60. What term refers to a specific set of values saved with the workbook ?
- Range
- File set
- Data set
- Scenario
Answer: Option D
61. We can cancel marquee by pressing ?
- Ctrl + Esc
- Alt + Esc
- Shift + Esc
- Esc
Answer: Option D
62. Which of the following methods cannot be used to edit the content of cell ?
- Pressing F2
- Clicking the formula bar
- Pressing the Alt key
- Double clicking the cell
Answer: Option C
63. When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors.
- True
- False
Answer: Option A
64. Which among following can't be considered as worksheet criterion ?
- Efficiency
- Auditability
- Clarity
- Description
Answer: Option D
65. When creating a vertical page break ?
- The active cell must be in row 1
- The active cell must be A1
- The active cell must be in row 10
- The active cell must be in column A
Answer: Option A
66. The intersection of row and column is called a ?
- dataset
- cell
- data
- set
Answer: Option B
67. You will use which feature in excel, if you want to work with one record at a time ?
- Auto Complete
- Auto Filter
- Sub Totals
- Data Form
Answer: Option D
68. Which dialogue box we can use to name a constant ?
- Create Name
- Define Name
- Get Name
- Create Constant
Answer: Option B
69. One cell format can be copied to another cell by using ?
- Format Painter
- Format Setting
- Format Showing
- Format Checking
Answer: Option A
70. Which among following is types of excel data types ?
- Numbers, Formulas, Labels
- Data, Words, Numbers
- Words, Number, Labels
- Equations, Data, Numbers
Answer: Option A
71. To join some cells and place the content at the middle of joined cell, which tool you will use?
- From Format Cells dialog box choose Merge and Center check box
- Click on Merge and Center tool on formatting toolbar
- From Format Cells dialog box select the Centered alignment
- From Format Cells dialog box click on Merge Cells check box
Answer: Option B
72. On Excel screen, Tab scroll buttons are
- towards the top left corner
- towards the top right corner
- towards the bottom right corner
- towards the bottom left corner
Answer: Option D
73. Choose from the following, which is not the correct method of editing the cell content ?
- Press the Alt key
- Press the F2 key
- Double click the cell
- Click the formula bar
Answer: Option A
74. In Excel Worksheet how can you show or hide the gridlines ?
- Click Gridline tool on Forms toolbar
- Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
- Both of above
- None of above
Answer: Option C
75. When you press Ctrl + X after selecting some cells in Excel, what will happen then
- The cell content of selected cells disappear from cell and stored in clipboard
- The selected cells are deleted and cells are shifted up
- The selected cells are deleted and the cells are shifted left
- The cells selected are marked for cutting
Answer: Option D
76. In Paste Special dialog box, which of the following option is not available ?
- Divide
- Add
- Subtract
- Square root
Answer: Option D
77. To convert a column of data into row, which command will you choose
- Edit -> Paste Special -> Transpose
- Cut and Paste
- Both of above
- None of above
Answer: Option A
78. Using Paste Special command which of the following you can paste selectively
- Formulas
- Validation
- Formats
- All of above
Answer: Option D
Hi there, i read your blog from time to time and i own a similar one and i was just wondering if you get a lot of spam comments? If so how do you protect against it, any plugin or anything you can advise? I get so much lately it's driving me insane so any assistance is very much appreciated.
ReplyDeleteInfluencer Marketing Schweiz