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.
You can activate a cell in Excel by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Correct answer is D
No explanation has been provided for this answer.
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Correct answer is B
B7:B9 indicates a range of cell between Cells B7 through B9
Logical
Math & Trigonometry
Statistical
Financial
Correct answer is D
No explanation has been provided for this answer.
is defined by a bold border around the cell
receives the data the user enters
is the formula bar
Only A and B
Correct answer is D
An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
Correct answer is B
Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.