LSAT - Microsoft Excel 1000+ MCQ [Solved] PDF Download
Thursday 9th of March 2023
Sharing is caring
1. To activate the previous cell in a pre-selected range, press
A. The Alt key
B. The Tab key
C. The Enter key
D. None of the above
Answer : D
A. The Alt key
B. The Tab key
C. The Enter key
D. None of the above
Answer : D
2. In Excel, a Data Series is defined as what?
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C
3. Where can you set the shading color for a range of cells in Excel?
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer : D
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer : D
4. Status indicators are located on the
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
Answer : C
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
Answer : C
5. How can you print three copies of a workbook?
A. Select File > Properties form the menu and type 3 in the Copies to print text box
B. Select File > Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
D. Press Ctrl+P+3
Answer : B
A. Select File > Properties form the menu and type 3 in the Copies to print text box
B. Select File > Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
D. Press Ctrl+P+3
Answer : B
6. Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set condition to look for Bold and apply Italics on them
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if it is not requried
Answer : B
A. You can add more than one condition to check
B. You can set condition to look for Bold and apply Italics on them
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if it is not requried
Answer : B
7. You can use the drag and drop method to
A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. a and b
Answer : D
A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. a and b
Answer : D
8. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
Answer : A
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
Answer : A
9. When you insert an excel file into a word document. The data are
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
Answer : B
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
Answer : B
10. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
A. Custom List
B. Auto Fill Options
C. Fill Across Worksheet
D. Fill Series
Answer : A
A. Custom List
B. Auto Fill Options
C. Fill Across Worksheet
D. Fill Series
Answer : A
11. The Cancel and Enter buttons appear in the:
A. Title bar
B. Formula bar
C. Menu bar
D. Sheet tabs
Answer : B
A. Title bar
B. Formula bar
C. Menu bar
D. Sheet tabs
Answer : B
12. Which of the following is the latest version of Excel
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D
13. Which of the following is not a basic step in creating a worksheet?
A. Save workbook
B. Modifiy the worksheet
C. Enter text and data
D. Copy the worksheet
Answer : D
A. Save workbook
B. Modifiy the worksheet
C. Enter text and data
D. Copy the worksheet
Answer : D
14. Comments put in cells are called
A. Smart tip
B. Cell tip
C. Web tip
D. Soft tip
Answer : B
A. Smart tip
B. Cell tip
C. Web tip
D. Soft tip
Answer : B
15. When a label is too long to fit within a worksheet cell, you typically must
A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer : B
A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer : B
16. The autofill feature
A. extends a sequential series of data
B. automatically adds range of cell values
C. applies a boarder around the selected cells
D. none of the above
Answer : D
A. extends a sequential series of data
B. automatically adds range of cell values
C. applies a boarder around the selected cells
D. none of the above
Answer : D
17. You can use the formula palette to
A. Format cells containing numbers
B. Create and edit formulas containing functions
C. Enter assumptions data
D. Copy a range of cells
Answer : B
A. Format cells containing numbers
B. Create and edit formulas containing functions
C. Enter assumptions data
D. Copy a range of cells
Answer : B
18. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C
19. Tab scrolling button
A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheets tabs
Answer : D
A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheets tabs
Answer : D
20. How do you delete a column?
A. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B. Select the column heading you want to delete and select Insert Delete from the menu
C. Select the row heading you want to delete and select Edit>Delete from the menu
D. Right click the column heading you want to delete and select delete from the shortcut menu
Answer : D
A. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B. Select the column heading you want to delete and select Insert Delete from the menu
C. Select the row heading you want to delete and select Edit>Delete from the menu
D. Right click the column heading you want to delete and select delete from the shortcut menu
Answer : D
21. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
Answer : A
A. Pmt
B. Average
C. Max
D. Sum
Answer : A
22. Excel uniquely identifies cell within a worksheet with a cell name
A. Cell names
B. Column numbers and row letters
C. Column letters and row numbers
D. Cell locator coordinates
Answer : C
A. Cell names
B. Column numbers and row letters
C. Column letters and row numbers
D. Cell locator coordinates
Answer : C
23. You can move a sheet from one workbook into new book by
A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B. From Edit menu choose Move of Copy then choose (Move to end) and click OK
C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D. None of above
Answer : C
A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B. From Edit menu choose Move of Copy then choose (Move to end) and click OK
C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D. None of above
Answer : C
24. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above
Answer : D
A. 3
B. 8
C. 255
D. none of above
Answer : D
25. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer : B
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer : B
26. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl +Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
Answer : A
A. Press Ctrl +Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
Answer : A
27. Which elements of a worksheet can be protected from accidental modification?
A. Contents
B. Objects
C. Scenarios
D. All of the above
Answer : D
A. Contents
B. Objects
C. Scenarios
D. All of the above
Answer : D
28. Which is not the function of Edit, Clear command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C
29. Which of the cell pointer indicate that you can move the content to other cell?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : C
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : C
30. A typical worksheet has …. Number of columns
A. 128
B. 256
C. 512
D. 1024
Answer : B
A. 128
B. 256
C. 512
D. 1024
Answer : B
31. Which of the following formulas is not entered correctly?
A. =10+50
B. 10+50
C. =10+50
D. =B7+14
Answer : B
A. =10+50
B. 10+50
C. =10+50
D. =B7+14
Answer : B
32. A numeric value can be treated as a label value if it precedes with
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : A
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : A
33. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
Answer : C
A. insert
B. file
C. tools
D. view
Answer : C
34. How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
Answer : D
A. 256
B. 1024
C. 32000
D. 65535
Answer : D
35. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
A. An absolute cell address is created
B. Cell address will change when it is copied to another cell
C. The sheet tab is changed
D. The status bar does not display the cell address
Answer : A
A. An absolute cell address is created
B. Cell address will change when it is copied to another cell
C. The sheet tab is changed
D. The status bar does not display the cell address
Answer : A
36. Rounding errors can occur
A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
Answer : A
A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
Answer : A
37. Which of the following series type is not valid for Fill Series dialog box?
A. Linear
B. Growth
C. Autofill
D. Time
Answer : D
A. Linear
B. Growth
C. Autofill
D. Time
Answer : D
38. Which of the following you can paste selectively using Paste Special command?
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D
39. When a range is selected, how can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer : D
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer : D
40. In a worksheet you can select
A. The entire worksheet
B. Rows
C. Columns
D. All of the above
Answer : B
A. The entire worksheet
B. Rows
C. Columns
D. All of the above
Answer : B
41. How can you show or hide the gridlines in Excel Worksheet?
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer : C
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer : C
42. Comments put in cells are called .....
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Answer : B
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Answer : B
43. The first cell in EXCEL worksheet is labeled as
A. AA
B. A1
C. Aa
D. A0
Answer : B
A. AA
B. A1
C. Aa
D. A0
Answer : B
44. You cannot link excel worksheet data to a word document
A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer : D
A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer : D
45. Data can be arranged in a worksheet in a easy to understand manner using
A. auto formatting
B. applying styles
C. changing fonts
D. all of above
Answer : D
A. auto formatting
B. applying styles
C. changing fonts
D. all of above
Answer : D
46. Which of the following methods can not be used to edit the contents of a cell?
A. Press the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell
Answer : A
A. Press the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell
Answer : A
47. How do you select an entire column?
A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column
Answer : B
A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column
Answer : B
48. Long text can be broken down into many lines within a cell. You can do this through
A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer : A
A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer : A
49. When a row of data is to be converted into columns
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Answer : D
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Answer : D
50. What are the tabs that appear at the bottom of each workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer : D
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer : D