A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
When integrating Word and Excel, Word is usually the
Server
Destination
Client
Both b and c
Correct answer is D
No explanation has been provided for this answer.
How do you delete a column in Excel?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
Correct answer is D
Right click the column heading you want to delete and select delete from the shortcut menu in Excel 2003.
From 2007 and Higher version Home > Delete > Delete Sheet Columns.
To create a formula in Excel, you first
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Correct answer is B
No explanation has been provided for this answer.
How do you select an entire column in Excel?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Correct answer is B
No explanation has been provided for this answer.
How do you insert a row in Excel?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Correct answer is A
No explanation has been provided for this answer.