If you press ____, the cell accepts your typing as its contents?
Tab
Ctrl + Enter
Enter
Alt + Enter
SHOW ANSWERFormula palette is used to?
Format cells containing numbers
Create and edit formulas containing functions
Entered assumptions data
Copy all cells
SHOW ANSWERA value used in a formula that does not change is called a____
Constant
Cell address
Variable
Static
SHOW ANSWERTo create an interactive pivot Table for the web, you use a Microsoft office web component called?
HTML
Pivot Table Field List
Pivot Table Report
Pivot Table List
SHOW ANSWERWhat function displays row data in a column or column data in a row?
Transpose
Index
Rows
Hyperlinks
SHOW ANSWERExpect which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?
NOT
OR
IF
AND
SHOW ANSWERWhich of the following is not a valid zoom percentage in Excel?
10
100
300
500
SHOW ANSWERHow can we set Page Border in Excel?
From Edit menu
From Home
You cannot set page border in Excel
From Tools menu
SHOW ANSWERVLOOKUP function used to?
Finds related records
Looks up text that contain “V”
Check if two cells are identical
None of the above
SHOW ANSWERHow do you change column width to fit the contents?
Single – click the boundary to the left to the column heading
Double – click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
SHOW ANSWERTo drag a selected range of data to another worksheet in the same Workbook, use the?
Ctrl Key
Shift Key
Alt Key
Tab Key
SHOW ANSWERWhat excel feature can you uses if you want to work with one record at a time?
Auto complete
Data Form
Set Form
Auto Text
SHOW ANSWERWhich function in excel counts the numbers of characters in a cell?
LENGTH
LGT
LT
LEN
SHOW ANSWER