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.
How many worksheets can a workbook have?
3
8
255
None of the above
Correct answer is D
Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.
What is the correct way to refer to cell A10 on sheet3 from sheet1?
Sheet3!A10
Sheet1!A10
Sheet3.A10
A10
Correct answer is A
No explanation has been provided for this answer.
Which of the following Charts can be created in Excel?
Area
Line
Pie
All of the above
Correct answer is D
Excel offers the following major chart types:
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________
AutoFill
Auto correct
Auto sum
Auto format
Correct answer is C
AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.
An Excel Workbook is a collection of ________
Workbooks
Worksheets
Charts
Worksheets and Charts
Correct answer is D
A workbook is a collection of one or more spreadsheets and charts in a single file.