Search

Excel Exercise PDF

Uploaded by Abdul Hadi on May 04, 2023

 0 ratings · 584 views · 15 pages

AI-enhanced title and description

Document Information 
This document contains 71 multiple choice qu…

Download now
Date uploaded
May 04, 2023 
Download as pdf or txt
Original Title
Excel Exercise.pdf

Copyright
© ©1.A.All Rights Reserved
Comments put in cells are called _______.
Smart Tip
B. Cell Tip
C. Web Tip
Available Formats
D. Soft Tip
Ans: B
PDF,2.TXT or read online from Scribd
Comments can be added to cells using …..
A. Edit Comments

Share this document

B. Insert Comment
C. File Comments
D. View Comments
Ans: B


B. View Window Split
C. Window Split
Facebook
D. View Split

3. Which menu option can be used to split windows into two?
A. Format Window

Twitter
Ans: C

4. Getting data from a cell located in a different sheet is called….


A. Accessing
B. Referencing
C. Updating
D. Functioning
Ans: B
Email
5. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label

Did you find this document useful?

D. Date/Time
Ans: B

6. Which elements of a worksheet can be protected from accidental modification?

A. Contents
B. Objects
C. Scenarios
D. All of the above
Ans: D

7. A numeric value can be treated as label value if ______ precedes it.

A. Apostrophe (‘)
Is this content inappropriate?
B. Exclamation (!)
C. Hash (#)
D. Tilde (~)
Ans: A

Report

Ad Download to read ad-free

8. Concatenation of text can be done using

A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)
Ans: D

9. Which area in an Excel window allows entering values and formulas?

A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
Ans: C

10. Multiple calculations can be made in a single formula using…..

A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula
Ans: B

11. An Excel Workbook is a collection of …….

A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
Ans: D

12. What do you mean by a Workspace?

A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
Ans: D

13. MS-EXCEL is based on ……….?

A. WINDOWS
B. DOS
C. UNIX
D. OS/2
Ans: A

14. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format

Ad Download to read ad-free

Ans: C

15. To select an entire column in MS-EXCEL, press?

A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
Ans: D

16. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A. ROUND ( )
B. FACT ( )
C. MOD ( )
D. DIV ( )
Ans: C

17. Which function is not available in the Consolidate dialog box?

A. Pmt
B. Average
C. Max
D. Sum
Ans: A

18. Which is not the function of "Edit, Clear" command?

A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Ans: C

19. Microsoft Excel is a powerful ________.

A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
Ans: B

20. How do you rearrange the data in ascending or descending order?

A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
Ans: A

21. Which Chart can be created in Excel?

A. Area
B. Line
C. Pie

Ad Download to read ad-free

D. All of the above

Ans: D

22. What will be the output if you format the cell containing 5436.8 as '#,##0.00'?
A. 5,430.00
B. 5,436.80
C. 5,436.8
D. 6.8
Ans: B

23. How do you display current date and time in MS Excel?

A. date ()
B. Today ()
C. now ()
D. time ()
Ans: C

24. How do you display current date only in MS Excel?

A. date ()
B. Today ()
C. now ()
D. time ()
Ans: B

25. How do you wrap the text in a cell?

A. Format, cells, font
B. Format, cells, protection
C. format, cells, number
D. Format, cells, alignment
Ans: D

26. What does COUNTA () function do?

A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells
Ans: D

27. What is the short cut key to highlight the entire column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
Ans: D

28. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *

Ad Download to read ad-free

C. %
D. &
Ans: A

29. Excel displays the current cell address in the ______.

A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar
Ans: C

30. 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
Ans: A

31. Which language is used to create macros in Excel?

A. Visual Basic
B. C
C. Visual C++
D. Java
Ans: A

32. Which of the following is not a term of MS-Excel?

A. Cells
B. Rows
C. Columns
D. Document
Ans: D

33. How many worksheets can a workbook have?

A. 3
B. 8
C. 255
D. none of above
Ans: D

34. Which would you choose to create a bar diagram?

A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
Ans: B

35. Which setting you must modify to print a worksheet using letterhead?
A. Paper

Ad Download to read ad-free

B. Margin
C. Layout
D. Orientation
Ans: B

36. What do you call the chart that shows the proportions of how one or more data elements relate
to another data element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
Ans: C

37. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
Ans: C

38. Which key do you press to check spelling?

A. F3
B. F5
C. F7
D. F9
Ans: C

39. To record a sequence of keystrokes and mouse actions to play back later we use:
A. Media player
B. Sound Recorder
C. Calculator
D. Macro Recorder
Ans: D

40. We can save and protect the workbook by

A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
Ans: D

41. The first cell in EXCEL worksheet is labeled as

A. AA
B. A1
C. Aa
D. A0
Ans: B

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Ad Download to read ad-free

Reward Your Curiosity

Everything you want to read.
Anytime. Anywhere. Any device.

Read For Free

Cancel Anytime

Share this document

    

You might also like

Document 10 pages

Power Point Questions

Virendra Kumar
100% (3)

Document 13 pages

MS Excel Multiple Choice

Questions With Answers
Tayyaba ismail
79% (19)

Document 18 pages

Microso! Word Question

Bank
Sannu Vijayeendra
83% (6)

Document 3 pages

MS Excel Practical Questions

& Answers PDF: Ans: C…
Current State
RD ANF NORTH
100% (1)

Document 40 pages

Excel Test Questions

Hiến Nguyễn
100% (1)

Document 29 pages

Top 100 Most Repeate

Micros! Excel Mcqs Set-1
shahid khambro
100% (3)

Document 12 pages

Excel 100 Question Exam

Jahann Delgado
100% (3)

Download
Document 83 pages

MS Office MCQ
Ad
MuhammadHumayunKhrel
100% (4)