MS Excel Flashcards
Comments put in cells are called …
Cell Tip
Comments can be added to cells using …
Insert -> Comment
Which menu option can be used to split windows into two?
Window -> Split
Getting data from a cell located in a different sheet is called …
Referencing
Which of the following is not a valid data type in Excel?
a. Number
b. Character
c. Label
d. Date/Time
Character
Which elements of a worksheet can be protected from accidental modification?
a. Contents
b. Objects
c. Scenarios
d. All of the above
d. All of the above
A numeric value can be treated as label value if _________ precedes it.
Apostrophe ( ‘ )
Concentration of text can be done using _____.
a. Apostrophe
b. Exclamation
c. Hash
d. Ampersand
d. Ampersand (&)
Which area in an Excel window allows entering values and formulas?
Formula Bar
Multiple calculations can be made in a single formula using ______.
a. Standard Formula
b. Array Formula
c. Complex Formula
d. Smart Formula
b. Array Formula
An Excel Workbook is a collection of?
Worksheets and Charts
What do you mean by a Workspace?
a. Group of Worksheets
b. Group of Rows
c. Group of Workbooks
c. Group of Workbooks
MS-Excel is based on?
a. Windows
b. DOS
c. UNIX
d. OS/2
a. Windows
In Excel, you can sum a large range of data by simply selecting a tool button called ______ ?
Auto Sum
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
c. Auto Sum
To select an entire column in MS-Excel, press ______?
a. Ctrl + C
b. Ctrl + Arrow Key
c. Ctrl + S
d. None of the above
d. None of the above
We use this function to return the remainder after a number is divided by a divisor in Excel.
a. ROUND ( )
b. FACT ( )
c. MOD ( )
d. DIV ( )
c. MOD ( )
Which function is not available in the Consolidate dialog box?
a. Pmt
b. Average
c. Max
d. Sum
a. Pmt
Which is not the function of “Edit, Clear” command?
a. Delete Contents
b. Delete Notes
c. Delete Cells
d. Delete Formats
c. Delete Cells
Microsoft Excel is a powerful _____.
a. Word Processing Package
b. Spreadsheet Package
c. Communication S/W Package
d. DBMS Package
b. Spreadsheet Package
How do you rearrange the data in ascending or descending order?
a. Data, Sort
b. Data, Form
c. Data, Table
d. Data Subtotals
a. Data, Sort
