Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
Correct Answer :
C. Text boxes
Related Questions
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
You can use the formula pallette to
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Which of the cell pointer indicates that you can fill series?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which key do you press to check spelling?
F3
F5
F7
F9
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
How can you find specific information in a list?
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button