Title bar
Formula bar
Menu bar
Sheet tabs
B. Formula bar
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
AA
A1
Aa
A0
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
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
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
=
+
(
@
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Validation
Formats
Formulas
All of above
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Accessing
Referencing
Updating
Functioning
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
Option buttons
List boxes
Text boxes
Combo boxes
Pmt
Average
Max
Sum
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
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
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
256
1024
32000
65535
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
Contents tab
Answer Wizard tab
Index tab
all of the above
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
There is no way to copy and apply formatting in Excel You have to do it manually
The Format Painter button on the standard toolbar
0
1
5
10